Invalid Mapping sessions

Displays sessions that are created for invalid mappings by repository and folder.

Click on the text to copy the query report to your clipboard.


select "SESSION_INSTANCE_NAME",
"SUBJECT_AREA",
"REPOSITORY_NAME",
"MAPPING_NAME",
"SESSION_INSTANCE_ID"
from (SELECT  MAPPING_REPOSIT_INFO.REPOSITORY_NAME,  ALL_MAPPINGS.SUBJECT_AREA,  ALL_MAPPINGS.MAPPING_NAME,  MAPPING_SESSION_INSTANCES.SESSION_INSTANCE_NAME,                ALL_MAPPINGS.PARENT_MAPPING_IS_VALID as PARENT_MAPPING_IS_VALID,  (COUNT(MAPPING_SESSION_INSTANCES.SESSION_INSTANCE_ID)) as SESSION_INSTANCE_ID FROM  REP_SESSION_INSTANCES MAPPING_SESSION_INSTANCES,  REP_REPOSIT_INFO MAPPING_REPOSIT_INFO,  REP_ALL_MAPPINGS ALL_MAPPINGS    LEFT OUTER JOIN REP_SESS_PARTITION_DEF MAPPING_SESS_PARTITION_DEF    ON ALL_MAPPINGS.PARENT_MAPPING_ID = MAPPING_SESS_PARTITION_DEF.   MAPPING_ID  WHERE  (MAPPING_SESSION_INSTANCES.SESSION_ID = MAPPING_SESS_PARTITION_DEF.  SESSION_ID AND  MAPPING_SESSION_INSTANCES.SESSION_VERSION_NUMBER =   MAPPING_SESS_PARTITION_DEF.VERSION_NUMBER AND  ALL_MAPPINGS.PARENT_MAPPING_ID <> MAPPING_REPOSIT_INFO.REPOSITORY_ID) AND   ALL_MAPPINGS.PARENT_MAPPING_IS_VALID = 0     GROUP BY  MAPPING_REPOSIT_INFO.REPOSITORY_NAME,  ALL_MAPPINGS.SUBJECT_AREA,  ALL_MAPPINGS.MAPPING_NAME,                  PARENT_MAPPING_IS_VALID,  MAPPING_SESSION_INSTANCES.SESSION_INSTANCE_NAME  HAVING  (COUNT(MAPPING_SESSION_INSTANCES.SESSION_INSTANCE_ID)) > 0) "query"
where case when ("PARENT_MAPPING_IS_VALID" = 1) then ('Yes') else ('No') end = 'No' and "SUBJECT_AREA" in ('<Folder_Name>') and "SESSION_INSTANCE_ID" > 0
order by "REPOSITORY_NAME", "SUBJECT_AREA", "MAPPING_NAME", "SESSION_INSTANCE_NAME", "SESSION_INSTANCE_ID"