E1: ESU: ESU Patch Not Applying To A Single Pathcode Or Environment - OCI0000178/ OCI0000179 / JDB9900401/ JDB3400009 / JDB9900170 Errors (Doc ID 1276726.1)

Last updated on MAY 30, 2017

Applies to:

JD Edwards EnterpriseOne Tools - Version 8.98 and later
Information in this document applies to any platform.

Symptoms

EnterpriseOne 9.0. ESU patch not applying to a single pathcode or environment, in this case here customer is trying to apply an ESU to PY900 environment.  Errors in jde.log:

7232/4684 MAIN_THREAD Wed Dec 22 14:00:18.890000 Jdb_ctl.c3944        Starting OneWorld
7232/4020 WRK:Starting jdeCallObject Wed Dec 22 14:16:22.008000 B9600490.c1916     Verify Deployment Package (F98403): JL16095 Environment: PY900
7232/4020 WRK:Starting jdeCallObject Wed Dec 22 14:16:22.008001 B9600490.c1916     Dependent Objects Verified
7232/4020 WRK:Starting jdeCallObject Wed Dec 22 14:16:32.524000 Jdb_rq1.c1346        JDB3100080 - Failed to get XML Stream Reader or Writer for XML file: F045145.xml in directory: D:\JDEdwards\E900\Planner\Data\JL16095.
7232/4020 WRK:Starting jdeCallObject Wed Dec 22 14:16:46.368000 dbperfrq.c456        OCI0000178 - Unable to execute - INSERT INTO SY900.F98611 (OMENHV, OMDATP, OMSRVR, OMDATB, OMOOWN, OMDLLNAME, OMLL, OMLIB, OMOMUI, OMOMTO, OMOMDS, OMOMJD, OMOMCC, OMDSTP, OMPID, OMDATUSE, OMUSER, OMOCM1, OMJOBN, OMOCM2, OMUPMJ, OMOCM3, OMUPMT, OMOCMA, OMOCMB, OMOCMC, OMOCMDSC, OMDATB2, OMDBINST, OMSVRPORT, OMJDBNET, OMUNICODE, OMLOBFLG, OMDSFC30, OMDSFC10, OMDSFF1) VALUES (:BND1,:BND2,:BND3,:BND4,:BND5,:BND6,:BND7,:BND8,:BND9,:BND10,:BND11,:BND12,:BND13,:BND14,:BND15,:BND16,:BND17,:BND18,:BND19,:BND20,:BND21,:BND22,:BND23,:BND24,:BND25,:BND26,:BND27,:BND28,:BND29,:BND30,:BND31,:BND32,:BND33,:BND34,:BND35,:BND36)
7232/4020 WRK:Starting jdeCallObject Wed Dec 22 14:16:46.368001 dbperfrq.c462        OCI0000179 - Error - ORA-00001: unique constraint (SY900.F98611_PK) violated
7232/4020 WRK:Starting jdeCallObject Wed Dec 22 14:16:46.368002 Jdb_drvm.c1116     JDB9900401 - Failed to execute db request
7232/4020 WRK:Starting jdeCallObject Wed Dec 22 14:16:46.368003 Jdb_exet.c6144      JDB3400009 - Failed to perform Insert for F98611
7232/4020 WRK:Starting jdeCallObject Wed Dec 22 14:16:47.431000 dbperfrq.c456        OCI0000178 - Unable to execute - SELECT COUNT(*) FROM TA900.F98761 WHERE ( RSOBNM = :KEY1 AND RSVERS = :KEY2 )
7232/4020 WRK:Starting jdeCallObject Wed Dec 22 14:16:47.431001 dbperfrq.c462        OCI0000179 - Error - ORA-00942: table or view does not exist
7232/4020 WRK:Starting jdeCallObject Wed Dec 22 14:16:47.431002 Jdb_drvm.c1110     JDB9900170 - Failed to execute db request

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms