myITforum.com Community Forum myITforum.com Community Forum

Home  Forums  Blogs  Live Support chat  Search Articles  Wiki  FAQ  Email Lists  Register  Login  My Profile  Inbox  Address Book  My Subscription  My Forums 

Photo Gallery  Member List  Search  Calendars  FAQ  Ticket List  Log Out

All Forums RSS Feed Subscription:


  


Primary Child not updating

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
  Printable Version
All Forums >> [Management Products] >> Microsoft Systems Management Server >> SMS 2003 >> Primary Child not updating Page: [1]
Login
Message << Older Topic   Newer Topic >>
Primary Child not updating - 9/17/2008 2:40:15 AM   
igeyer

 

Posts: 2
Score: 0
Joined: 9/17/2008
Status: offline 		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)>
Post #: 1
RE: Primary Child not updating - 9/17/2008 5:13:36 AM   
iglatz


Posts: 848
Score: 23
Joined: 9/21/2001
From: Erding, Bavaria - Germany
Status: offline 		There's an "access denied" on SQL Server in the compsumm.log. If you use SQL on a different box, you'll need to add the machine account of the SMS server to the SiteToSqlServer (I think that's the name) group on the SQL server. Otherwise, data can't be inserted into the database. If it's not a permission issue, check the name resolution because "SQL server does not exist" might indicate a DNS issue.
Look in the event viewer for more information and check the status messages in the SMS admin console.

(in reply to igeyer)
Post #: 2
RE: Primary Child not updating - 9/17/2008 5:57:45 AM   
igeyer

 

Posts: 2
Score: 0
Joined: 9/17/2008
Status: offline 		Hi

Thanx for your quick response!!!

SMS Server part of Local Admin group, also part of SMS_SiteSystemtoSQL group (on SQL box).
SQL server also part of Local admin group and also part of SMS_SitetoSite connection and SMS_SiteSystemtoServer Connection (SMS Server)
Did Gpupdate on both servers. Restarted relevant SMS services.
Can not see anything in event viewer except that server restarted just before error occured.
Can not see if anything was installed prior to error.

(in reply to iglatz)
Post #: 3
Page:   [1]
All Forums >> [Management Products] >> Microsoft Systems Management Server >> SMS 2003 >> Primary Child not updating Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts



  
Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

0.219