Audit Log fails for OAM version 11.1.2.1.2 Error caught exception oracle.security.audit.AuditException: java.sql.SQLException: Year out of range.

(Doc ID 2086696.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Access Manager - Version 11.1.2.1.0 and later
Information in this document applies to any platform.

Symptoms

Need fix for Error copied below:

[2015-08-27T14:44:12.959-04:00] [oam_server1] [ERROR] [] [oracle.jps.audit] [tid: AuditLoaderRunner] [userId: <WLS Kernel>] [ecid: 4b381c1128830a76:-165a289:14ec2306372:-8000-0000000000000007,0] IAU:IAU-5047: Problem in transferring audit record from file:/webapps/domains/AMDomain/servers/oam_server1/logs/auditlogs/OAM/audit.log position:9,094,358 will retry in next cycle. caught exception oracle.security.audit.AuditException: java.sql.SQLException: Year out of range.[[
at oracle.security.audit.ajl.loader.standard.OracleStandardComponentDataWriter.write(OracleStandardComponentDataWriter.java:237)
at oracle.security.audit.ajl.loader.AuditLoader.readMessages(AuditLoader.java:488)
at oracle.security.audit.service.AuditLoaderManager.readMessages(AuditLoaderManager.java:210)
at oracle.security.audit.service.AuditLoaderManager$Runner.run(AuditLoaderManager.java:284)
Caused by: java.sql.SQLException: Year out of range.
at oracle.jdbc.driver.DateCommonBinder.setOracleCYMD(OraclePreparedStatement.java:24355)
at oracle.jdbc.driver.TimestampBinder.bind(OraclePreparedStatement.java:24741)
at oracle.jdbc.driver.OraclePreparedStatement.setupBindBuffers(OraclePreparedStatement.java:3278)
at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:2475)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3764)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3904)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1512)
at weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:172)
at oracle.security.audit.ajl.loader.standard.OracleStandardComponentDataWriter.write(OracleStandardComponentDataWriter.java:198)
at oracle.security.audit.ajl.loader.ChainComponentDataWriter.write(ChainComponentDataWriter.java:66)
at oracle.security.audit.ajl.loader.JDBCLogWriter.write(JDBCLogWriter.java:107)
at oracle.security.audit.ajl.loader.AuditLoader.readMessages(AuditLoader.java:488)
at oracle.security.audit.service.AuditLoaderManager.readMessages(AuditLoaderManager.java:209)
... 1 more

]]

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