My Oracle Support Banner

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 MAY 04, 2021

Applies to:

Oracle Real-Time Scheduler - Version and later
Oracle Utilities Mobile Workforce Management - Version and later
Oracle Utilities Meter Data Management - Version and later
Information in this document applies to any platform.


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.

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(
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4C8Oall.processError(
at oracle.jdbc.driver.T4CTTIfun.receive(
at oracle.jdbc.driver.T4CTTIfun.doRPC(
at oracle.jdbc.driver.T4C8Oall.doOALL(



To view full details, 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 a vibrant support community of peers and Oracle experts.