Authentication violation error with OEM Sybase

  • 7017756
  • 21-Jun-2016
  • 21-Jun-2016

Environment

Novell ZENworks Configuration Management 11.4 Database

Situation

The database in use is OEM Sybase.
Authentication to database works properly while zenworks loader starts up.
The following error (or similar for a different service)

[TRACE] [06/19/2016 18:05:44.551] [4624] [ZENLoader] [871] [] [Audit Admin Service] [java.sql.SQLException: ((Sybase()((JDBC Driver()((SQL Anywhere()Authentication violation

is reported in loader-messages.log when a task involving writing to the database is executed.

Resolution

- Verify the value of the setting "OEM Database" and set it to true accordingly.
Setting
<entry key="OEM Database">true</entry>
in configuration files
zdm.xml
zenaudit.xml

in folder
Linux : /etc/opt/novell/zenworks/datamodel/
Windows : %zenworks_home%\conf\datamodel\
- Restart all Zenworks services after changing the setting.