Unable to Access Collaborator Workbench, Workflow Manager After Deploying demantra.war File (Doc ID 954484.1)

Last updated on JANUARY 29, 2015

Applies to:

Oracle Demantra Demand Management - Version 11.5.10 and later
Information in this document applies to any platform.
*** Checked for relevance on 29-Aug-2013 ***

Symptoms

-- Problem Statement:
On 7.3 in Production:
When attempting to access the Demantra Collaborator Workbench after redeploying the WAR file,
the following error occurs:

ERROR
-----------------------
"An error occurred while processing the page you requested "

collaborator.log file shows:

"

[OC4J Launcher] WARN appserver.system: The system had failed to query APS_PARAMS table for system configurations. System defaults will be used.
java.sql.SQLException: ORA-00942: table or view does not exist

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)

[...]

COT [OC4J Launcher] WARN appserver.system: Missing Application Server parameter 'License.ExpirationMessage'. Using system default value (The application server failed to properly start.<BR>This could be caused by a number of issues, including network problems,
database availability or out of memory errors.<BR>Please consult your IT department or Oracle Support.).

[OC4J Launcher] ERROR appserver.error:
java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00201: identifier 'PRE_LOGON' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
"

Changes

This is a new installation . I configured Native Datasource and redeploy war file. Issue did not get resolved.

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