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 error or affected 0 rows
ObjMgrBusCompLog Error 1 000000fa635f2ee4:0 2022-10-31 21:10:15 (oracon.cpp (3896)) SBL-DBC-00111: An error has occurred writing to a record.
Please continue or ask your systems administrator to check your application configuration if the problem persists.
SQLParseAndExecute Execute 5 000000fa635f2ee4:0 2022-10-31 21:10:15 ORA-01653: unable to extend table SIEBEL.S_WFA_INSTP_LOG by 8192 in tablespace SIEBEL_DB
Solution:
As from the logs it is clear that this issue is due to the table space. For fix care fully TRUNCATE the table. Use below two TRUNCATE statements, possibly when you remove the data from "Step Instance" will also cascade delete the "Process Properties".
Solution Implementation:
Open Oracle SQL Developer client, connect the db and use below queries.
Step Instance:
SELECT COUNT(*) FROM S_WFA_INSTP_LOG
SELECT * FROM S_WFA_INSTP_LOG
--TRUNCATE TABLE S_WFA_INSTP_LOG
Process Properties:
SELECT COUNT(*) FROM S_WFA_STPRP_LOG
SELECT * FROM S_WFA_STPRP_LOG
--TRUNCATE TABLE S_WFA_STPRP_LOG
Similar Post:
How to delete Siebel Workflow Instance monitor logs SQL Developer