My Oracle Support Banner

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 later
Information in this document applies to any platform.

Symptoms

 

[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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.