SQL Queries - CAST Measure Base - Consolidation - Check if there is a lock created for synchronization and remove it

Purpose of Query

This page provides remediation when there is a lock created for synchronization.

Applicable CAST Version

Applicable RDBMS

Query for CSS

Check if there is a lock created for synchronization

SELECT DISTINCT ( CASE
                    WHEN option_name = 'LOCK_SYNCHRO' THEN 'LOCKED'
                  END )
FROM   sys_site_options
WHERE  option_name = 'LOCK_SYNCHRO'

Query result example

LOCKED

Query result interpretation

If the query returns **"**LOCKED" then there is a lock created for the synchronization

 To remove the lock run the following query on the measure schema

DELETE
FROM   sys_site_options
WHERE  option_name = 'LOCK_SYNCHRO'

Query for Oracle

Check if there is a lock created for synchronization

SELECT DISTINCT ( CASE
                    WHEN option_name = 'LOCK_SYNCHRO' THEN 'LOCKED'
                  END )
FROM   sys_site_options
WHERE  option_name = 'LOCK_SYNCHRO'

Query result example

LOCKED

Query result interpretation

If the query returns **"**LOCKED" then there is a lock created for the synchronization

 To remove the lock run the following query on the measure schema:

DELETE
FROM   sys_site_options
WHERE  option_name = 'LOCK_SYNCHRO'

Query for SQL server

Check if there is a lock created for synchronization

SELECT DISTINCT ( CASE
                    WHEN option_name = 'LOCK_SYNCHRO' THEN 'LOCKED'
                  END )
FROM   sys_site_options
WHERE  option_name = 'LOCK_SYNCHRO'

Query result example

LOCKED

Query result interpretation

If the query returns **"**LOCKED" then there is a lock created for the synchronization

To remove the lock run the following query on the measure schema:

DELETE
FROM   sys_site_options
WHERE  option_name = 'LOCK_SYNCHRO'

Notes/comments

Related Pages