My Oracle Support Banner

Agile Application Server Fails to Start up with Error PLS-00201: Identifier 'get_agile_object_id' Must Be Declared After Installation (Doc ID 2473195.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Agile PLM Framework - Version 9.3.6.0 and later
Information in this document applies to any platform.

Symptoms

Agile Application fails to start up after installing Agile 9.3.6 for the first time with below error in the Agile Application Server log

Error

AgileAuthenticationProviderImpl.initialize
java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00201: identifier 'GET_AGILE_OBJECT_ID' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1113)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:603)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:228)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:49)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1000)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1316)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:5010)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:5195)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:10814)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1546)
at com.agile.admin.security.userregistry.OracleDataObjectIDGenerator2.getIDImpl(OracleDataObjectIDGenerator2.java:55)
at com.agile.admin.security.userregistry.OracleIDGenerator2.getNextIDImpl(OracleIDGenerator2.java:94)
at com.agile.admin.security.userregistry.IDGenerator2.getNextID(IDGenerator2.java:101)
at com.agile.admin.security.userregistry.DBUserAdapter.logFailure(DBUserAdapter.java:1100)
at com.agile.admin.security.weblogic.WLSLoginModule.logFailure(WLSLoginModule.java:302)
at com.agile.admin.security.weblogic.WLSLoginModule.login(WLSLoginModule.java:259)




Steps

The issue can be reproduced at will with the following steps:
1. Install Agile database schema
2. Install Agile PLM
2. Start Agile Application Server




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
Cause
Solution
References


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