Logfile monitoring for MSSQL ERRORLOG does not work with sapccmsr

[tombo_larsen]

Hi

We are running MSSQL2005 and wants to monitor the ERRORLOG for certain patterns, using the logfile monitoring feature of SAPCCMSR.

We are using logfile monitoring with sapccmsr for a lot of other logfiles without problems, but for ERRORLOG is does not work!

To be more precise: The agent does not report alerts for the text patterns specified. The agent runs fine and in RZ20 we can see that the logfile are checked every minute (but without finding the patterns).

The strange thing is that:

- It works for all other logfiles

- If we do a "type ERRORLOG >> <new file>" and runs the same monitoring on this "copy" of the ERRORLOG then it works

Any ideas?

Best regards

Tom Bo

[clas_hortien · Accepted solution]

Hello,

the original errorlog file is a unicode file, the copy is most probably a normal ascii file. Can you change the type of the file in the SAPCCMSR transaction ?

Regards

Clas

[rolfc_weber · Accepted solution]

Hi,

Please look at SAP note 1013331 https://service.sap.com/sap/support/notes/1013331.

In special the changes after patch collection 2007/5.

Practical you have to use a unicode CCMS Agent to monitor the ERRORLOG file of SQL2005, and add the "ENCODING=UTF-16" parameter in the template file....

hope this helps..

Regards

Rolf