Purpose of Query
This page helps to identify the list of objects with missing types.
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
SELECT DISTINCT do1.object_name AS "Invalid Object Name", do1.object_type_id AS "Missing Object Type ID", do2.object_id AS "Container ID", do2.object_name AS "Container Name", CASE do2.object_type_id WHEN -102 THEN 'Application' WHEN -101 THEN 'System' WHEN 20000 THEN 'Module' END AS "Container Type", dtt.site_id AS "Central Site ID" FROM dss_objects do1 JOIN dss_translation_table dtt ON dtt.object_id = do1.object_id JOIN dss_links dl ON dl.next_object_id = do1.object_id JOIN dss_objects do2 ON do2.object_id = dl.previous_object_id LEFT JOIN dss_object_types sot ON sot.object_type_id = do1.object_type_id WHERE sot.object_type_id IS NULL AND do1.object_type_id NOT IN ( -101, -102, 20000 )
Query result example
"xyz";138049;16419250;"ABCD";"";243
Query result interpretation
In the provided example, for application "ABCD ", represented by CB of Site Id 243 there is one object of type 138049 and this type is missing.
How to fix the issue?
- Remove the corruption from the central schema SQL Queries - CAST Central Base - Checking and removing corruptions in CB - Objects with missing types
- Remove the consolidate snapshot from the measure schema
- Consolidate the snapshot again
Query for Oracle
SELECT DISTINCT do1.object_name AS "Invalid Object Name", do1.object_type_id AS "Missing Object Type ID", do2.object_id AS "Container ID", do2.object_name AS "Container Name", CASE do2.object_type_id WHEN -102 THEN 'Application' WHEN -101 THEN 'System' WHEN 20000 THEN 'Module' END AS "Container Type", dtt.site_id AS "Central Site ID" FROM dss_objects do1 JOIN dss_translation_table dtt ON dtt.object_id = do1.object_id JOIN dss_links dl ON dl.next_object_id = do1.object_id JOIN dss_objects do2 ON do2.object_id = dl.previous_object_id LEFT JOIN dss_object_types sot ON sot.object_type_id = do1.object_type_id WHERE sot.object_type_id IS NULL AND do1.object_type_id NOT IN ( -101, -102, 20000 )
Query result example
"xyz";138049;16419250;"ABCD";"";243
Query result interpretation
In the provided example, for application "ABCD ", represented by CB of Site Id 243 there is one object of type 138049 and this type is missing
How to fix the issue?
- Remove the corruption from the central schema SQL Queries - CAST Central Base - Checking and removing corruptions in CB - Objects with missing types
- Remove the consolidate snapshot from the measure schema
- Consolidate the snapshot again
Query for SQL server
SELECT DISTINCT do1.object_name AS "Invalid Object Name", do1.object_type_id AS "Missing Object Type ID", do2.object_id AS "Container ID", do2.object_name AS "Container Name", CASE do2.object_type_id WHEN -102 THEN 'Application' WHEN -101 THEN 'System' WHEN 20000 THEN 'Module' END AS "Container Type", dtt.site_id AS "Central Site ID" FROM dss_objects do1 JOIN dss_translation_table dtt ON dtt.object_id = do1.object_id JOIN dss_links dl ON dl.next_object_id = do1.object_id JOIN dss_objects do2 ON do2.object_id = dl.previous_object_id LEFT JOIN dss_object_types sot ON sot.object_type_id = do1.object_type_id WHERE sot.object_type_id IS NULL AND do1.object_type_id NOT IN ( -101, -102, 20000 )
Query result example
"xyz";138049;16419250;"ABCD";"";243
Query result interpretation
In the provided example, for application "ABCD ", represented by CB of Site Id 243 there is one object of type 138049 and this type is missing
How to fix the issue?
- Remove the corruption from the central schema SQL Queries - CAST Central Base - Checking and removing corruptions in CB - Objects with missing types
- Remove the consolidate snapshot from the measure schema
- Consolidate the snapshot again
Notes/comments
Related Pages