Operations reports
This page will show you all the Available reports for Operations reports, once you select a report name, it will open the report query page. copy and paste it to your PC and run it from, toad or any other DB tools you have.
Available Reports
Session Execution reports
Displays sessions associated with a particular connection by repository by folder. This report is the first node in the analytic workflow associated with the Connection Usage primary report.
select “SUBJECT_AREA”,
“WIDGET_TYPE”,
“READER_WRITER_TYPE”,
“REPOSITORY_NAME”,
“SESSION_NAME”,
“WIDGET_INSTANCE_ID”,
“SESSION_INSTANCE_NAME”,
“CNX_NAME”,
“WORKFLOW_NAME”
from (SELECT SESSION_REPOSIT_INFO.REPOSITORY_NAME, ALL_SESSIONS.SUBJECT_AREA, SESSION_LOG.WORKFLOW_NAME, ALL_SESSIONS.SESSION_NAME, SESSION_LOG.SESSION_INSTANCE_NAME, SESSION_ALL_CNXS.CNX_NAME, SESSION_ALL_CNXS.READER_WRITER_TYPE, CASE WHEN SESSION_ALL_CNXS.WIDGET_TYPE = 2 THEN ‘Target Connection’ ELSE CASE WHEN SESSION_ALL_CNXS.WIDGET_TYPE IN (1,3,56,45,55,84) THEN ‘Source Connection’ ELSE NULL END END AS WIDGET_TYPE, (COUNT(SESSION_ALL_CNXS.WIDGET_INSTANCE_ID)) AS WIDGET_INSTANCE_ID FROM REP_LOAD_SESSIONS ALL_SESSIONS, REP_SESS_WIDGET_CNXS SESSION_ALL_CNXS, REP_REPOSIT_INFO SESSION_REPOSIT_INFO, REP_SESS_LOG SESSION_LOG WHERE (ALL_SESSIONS.SESSION_ID = SESSION_ALL_CNXS.SESSION_ID AND ALL_SESSIONS.SESSION_VERSION_NUMBER = SESSION_ALL_CNXS. SESSION_VERSION_NUMBER AND ALL_SESSIONS.SESSION_ID <> SESSION_REPOSIT_INFO.REPOSITORY_ID AND ALL_SESSIONS.SESSION_ID = SESSION_LOG.SESSION_ID AND ALL_SESSIONS.SESSION_VERSION_NUMBER = SESSION_LOG.TASK_VERSION_NUMBER) GROUP BY SESSION_REPOSIT_INFO.REPOSITORY_NAME, ALL_SESSIONS.SUBJECT_AREA, SESSION_LOG.WORKFLOW_NAME, ALL_SESSIONS.SESSION_NAME, SESSION_LOG.SESSION_INSTANCE_NAME, SESSION_ALL_CNXS.CNX_NAME, SESSION_ALL_CNXS.READER_WRITER_TYPE, CASE WHEN SESSION_ALL_CNXS.WIDGET_TYPE = 2 THEN ‘Target Connection’ ELSE CASE WHEN SESSION_ALL_CNXS.WIDGET_TYPE IN (1,3,56,45,55,84) THEN ‘Source Connection’ ELSE NULL END END) “query”
order by “REPOSITORY_NAME”, “SUBJECT_AREA”
Displays the total number of sessions currently running by PowerCenter Server. This cached report is attached to the 5 Minute Refresh schedule, which refreshes every 5 minutes.
select “REPOSITORY_NAME”,
“TASK_ID”,
“SERVER_NAME”,
“END_TIME”
from (SELECT SESSION_TASK_INST_RUN.SERVER_NAME, SESSION_TASK_REPOSIT_INFO.REPOSITORY_NAME, TO_DATE(TO_CHAR(SESSION_TASK_INST_RUN.END_TIME, ‘yyyy-MM-dd’), ‘yyyy-MM-dd’) as END_TIME, (COUNT(SESSION_TASK_INST_RUN.TASK_ID)) as TASK_ID FROM REP_TASK_INST_RUN SESSION_TASK_INST_RUN, REP_REPOSIT_INFO SESSION_TASK_REPOSIT_INFO WHERE (SESSION_TASK_INST_RUN.TASK_ID <> SESSION_TASK_REPOSIT_INFO.REPOSITORY_ID AND SESSION_TASK_INST_RUN.TASK_TYPE = 68) AND (SESSION_TASK_INST_RUN.END_TIME IS NULL ) GROUP BY SESSION_TASK_INST_RUN.SERVER_NAME, SESSION_TASK_REPOSIT_INFO.REPOSITORY_NAME, TO_DATE(TO_CHAR(SESSION_TASK_INST_RUN.END_TIME, ‘yyyy-MM-dd’), ‘yyyy-MM-dd’)) “query”
Displays session details, by repository and folder, for sessions that started yesterday and failed. This report is the first node in a workflow associated with the Failed Session Statistics (Yesterday) primary report.
select “SERVER_NAME”,
“FIRST_ERROR_MSG”,
“FAILED_ROWS”,
“LAST_ERROR_CODE”,
“SESSION_TIMESTAMP_SUB”,
“SUCCESSFUL_SOURCE_ROWS”,
“SESSION_INSTANCE_NAME”,
“SESSION_TIMESTAMP”,
“SUCCESSFUL_ROWS”,
“SESSION_LOG_FILE”,
“WORKFLOW_NAME”,
“ACTUAL_START”,
“SUBJECT_AREA”,
“FIRST_ERROR_CODE”,
“FAILED_SOURCE_ROWS”,
“SESSION_NAME”,
“ACTUAL_START_SUB”,
“MAPPING_NAME”,
“LAST_ERROR”,
“REPOSITORY_NAME”,
“TOTAL_ERR”
from (SELECT SESSION_REPOSIT_INFO.REPOSITORY_NAME, TO_CHAR(SESSION_LOG.ACTUAL_START,’DD-MON-YYYY’) as ACTUAL_START_SUB, ALL_SESSIONS.SUBJECT_AREA, SESSION_LOG.WORKFLOW_NAME, ALL_SESSIONS.SESSION_NAME, SESSION_LOG.SESSION_INSTANCE_NAME, SESSION_LOG.MAPPING_NAME, SESSION_TASK_INST_RUN.SERVER_NAME, SESSION_LOG.ACTUAL_START, SESSION_LOG.SESSION_TIMESTAMP, SESSION_LOG.SESSION_LOG_FILE as SESSION_LOG_FILE, SESSION_LOG.FIRST_ERROR_CODE, SESSION_LOG.FIRST_ERROR_MSG as FIRST_ERROR_MSG, SESSION_LOG.LAST_ERROR_CODE, SESSION_LOG.LAST_ERROR as LAST_ERROR, (SUM(SESSION_LOG.SUCCESSFUL_SOURCE_ROWS)) as SUCCESSFUL_SOURCE_ROWS, (SUM(SESSION_LOG.FAILED_SOURCE_ROWS)) as FAILED_SOURCE_ROWS, (SUM(SESSION_LOG.SUCCESSFUL_ROWS)) as SUCCESSFUL_ROWS, (SUM(SESSION_LOG.FAILED_ROWS)) as FAILED_ROWS, (SUM(SESSION_LOG.TOTAL_ERR)) as TOTAL_ERR, (SUM( CASE WHEN SESSION_LOG.SESSION_TIMESTAMP IS NOT NULL THEN (SESSION_LOG.SESSION_TIMESTAMP – SESSION_LOG.ACTUAL_START) * 86400 END)) as SESSION_TIMESTAMP_SUB FROM REP_LOAD_SESSIONS ALL_SESSIONS, REP_SESS_LOG SESSION_LOG, REP_REPOSIT_INFO SESSION_REPOSIT_INFO, REP_TASK_INST_RUN SESSION_TASK_INST_RUN 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 SESSION_LOG.SESSION_ID = SESSION_TASK_INST_RUN.TASK_ID AND SESSION_LOG.INSTANCE_ID = SESSION_TASK_INST_RUN.INSTANCE_ID AND SESSION_LOG.TASK_VERSION_NUMBER = SESSION_TASK_INST_RUN.TASK_VERSION_NUMBER AND SESSION_LOG.WORKFLOW_ID = SESSION_TASK_INST_RUN.WORKFLOW_ID AND SESSION_LOG.WORKFLOW_VERSION_NUMBER = SESSION_TASK_INST_RUN.VERSION_NUMBER AND SESSION_LOG.WORKFLOW_RUN_ID = SESSION_TASK_INST_RUN.WORKFLOW_RUN_ID AND SESSION_TASK_INST_RUN.TASK_TYPE = 68 ) AND (TO_CHAR(SESSION_LOG.ACTUAL_START,’DD-MON-YYYY’) = TO_CHAR(SYSDATE-1, ‘DD-MON-YYYY’) AND CASE WHEN SESSION_LOG.RUN_STATUS_CODE <= 9 THEN CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 1 THEN ‘Succeeded’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 2 THEN ‘Disabled’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 3 THEN ‘Failed’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 4 THEN ‘Stopped’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 5 THEN ‘Aborted’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 6 THEN ‘Running’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 7 THEN ‘Suspending’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 8 THEN ‘Suspended’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 9 THEN ‘Stopping’ END END END END END END END END END ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 10 THEN ‘Aborting’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 11 THEN ‘Waiting’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 12 THEN ‘Scheduled’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 13 THEN ‘UnScheduled’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 14 THEN ‘Unknown’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 15 THEN ‘Terminated’ END END END END END END END = ‘Failed’ ) GROUP BY SESSION_REPOSIT_INFO.REPOSITORY_NAME, TO_CHAR(SESSION_LOG.ACTUAL_START,’DD-MON-YYYY’), ALL_SESSIONS.SUBJECT_AREA, SESSION_LOG.WORKFLOW_NAME, ALL_SESSIONS.SESSION_NAME, SESSION_LOG.SESSION_INSTANCE_NAME, SESSION_LOG.MAPPING_NAME, SESSION_TASK_INST_RUN.SERVER_NAME, SESSION_LOG.ACTUAL_START, SESSION_LOG.SESSION_TIMESTAMP, SESSION_LOG.SESSION_LOG_FILE, SESSION_LOG.FIRST_ERROR_CODE, SESSION_LOG.FIRST_ERROR_MSG, SESSION_LOG.LAST_ERROR_CODE, SESSION_LOG.LAST_ERROR) “query”
order by “REPOSITORY_NAME”, “ACTUAL_START_SUB”, “SUBJECT_AREA”
Displays the total number of sessions that started yesterday and resulted in failed statuses by repository by folder. A session can fail due to read login failure or custom select statement error.
select “ACTUAL_START”,
“RUN_STATUS_CODE”,
“REPOSITORY_NAME”,
“INSTANCE_ID”,
“SUBJECT_AREA”,
“WORKFLOW_NAME”
from (SELECT SESSION_REPOSIT_INFO.REPOSITORY_NAME, TO_CHAR(SESSION_LOG.ACTUAL_START,’DD-MON-YYYY’) AS “ACTUAL_START”, ALL_SESSIONS.SUBJECT_AREA, SESSION_LOG.WORKFLOW_NAME, CASE WHEN SESSION_LOG.RUN_STATUS_CODE <= 9 THEN CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 1 THEN ‘Succeeded’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 2 THEN ‘Disabled’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 3 THEN ‘Failed’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 4 THEN ‘Stopped’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 5 THEN ‘Aborted’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 6 THEN ‘Running’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 7 THEN ‘Suspending’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 8 THEN ‘Suspended’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 9 THEN ‘Stopping’ END END END END END END END END END ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 10 THEN ‘Aborting’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 11 THEN ‘Waiting’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 12 THEN ‘Scheduled’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 13 THEN ‘UnScheduled’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 14 THEN ‘Unknown’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 15 THEN ‘Terminated’ END END END END END END END AS RUN_STATUS_CODE, (COUNT( CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 3 THEN SESSION_LOG.INSTANCE_ID END)) AS INSTANCE_ID 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’) AND CASE WHEN SESSION_LOG.RUN_STATUS_CODE <= 9 THEN CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 1 THEN ‘Succeeded’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 2 THEN ‘Disabled’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 3 THEN ‘Failed’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 4 THEN ‘Stopped’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 5 THEN ‘Aborted’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 6 THEN ‘Running’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 7 THEN ‘Suspending’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 8 THEN ‘Suspended’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 9 THEN ‘Stopping’ END END END END END END END END END ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 10 THEN ‘Aborting’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 11 THEN ‘Waiting’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 12 THEN ‘Scheduled’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 13 THEN ‘UnScheduled’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 14 THEN ‘Unknown’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 15 THEN ‘Terminated’ END END END END END END END = ‘Failed’ ) GROUP BY SESSION_REPOSIT_INFO.REPOSITORY_NAME, TO_CHAR(SESSION_LOG.ACTUAL_START,’DD-MON-YYYY’), ALL_SESSIONS.SUBJECT_AREA, SESSION_LOG.WORKFLOW_NAME, CASE WHEN SESSION_LOG.RUN_STATUS_CODE <= 9 THEN CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 1 THEN ‘Succeeded’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 2 THEN ‘Disabled’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 3 THEN ‘Failed’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 4 THEN ‘Stopped’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 5 THEN ‘Aborted’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 6 THEN ‘Running’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 7 THEN ‘Suspending’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 8 THEN ‘Suspended’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 9 THEN ‘Stopping’ END END END END END END END END END ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 10 THEN ‘Aborting’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 11 THEN ‘Waiting’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 12 THEN ‘Scheduled’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 13 THEN ‘UnScheduled’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 14 THEN ‘Unknown’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 15 THEN ‘Terminated’ END END END END END END END) “query”
order by “REPOSITORY_NAME”, “ACTUAL_START”
Displays the total number of sessions that ran and the total session run duration for yesterday by server by repository. This cached report is attached to the Midnight Daily schedule, where it runs everyday at midnight.
select “ACTUAL_START”,
“SESSION_TIMESTAMP”,
“SERVER_NAME”,
“REPOSITORY_NAME”,
“INSTANCE_ID”
from (SELECT SESSION_REPOSIT_INFO.REPOSITORY_NAME, TO_CHAR(SESSION_LOG.ACTUAL_START,’DD-MON-YYYY’) AS “ACTUAL_START”, SESSION_TASK_INST_RUN.SERVER_NAME, (COUNT(SESSION_LOG.INSTANCE_ID)) AS INSTANCE_ID, (SUM( CASE WHEN SESSION_LOG.SESSION_TIMESTAMP IS NOT NULL THEN (SESSION_LOG.SESSION_TIMESTAMP – SESSION_LOG.ACTUAL_START) * 86400 END)) AS “SESSION_TIMESTAMP” FROM REP_LOAD_SESSIONS ALL_SESSIONS, REP_SESS_LOG SESSION_LOG, REP_REPOSIT_INFO SESSION_REPOSIT_INFO, REP_TASK_INST_RUN SESSION_TASK_INST_RUN 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 SESSION_LOG.SESSION_ID = SESSION_TASK_INST_RUN.TASK_ID AND SESSION_LOG.INSTANCE_ID = SESSION_TASK_INST_RUN.INSTANCE_ID AND SESSION_LOG.TASK_VERSION_NUMBER = SESSION_TASK_INST_RUN.TASK_VERSION_NUMBER AND SESSION_LOG.WORKFLOW_ID = SESSION_TASK_INST_RUN.WORKFLOW_ID AND SESSION_LOG.WORKFLOW_VERSION_NUMBER = SESSION_TASK_INST_RUN.VERSION_NUMBER AND SESSION_LOG.WORKFLOW_RUN_ID = SESSION_TASK_INST_RUN.WORKFLOW_RUN_ID AND SESSION_TASK_INST_RUN.TASK_TYPE = 68 ) AND (TO_CHAR(SESSION_LOG.ACTUAL_START,’DD-MON-YYYY’) = TO_CHAR(SYSDATE-1, ‘DD-MON-YYYY’) ) GROUP BY SESSION_REPOSIT_INFO.REPOSITORY_NAME, TO_CHAR(SESSION_LOG.ACTUAL_START,’DD-MON-YYYY’) , SESSION_TASK_INST_RUN.SERVER_NAME) “query”
order by “REPOSITORY_NAME”, “ACTUAL_START”
Displays the total number of sessions that ran and the total session run duration for any day of week in any given month of the year by server by repository. For example, all Mondays in September are represented in one row if that month had 4 Mondays.
select “TIME_STAMP”,
“ACTUAL_START_FOURTH”,
“SERVER_NAME”,
“DATE_NAME”,
“REPOSITORY_NAME”,
“INSTANCE_ID”
from (SELECT distinct SESSION_REPOSIT_INFO.REPOSITORY_NAME, (COUNT(SESSION_LOG.INSTANCE_ID)) as INSTANCE_ID, SESSION_TASK_INST_RUN.SERVER_NAME, TO_CHAR(SESSION_LOG.ACTUAL_START,’YYYYMM’) as “ACTUAL_START_FIRST”, TO_CHAR(SESSION_LOG.ACTUAL_START,’D’) as “ACTUAL_START_SECOND”, TO_CHAR(SESSION_LOG.ACTUAL_START,’MON-YYYY’) as ACTUAL_START_FOURTH, TO_CHAR(SESSION_LOG.ACTUAL_START,’Day’) as DATE_NAME, (SUM( CASE WHEN SESSION_LOG.SESSION_TIMESTAMP IS NOT NULL THEN (SESSION_LOG.SESSION_TIMESTAMP – SESSION_LOG.ACTUAL_START) * 86400 END)) as TIME_STAMP FROM REP_LOAD_SESSIONS ALL_SESSIONS, REP_SESS_LOG SESSION_LOG, REP_REPOSIT_INFO SESSION_REPOSIT_INFO, REP_TASK_INST_RUN SESSION_TASK_INST_RUN 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 SESSION_LOG.SESSION_ID = SESSION_TASK_INST_RUN.TASK_ID AND SESSION_LOG.INSTANCE_ID = SESSION_TASK_INST_RUN.INSTANCE_ID AND SESSION_LOG.TASK_VERSION_NUMBER = SESSION_TASK_INST_RUN.TASK_VERSION_NUMBER AND SESSION_LOG.WORKFLOW_ID = SESSION_TASK_INST_RUN.WORKFLOW_ID AND SESSION_LOG.WORKFLOW_VERSION_NUMBER = SESSION_TASK_INST_RUN.VERSION_NUMBER AND SESSION_LOG.WORKFLOW_RUN_ID = SESSION_TASK_INST_RUN.WORKFLOW_RUN_ID AND SESSION_TASK_INST_RUN.TASK_TYPE = 68 ) GROUP BY SESSION_REPOSIT_INFO.REPOSITORY_NAME, TO_CHAR(SESSION_LOG.ACTUAL_START,’YYYYMM’), SESSION_TASK_INST_RUN.SERVER_NAME , TO_CHAR(SESSION_LOG.ACTUAL_START,’D’), TO_CHAR(SESSION_LOG.ACTUAL_START,’MON-YYYY’) , TO_CHAR(SESSION_LOG.ACTUAL_START,’Day’)) “query”
where “ACTUAL_START_FOURTH” in (‘<Session_Run_Month>’)
order by “REPOSITORY_NAME”
Displays session run details for any start date by repository by folder. This is a primary report in an analytic workflow.
select “FAILED_SOURCE_ROWS”,
“SERVER_NAME”,
“SESSION_TIMESTAMP”,
“SUCCESSFUL_SOURCE_ROWS”,
“SESSION_INSTANCE_NAME”,
“LAST_ERROR”,
“FIRST_ERROR_MSG”,
“SESSION_TIMESTAMP_LOG”,
“SUCCESSFUL_ROWS”,
“WORKFLOW_NAME”,
“FAILED_ROWS”,
“SESSION_NAME”,
“ACTUAL_START”,
case when (“RUN_STATUS_CODE” <= 9) then (case when (“RUN_STATUS_CODE” = 1) then (‘Succeeded’) else (case when (“RUN_STATUS_CODE” = 2) then (‘Disabled’) else (case when (“RUN_STATUS_CODE” = 3) then (‘Failed’) else (case when (“RUN_STATUS_CODE” = 4) then (‘Stopped’) else (case when (“RUN_STATUS_CODE” = 5) then (‘Aborted’) else (case when (“RUN_STATUS_CODE” = 6) then (‘Running’) else (case when (“RUN_STATUS_CODE” = 7) then (‘Suspending’) else (case when (“RUN_STATUS_CODE” = 8) then (‘Suspended’) else (case when (“RUN_STATUS_CODE” = 9) then (‘Stopping’) else (”) end) end) end) end) end) end) end) end) end) else (case when (“RUN_STATUS_CODE” = 10) then (‘Aborting’) else (case when (“RUN_STATUS_CODE” = 11) then (‘Waiting’) else (case when (“RUN_STATUS_CODE” = 12) then (‘Scheduled’) else (case when (“RUN_STATUS_CODE” = 13) then (‘UnScheduled’) else (case when (“RUN_STATUS_CODE” = 14) then (‘Unknown’) else (case when (“RUN_STATUS_CODE” = 15) then (‘Terminated’) else (”) end) end) end) end) end) end) end as “Calc_RUN_STATUS_CODE”,
“LAST_ERROR_CODE”,
“SESSION_LOG_FILE”,
“REPOSITORY_NAME”,
“MAPPING_NAME”,
“TOTAL_ERR”,
“SUBJECT_AREA”,
“FIRST_ERROR_CODE”
from (SELECT SESSION_REPOSIT_INFO.REPOSITORY_NAME, ALL_SESSIONS.SUBJECT_AREA, SESSION_LOG.WORKFLOW_NAME, ALL_SESSIONS.SESSION_NAME, SESSION_LOG.SESSION_INSTANCE_NAME, SESSION_LOG.MAPPING_NAME, SESSION_TASK_INST_RUN.SERVER_NAME, to_char(SESSION_LOG.ACTUAL_START,’mm/dd/yy HH:MI:SS AM’) as ACTUAL_START , SESSION_LOG.SESSION_TIMESTAMP as SESSION_TIMESTAMP, SESSION_LOG.RUN_STATUS_CODE as RUN_STATUS_CODE, SESSION_LOG.SESSION_LOG_FILE as SESSION_LOG_FILE, SESSION_LOG.FIRST_ERROR_CODE, SESSION_LOG.FIRST_ERROR_MSG as FIRST_ERROR_MSG, SESSION_LOG.LAST_ERROR_CODE, SESSION_LOG.LAST_ERROR as LAST_ERROR, (SUM(SESSION_LOG.SUCCESSFUL_SOURCE_ROWS)) as SUCCESSFUL_SOURCE_ROWS, (SUM(SESSION_LOG.FAILED_SOURCE_ROWS)) as FAILED_SOURCE_ROWS, (SUM(SESSION_LOG.SUCCESSFUL_ROWS)) as SUCCESSFUL_ROWS, (SUM(SESSION_LOG.FAILED_ROWS)) as FAILED_ROWS, (SUM(SESSION_LOG.TOTAL_ERR)) as TOTAL_ERR, (SUM( CASE WHEN SESSION_LOG.SESSION_TIMESTAMP IS NOT NULL THEN (SESSION_LOG.SESSION_TIMESTAMP – SESSION_LOG.ACTUAL_START) * 86400 END)) as SESSION_TIMESTAMP_LOG FROM REP_LOAD_SESSIONS ALL_SESSIONS, REP_SESS_LOG SESSION_LOG, REP_REPOSIT_INFO SESSION_REPOSIT_INFO, REP_TASK_INST_RUN SESSION_TASK_INST_RUN 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 SESSION_LOG.SESSION_ID = SESSION_TASK_INST_RUN.TASK_ID AND SESSION_LOG.INSTANCE_ID = SESSION_TASK_INST_RUN.INSTANCE_ID AND SESSION_LOG.TASK_VERSION_NUMBER = SESSION_TASK_INST_RUN.TASK_VERSION_NUMBER AND SESSION_LOG.WORKFLOW_ID = SESSION_TASK_INST_RUN.WORKFLOW_ID AND SESSION_LOG.WORKFLOW_VERSION_NUMBER = SESSION_TASK_INST_RUN.VERSION_NUMBER AND SESSION_LOG.WORKFLOW_RUN_ID = SESSION_TASK_INST_RUN.WORKFLOW_RUN_ID AND SESSION_TASK_INST_RUN.TASK_TYPE = 68 ) GROUP BY SESSION_REPOSIT_INFO.REPOSITORY_NAME, ALL_SESSIONS.SUBJECT_AREA, SESSION_LOG.WORKFLOW_NAME, ALL_SESSIONS.SESSION_NAME, SESSION_LOG.SESSION_INSTANCE_NAME, SESSION_LOG.MAPPING_NAME, SESSION_TASK_INST_RUN.SERVER_NAME, SESSION_LOG.ACTUAL_START, SESSION_LOG.SESSION_TIMESTAMP, SESSION_LOG.RUN_STATUS_CODE, SESSION_LOG.SESSION_LOG_FILE, SESSION_LOG.FIRST_ERROR_CODE, SESSION_LOG.FIRST_ERROR_MSG, SESSION_LOG.LAST_ERROR_CODE, SESSION_LOG.LAST_ERROR) “query”
where “SUBJECT_AREA” in (‘<Folder_Name>’) and “SESSION_NAME” in (‘<Session_Name>’) and “SESSION_TIMESTAMP” between DATE ‘<Start_Date_Between>’ and DATE ‘<Date_And>’
order by “REPOSITORY_NAME”, “SUBJECT_AREA”
Displays all sessions that started yesterday and had rejected rows by repository and folder. This cached report is attached to the Midnight Daily schedule, where it runs everyday at midnight.
select “SUCCESSFUL_ROWS”,
“LAST_ERROR_CODE”,
“FIRST_ERROR_CODE”,
“SESSION_TIMESTAMP_DIFF”,
case when (“RUN_STATUS_CODE” <= 9) then (case when (“RUN_STATUS_CODE” = 1) then (‘Succeeded’) else (case when (“RUN_STATUS_CODE” = 2) then (‘Disabled’) else (case when (“RUN_STATUS_CODE” = 3) then (‘Failed’) else (case when (“RUN_STATUS_CODE” = 4) then (‘Stopped’) else (case when (“RUN_STATUS_CODE” = 5) then (‘Aborted’) else (case when (“RUN_STATUS_CODE” = 6) then (‘Running’) else (case when (“RUN_STATUS_CODE” = 7) then (‘Suspending’) else (case when (“RUN_STATUS_CODE” = 8) then (‘Suspended’) else (case when (“RUN_STATUS_CODE” = 9) then (‘Stopping’) else (”) end) end) end) end) end) end) end) end) end) else (case when (“RUN_STATUS_CODE” = 10) then (‘Aborting’) else (case when (“RUN_STATUS_CODE” = 11) then (‘Waiting’) else (case when (“RUN_STATUS_CODE” = 12) then (‘Scheduled’) else (case when (“RUN_STATUS_CODE” = 13) then (‘UnScheduled’) else (case when (“RUN_STATUS_CODE” = 14) then (‘Unknown’) else (case when (“RUN_STATUS_CODE” = 15) then (‘Terminated’) else (”) end) end) end) end) end) end) end as “Calc_RUN_STATUS_CODE”,
“ACTUAL_START_TIME”,
“FAILED_ROWS”,
“LAST_ERROR”,
“SESSION_INSTANCE_NAME”,
“REPOSITORY_NAME”,
“TOTAL_ERR”,
“SERVER_NAME”,
“FIRST_ERROR_MSG”,
“SUBJECT_AREA”,
“SESSION_NAME”,
“FAILED_SOURCE_ROWS”,
“ACTUAL_START”,
“WORKFLOW_NAME”,
“MAPPING_NAME”,
“SESSION_LOG_FILE”,
“SESSION_TIMESTAMP”,
“SUCCESSFUL_SOURCE_ROWS”
from (SELECT SESSION_REPOSIT_INFO.REPOSITORY_NAME, TO_CHAR(SESSION_LOG.ACTUAL_START,’DD-MON-YYYY’) as ACTUAL_START_TIME, ALL_SESSIONS.SUBJECT_AREA, SESSION_LOG.WORKFLOW_NAME, ALL_SESSIONS.SESSION_NAME, SESSION_LOG.SESSION_INSTANCE_NAME, SESSION_LOG.MAPPING_NAME, SESSION_TASK_INST_RUN.SERVER_NAME, SESSION_LOG.ACTUAL_START, SESSION_LOG.SESSION_TIMESTAMP, SESSION_LOG.RUN_STATUS_CODE as RUN_STATUS_CODE, SESSION_LOG.SESSION_LOG_FILE as SESSION_LOG_FILE, SESSION_LOG.FIRST_ERROR_CODE, SESSION_LOG.FIRST_ERROR_MSG as FIRST_ERROR_MSG, SESSION_LOG.LAST_ERROR_CODE, SESSION_LOG.LAST_ERROR as LAST_ERROR, (SUM(SESSION_LOG.SUCCESSFUL_SOURCE_ROWS)) as SUCCESSFUL_SOURCE_ROWS, (SUM(SESSION_LOG.FAILED_SOURCE_ROWS)) as FAILED_SOURCE_ROWS, (SUM(SESSION_LOG.SUCCESSFUL_ROWS)) as SUCCESSFUL_ROWS, (SUM(SESSION_LOG.FAILED_ROWS)) as FAILED_ROWS, (SUM(SESSION_LOG.TOTAL_ERR)) as TOTAL_ERR, (SUM( CASE WHEN SESSION_LOG.SESSION_TIMESTAMP IS NOT NULL THEN (SESSION_LOG.SESSION_TIMESTAMP – SESSION_LOG.ACTUAL_START) * 86400 END)) as SESSION_TIMESTAMP_DIFF FROM REP_LOAD_SESSIONS ALL_SESSIONS, REP_SESS_LOG SESSION_LOG, REP_REPOSIT_INFO SESSION_REPOSIT_INFO, REP_TASK_INST_RUN SESSION_TASK_INST_RUN 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 SESSION_LOG.SESSION_ID = SESSION_TASK_INST_RUN.TASK_ID AND SESSION_LOG.INSTANCE_ID = SESSION_TASK_INST_RUN.INSTANCE_ID AND SESSION_LOG.TASK_VERSION_NUMBER = SESSION_TASK_INST_RUN.TASK_VERSION_NUMBER AND SESSION_LOG.WORKFLOW_ID = SESSION_TASK_INST_RUN.WORKFLOW_ID AND SESSION_LOG.WORKFLOW_VERSION_NUMBER = SESSION_TASK_INST_RUN.VERSION_NUMBER AND SESSION_LOG.WORKFLOW_RUN_ID = SESSION_TASK_INST_RUN.WORKFLOW_RUN_ID AND SESSION_TASK_INST_RUN.TASK_TYPE = 68 ) AND (TO_CHAR(SESSION_LOG.ACTUAL_START,’DD-MON-YYYY’) =TO_CHAR(SYSDATE-1, ‘DD-MON-YYYY’) ) GROUP BY SESSION_REPOSIT_INFO.REPOSITORY_NAME, TO_CHAR(SESSION_LOG.ACTUAL_START,’DD-MON-YYYY’), ALL_SESSIONS.SUBJECT_AREA, SESSION_LOG.WORKFLOW_NAME, ALL_SESSIONS.SESSION_NAME, SESSION_LOG.SESSION_INSTANCE_NAME, SESSION_LOG.MAPPING_NAME, SESSION_TASK_INST_RUN.SERVER_NAME, SESSION_LOG.ACTUAL_START, SESSION_LOG.SESSION_TIMESTAMP, SESSION_LOG.RUN_STATUS_CODE, SESSION_LOG.SESSION_LOG_FILE, SESSION_LOG.FIRST_ERROR_CODE, SESSION_LOG.FIRST_ERROR_MSG, SESSION_LOG.LAST_ERROR_CODE, SESSION_LOG.LAST_ERROR HAVING (SUM(SESSION_LOG.FAILED_ROWS)) > 0) “query”
order by “REPOSITORY_NAME”, “ACTUAL_START_TIME”, “SUBJECT_AREA”
Displays the load statistics for each table for last month by repository by folder. This is a primary report in an analytic workflow.
select “MAPPING_NAME”,
“SESSION_NAME”,
“FAILED_ROWS”,
“REPOSITORY_NAME”,
“TABLE_BUSNAME”,
“SESSION_INSTANCE_ID”,
“SUBJECT_AREA”,
“SESSION_INSTANCE_NAME”,
“SUCCESSFUL_ROWS”,
“WIDGET_NAME”,
“WORKFLOW_NAME”,
“START_TIME”,
“SUCCESSFUL_AFFECTED_ROWS”
from (SELECT SESSION_REPOSIT_INFO.REPOSITORY_NAME, TO_CHAR(SESSION_TBL_LOG.START_TIME,’MON-YYYY’) as “START_TIME”, ALL_SESSIONS.SUBJECT_AREA, SESSION_LOG.WORKFLOW_NAME, ALL_SESSIONS.SESSION_NAME, SESSION_LOG.SESSION_INSTANCE_NAME, SESSION_LOG.MAPPING_NAME, SESSION_TBL_LOG.WIDGET_NAME, SESSION_TBL_LOG.TABLE_BUSNAME, (SUM(SESSION_TBL_LOG.SUCCESSFUL_ROWS)) as SUCCESSFUL_ROWS, (SUM(SESSION_TBL_LOG.FAILED_ROWS)) as FAILED_ROWS, (SUM(SESSION_TBL_LOG.SUCCESSFUL_AFFECTED_ROWS)) as SUCCESSFUL_AFFECTED_ROWS, (COUNT(SESSION_TBL_LOG.SESSION_INSTANCE_ID)) as SESSION_INSTANCE_ID FROM REP_SESS_LOG SESSION_LOG, REP_SESS_TBL_LOG SESSION_TBL_LOG, REP_LOAD_SESSIONS ALL_SESSIONS, REP_REPOSIT_INFO SESSION_REPOSIT_INFO WHERE (SESSION_LOG.SESSION_ID = SESSION_TBL_LOG.SESSION_ID AND SESSION_LOG.TASK_VERSION_NUMBER = SESSION_TBL_LOG.SESSION_VERSION_NUMBER AND SESSION_LOG.INSTANCE_ID = SESSION_TBL_LOG.SESSION_INSTANCE_ID AND SESSION_TBL_LOG.START_TIME >= SESSION_LOG.ACTUAL_START AND SESSION_TBL_LOG.START_TIME <= SESSION_LOG.SESSION_TIMESTAMP AND 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_TBL_LOG.START_TIME,’MON-YYYY’) = TO_CHAR(TO_DATE(’01’||TO_CHAR(SYSDATE,’MON-YY’),’DD-MON-YY’)-1,’MON-YYYY’) ) GROUP BY SESSION_REPOSIT_INFO.REPOSITORY_NAME, TO_CHAR(SESSION_TBL_LOG.START_TIME,’MON-YYYY’), ALL_SESSIONS.SUBJECT_AREA, SESSION_LOG.WORKFLOW_NAME, ALL_SESSIONS.SESSION_NAME, SESSION_LOG.SESSION_INSTANCE_NAME, SESSION_LOG.MAPPING_NAME, SESSION_TBL_LOG.WIDGET_NAME, SESSION_TBL_LOG.TABLE_BUSNAME) “query”
order by “REPOSITORY_NAME”, “START_TIME”, “SUBJECT_AREA”
Displays, by folder and repository, session details for all sessions that started today and failed. This report is the first node in the analytic workflow associated with the Today’s Failed Session Statistics primary report.
select “FAILED_ROWS”,
“SESSION_LOG_FILE”,
“SUCCESSFUL_SOURCE_ROWS”,
“SESSION_TIMESTAMP_SUM”,
“ACTUAL_START_CONVERSION”,
“LAST_ERROR”,
“FAILED_SOURCE_ROWS”,
“MAPPING_NAME”,
“FIRST_ERROR_MSG”,
“SESSION_TIMESTAMP”,
“SERVER_NAME”,
“SUBJECT_AREA”,
“SUCCESSFUL_ROWS”,
“LAST_ERROR_CODE”,
“WORKFLOW_NAME”,
“ACTUAL_START”,
“FIRST_ERROR_CODE”,
“TOTAL_ERR”,
“SESSION_INSTANCE_NAME”,
“REPOSITORY_NAME”,
“SESSION_NAME”
from (SELECT SESSION_REPOSIT_INFO.REPOSITORY_NAME, TO_CHAR(SESSION_LOG.ACTUAL_START,’DD-MON-YYYY’) as ACTUAL_START_CONVERSION, ALL_SESSIONS.SUBJECT_AREA, SESSION_LOG.WORKFLOW_NAME, ALL_SESSIONS.SESSION_NAME, SESSION_LOG.SESSION_INSTANCE_NAME, SESSION_LOG.MAPPING_NAME, SESSION_TASK_INST_RUN.SERVER_NAME, SESSION_LOG.ACTUAL_START, SESSION_LOG.SESSION_TIMESTAMP, SESSION_LOG.SESSION_LOG_FILE as SESSION_LOG_FILE, SESSION_LOG.FIRST_ERROR_CODE, SESSION_LOG.FIRST_ERROR_MSG as FIRST_ERROR_MSG, SESSION_LOG.LAST_ERROR_CODE, SESSION_LOG.LAST_ERROR as LAST_ERROR, (SUM(SESSION_LOG.SUCCESSFUL_SOURCE_ROWS)) as SUCCESSFUL_SOURCE_ROWS, (SUM(SESSION_LOG.FAILED_SOURCE_ROWS)) as FAILED_SOURCE_ROWS, (SUM(SESSION_LOG.SUCCESSFUL_ROWS)) as SUCCESSFUL_ROWS, (SUM(SESSION_LOG.FAILED_ROWS)) as FAILED_ROWS, (SUM(SESSION_LOG.TOTAL_ERR)) as TOTAL_ERR, (SUM( CASE WHEN SESSION_LOG.SESSION_TIMESTAMP IS NOT NULL THEN (SESSION_LOG.SESSION_TIMESTAMP – SESSION_LOG.ACTUAL_START) * 86400 END)) as SESSION_TIMESTAMP_SUM FROM REP_LOAD_SESSIONS ALL_SESSIONS, REP_SESS_LOG SESSION_LOG, REP_REPOSIT_INFO SESSION_REPOSIT_INFO, REP_TASK_INST_RUN SESSION_TASK_INST_RUN 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 SESSION_LOG.SESSION_ID = SESSION_TASK_INST_RUN.TASK_ID AND SESSION_LOG.INSTANCE_ID = SESSION_TASK_INST_RUN.INSTANCE_ID AND SESSION_LOG.TASK_VERSION_NUMBER = SESSION_TASK_INST_RUN.TASK_VERSION_NUMBER AND SESSION_LOG.WORKFLOW_ID = SESSION_TASK_INST_RUN.WORKFLOW_ID AND SESSION_LOG.WORKFLOW_VERSION_NUMBER = SESSION_TASK_INST_RUN.VERSION_NUMBER AND SESSION_LOG.WORKFLOW_RUN_ID = SESSION_TASK_INST_RUN.WORKFLOW_RUN_ID AND SESSION_TASK_INST_RUN.TASK_TYPE = 68 ) AND (TO_CHAR(SESSION_LOG.ACTUAL_START,’DD-MON-YYYY’) = TO_CHAR(TRUNC(SYSDATE), ‘DD-MON-YYYY’) AND CASE WHEN SESSION_LOG.RUN_STATUS_CODE <= 9 THEN CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 1 THEN ‘Succeeded’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 2 THEN ‘Disabled’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 3 THEN ‘Failed’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 4 THEN ‘Stopped’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 5 THEN ‘Aborted’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 6 THEN ‘Running’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 7 THEN ‘Suspending’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 8 THEN ‘Suspended’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 9 THEN ‘Stopping’ END END END END END END END END END ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 10 THEN ‘Aborting’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 11 THEN ‘Waiting’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 12 THEN ‘Scheduled’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 13 THEN ‘UnScheduled’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 14 THEN ‘Unknown’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 15 THEN ‘Terminated’ END END END END END END END = ‘Failed’ ) GROUP BY SESSION_REPOSIT_INFO.REPOSITORY_NAME, TO_CHAR(SESSION_LOG.ACTUAL_START,’DD-MON-YYYY’), ALL_SESSIONS.SUBJECT_AREA, SESSION_LOG.WORKFLOW_NAME, ALL_SESSIONS.SESSION_NAME, SESSION_LOG.SESSION_INSTANCE_NAME, SESSION_LOG.MAPPING_NAME, SESSION_TASK_INST_RUN.SERVER_NAME, SESSION_LOG.ACTUAL_START, SESSION_LOG.SESSION_TIMESTAMP, SESSION_LOG.SESSION_LOG_FILE, SESSION_LOG.FIRST_ERROR_CODE, SESSION_LOG.FIRST_ERROR_MSG, SESSION_LOG.LAST_ERROR_CODE, SESSION_LOG.LAST_ERROR) “query”
order by “REPOSITORY_NAME”, “ACTUAL_START_CONVERSION”, “SUBJECT_AREA”
Displays, by folder and repository, the target details for all target instances in sessions that started today and failed. This report is the second node in a workflow associated with the Today’s Failed Session Statistics primary report.
select “MAPPING_NAME”,
“THROUGHPUT”,
“SUBJECT_AREA”,
“GROUP_NAME”,
“END_TIME”,
“TABLE_BUSNAME”,
“REPOSITORY_NAME”,
“MAPPLET_INSTANCE_NAME”,
“WORKFLOW_NAME”,
“TABLE_INSTANCE_NAME”,
“ACTUAL_START_CONVERSION”,
“PARTITION_NAME”,
“SESSION_INSTANCE_NAME”,
“WIDGET_NAME”,
“SUCCESSFUL_ROWS”,
“SUCCESSFUL_AFFECTED_ROWS”,
“LAST_ERROR_CODE”,
“START_TIME”,
“LAST_ERROR”,
“FAILED_ROWS”,
“SESSION_NAME”
from (SELECT SESSION_REPOSIT_INFO.REPOSITORY_NAME, TO_CHAR(SESSION_LOG.ACTUAL_START,’DD-MON-YYYY’) AS ACTUAL_START_CONVERSION, ALL_SESSIONS.SUBJECT_AREA, SESSION_LOG.WORKFLOW_NAME, SESSION_LOG.SESSION_NAME, SESSION_LOG.SESSION_INSTANCE_NAME, SESSION_LOG.MAPPING_NAME, SESSION_TBL_LOG.MAPPLET_INSTANCE_NAME, SESSION_TBL_LOG.WIDGET_NAME, SESSION_TBL_LOG.TABLE_INSTANCE_NAME, SESSION_TBL_LOG.TABLE_BUSNAME, SESSION_TBL_LOG.PARTITION_NAME, SESSION_TBL_LOG.GROUP_NAME, SESSION_TBL_LOG.START_TIME, SESSION_TBL_LOG.END_TIME, SESSION_TBL_LOG.LAST_ERROR_CODE, SESSION_TBL_LOG.LAST_ERROR AS LAST_ERROR, (SUM(SESSION_TBL_LOG.SUCCESSFUL_ROWS)) AS SUCCESSFUL_ROWS, (SUM(SESSION_TBL_LOG.FAILED_ROWS)) AS FAILED_ROWS, (SUM(SESSION_TBL_LOG.SUCCESSFUL_AFFECTED_ROWS)) AS SUCCESSFUL_AFFECTED_ROWS, (SUM(SESSION_TBL_LOG.THROUGHPUT)) AS THROUGHPUT FROM REP_SESS_LOG SESSION_LOG, REP_SESS_TBL_LOG SESSION_TBL_LOG, REP_LOAD_SESSIONS ALL_SESSIONS, REP_REPOSIT_INFO SESSION_REPOSIT_INFO WHERE (SESSION_LOG.SESSION_ID = SESSION_TBL_LOG.SESSION_ID AND SESSION_LOG.TASK_VERSION_NUMBER = SESSION_TBL_LOG.SESSION_VERSION_NUMBER AND SESSION_LOG.INSTANCE_ID = SESSION_TBL_LOG.SESSION_INSTANCE_ID AND SESSION_TBL_LOG.START_TIME >= SESSION_LOG.ACTUAL_START AND SESSION_TBL_LOG.START_TIME <= SESSION_LOG.SESSION_TIMESTAMP AND 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(TRUNC(SYSDATE), ‘DD-MON-YYYY’) AND CASE WHEN SESSION_LOG.RUN_STATUS_CODE <= 9 THEN CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 1 THEN ‘Succeeded’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 2 THEN ‘Disabled’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 3 THEN ‘Failed’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 4 THEN ‘Stopped’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 5 THEN ‘Aborted’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 6 THEN ‘Running’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 7 THEN ‘Suspending’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 8 THEN ‘Suspended’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 9 THEN ‘Stopping’ END END END END END END END END END ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 10 THEN ‘Aborting’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 11 THEN ‘Waiting’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 12 THEN ‘Scheduled’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 13 THEN ‘UnScheduled’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 14 THEN ‘Unknown’ ELSE CASE WHEN SESSION_LOG.RUN_STATUS_CODE = 15 THEN ‘Terminated’ END END END END END END END = ‘Failed’ ) GROUP BY SESSION_REPOSIT_INFO.REPOSITORY_NAME, TO_CHAR(SESSION_LOG.ACTUAL_START,’DD-MON-YYYY’), ALL_SESSIONS.SUBJECT_AREA, SESSION_LOG.WORKFLOW_NAME, SESSION_LOG.SESSION_NAME, SESSION_LOG.SESSION_INSTANCE_NAME, SESSION_LOG.MAPPING_NAME, SESSION_TBL_LOG.MAPPLET_INSTANCE_NAME, SESSION_TBL_LOG.WIDGET_NAME, SESSION_TBL_LOG.TABLE_INSTANCE_NAME, SESSION_TBL_LOG.TABLE_BUSNAME, SESSION_TBL_LOG.PARTITION_NAME, SESSION_TBL_LOG.GROUP_NAME, SESSION_TBL_LOG.START_TIME, SESSION_TBL_LOG.END_TIME, SESSION_TBL_LOG.LAST_ERROR_CODE, SESSION_TBL_LOG.LAST_ERROR) “query”
order by “REPOSITORY_NAME”, “ACTUAL_START_CONVERSION”, “SUBJECT_AREA”
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.
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”
Displays by folder the top 5 most common error messages encountered by sessions.
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”
Workflow Execution
Displays the run statistics of all workflows by repository by folder. This is a primary report in an analytic workflow.
select “USER_NAME”,
“START_TIME”,
“SERVER_NAME”,
“LOG_FILE”,
“REPOSITORY_NAME”,
case when (“RUN_STATUS_CODE” <= 9) then (case when (“RUN_STATUS_CODE” = 1) then (‘Succeeded’) else (case when (“RUN_STATUS_CODE” = 2) then (‘Disabled’) else (case when (“RUN_STATUS_CODE” = 3) then (‘Failed’) else (case when (“RUN_STATUS_CODE” = 4) then (‘Stopped’) else (case when (“RUN_STATUS_CODE” = 5) then (‘Aborted’) else (case when (“RUN_STATUS_CODE” = 6) then (‘Running’) else (case when (“RUN_STATUS_CODE” = 7) then (‘Suspending’) else (case when (“RUN_STATUS_CODE” = 8) then (‘Suspended’) else (case when (“RUN_STATUS_CODE” = 9) then (‘Stopping’) else (”) end) end) end) end) end) end) end) end) end) else (case when (“RUN_STATUS_CODE” = 10) then (‘Aborting’) else (case when (“RUN_STATUS_CODE” = 11) then (‘Waiting’) else (case when (“RUN_STATUS_CODE” = 12) then (‘Scheduled’) else (case when (“RUN_STATUS_CODE” = 13) then (‘UnScheduled’) else (case when (“RUN_STATUS_CODE” = 14) then (‘Unknown’) else (case when (“RUN_STATUS_CODE” = 15) then (‘Terminated’) else (”) end) end) end) end) end) end) end as “Calc_RUN_STATUS_CODE”,
“RUN_ERR_MSG”,
case when (“RUN_TYPE” = 1) then (‘Normal’) else (case when (“RUN_TYPE” = 2) then (‘Recovery’) else (”) end) end as “Calc_RUN_TYPE”,
“SUBJECT_AREA”,
“END_TIME”,
“RUN_ERR_CODE”,
“WORKFLOW_NAME”
from (SELECT DISTINCT WORKFLOW_REPOSIT_INFO.REPOSITORY_NAME, ALL_WORKFLOWS.SUBJECT_AREA, ALL_WORKFLOWS.WORKFLOW_NAME, WORKFLOW_RUN.USER_NAME, WORKFLOW_RUN.SERVER_NAME, WORKFLOW_RUN.START_TIME AS START_TIME ,WORKFLOW_RUN.END_TIME as END_TIME , WORKFLOW_RUN.RUN_STATUS_CODE as RUN_STATUS_CODE, WORKFLOW_RUN.RUN_ERR_CODE, WORKFLOW_RUN.RUN_ERR_MSG as RUN_ERR_MSG, WORKFLOW_RUN.LOG_FILE as LOG_FILE, WORKFLOW_RUN.RUN_TYPE as RUN_TYPE FROM REP_REPOSIT_INFO WORKFLOW_REPOSIT_INFO, REP_WORKFLOWS ALL_WORKFLOWS, REP_WFLOW_RUN WORKFLOW_RUN WHERE (ALL_WORKFLOWS.WORKFLOW_ID <> WORKFLOW_REPOSIT_INFO.REPOSITORY_ID AND ALL_WORKFLOWS.WORKFLOW_ID = WORKFLOW_RUN.WORKFLOW_ID AND ALL_WORKFLOWS.WORKFLOW_VERSION_NUMBER = WORKFLOW_RUN.VERSION_NUMBER )) “query”
where “SUBJECT_AREA” in (‘<Folder_Name>’) and “WORKFLOW_NAME” in (‘<Workflow_Name>’) and “START_TIME” between DATE ‘<Start_Date>’ and DATE ‘<End_Date>’
order by “REPOSITORY_NAME”, “SUBJECT_AREA”
Displays the run statistics of all tasks in a workflow by repository by folder. This report is the first node in the analytic workflow associated with the Workflow Run Details primary report.
select “START_TIME”,
“RUN_ERR_CODE”,
“RUN_ERR_MSG”,
“END_TIME”,
“TASK_TYPE_NAME”,
case when (“RUN_STATUS_CODE” <= 9) then (case when (“RUN_STATUS_CODE” = 1) then (‘Succeeded’) else (case when (“RUN_STATUS_CODE” = 2) then (‘Disabled’) else (case when (“RUN_STATUS_CODE” = 3) then (‘Failed’) else (case when (“RUN_STATUS_CODE” = 4) then (‘Stopped’) else (case when (“RUN_STATUS_CODE” = 5) then (‘Aborted’) else (case when (“RUN_STATUS_CODE” = 6) then (‘Running’) else (case when (“RUN_STATUS_CODE” = 7) then (‘Suspending’) else (case when (“RUN_STATUS_CODE” = 8) then (‘Suspended’) else (case when (“RUN_STATUS_CODE” = 9) then (‘Stopping’) else (”) end) end) end) end) end) end) end) end) end) else (case when (“RUN_STATUS_CODE” = 10) then (‘Aborting’) else (case when (“RUN_STATUS_CODE” = 11) then (‘Waiting’) else (case when (“RUN_STATUS_CODE” = 12) then (‘Scheduled’) else (case when (“RUN_STATUS_CODE” = 13) then (‘UnScheduled’) else (case when (“RUN_STATUS_CODE” = 14) then (‘Unknown’) else (case when (“RUN_STATUS_CODE” = 15) then (‘Terminated’) else (”) end) end) end) end) end) end) end as “Calc_RUN_STATUS_CODE”,
“INSTANCE_NAME”,
“WORKFLOW_NAME”,
“SUBJECT_AREA”,
“REPOSITORY_NAME”
from (SELECT DISTINCT WORKFLOW_REPOSIT_INFO.REPOSITORY_NAME, ALL_WORKFLOWS.SUBJECT_AREA, ALL_WORKFLOWS.WORKFLOW_NAME, WORKFLOW_TASK_INST_RUN.TASK_TYPE_NAME, WORKFLOW_TASK_INST_RUN.INSTANCE_NAME, WORKFLOW_TASK_INST_RUN.START_TIME as START_TIME, to_char(WORKFLOW_TASK_INST_RUN.END_TIME,’mm/dd/yy HH:MI:SS AM’) as END_TIME, WORKFLOW_TASK_INST_RUN.RUN_STATUS_CODE AS RUN_STATUS_CODE, WORKFLOW_TASK_INST_RUN.RUN_ERR_CODE, WORKFLOW_TASK_INST_RUN.RUN_ERR_MSG As RUN_ERR_MSG FROM REP_WFLOW_RUN WORKFLOW_RUN, REP_TASK_INST_RUN WORKFLOW_TASK_INST_RUN, REP_WORKFLOWS ALL_WORKFLOWS, REP_REPOSIT_INFO WORKFLOW_REPOSIT_INFO WHERE (WORKFLOW_RUN.WORKFLOW_ID = WORKFLOW_TASK_INST_RUN.WORKFLOW_ID AND WORKFLOW_RUN.WORKFLOW_RUN_ID = WORKFLOW_TASK_INST_RUN.WORKFLOW_RUN_ID AND ALL_WORKFLOWS.WORKFLOW_ID <> WORKFLOW_REPOSIT_INFO.REPOSITORY_ID AND ALL_WORKFLOWS.WORKFLOW_ID = WORKFLOW_RUN.WORKFLOW_ID AND ALL_WORKFLOWS.WORKFLOW_VERSION_NUMBER = WORKFLOW_RUN.VERSION_NUMBER )) “query”
where “SUBJECT_AREA” in (‘<Folder_Name>’) and “WORKFLOW_NAME” in (‘<Workflow_Name>’) and “START_TIME” between DATE ‘<Start_Date>’ and DATE ‘<End_Date>’
order by “REPOSITORY_NAME”, “SUBJECT_AREA”
Displays the run statistics of all worklets by repository by folder.
select “RUN_ERR_MSG”,
“SUBJECT_AREA”,
“REPOSITORY_NAME”,
“END_TIME”,
“WORKFLOW_NAME”,
case when (“RUN_STATUS_CODE” <= 9) then (case when (“RUN_STATUS_CODE” = 1) then (‘Succeeded’) else (case when (“RUN_STATUS_CODE” = 2) then (‘Disabled’) else (case when (“RUN_STATUS_CODE” = 3) then (‘Failed’) else (case when (“RUN_STATUS_CODE” = 4) then (‘Stopped’) else (case when (“RUN_STATUS_CODE” = 5) then (‘Aborted’) else (case when (“RUN_STATUS_CODE” = 6) then (‘Running’) else (case when (“RUN_STATUS_CODE” = 7) then (‘Suspending’) else (case when (“RUN_STATUS_CODE” = 8) then (‘Suspended’) else (case when (“RUN_STATUS_CODE” = 9) then (‘Stopping’) else (”) end) end) end) end) end) end) end) end) end) else (case when (“RUN_STATUS_CODE” = 10) then (‘Aborting’) else (case when (“RUN_STATUS_CODE” = 11) then (‘Waiting’) else (case when (“RUN_STATUS_CODE” = 12) then (‘Scheduled’) else (case when (“RUN_STATUS_CODE” = 13) then (‘UnScheduled’) else (case when (“RUN_STATUS_CODE” = 14) then (‘Unknown’) else (case when (“RUN_STATUS_CODE” = 15) then (‘Terminated’) else (”) end) end) end) end) end) end) end as “Calc_RUN_STATUS_CODE”,
“START_TIME”,
“RUN_ERR_CODE”,
“TASK_NAME”
from (SELECT DISTINCT WORKLET_REPOSIT_INFO.REPOSITORY_NAME, ALL_WORKLETS.SUBJECT_AREA, ALL_WORKLETS.TASK_NAME, WORKLET_RUN.WORKFLOW_NAME, WORKLET_RUN.START_TIME as START_TIME, to_char(WORKLET_RUN.END_TIME,’mm/dd/yy HH:MI:SS AM’) as END_TIME, WORKLET_RUN.RUN_STATUS_CODE AS RUN_STATUS_CODE, WORKLET_RUN.RUN_ERR_CODE, WORKLET_RUN.RUN_ERR_MSG AS RUN_ERR_MSG FROM REP_ALL_TASKS ALL_WORKLETS, REP_TASK_INST_RUN WORKLET_RUN, REP_REPOSIT_INFO WORKLET_REPOSIT_INFO WHERE (ALL_WORKLETS.TASK_ID = WORKLET_RUN.TASK_ID AND ALL_WORKLETS.VERSION_NUMBER = WORKLET_RUN.TASK_VERSION_NUMBER AND ALL_WORKLETS.TASK_ID <> WORKLET_REPOSIT_INFO.REPOSITORY_ID AND ALL_WORKLETS.TASK_TYPE = 70)) “query”
where “SUBJECT_AREA” in (‘<Folder_Name>’) and “TASK_NAME” in (‘<Worklet_Name>’) and “START_TIME” between DATE ‘<Start_Date>’ and DATE ‘<End_Date>’
order by “REPOSITORY_NAME”, “SUBJECT_AREA”
Displays the run statistics of all tasks in a worklet by repository by folder.
select “WORKFLOW_NAME”,
“END_TIME”,
“RUN_ERR_CODE”,
“REPOSITORY_NAME”,
“RUN_ERR_MSG”,
“INSTANCE_NAME”,
“TASK_TYPE_NAME”,
“SUBJECT_AREA”,
“TASK_NAME”,
case when (“RUN_STATUS_CODE” <= 9) then (case when (“RUN_STATUS_CODE” = 1) then (‘Succeeded’) else (case when (“RUN_STATUS_CODE” = 2) then (‘Disabled’) else (case when (“RUN_STATUS_CODE” = 3) then (‘Failed’) else (case when (“RUN_STATUS_CODE” = 4) then (‘Stopped’) else (case when (“RUN_STATUS_CODE” = 5) then (‘Aborted’) else (case when (“RUN_STATUS_CODE” = 6) then (‘Running’) else (case when (“RUN_STATUS_CODE” = 7) then (‘Suspending’) else (case when (“RUN_STATUS_CODE” = 8) then (‘Suspended’) else (case when (“RUN_STATUS_CODE” = 9) then (‘Stopping’) else (”) end) end) end) end) end) end) end) end) end) else (case when (“RUN_STATUS_CODE” = 10) then (‘Aborting’) else (case when (“RUN_STATUS_CODE” = 11) then (‘Waiting’) else (case when (“RUN_STATUS_CODE” = 12) then (‘Scheduled’) else (case when (“RUN_STATUS_CODE” = 13) then (‘UnScheduled’) else (case when (“RUN_STATUS_CODE” = 14) then (‘Unknown’) else (case when (“RUN_STATUS_CODE” = 15) then (‘Terminated’) else (”) end) end) end) end) end) end) end as “Calc_RUN_STATUS_CODE”,
“START_TIME”
from (SELECT DISTINCT WORKLET_REPOSIT_INFO.REPOSITORY_NAME, ALL_WORKLETS.SUBJECT_AREA, ALL_WORKLETS.TASK_NAME, WORKLET_RUN.WORKFLOW_NAME, WORKLET_TASK_INST_RUN.TASK_TYPE_NAME, WORKLET_TASK_INST_RUN.INSTANCE_NAME, WORKLET_TASK_INST_RUN.START_TIME as START_TIME, WORKLET_TASK_INST_RUN.END_TIME as END_TIME, WORKLET_TASK_INST_RUN.RUN_STATUS_CODE as RUN_STATUS_CODE, WORKLET_TASK_INST_RUN.RUN_ERR_CODE, WORKLET_TASK_INST_RUN.RUN_ERR_MSG as RUN_ERR_MSG FROM REP_ALL_TASKS ALL_WORKLETS, REP_TASK_INST_RUN WORKLET_RUN, REP_REPOSIT_INFO WORKLET_REPOSIT_INFO, REP_TASK_INST_RUN WORKLET_TASK_INST_RUN WHERE (ALL_WORKLETS.TASK_ID = WORKLET_RUN.TASK_ID AND ALL_WORKLETS.VERSION_NUMBER = WORKLET_RUN.TASK_VERSION_NUMBER AND ALL_WORKLETS.TASK_ID <> WORKLET_REPOSIT_INFO.REPOSITORY_ID AND ALL_WORKLETS.TASK_TYPE = 70 AND WORKLET_RUN.WORKFLOW_ID = WORKLET_TASK_INST_RUN.WORKFLOW_ID AND WORKLET_RUN.WORKFLOW_RUN_ID = WORKLET_TASK_INST_RUN.WORKFLOW_RUN_ID AND WORKLET_RUN.WORKLET_RUN_ID = WORKLET_TASK_INST_RUN.WORKLET_RUN_ID )) “query”
where “SUBJECT_AREA” in (‘<Folder_Name>’) and “TASK_NAME” in (‘<Worklet_Name>’) and “START_TIME” between DATE ‘<Start_Date>’ and DATE ‘<End_Date>’
order by “REPOSITORY_NAME”, “SUBJECT_AREA”
Hello! Someone in my Facebook group shared this site with us so I came to take a look.
I’m definitely loving the information. I’m
bookmarking and will be tweeting this to my followers!
Hello this is kind of of off topic but I was wanting to know if blogs use
WYSIWYG editors or if you have to manually code with HTML. I’m starting
a blog soon but have no coding knowledge so I wanted to get
guidance from someone with experience. Any help would be enormously appreciated!