Audit not working with MSSQL DB & default collation not set to SQL_Latin1_General_CP1_CI_AS

  • 7014891
  • 10-Apr-2014
  • 10-Apr-2014

Environment

Novell ZENworks Configuration Management 11.3 Database
Microsoft SQL 2008

Situation

Configured Audit events are not visible in the Audit dashboard. The following error message is logged in the log file loader-messages.log

[TRACE] [03/19/2014 09:13:53.346] [2672] [ZENLoader] [63] []
[Loader.AuditEventStorerModule] [] [Caught exception while processing event
filesjava.sql.SQLException: java.sql.SQLException: Cannot resolve the collation
conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in
the equal to operation.
   at
com.novell.zenworks.datamodel.audit.utils.SettingsBatchProcessor.getSettingsFromDB(SettingsBatchProcessor.java:191)
   at
com.novell.zenworks.audit.loader.modules.auditeventstorer.LoaderAuditParserEventHandler._loadEventSettings(LoaderAuditParserEventHandler.java:246)
   at
com.novell.zenworks.audit.loader.modules.auditeventstorer.LoaderAuditParserEventHandler.endBatchProcessing(LoaderAuditParserEventHandler.java:135)
   at
com.novell.zenworks.audit.loader.modules.auditeventstorer.AuditEventStorerModule.run(AuditEventStorerModule.java:271)
   at com.novell.zenworks.loader.ZENModuleThread.run(ZENModuleThread.java:112)
Caused by: java.sql.SQLException: Cannot resolve the collation conflict between
"SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to
operation.


Cause

When the Audit database is precreated but not set to SQL_Latin1_General_CP_CI_AS, configured events will not be logged. As a result the dashboard will remain empty.

Status

Reported to Engineering