Loading Audit Data into Microsoft SQL Server Database Fails with Error " Invalid object name 'V$NLS_PARAMETERS' "
(Doc ID 3074639.1)
Last updated on MARCH 08, 2025
Applies to:
Oracle Platform Security for Java - Version 12.2.1.4.210418 and laterInformation in this document applies to any platform.
Symptoms
- OAS Domain
- Using MS SQL Server Database for loading Audit Data
- The audit logs are generated at the bus-stop file location. But the data is not getting loaded to the DB
- BI Server log shows the following error stack
[oracle.jps.common] [tid: [ACTIVE].ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: <ecid>] [partition-name: DOMAIN] [tenant-name: GLOBAL] IAU:IAU-5047: Problem in transferring audit record from file:<domain_home>/servers/bi_server1/logs/auditlogs/bipublisher/audit_1_0-34.log position:2,509 will retry in next cycle. caught exception oracle.security.audit.AuditException: java.sql.SQLSyntaxErrorException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Invalid object name 'V$NLS_PARAMETERS'.[[
at oracle.security.audit.ajl.loader.OracleRepository.getCharacterSet(OracleRepository.java:147)
at oracle.security.audit.ajl.loader.OracleRepository.createConnectionFromDatasource(OracleRepository.java:84)
at oracle.security.audit.ajl.loader.OracleRepository.<init>(OracleRepository.java:66)
at oracle.security.audit.ajl.loader.DatabaseRepository.getInstance(DatabaseRepository.java:190)
at oracle.security.audit.ajl.loader.JDBCLogWriter.reinit(JDBCLogWriter.java:95)
at oracle.security.audit.ajl.loader.JDBCLogWriter.write(JDBCLogWriter.java:134)
at oracle.security.audit.ajl.loader.AuditLoader.writeMessages(AuditLoader.java:625)
at oracle.security.audit.ajl.loader.AuditLoader.readBusstopMessages(AuditLoader.java:575)
at oracle.security.audit.ajl.loader.AuditLoader.readMessages(AuditLoader.java:484)
at oracle.security.audit.service.AuditLoaderManager.readMessages(AuditLoaderManager.java:451)
at oracle.security.audit.service.AuditLoaderManager$Runner.run(AuditLoaderManager.java:528)
at javax.enterprise.concurrent.ManagedExecutors$RunnableAdapter.run(ManagedExecutors.java:211)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at weblogic.work.concurrent.TaskWrapper.call(TaskWrapper.java:151)
at weblogic.work.concurrent.future.AbstractFutureImpl.runTask(AbstractFutureImpl.java:391)
at weblogic.work.concurrent.future.AbstractFutureImpl.doRun(AbstractFutureImpl.java:436)
at weblogic.work.concurrent.future.ManagedScheduledFutureImpl.timerExpired(ManagedScheduledFutureImpl.java:86)
at weblogic.work.concurrent.future.ManagedPeriodFutureImpl.timerExpired(ManagedPeriodFutureImpl.java:97)
at weblogic.timers.internal.TimerImpl.run(TimerImpl.java:301)
at weblogic.work.concurrent.future.ManagedScheduledFutureImpl.run(ManagedScheduledFutureImpl.java:96)
at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:352)
at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:337)
at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:57)
at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41)
at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:655)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:420)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:360)
Caused by: java.sql.SQLSyntaxErrorException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Invalid object name 'V$NLS_PARAMETERS'.
at weblogic.jdbc.sqlserverbase.ddco.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddco.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddco.a(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddr.v(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddr.c(Unknown Source)
at weblogic.jdbc.sqlserver.dda4.m(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddev.e(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddev.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddev.x(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddev.w(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddev.executeQuery(Unknown Source)
at weblogic.jdbc.wrapper.Statement.executeQuery(Statement.java:499)
at oracle.security.audit.ajl.loader.DatabaseRepository.query(DatabaseRepository.java:102)
at oracle.security.audit.ajl.loader.OracleRepository.getCharacterSet(OracleRepository.java:140)
... 26 more
]]
[ERROR] [] [oracle.jps.common] [tid: [ACTIVE].ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: <ecid>] [partition-name: DOMAIN] [tenant-name: GLOBAL] IAU:IAU-5048: Problem in transferring audit record to Audit Store null null. Please verify your Audit Store configuration
[ERROR] [] [oracle.jps.common] [tid: [ACTIVE].ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: <ecid>] [partition-name: DOMAIN] [tenant-name: GLOBAL] IAU:Could not resume reading <domain_home>/servers/bi_server1/logs/auditlogs/bipublisher/audit_1_0-1.log. Digest mismatch
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |