Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Year out of range error

User630376-OracleFeb 22 2011 — edited Feb 23 2011
We are getting below error:
oracle.odi.runtime.agent.ExecutionException: Session Failed :3044 : 17268 :
99999 : java.sql.BatchUpdateException: Year out of range.17268 : 99999 :
java.sql.SQLException: Year out of range.
java.sql.BatchUpdateException: Year out of range.

We are running ODI scenario and it tries to read from source and load into target both Oracle.
In the source there is one row with Date value as ‘01-01-4712 00:00:00’ (BC date). that gives mentioned error.
ODI APIs on WebLogic 10.3.4 and ojdbc6dms.jar gets used. Same jar used from 10.3.3 works fine.

Can anyone suggest anything.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 23 2011
Added on Feb 22 2011
#general-database-discussions
3 comments
10,065 views