This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Child SUM not picking up all subscriptions from parent

Right third attempt at this post! Doesn't seem to work in IE9.... My parent is successfully downloading recommended OS X and Windows version of Sophos. My child updates from the parent by http. It has always worked fine but now the child can only see the OS X version from the parent and not the Windows version. If I browse to the http share I can see both the windows and OS X versions within CIDs/S000 so I am not quite sure what is going on! Any ideas?
:10139


This thread was automatically locked due to age.
  • I decided to go for it and clear down.  It has redownloaded it all but I am still stuck with the same problem.  I now have the software deliver failed error and have errors relating to the bad Windows 9.5 package in the log...

    2011-03-10 12:21:07 : Cmd-ALL << [E402A][F26F7EC0-1302-4DA7-8B6B-A5383051D41A][RECOMMENDED] The decode of payload F26F7EC0-1302-4DA7-8B6B-A5383051D41A and requested version RECOMMENDED was aborted because the synchronise is marked as failed.

    Maybe I should clear the parent down to?  Could it be downloading bad data from the parent?  I wouldn't have thought so as the parent is working perfectly.

    :10231
  • the synchronise is marked as failed

    Could it be downloading bad data from the parent?

    Unlikely that it downloads bad data but not impossible. Involves some searching, perhaps you can find out where and why the synchronize fails. Although clearing the Warehouse on the parent should cause no problems I'd rather search for the failing item first.

    Christian 

    :10233
  • I decided to clear down the parent just in case, this made no odds.  The child is failing with the 80040406 error.  I have been through the Sophos articles for this error and cleared down the Working and Warehouse folders and then tried to update again with no luck.  Here are some errors from the SUMTrace log file, which may provide a clue...?  (i have removed server names)

    2011-03-10 14:10:33 : Sync failure: Cannot locate server for xxx/.../sdds.local.xml
    2011-03-10 14:10:33 : EventLog: 3758112769 1 Inserts:> "F26F7EC0-1302-4DA7-8B6B-A5383051D41A" "Cannot locate server for xxx/.../sdds.local.xml&quot; "RECOMMENDED" "xxx/.../Warehouse&quot; 
    2011-03-10 14:10:33 : Cmd-ALL << [E4001][F26F7EC0-1302-4DA7-8B6B-A5383051D41A][Cannot locate server for http://xxx/SophosUpdate/Warehouse/catalogue/sdds.local.xml][RECOMMENDED][http://xxx/SophosUpdate/Warehouse] Synchronise operation failed when synchronising payload 'F26F7EC0-1302-4DA7-8B6B-A5383051D41A'. Details: Cannot locate server for xxx/.../sdds.local.xml
    2011-03-10 14:10:33 : EventLog: 3758112827 1 Inserts:> "8BAA10C1-3844-465E-919C-D778A5407708" "Not attempted." "RECOMMENDED" "xxx/.../Warehouse&quot; 
    2011-03-10 14:10:33 : Cmd-ALL << [E403B][8BAA10C1-3844-465E-919C-D778A5407708][Not attempted.][RECOMMENDED][http://xxx/SophosUpdate/Warehouse] Payload '8BAA10C1-3844-465E-919C-D778A5407708' could not be synchronised because the synchronise operation failed due to an earlier error.
    2011-03-10 14:10:33 : EventLog: 3758112827 1 Inserts:> "7D48A012-0C64-4F21-BA27-A9CEDF442749" "Not attempted." "0.0.0" "xxx/.../Warehouse&quot; 
    2011-03-10 14:10:33 : Cmd-ALL << [E403B][7D48A012-0C64-4F21-BA27-A9CEDF442749][Not attempted.][0.0.0][http://xxx/SophosUpdate/Warehouse] Payload '7D48A012-0C64-4F21-BA27-A9CEDF442749' could not be synchronised because the synchronise operation failed due to an earlier error.
    2011-03-10 14:10:33 : EventLog: 3758112827 1 Inserts:> "A845A8B5-6532-4EF1-B19E-1DB2B3CB73D1" "Not attempted." "RECOMMENDED" "xxx/.../Warehouse&quot; 
    2011-03-10 14:10:33 : Cmd-ALL << [E403B][A845A8B5-6532-4EF1-B19E-1DB2B3CB73D1][Not attempted.][RECOMMENDED][http://xxx/SophosUpdate/Warehouse] Payload 'A845A8B5-6532-4EF1-B19E-1DB2B3CB73D1' could not be synchronised because the synchronise operation failed due to an earlier error.

    I have checked all the URLs it is trying to pull the data from and the files named above exist and open correctly from the child server using IE.

    :10247
  • You said the child did download lots of stuff? Or is the Warehouse on the child now empty?

    :10249
  • The warehouse on the child has downloaded some but not all.  There is only a single directory and a handfull of xml files.

    :10255
  • One directory under Warehouse? Which one? Do all the files have a .xml extension?

    Usually identifying the first failing download helps in diagnosing the problem.

    Christian

    :10259
  • Right, the child has picked up some more data now but there is nothing like as much data in the CHILD Warehouse as there is in the parent.

    The child now has 42 folders, the parent has 72.

    The most recent file in the child is an xml named 5c01352a20c41a9ab3a939f3a2e3cd30x000.xml.

    The child has 23 .xml files where as the parent has 967 .dat files and 1,664 .xml

    :10261
  • Well I have been playing around further with this, removed the parent as a source and pointed the child directly to Sophos instead.  Redownload took a while and was successful, no errors.  The available packages are still a mess though...

    :10269
  • And SUM on the management server is up to date without errors? Looks totally confused as a number of products is missing. If the existing clients are updating and current (167 IDEs for 4.63 detection data on the current versions) then the SUMs are working correctly I'd say. Is this the fact for either update location (master and child SUM)? If so, then "internal" communication (RMS/Agent) seems to be the problem. But that's just guessing.

    Christian

    :10303
  • With help from support this is now fixed.  I had to do the following...

    1. Stop the Management Service
    2. Stop the Update Manager Service
    3. Use osql to run the following query against the Sophos database:
    UPDATE dbo.LatestData SET DataSource = 'Settings/MetadataSignatures.deleted' WHERE DataSource = 'Settings/MetadataSignatures'
    4. Start the Management Service
    5. Start the Update Manager Service
    6. Wait 5-10 minutes and then try creating a new / modifying a Software Subscription

    :10461