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
Article Type
Technical Solution


Environment

Issue



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