|
igeyer -> Primary Child not updating (9/17/2008 2:40:15 AM)
|
Good day to you all !!
Primary child site not updating even when looking at the console @ the spesific site it is also not updated.
SQL is running on seperate box but the services is started.
Restarted SMS SQL Service, SMS Site Component Manager and SMS Executive but still not updated.
Following error from log files:
From
Compsumm.log
Standard Time><thread=2152 (0x868)>
---->: Now processing anything that may be pending. $$<SMS_COMPONENT_STATUS_SUMMARIZER><Wed Sep 10 18:53:53.875 2008 South Africa Standard Time><thread=2152 (0x868)>
---->: Checking for expired tally intervals. $$<SMS_COMPONENT_STATUS_SUMMARIZER><Wed Sep 10 18:53:53.875 2008 South Africa Standard Time><thread=2152 (0x868)>
---->: The summary record aging timer has exceeded 20 seconds and expired, Writing changed records to the datastore $$<SMS_COMPONENT_STATUS_SUMMARIZER><Wed Sep 10 18:53:53.875 2008 South Africa Standard Time><thread=2152 (0x868)>
Info>: Updating the datastore $$<SMS_COMPONENT_STATUS_SUMMARIZER><Wed Sep 10 18:53:53.875 2008 South Africa Standard Time><thread=2152 (0x868)>
*** [08001][17][Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. $$<SMS_COMPONENT_STATUS_SUMMARIZER><Wed Sep 10 18:55:09.344 2008 South Africa Standard Time><thread=2152 (0x868)>
*** [01000][53][Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). $$<SMS_COMPONENT_STATUS_SUMMARIZER><Wed Sep 10 18:55:09.344 2008 South Africa Standard Time><thread=2152 (0x868)>
*** Failed to connect to the SQL Server. $$<SMS_COMPONENT_STATUS_SUMMARIZER><Wed Sep 10 18:55:09.344 2008 South Africa Standard Time><thread=2152 (0x868)>
Error: Could not get a SQL connection from the connection cache. Will try again in 60 seconds. : The operation completed successfully.~~ $$<SMS_COMPONENT_STATUS_SUMMARIZER><Wed Sep 10 18:55:09.344 2008 South Africa Standard Time><thread=2152 (0x868)>
*** [08001][17][Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. $$<SMS_COMPONENT_STATUS_SUMMARIZER><Wed Sep 10 18:58:01.499 2008 South Africa Standard Time><thread=2152 (0x868)>
*** [01000][53][Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). $$<SMS_COMPONENT_STATUS_SUMMARIZER><Wed Sep 10 18:58:01.499 2008 South Africa Standard Time><thread=2152 (0x868)>
*** Failed to connect to the SQL Server. $$<SMS_COMPONENT_STATUS_SUMMARIZER><Wed Sep 10 18:58:01.499 2008 South Africa Standard Time><thread=2152 (0x868)>
Error: Could not get a SQL connection from the connection cache. Will try again in 60 seconds. : The operation completed successfully.~~ $$<SMS_COMPONENT_STATUS_SUMMARIZER><Wed Sep 10 18:58:01.499 2008 South Africa Standard Time><thread=2152 (0x868)>
*** [HYT00][0][Microsoft][ODBC SQL Server Driver]Timeout expired $$<SMS_COMPONENT_STATUS_SUMMARIZER><Wed Sep 10 19:00:10.842 2008 South Africa Standard Time><thread=2152 (0x868)>
*** Failed to connect to the SQL Server. $$<SMS_COMPONENT_STATUS_SUMMARIZER><Wed Sep 10 19:00:10.842 2008 South Africa Standard Time><thread=2152 (0x868)>
Error: Could not get a SQL connection from the connection cache. Will try again in 60 seconds. : The operation completed successfully.~~ $$<SMS_COMPONENT_STATUS_SUMMARIZER><Wed Sep 10 19:00:10.842 2008 South Africa Standard Time><thread=2152 (0x868)>
From statmgr.log
(0x1C90)>
*** [08S01][0][Microsoft][ODBC SQL Server Driver]Communication link failure $$<SMS_STATUS_MANAGER><Wed Sep 10 18:53:48.860 2008 South Africa Standard Time><thread=7312 (0x1C90)>
*** Error rolling back transaction, tries left: 4 $$<SMS_STATUS_MANAGER><Wed Sep 10 18:53:48.860 2008 South Africa Standard Time><thread=7312 (0x1C90)>
*** select convert(int,@@spid) $$<SMS_STATUS_MANAGER><Wed Sep 10 18:53:48.985 2008 South Africa Standard Time><thread=7312 (0x1C90)>
*** [08S01][0][Microsoft][ODBC SQL Server Driver]Communication link failure $$<SMS_STATUS_MANAGER><Wed Sep 10 18:53:48.985 2008 South Africa Standard Time><thread=7312 (0x1C90)>
Released SQL connection (SPID = 0) back into the SQL connection cache. $$<SMS_STATUS_MANAGER><Wed Sep 10 18:53:48.985 2008 South Africa Standard Time><thread=7312 (0x1C90)>
Wrote the new transaction's SQL commands to file "E:\SMS\inboxes\statmgr.box\retry\t2hv61lu.sql". $$<SMS_STATUS_MANAGER><Wed Sep 10 18:53:48.985 2008 South Africa Standard Time><thread=7312 (0x1C90)>
Sleeping until an event is signalled... $$<SMS_STATUS_MANAGER><Wed Sep 10 18:53:48.985 2008 South Africa Standard Time><thread=7312 (0x1C90)>
Status messages might be available in the in-memory queue. $$<SMS_STATUS_MANAGER><Wed Sep 10 18:53:53.860 2008 South Africa Standard Time><thread=7312 (0x1C90)>
Removed 2 status messages from the in-memory queue for processing. $$<SMS_STATUS_MANAGER><Wed Sep 10 18:53:53.860 2008 South Africa Standard Time><thread=7312 (0x1C90)>
Processing complete. $$<SMS_STATUS_MANAGER><Wed Sep 10 18:53:53.860 2008 South Africa Standard Time><thread=7312 (0x1C90)>
Sleeping until an event is signalled... $$<SMS_STATUS_MANAGER><Wed Sep 10 18:53:53.875 2008 South Africa Standard Time><thread=7312 (0x1C90)>
Status messages might be available in the in-memory queue. $$<SMS_STATUS_MANAGER><Wed Sep 10 18:53:53.875 2008 South Africa Standard Time><thread=7312 (0x1C90)>
Removed 2 status messages from the in-memory queue for processing. $$<SMS_STATUS_MANAGER><Wed Sep 10 18:53:53.875 2008 South Africa Standard Time><thread=7312 (0x1C90)>
Processing complete. $$<SMS_STATUS_MANAGER><Wed Sep 10 18:53:53.875 2008 South Africa Standard Time><thread=7312 (0x1C90)>
Sleeping until an event is signalled... $$<SMS_STATUS_MANAGER><Wed Sep 10 18:53:53.875 2008 South Africa Standard Time><thread=7312 (0x1C90)>
It is now time to commit the SQL transaction we've been building, because at least 60000 milliseconds have elapsed since we started building it. $$<SMS_STATUS_MANAGER><Wed Sep 10 18:54:53.859 2008 South Africa Standard Time><thread=7312 (0x1C90)>
We're now ready to execute a 953-byte SQL transaction to insert 4 status messages and their 16 insertion strings and 0 attribute ID/value pairs into the database, but 1 transactions are currently queued up in front of this one. We'll write the new transactions's commands to a file and execute them when the prior transactions have completed successfully. $$<SMS_STATUS_MANAGER><Wed Sep 10 18:54:53.859 2008 South Africa Standard Time><thread=7312 (0x1C90)>
Wrote the new transaction's SQL commands to file "E:\SMS\inboxes\statmgr.box\retry\ky910d1h.sql". $$<SMS_STATUS_MANAGER><Wed Sep 10 18:54:53.859 2008 South Africa Standard Time><thread=7312 (0x1C90)>
Sleeping until an event is signalled... $$<SMS_STATUS_MANAGER><Wed Sep 10 18:54:53.875 2008 South Africa Standard Time><thread=7312 (0x1C90)>
It is now time to replicate the batch of medium-priority status messages, because at least 300000 have elapsed since we started building the batch. $$<SMS_STATUS_MANAGER><Wed Sep 10 18:58:43.842 2008 South Africa Standard Time><thread=7312 (0x1C90)>
Successfully instructed SMS_REPLICATION_MANAGER to replicate a medium-priority, 834-byte batch of 6 status messages to our parent site C00. $$<SMS_STATUS_MANAGER><Wed Sep 10 18:58:44.420 2008 South Africa Standard Time><thread=7312 (0x1C90)>
Sleeping until an event is signalled... $$<SMS_STATUS_MANAGER><Wed Sep 10 18:58:44.420 2008 South Africa Standard Time><thread=7312 (0x1C90)>
It is now time to retry the failed SQL transaction. $$<SMS_STATUS_MANAGER><Wed Sep 10 19:03:48.856 2008 South Africa Standard Time><thread=7312 (0x1C90)>
Retrying a 456-byte SQL transaction to insert 2 status messages and their 6 insertion strings and 0 attribute ID/value pairs into the database. $$<SMS_STATUS_MANAGER><Wed Sep 10 19:03:48.856 2008 South Africa Standard Time><thread=7312 (0x1C90)>
|
|
|
|
