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:

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

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