Salesforce

CIMDATMERGE failed with numeric overflow error ORA-06512 / ORA-01426

Printable View
« Go Back

Information

 
TitleCIMDATMERGE failed with numeric overflow error ORA-06512 / ORA-01426
SummaryWhen trying to run the process CIMSyncPKBF to synchronize data from Foundation to Quartz Cube the process fail with ORA errors ORA-06512/ ORA-01426
URL NameCIMDATMERGE-failed-with-numeric-overflow-error-ORA-06512-ORA-01426
Resolution
  1. Delete values from Foundation and PKB staging tables where metrics with more than the necessary  digits and then reformat the data to only have the number of decimals needed
  2. Use Foundation Data Export (pkbfdatexp) as Latest to generate a file of the data and got it to run without the numeric overflow error
  3. Clear all existing data for that version
  4. Restage the data from the Foundation Data Export  (FDE) file
  5. Execute the Foundation Data Update  (FDU) and sync process for the respective cube
ProductsEnterprise Knowledge Base
ModuleCIMSyncPKBF type=data (Cimdatmerge)
Version2016.1
Error Message Code
Cim.log 

UT,PLAN_BUPP,AAAAAAAA,Start processing:  cimdatmerge / PLAN_BUPP method=D age=Y SHADOW=N ANALYZE=Y RESTART=Y trace=L:\ProgramData\JDA\EKB\plan_bupp\log\CIMSyncPKBF_DATA.trc 
E,11:10017,SQL Error -1426 while processing update transactions,5492,12/02/2017,08:18:41,2017-12-02 14:18:41 UT,PLAN_BUPP,AAAAAAAA,ORA-01426: numeric overflow ORA-06512: at line 107 
E,11:10017,SQL Error -1426 while processing update transactions,4804,12/02/2017,08:18:42,2017-12-02 14:18:42 UT,PLAN_BUPP,AAAAAAAA,ORA-01426: numeric overflow ORA-06512: at line 107 
E,11:10017,SQL Error -1426 while processing update transactions,5528,12/02/2017,08:18:43,2017-12-02 14:18:43 UT,PLAN_BUPP,AAAAAAAA,ORA-01426: numeric overflow ORA-06512: at line 101 
E,11:10017,SQL Error -1426 while processing update transactions,5900,12/02/2017,08:18:53,2017-12-02 14:18:53 UT,PLAN_BUPP,AAAAAAAA,ORA-01426: numeric overflow ORA-06512: at line 101 
I,11:10015,CIMDATMERGE,5412,12/02/2017,08:18:55,2017-12-02 14:18:55 UT,PLAN_BUPP,AAAAAAAA,Status:  Process completed with errors
I,6:10015,CIMDATUPD,5552,12/02/2017,08:18:56,2017-12-02 14:18:56 UT,PLAN_BUPP,AAAAAAAA,Status:  Process completed with errors :Exiting with error code 1
I,50:10015,CIMSYNCPKBF,6000,12/02/2017,08:18:59,2017-12-02 14:18:59 UT,PLAN_BUPP,AAAAAAAA,Status:  Process completed with errors
I,50:10015,CIMSYNCPKBF,6000,12/02/2017,08:18:59,2017-12-02 14:18:59 UT,PLAN_BUPP,AAAAAAAA,Status:  Process completed with errors

Pkbf.log

I,15:10008,PKBFDATEXP v2016.1.0.2303 Server AAAAAAAA/02/2017,17:04:23,2017-12-02 23:04:23 UT,ekb,AAAAAAAA,Start processing:  pkbfdatexp / fde_plan_bupp.xml plan_bupp.tab fmtfile=plan_bupp.fmt 
E,15:10017,SQL Error -1426 while reading FDE view EKB.PF_DEV_44410,1960,12/02/2017,17:04:35,2017-12-02 23:04:35 UT,ekb,AAAAAAAA,ORA-01426: numeric overflow 
I,15:10015,PKBFDATEXP,1960,12/02/2017,17:04:35,2017-12-02 23:04:35 UT,ekb,AAAAAAAA,Status:  Process completed with errors
I,15:10008,PKBFDATEXP v2016.1.0.2303 Server AAAAAAAA,984,12/02/2017,18:59:55,2017-12-03 00:59:55 UT,ekb,AAAAAAAA,Start processing:  pkbfdatexp / fde_plan_bupp.xml plan_bupp.tab fmtfile=plan_bupp.fmt 
E,15:10017,SQL Error -1426 while reading FDE view EKB.PF_DEV_44411,984,12/02/2017,19:00:08,2017-12-03 01:00:08 UT,ekb,AAAAAAAA,ORA-01426: numeric overflow 
I,15:10015,PKBFDATEXP,984,12/02/2017,19:00:08,2017-12-03 01:00:08 UT,ekb,AAAAA54005,Status:  Process completed with errors

 
Cause
This may occur if the data in the granite or staging tables has a column datatype number with values more than 150 digits. 
Additional Information
Number Datatype definition:
The Number datatype stores fixed and floating-point numbers. Numbers of virtually any magnitude can be stored and are guaranteed portable among different systems operating Oracle Database, up to 38 digits of precision.
The following numbers can be stored in a Number column:
  • Positive numbers in the range 1 x 10-130 to 9.99...9 x 10125 with up to 38 significant digits
  • Negative numbers from -1 x 10-130 to 9.99...99 x 10125 with up to 38 significant digits
  • Zero
Publication StatusPublished
Powered by