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

Release	Yes/No
8.3.x
8.2.x
8.1.x
8.0.x

Applicable RDBMS

RDBMS	Yes/No
Oracle Server
Microsoft SQL Server
CSS2

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