My Oracle Support Banner

ODI Scenario Regeneration Fails with ODI-10207 and "ORA-03120: two-task conversion routine: integer overflow" (Doc ID 2603834.1)

Last updated on APRIL 10, 2020

Applies to:

Oracle Data Integrator - Version 11.1.1.9.0 and later
Information in this document applies to any platform.

Symptoms

Regenerating package scenarios in Oracle Data Integrator (ODI) results in the following error:

oracle.odi.core.persistence.transaction.TransactionSystemException: ODI-10207: Uncategorized exception during transaction system usage.
Internal Exception: java.sql.SQLException: ORA-03120: two-task conversion routine: integer overflow
Error Code: 3120

 

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.