Troubleshooting
Problem
Error ORA-01455 is seen within Optim products against Oracle 11.2 and later.
Symptom
The following examples have been seen with this underlying problem:
- After installing Optim for Oracle eBusiness 6.0 connected to an Oracle 11.2 database, importing the templates for module AR and OM may fail with the following error message:
primary key on:
apps_optim_candidate
"Unable To Import Primary Key.
R12ARC.APPS.OPTIM_CANDIDATES
ORA-01455 converting collumn overflows integer datatype"
The template import fails. - The following error can be seen when attempting to restore a table from archive:
Internal error: ORA-01455: overflow of integer type on conversion of column (7500)
[{"Product":{"code":"SSMLQ4","label":"IBM InfoSphere Optim Test Data Management Solution"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF033","label":"Windows"}],"Version":"7.1.0;7.1.1;7.1.2;7.2;7.2.0;7.2.1;7.2.2;7.3;7.3.1","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
08 July 2021
UID
swg21506554