Unable To Deploy IWS due to "ORA-00904: "USER_LOCK"."REQUEST": invalid identifier" Becasue userlock.sql Not Run (Doc ID 2041815.1)

Last updated on APRIL 05, 2017

Applies to:

Oracle Real-Time Scheduler - Version 2.2.0 and later
Oracle Utilities Mobile Workforce Management - Version 2.2.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)

 

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