E1: UBE: 17: R17321 Amortization Workfile Generation or Custom Copy of R17321 Ends in Error Status When Executed on Large Data Sets with UBE Log Errors OCI0000179 & ORA-12599
(Doc ID 2984292.1)
Last updated on NOVEMBER 06, 2023
Applies to:
JD Edwards EnterpriseOne Tools - Version 9.2 and laterJD Edwards EnterpriseOne Service Management - Version 9.2 and later
Information in this document applies to any platform.
Symptoms
Standard JDE Reports such as R17321 (Amortization Workfile Generation) or Custom Reports which are created as copy of these reports end in ERROR status when viewed in Submitted Jobs-Submitted Job Search application(WSJ ). This issue occurs only when the reports are executed over a large data set such as 80,000 records or more. Reports used to run fine before and this behaviour is observed after a recent Database upgrade to 19C.
UBE jde log shows below messages :
19867 Sat Aug 5 13:38:45.092917 dbfetch.c163
OCI0000056 - Unable to fetch - SELECT CHDOCO, CHKCOO, CHCOCH, CHMCU, CHCO, CHCRCD, CHCRCF, CHCRRM FROM PRODDTA.F1720 WHERE ( CHDOCO = :KEY1 AND CHCOCH = :KEY2 ) AND ( ( CHCO = :KEY3 OR CHCO BETWEEN :KEY4 AND :KEY5 OR CHCO = :KEY6 ) )
19867 Sat Aug 5 13:38:45.093050 dbfetch.c169
OCI0000057 - Error - ORA-12599: TNS:cryptographic checksum mismatch
19867 Sat Aug 5 13:38:45.093229 jdb_drvm.c1060
JDB9900172 - Failed to execute db fetch
19867 Sat Aug 5 13:38:45.093658 dbperfrq.c360
OCI0000178 - Unable to execute - SELECT * FROM PRODDTA.F1794 WHERE ( NKDOCO = :KEY1 AND NKDCTO = :KEY2 AND NKKCOO = :KEY3 AND NKCOCH = :KEY4 AND NKLNID = :KEY5 AND NKGENT = :KEY6 AND NKCTRY = :KEY7 AND NKFY = :KEY8 )
19867 Sat Aug 5 13:38:45.093777 dbperfrq.c366
OCI0000179 - Error - ORA-03114: not connected to ORACLE
19867 Sat Aug 5 13:38:45.093881 jdb_drvm.c1000
JDB9900401 - Failed to execute db request
19867 Sat Aug 5 13:38:45.093984 jtp_cm.c1368
JDB9900255 - Database connection to F1794 (Business Data - PROD) has been lost.
INFO: Entering kernel signal handler, process exiting soon: iParam: 00000000001691239125
INFO: Entering kernel signal handler, with signal: iParam: 00000000000000000011
INFO: In kernel signal handler, starting alarm handler: iParam: 00000000001691239126
INFO: Done setting IPC Handle State structures to abandoned, process exiting immediately: iParam: 00000000001691239126
Changes
Database Upgrade to 19C
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 |
| Changes |
| Cause |
| Solution |
| References |