Informatica help

Informatica help and metadata report query

Top 5 Session Error Messages

Top 5 Session Error Messages

Displays by folder the top 5 most common error messages encountered by sessions.


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


select "REPOSITORY_NAME",
"FIRST_ERROR_MSG",
"NUM",
"SUBJECT_AREA"
from (select * from ( SELECT  SESSION_REPOSIT_INFO.REPOSITORY_NAME,  to_char(SUBSTR(SESSION_LOG.FIRST_ERROR_MSG,1,254)) as FIRST_ERROR_MSG,  ALL_SESSIONS.SUBJECT_AREA,  (COUNT(SESSION_LOG.INSTANCE_ID)) as NUM, RANK() OVER(ORDER BY (COUNT(SESSION_LOG.INSTANCE_ID)) 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(SUBSTR(SESSION_LOG.FIRST_ERROR_MSG,1,254)) IS NOT NULL) AND  (TO_CHAR(SUBSTR(SESSION_LOG.FIRST_ERROR_MSG,1,254)) <> 'No errors encountered.' )  GROUP BY  SESSION_REPOSIT_INFO.REPOSITORY_NAME,  TO_CHAR(SUBSTR(SESSION_LOG.FIRST_ERROR_MSG,1,254)),  ALL_SESSIONS.SUBJECT_AREA  HAVING ((COUNT(SESSION_LOG.INSTANCE_ID)) IS NOT NULL ))  where RANK<6) "query"

Leave a Reply

Your email address will not be published.Email address is required.

Sponsored Content


Canon EOS 5D Mark IV Full Frame Digital SLR Camera Body


Canon EF 24-70mm f/2.8L II USM Standard Zoom Lens

GoPro HERO5 Black

Canon EF 100-400mm f/4.5-5.6L IS II USM Lens

Firefield FF16001 NVRS 3x 42mm Gen 1 Night Vision Riflescope, Black

Visitors


Quantcast