Audit DB datasource (auditDbDataSource) not bound (Legacy_Onyx KB Id: 203746)

Document ID : KB000054860
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

I received these error messages for all IME at JBOSS startup:

... ERROR [ims] Invalid audit data source for IME "Gestione Dipendenti" : data source name ""
... ERROR [ims] Invalid audit data source for IME "Gestione Canali" : data source name ""
... ERROR [ims] Invalid audit data source for IME "test" : data source name ""

Then I tried to make an Export/Import about Audit settings XML file for the first environment, editing the "datasource" line:

Old line: &ltAudit enabled="false" auditlevel="NONE" datasource="">
New line: &ltAudit enabled="false" auditlevel="NONE" datasource="auditDbDataSource">

but a have this new error message
... ERROR [ims] Setting up Audit DB Connection for IME "Gestione Dipendenti" failed with error "Failed to load Database driver "auditDbDataSource" with error "auditDbDataSource not bound""

Note: following the JBOSS audit database service configuration file (imauditdb-ds.xml)
...
&ltdatasources>
&ltlocal-tx-datasource>
&ltjndi-name>auditDbDataSource</jndi-name>

<!-- Oracle
&ltconnection-url>jdbc:oracle:thin:@DBMACHINENAME:1521:AUDIT_STORE</connection-url>
&ltdriver-class>oracle.jdbc.driver.OracleDriver</driver-class>
-->

<!-- SQL Server -->
&ltconnection-url>jdbc:microsoft:sqlserver://96.58.20.56:1433;selectMethod=cursor;DatabaseName=IM_AUSTORE</connection-url>
&ltdriver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>

&ltuser-name>im_auuser</user-name>
&ltpassword>*********</password>
&ltmin-pool-size>5</min-pool-size>
&ltmax-pool-size>20</max-pool-size>
&ltidle-timeout-minutes>5</idle-timeout-minutes>
&ltblocking-timeout-millis>5000</blocking-timeout-millis>

&ltcheck-valid-connection-sql>select 1</check-valid-connection-sql>

</local-tx-datasource>
</datasources>
...

Note: db login credentials (user-name/password) are correct (checked by SQL Query Analizer).


Solution:

Datasource value in AuditSettings.xml should be written as "java:/auditDbDataSource" instead of "auditDbDataSource" as IMWE configuration guide v6.0 suggests.

imauditdb-ds.xml should be "...&ltjndi-name>auditDbDataSource</jndi-name>..." .