BI Publisher11g OBIEE Datasource Report Auditing Is Not Working And DB Table IAU_BASE Is not Updated Due To 'java.lang.NumberFormatException.forInputString' Errors (Doc ID 2085513.1)

Last updated on JULY 20, 2016

Applies to:

BI Publisher (formerly XML Publisher) - Version 11.1.1.7.x to 11.1.1.9.0 [Release 11.1]
Information in this document applies to any platform.

Symptoms

BI Publisher is integrated with OBIEE BIEE. After setting up 11g OBIEE datasource auditing, the IAU_BASE table is empty.

Analytics does successfully populate the S_NQ_ACCT DB table.

The audit details are only written into $DOMAIN_HOME/servers/bi_server1/logs/auditlogs/xmlpserver/audit.log, and not written into DB. No error messages are received.

The following setup documentation was used:

<Note 1939128.1> - OBIEE 11g - How To Configure Audit Datasource

and

Administrator's Guide for Oracle Business Intelligence Publisher

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms