Unable To Deploy IWS due to "ORA-00904: "USER_LOCK"."REQUEST": invalid identifier" Because userlock.sql Not Run
(Doc ID 2041815.1)
Last updated on JANUARY 08, 2024
Applies to:
Oracle Real-Time Scheduler - Version 2.2.0.0.0 and laterOracle Utilities Mobile Workforce Management - Version 2.2.0.0.0 and later
Oracle Utilities Meter Data Management - Version 2.1.0.2 and later
Information in this document applies to any platform.
Symptoms
When trying to deploy the Inbound Web Services (IWS) module to the MWM/ORS environment, it errors when attempting to execute selects on F1_INSTALLATION and the Webservices.war is not deployed correctly to WLS.
STEPS
-----------------------
Perform steps as outline in Installing Oracle Real-Time Scheduler v2.2.0.3 --> Performing Post-Installation Tasks --> 3. Deploying Inbound Web Services (IWS) --> UNIX on page 49 of ORS_Installation_Guide_v2_2_0_3.pdf
The following error is seen in the iwsdeploy logs:
- 2015-08-06 19:08:27,109 [main] ERROR (support.sql.PreparedStatementImpl) Error executing iterate for rawSQL:
select user_lock.request(?, ?, ?, ?) as STATUS from F1_INSTALLATION /* locking IwsDeploy */
with 'integer' parameter named 'id' to : '167772743' to indices: 1
with 'integer' parameter named 'release' to : '1' to indices: 4
with 'integer' parameter named 'timeout' to : '2' to indices: 3
with 'integer' parameter named 'mode' to : '6' to indices: 2
java.sql.SQLSyntaxErrorException: ORA-00904: "USER_LOCK"."REQUEST": invalid identifier
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
select user_lock.request(?, ?, ?, ?) as STATUS from F1_INSTALLATION /* locking IwsDeploy */
with 'integer' parameter named 'id' to : '167772743' to indices: 1
with 'integer' parameter named 'release' to : '1' to indices: 4
with 'integer' parameter named 'timeout' to : '2' to indices: 3
with 'integer' parameter named 'mode' to : '6' to indices: 2
java.sql.SQLSyntaxErrorException: ORA-00904: "USER_LOCK"."REQUEST": invalid identifier
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
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! |