Siebel SQLs/Error Messages >  Siebel Merge and Project Locking

Siebel Merge and Project Locking:

Deployment of Artifacts
You can correctly activate Workflows with this SQL

UPDATE SIEBEL.S_WFR_PROC
SET STATUS_CD = 'NOT_IN_USE'
WHERE ROW_ID IN (
SELECT proc.ROW_ID
FROM SIEBEL.S_WFR_PROC proc
WHERE proc.STATUS_CD = 'COMPLETED'
AND proc.PROC_NAME IN (
SELECT PROC_NAME
FROM SIEBEL.S_WFR_PROC
WHERE STATUS_CD = 'COMPLETED'
GROUP BY PROC_NAME
HAVING Count(*) > 1
) AND proc.CREATED <> (
SELECT Max(uproc.CREATED)
FROM SIEBEL.S_WFR_PROC uproc
WHERE STATUS_CD = 'COMPLETED'
AND uproc.PROC_NAME = proc.PROC_NAME
)
);

You can lock projects with this SQL in Repository:

UPDATE SIEBEL.S_PROJECT
SET LOCKED_BY = (SELECT ROW_ID FROM SIEBEL.S_USER WHERE UPPER(LOGIN) = 'YOUR_SIEBEL_LOGIN'),
LOCKED_FLG = 'Y',
LOCKED_DATE = SYSDATE,
LOCKED_LANG = 'ENU';

UPDATE SIEBEL.S_PROJECT
SET LOCKED_BY = NULL,
LOCKED_FLG = 'N',
LOCKED_DATE = NULL,
LOCKED_LANG = NULL;

COMMIT;