My Oracle Support Banner

Workarea Installation Failure "ORA-04042: procedure, function, package, or package body does not exist" and "Error during Workarea Install" (Doc ID 2685881.1)

Last updated on FEBRUARY 20, 2023

Applies to:

Oracle Life Sciences Data Hub - Version 2.4.9.1 and later
Information in this document applies to any platform.

Symptoms

On Oracle Life Sciences Data Hub (LSH) 2.4.9.1, a specific Work Area installation is encountering the following error message in the Work Area installation log:


Work Area Installation Log
=================

ERROR: Error during Workarea Install : There are errors during OWB deployment. See install log for details.

AND

/* Grants on the main Package for Program Obj Id <OBJECT ID> in Workarea Obj Id - <WORK AREA OBJECT ID> */
GRANT EXECUTE ON <PACKAGE> TO PUBLIC
Revoking privileges from the primary schema
Revoking the SELECT ANY DICTIONARY from the <SCHEMA NAME>
There are errors during OWB deployment. See install log for details

 

 

OWB Log
========

2020/06/18-20:08:01-CEST [7162E295][CDR_RTREPOS.CDR_RTREPOS] java.sql.SQLException: ORA-04042: procedure, function, package, or package body does not exist
at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:777)
at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:673)
at oracle.jdbc.driver.T2CStatement.executeForDescribe(T2CStatement.java:765)

 

 

Changes

 Users may have made changes to the Program Source Code.

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


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