CMS Database Connectivity

[Former Member]

I am getting an intermitten problem where the CMS is not able to connect to the CMS Database (SQL Server) and then services shut down. This seems to happen over the weekends more so than the week days. The Windows Event logs indicate "CMS is unstable and will shut down immediately. Reason: Database access error. Reason [Microsoft][ODBC SQL Server Driver]Communication link failure."

I can't find any resolution for this other than dedicating communication on one NIC. We only have one NIC on the server. Any ideas?

[Former Member · Accepted solution]

Hi Bill,

Are there any maintenance tasks on going when the CMS goes down, for instance is the DB being backed up?

Regards

Alan

[Former Member · Accepted solution]

I know the DB gets backed up regularly. I am finding out how often and what the schedule is. I'm not sure it is related to the back up of DB. My event log is full of warnings of Transport error: Invalid object reference.

[Former Member · Accepted solution]

Hello Bill,

"Transport error: Invalid object reference" is a fairly generic error and is indicative of a problem rather than being the problem itself. As Alan mentioned, it's rather likely that your CMS goes down when backups (or intensive task) runs on the db.

Have you looked at the CMS logs? Do they contain anything interesting?

Best,

Srinivas

[Former Member · Accepted solution]

Here's what I have in the CMS logs.

[Mon Jan 26 09:22:18 2009] 4720 5004 assert failure: (.\auditsubsystem_impl.cpp:2365). (false : Next event id value should be greater than the current one, check the auditee packing events code).

[Mon Jan 26 12:00:08 2009] 4720 4992 assert failure: (.\ad_impl.cpp:3779). (tmp_ptr->attrList : no message).

There are numerous entries of the first error and about 5 entries of the second.

[Former Member · Accepted solution]

I am assuming you have "trace" turned on for the CMS service? That should give much more detailed information on the logs than what you posted.

[Former Member · Accepted solution]

I will add the trace option and get back to you when I get more detailed info.

Thnks