My Oracle Support Banner

LSH: WA Installation Error "Locked By User" And "User Doesnt Have Privileges To Modify" (Doc ID 2444566.1)

Last updated on MARCH 08, 2021

Applies to:

Oracle Life Sciences Data Hub - Version 2.4.6 and later
Information in this document applies to any platform.

Symptoms

LSH 2.4, users are seeing the following error message in the LSH UI:

1. Invalid Validation Failed : Domain > Application Area > Work Area > Data Model > Program Name Locked by user
2. Invalid Validation Failed : Domain > Application Area > Work Area > Data Model > Program Name Locked by user
3. Invalid Validation Failed : Domain > Application Area > Work Area > Data Model > Program Name Locked by user
4. Invalid Validation Failed : Domain > Application Area > Work Area > Data Model > Program Name Locked by user
5. Invalid Validation Failed : Domain > Application Area > Work Area > Data Model > Program Name Locked by user
Invalid Validation Failed : User doesnt have privileges to modify all the programs which read from the table selected for install.


o This behavior happens in multi user scenario


STEPS TO REPLICATE
===============
In Domain DOM1 with user1
-- Create application area : AA1_SRC
-- Create workarea : WA1_SRC
-- Create PLSQL program PRG_SRC
-- Create Table descriptor with MDD attached (EMP_TABLE, DEPT) tables (dataMDD.zip)
-- Create TI from TD

-- Add source code for PLSQL:
(null code)


CREATE OR REPLACE PACKAGE PKG AS
procedure MAIN;
end PKG;


CREATE OR REPLACE PACKAGE BODY PKG AS
procedure MAIN is
begin
NULL;
end MAIN;
end PKG;


Install WA1_SRC
logout

In Domain DOM II with veronica.w
-- Create application area : AA1_TRG
-- Create workarea : WA1_TRG
-- Create PLSQL program PRG_TRG
-- Add source tables from AA1_SRC -- WA1_SRC
-- Add source code for PLSQL:

CREATE OR REPLACE PACKAGE PKG AS
procedure MAIN;
end PKG;

CREATE OR REPLACE PACKAGE BODY PKG AS
procedure MAIN is
begin
NULL;
end MAIN;
end PKG;

-- Install WA1_TRG
-- Navigate to program instance AA1_TRG--> WA1_TRG -> PRG_TRG, and update description (PRG_TRG program instance should be implicitly checked out, NO explicit checkout required)
-- logout
-- login as user1
-- Checkout table instance AA1_SRC -- WA1_SRC -- Dept
-- Add column to table instance and modify table instance "Blinding Flag" to "No".
-- Update PRG_SRC's dept table descriptor with latest version of dept table definition and complete mapping
(All objects in AA1_SRC -- WA1_SRC workarea should installable )
-- Do upgrade install for Dept table instance and PRG_SRC
-- Expected error on UI

 

Error
Install Validation Failed : dom II > AA1_TRG > WA1_TRG > PRG_TRG Locked by <MY_DMW_USERID>
Install Validation Failed : User doesnt have privileges to modify all the programs which read from the table selected for install.

Changes

 

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


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