E1: PKG: Spec Tables Not Deleted During Package Deletion - Oracle Database - Error: PKGENG0036 - Failed To Delete Package Spec Repository
(Doc ID 657758.1)
Last updated on DECEMBER 12, 2022
Applies to:
JD Edwards EnterpriseOne Tools - Version 8.98 and laterInformation in this document applies to any platform.
Symptoms
In EnterpriseOne using Oracle database, when a package is deleted from Package Build P9621 / Package Assembly P9601 applications from the EnterpriseOne fat client machine, the Package Spec tables are not deleted from the database. The following errors appear in the JDE.LOG and package build kernel log:
jde.log:
5160/368 WRK:Starting jdeCallObject Tue Sep 18 11:14:54.666001 dbperfrq.c449
OCI0000178 - Unable to execute - DROP TABLE DV812.F98762DVMP0005
5160/368 WRK:Starting jdeCallObject Tue Sep 18 11:14:54.682001 dbperfrq.c455
OCI0000179 - Error - ORA-01031: insufficient privileges
5160/368 WRK:Starting jdeCallObject Tue Sep 18 11:14:54.682003 Jdb_drvm.c982
JDB9900401 - Failed to execute db request
5160/368 WRK:Starting jdeCallObject Tue Sep 18 11:14:54.682005 Jdb_exem.c1563
JDB9900827 - Failed to drop table F98762
. . . [More DROP TABLE error messages for other Spec Tables]
5160/368 WRK:Starting jdeCallObject Tue Sep 18 11:14:55.869025 spkgeng.c1136
PKGENG0036 - Failed to delete package spec repository.
pkg build kernel log:
OCI0000178 - Unable to execute - GRANT INDEX ON DV920.F98762DVUFE30 TO JDEADMIN
OCI0000179 - Error - ORA-01931: cannot grant INDEX to a role
JDB9900401 - Failed to execute db request
OCI0000178 - Unable to execute - DROP TABLE DV920.F98762DVUFE30
OCI0000179 - Error - ORA-01031: insufficient privileges
JDB9900401 - Failed to execute db request
JDB9900827 - Failed to drop table F98762
PKGENG0036 - Failed to delete package spec repository.
5160/368 WRK:Starting jdeCallObject Tue Sep 18 11:14:54.666001 dbperfrq.c449
OCI0000178 - Unable to execute - DROP TABLE DV812.F98762DVMP0005
5160/368 WRK:Starting jdeCallObject Tue Sep 18 11:14:54.682001 dbperfrq.c455
OCI0000179 - Error - ORA-01031: insufficient privileges
5160/368 WRK:Starting jdeCallObject Tue Sep 18 11:14:54.682003 Jdb_drvm.c982
JDB9900401 - Failed to execute db request
5160/368 WRK:Starting jdeCallObject Tue Sep 18 11:14:54.682005 Jdb_exem.c1563
JDB9900827 - Failed to drop table F98762
. . . [More DROP TABLE error messages for other Spec Tables]
5160/368 WRK:Starting jdeCallObject Tue Sep 18 11:14:55.869025 spkgeng.c1136
PKGENG0036 - Failed to delete package spec repository.
pkg build kernel log:
OCI0000178 - Unable to execute - GRANT INDEX ON DV920.F98762DVUFE30 TO JDEADMIN
OCI0000179 - Error - ORA-01931: cannot grant INDEX to a role
JDB9900401 - Failed to execute db request
OCI0000178 - Unable to execute - DROP TABLE DV920.F98762DVUFE30
OCI0000179 - Error - ORA-01031: insufficient privileges
JDB9900401 - Failed to execute db request
JDB9900827 - Failed to drop table F98762
PKGENG0036 - Failed to delete package spec repository.
Changes
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 |