Top 10 Sessions with Rejected Rows(Yesterday)

Displays the top 10 sessions that had the most number of rows rejected. This cached report is attached to the Midnight Daily schedule, where it runs everyday at midnight.


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


select "NO_FAILED_ROWS",
"SUBJECT_AREA",
"SESSION_INSTANCE_NAME",
"WORKFLOW_NAME",
"REPOSITORY_NAME",
"ACTUAL_START"
from (select *  from( SELECT  SESSION_REPOSIT_INFO.REPOSITORY_NAME,  SESSION_LOG.SESSION_INSTANCE_NAME,  ALL_SESSIONS.SUBJECT_AREA,  SESSION_LOG.WORKFLOW_NAME,  TO_CHAR(SESSION_LOG.ACTUAL_START,'DD-MON-YYYY') as ACTUAL_START,  (SUM(SESSION_LOG.FAILED_ROWS))  as no_failed_rows, RANK() OVER(ORDER BY (SUM(SESSION_LOG.FAILED_ROWS)) desc) as RANK FROM  REP_LOAD_SESSIONS ALL_SESSIONS,  REP_SESS_LOG SESSION_LOG,  REP_REPOSIT_INFO SESSION_REPOSIT_INFO  WHERE  (ALL_SESSIONS.SESSION_ID = SESSION_LOG.SESSION_ID AND  ALL_SESSIONS.SESSION_VERSION_NUMBER = SESSION_LOG.TASK_VERSION_NUMBER AND  ALL_SESSIONS.SESSION_ID <> SESSION_REPOSIT_INFO.REPOSITORY_ID) and    (TO_CHAR(SESSION_LOG.ACTUAL_START,'DD-MON-YYYY') = TO_CHAR(SYSDATE-1,'DD-MON-YYYY'))   GROUP BY  SESSION_REPOSIT_INFO.REPOSITORY_NAME,  SESSION_LOG.SESSION_INSTANCE_NAME,  ALL_SESSIONS.SUBJECT_AREA,  SESSION_LOG.WORKFLOW_NAME,  TO_CHAR(SESSION_LOG.ACTUAL_START,'DD-MON-YYYY')  HAVING  (SUM(SESSION_LOG.FAILED_ROWS)) > 0 AND  (SUM(SESSION_LOG.FAILED_ROWS)) IS NOT NULL ) where RANK<6) "query"
order by "REPOSITORY_NAME", "SESSION_INSTANCE_NAME", "ACTUAL_START", "NO_FAILED_ROWS"

Leave a Comment

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>
*
*