ITCanopy

Workflow instance monitor have three separate tables. One for logging workflow run (workflow instance), second for its steps execution to log (workflow steps) and third for logging the values of each process property value against each step of workflow (workflow process properties). If you increase the Workflow Monitoring level over the time tables space and DB load will be increase and sometimes instance monitor will be stopped working (Check Siebel Workflow Instance Monitor not working to fix this issue) . Its a good practice to delete the old workflow instance monitor records. Below are the queries for deleting the data. Its better to delete only old data and Year is perfect condition. Workflow Instance select count(*) from S_WFA_INST_LOG where EXTRACT(YEAR FROM TO_DATE(created))='2022' --delete from S_WFA_INST_LOG where EXTRACT(YEAR FROM TO_DATE(created))='2022' Workflow Instance Steps select count(*) from S_WFA_INSTP_LOG where EXTRACT(YEAR FROM TO_DATE(created))=...

Issue Details: In "Active Workflow Processes" Monitoring Level of  workflow is set to "3 - Detail" but when check the "Workflow Instance Monitor" there are no "Step Instances". Step to find the root cause: Set the Workflow Monitoring Level to "3 - Detail". Increase the Application Object Manager (in this case Public Sector) logs to level 5. Re login the application and invoke the workflow.  Find the Public Sector OM logs. (Path: C:\Siebel\15.0.0.0.0\ses\siebsrvr\log) Open the log file (PSCcObjMgr_enu_*.log) and search "Instantiating". When you find your Workflow step name (set in workflow) scroll down and find the place where Siebel is inserting the "Step Instance" and "Process Properties". Carefully read the end lines and you will find the issue. In my case below was the issue mentioned in logs: SQLParseAndExecute    Execute    5    000000fa635f2ee4:0    2022-10-31 21:10:15    OCIStmtExecute: DML erro...

Below is the query for getting workflow instance monitor values from table: select wfdl.NAME as 'WF Name' ,wfdl.DEPLOY_STATUS_CD as 'Status' ,wfdl.VERSION as 'WF Version' ,wfil.END_TS as 'Instance EndDate' ,wfil.STATUS_CD as 'Instance Status' ,wfsil.STEP_NAME as 'Step Name' ,wfsil.STATUS_CD as 'Step Status' ,wfsl.NAME as 'Process Name' ,wfsl.PROP_VAL as 'Process Value' from S_WFA_DEFN_LOG wfdl join S_WFA_INST_LOG wfil on wfdl.ROW_ID = wfil.DEFINITION_ID  --Process Instance join S_WFA_INSTP_LOG wfsil on wfil.ROW_ID = wfsil.INST_LOG_ID --Step Instance join S_WFA_STPRP_LOG wfsl on wfsil.ROW_ID = wfsl.STEP_LOG_ID  --Process Properties where wfdl.NAME = 'Workflow name with instance monitor level 3' --and wfil.STATUS_CD = 'COMPLETED' --and wfsil.STEP_NAME = 'step name' --and wfsl.NAME <> 'Error Message'