E1: UPG: UDC Merge R9600042 Ending in Error OCI0000179 - Error - ORA-12899: value too large for column "TESTCTL"."F0005"."DRDL01" (actual: 32, maximum: 30) (Doc ID 2561877.1)

Last updated on DECEMBER 28, 2022

Applies to:

Symptoms

R9600042 shows errors on the UDC Merge

70 , GC, 15.4 Error: Insert to table F0005 failed - DV920
70 , GC, 24 Error: Insert to table F0005 failed - DV920
70 , GC, 24.1 Error: Insert to table F0005 failed - DV920
70 , GC, 25 Error: Insert to table F0005 failed - DV920
70 , GC, 25.1 Error: Insert to table F0005 failed - DV920
70 , GC, 25.2 Error: Insert to table F0005 failed - DV920

Errors shown in jde.log


7512/5604 WRK:Starting jdeCallObject         Mon Jul  1 15:51:04.305000 dbperfrq.c358
OCI0000178 - Unable to execute - INSERT INTO TESTCTL.F0005 (DRSY, DRRT, DRKY, DRDL01, DRDL02, DRSPHD, DRUDCO, DRHRDC, DRUSER, DRPID, DRUPMJ, DRJOBN, DRUPMT) VALUES (:BND1,:BND2,:BND3,:BND4,:BND5,:BND6,:BND7,:BND8,:BND9,:BND10,:BND11,:BND12,:BND13)

7512/5604 WRK:Starting jdeCallObject         Mon Jul  1 15:51:04.316000 dbperfrq.c364
OCI0000179 - Error - ORA-12899: value too large for column "TESTCTL"."F0005"."DRDL01" (actual: 32, maximum: 30)

7512/5604 WRK:Starting jdeCallObject         Mon Jul  1 15:51:04.327000 jdb_drvm.c998
JDB9900401 - Failed to execute db request

7512/5604 WRK:Starting jdeCallObject         Mon Jul  1 15:51:04.337000 jdb_exet.c4319
JDB3400009 - Failed to perform Insert for F0005

Changes

Cause

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