My Oracle Support Banner

Transformation Job Fails with 'ORA-01438: value larger than specified precision allowed for this column' (Doc ID 2883300.1)

Last updated on JULY 15, 2022

Applies to:

Oracle Health Sciences Data Management Workbench - Version 2.5.2 and later
Information in this document applies to any platform.

Symptoms

On Oracle Health Sciences Data Management Workbench (DMW) 2.5.2 version,

When attempting to submit a transformation job,
the following error occurs:

ERROR
-----------------------

******************** ERROR ********************
Error from OWB/CDR DB Server-PLSQL Operator: statement:"begin CDR_W###_#######_1.PKG_EBDRECON.PRC_EBDRECON ; end;" caught:java.sql.SQLDataException: ORA-01438: value larger than specified precision allowed for this column
ORA-06512: at "CDR_W###_#######_1.PKG_EBDRECON", line 7
ORA-06512: at line 1
******************** ERROR ********************


STEPS
-----------------------
The issue can be reproduced with the following steps:
1. Login to DMW.
2. Select a study in Development lifecycle.
3. Navigate to a transformation.
4. Add one more table to that transformation.
5. Install the transformation.
6. Submit the transformation.

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.