IM ETL Failed With Java.sql.BatchUpdateException: Year Out Of Range (Doc ID 2042321.1)

Last updated on SEPTEMBER 18, 2015

Applies to:

Oracle Knowledge - Version 8.4.2.2 and later
Information in this document applies to any platform.

Symptoms

IM Log Load fails with the following exception:


"Error: log file "prodhost_imadmin_1_contentaudit.log.2015-07-21" loading failed" called with: "java.sql.BatchUpdateException: Year out of range."
2015/07/23 03:01:43 | java.sql.BatchUpdateException: Year out of range.
2015/07/23 03:01:43 |   at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10296)
2015/07/23 03:01:43 |   at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:216)
2015/07/23 03:01:43 |   at com.inquira.analytics.im.Log2Ods.loadLogFile(Log2Ods.java:438)
2015/07/23 03:01:43 |   at com.inquira.analytics.im.Log2Ods.loadLogFiles(Log2Ods.java:259)
2015/07/23 03:01:43 |   at com.inquira.analytics.im.Log2Ods.loadLogFiles(Log2Ods.java:155)
2015/07/23 03:01:43 |   at com.inquira.analytics.im.IMLoad.doWork(IMLoad.java:126)
2015/07/23 03:01:43 |   at com.inquira.analytics.OdsTask.run(OdsTask.java:267)
2015/07/23 03:01:43 |   at com.inquira.scheduler.job.Task.run(Task.java:1240)

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