CA11.0.8: Sample Audit reports not working after successful setup steps

[screwdrive]

Followed all the steps for setting up the Audit package and Sample audit reports as per below knowledge note but getting below error when run any sample audit reports.-

http://www-01.ibm.com/support/docview.wss?uid=swg21996317


Error: XQE-DAT-0001 Data source adapter error: java.sql.SQLException: ORA-08103: object no longer exists.

COGNOS ANALYTICS: 11.0.8 version on Linux X86_64 platform.
AUDIT data source connection succeeds

Audit DB is based of the Linux X86_64 and its version is Oracle 12c - 12.2.0.1.0 64-bit. And on BI server, we have 32-bit client installed.

Drivers are present and actually this is production environment with content store up and running since long. THe content store reside in a different scehma than Audit store on the same database server.