SQL logs on CSM_Report database server show event ID 9724 every time a job runs.
| Article:TECH177231 | | | Created: 2011-12-19 | | | Updated: 2012-03-16 | | | Article URL http://www.symantec.com/docs/TECH177231 |
Problem
Symantec Control Compliance Suite 10.5 onwards shows messages in the SQL logs on CSM_Report database server. Windows event ID 9724 is also shown in the application logs every time a job runs.
Error
12/01/2011 16:29:07,spid59s,Unknown,The activated proc [dbo].[spRecvLoadCommandCall] running on queue CSM_Reports.dbo.qLoadCommand output the following: 'out of catch'
12/01/2011 16:29:07,spid59s,Unknown,The activated proc [dbo].[spRecvLoadCommandCall] running on queue CSM_Reports.dbo.qLoadCommand output the following: 'done with commit'
12/01/2011 16:29:07,spid59s,Unknown,The activated proc [dbo].[spRecvLoadCommandCall] running on queue CSM_Reports.dbo.qLoadCommand output the following: '@delete end0'
12/01/2011 16:29:07,spid59s,Unknown,The activated proc [dbo].[spRecvLoadCommandCall] running on queue CSM_Reports.dbo.qLoadCommand output the following: '@delete end0'
12/01/2011 16:28:53,spid58s,Unknown,The activated proc [dbo].[spRecvImportCall] running on queue CSM_Reports.dbo.qImportMessage output the following: '@ strd insert'
12/01/2011 16:28:51,spid58s,Unknown,The activated proc [dbo].[spRecvImportCall] running on queue CSM_Reports.dbo.qImportMessage output the following: '@ strd insert'
Environment
Symantec Control Compliance Suite 10.5
Microsoft SQL server.
Cause
These messages are informational and are due to the way the stored procedures are executed.
Solution
PCU 2012-1 contains a permanent fix for theses informational messages, apply PCU 2012-1 or above to prevent these messages from showing.
see http://www.symantec.com/docs/TECH181183 for more detals on PCU 2012-1.
|
|
|
|
|
|
Article URL http://www.symantec.com/docs/TECH177231
Terms of use for this information are found in Legal Notices
Thank you.