Return
-
Title
How to unlock read only objects within a closed CSR -
Description
After closing a CSR, most of the objects within it stay locked and in read only mode, so that you cannot perform the action of unlocking. How can you unlock these objects like the others included in the CSR? -
Resolution
Solution:
1. Please check if there is data in this table for the CSR:
SELECT * FROM MERC_PSOBJ_EVENT
WHERE PROCESS_STATUS<>2
AND SD_CD=’ENTER_SERVICE_DOMAIN’
AND CSR_ID=ENTER_CSR_ID
2. If there are any rows returned back for the CSR, then run this update:
UPDATE MERC_PSOBJ_EVENT
SET PROCESS_STATUS=2
WHERE PROCESS_STATUS<>2
AND SD_CD=’ENTER_SERVICE_DOMAIN’
AND CSR_ID=ENTER_CSR_ID;
COMMIT;
Afterwards, open up the CSR | Objects tab and manually unlock those objects that have a lock on them.