Hello,
We are noticing a recurring WARN type message in our bg-ca.logs, that we suspect is causing problems on the Clarity DB transaction log size to grow too big, until its full (its set to 120GB), that leads to ERRORS to start occuring. We dont think that this problem will go away by just increasing the size of the transacion log of the DB.
Is our assumption correct, and is there a way to identify the process/script/query/filter that is causing these errors?
Thank you for any input!
WARN 2022-08-12 22:46:58,627 [Process Controller (tenant=clarity)] bpm.engine (clarity:process_admin:31637700__6996A861-5F76-4A14-B615-8F5944EE7790:none) Step Instances are in queue for the ActionExecutionPipelineManager but the pipeline is sleeping. No of step instances: 14 Waking up pipeline...
WARN 2022-08-12 22:47:01,834 [Post Condition Transition Pipeline 1 (tenant=clarity)] expr.omp (clarity:process_admin:31607228__3AA73057-7F0F-482B-9DC2-9B5C1415EAAD:none) Failed to bind variable using generated query: No records available from specified query.
WARN 2022-08-12 22:47:01,834 [Post Condition Transition Pipeline 2 (tenant=clarity)] expr.omp (clarity:process_admin:31607228__3AA73057-7F0F-482B-9DC2-9B5C1415EAAD:none) Failed to bind variable using generated query: No records available from specified query.
WARN 2022-08-12 22:47:01,834 [Post Condition Transition Pipeline 0 (tenant=clarity)] expr.omp (clarity:process_admin:31607228__3AA73057-7F0F-482B-9DC2-9B5C1415EAAD:none) Failed to bind variable using generated query: No records available from specified query.
WARN 2022-08-12 22:47:01,849 [Post Condition Transition Pipeline 2 (tenant=clarity)] expr.omp (clarity:process_admin:31607228__3AA73057-7F0F-482B-9DC2-9B5C1415EAAD:none) Failed to bind variable using generated query: No records available from specified query.
WARN 2022-08-12 22:47:01,849 [Post Condition Transition Pipeline 0 (tenant=clarity)] expr.omp (clarity:process_admin:31607228__3AA73057-7F0F-482B-9DC2-9B5C1415EAAD:none) Failed to bind variable using generated query: No records available from specified query.
WARN 2022-08-12 22:47:01,850 [Post Condition Transition Pipeline 1 (tenant=clarity)] expr.omp (clarity:process_admin:31607228__3AA73057-7F0F-482B-9DC2-9B5C1415EAAD:none) Failed to bind variable using generated query: No records available from specified query.
WARN 2022-08-12 22:47:01,855 [Post Condition Transition Pipeline 0 (tenant=clarity)] expr.omp (clarity:process_admin:31607228__3AA73057-7F0F-482B-9DC2-9B5C1415EAAD:none) Failed to bind variable using generated query: No records available from specified query.
WARN 2022-08-12 22:47:01,857 [Post Condition Transition Pipeline 1 (tenant=clarity)] expr.omp (clarity:process_admin:31607228__3AA73057-7F0F-482B-9DC2-9B5C1415EAAD:none) Failed to bind variable using generated query: No records available from specified query.
WARN 2022-08-12 22:47:01,857 [Post Condition Transition Pipeline 2 (tenant=clarity)] expr.omp (clarity:process_admin:31607228__3AA73057-7F0F-482B-9DC2-9B5C1415EAAD:none) Failed to bind variable using generated query: No records available from specified query.
WARN 2022-08-12 22:47:01,864 [Post Condition Transition Pipeline 2 (tenant=clarity)] expr.omp (clarity:process_admin:31607228__3AA73057-7F0F-482B-9DC2-9B5C1415EAAD:none) Failed to bind variable using generated query: No records available from specified query.
WARN 2022-08-12 22:47:01,864 [Post Condition Transition Pipeline 1 (tenant=clarity)] expr.omp (clarity:process_admin:31607228__3AA73057-7F0F-482B-9DC2-9B5C1415EAAD:none) Failed to bind variable using generated query: No records available from specified query.
WARN 2022-08-12 22:47:01,868 [Post Condition Transition Pipeline 0 (tenant=clarity)] expr.omp (clarity:process_admin:31607228__3AA73057-7F0F-482B-9DC2-9B5C1415EAAD:none) Failed to bind variable using generated query: No records available from specified query.
WARN 2022-08-12 22:47:01,870 [Post Condition Transition Pipeline 2 (tenant=clarity)] expr.omp (clarity:process_admin:31607228__3AA73057-7F0F-482B-9DC2-9B5C1415EAAD:none) Failed to bind variable using generated query: No records available from specified query.
WARN 2022-08-12 22:47:01,870 [Post Condition Transition Pipeline 1 (tenant=clarity)] expr.omp (clarity:process_admin:31607228__3AA73057-7F0F-482B-9DC2-9B5C1415EAAD:none) Failed to bind variable using generated query: No records available from specified query.
WARN 2022-08-12 22:47:01,876 [Post Condition Transition Pipeline 1 (tenant=clarity)] expr.omp (clarity:process_admin:31607228__3AA73057-7F0F-482B-9DC2-9B5C1415EAAD:none) Failed to bind variable using generated query: No records available from specified query.
WARN 2022-08-12 22:47:01,876 [Post Condition Transition Pipeline 0 (tenant=clarity)] expr.omp (clarity:process_admin:31607228__3AA73057-7F0F-482B-9DC2-9B5C1415EAAD:none) Failed to bind variable using generated query: No records available from specified query.
WARN 2022-08-12 22:47:01,877 [Post Condition Transition Pipeline 2 (tenant=clarity)] expr.omp (clarity:process_admin:31607228__3AA73057-7F0F-482B-9DC2-9B5C1415EAAD:none) Failed to bind variable using generated query: No records available from specified query.
WARN 2022-08-12 22:47:01,881 [Post Condition Transition Pipeline 0 (tenant=clarity)] expr.omp (clarity:process_admin:31607228__3AA73057-7F0F-482B-9DC2-9B5C1415EAAD:none) Failed to bind variable using generated query: No records available from specified query.
WARN 2022-08-12 22:47:01,882 [Post Condition Transition Pipeline 1 (tenant=clarity)] expr.omp (clarity:process_admin:31607228__3AA73057-7F0F-482B-9DC2-9B5C1415EAAD:none) Failed to bind variable using generated query: No records available from specified query.
WARN 2022-08-12 22:47:01,888 [Post Condition Transition Pipeline 1 (tenant=clarity)] expr.omp (clarity:process_admin:31607228__3AA73057-7F0F-482B-9DC2-9B5C1415EAAD:none) Failed to bind variable using generated query: No records available from specified query.
WARN 2022-08-12 22:47:01,890 [Post Condition Transition Pipeline 2 (tenant=clarity)] expr.omp (clarity:process_admin:31607228__3AA73057-7F0F-482B-9DC2-9B5C1415EAAD:none) Failed to bind variable using generated query: No records available from specified query.
WARN 2022-08-12 22:47:01,894 [Post Condition Transition Pipeline 1 (tenant=clarity)] expr.omp (clarity:process_admin:31607228__3AA73057-7F0F-482B-9DC2-9B5C1415EAAD:none) Failed to bind variable using generated query: No records available from specified query.
WARN 2022-08-12 22:47:01,902 [Post Condition Transition Pipeline 0 (tenant=clarity)] expr.omp (clarity:process_admin:31607228__3AA73057-7F0F-482B-9DC2-9B5C1415EAAD:none) Failed to bind variable using generated query: No records available from specified query.
WARN 2022-08-12 22:47:01,905 [Post Condition Transition Pipeline 2 (tenant=clarity)] expr.omp (clarity:process_admin:31607228__3AA73057-7F0F-482B-9DC2-9B5C1415EAAD:none) Failed to bind variable using generated query: No records available from specified query.
WARN 2022-08-12 22:47:01,905 [Post Condition Transition Pipeline 1 (tenant=clarity)] expr.omp (clarity:process_admin:31607228__3AA73057-7F0F-482B-9DC2-9B5C1415EAAD:none) Failed to bind variable using generated query: No records available from specified query.
WARN 2022-08-12 22:47:01,908 [Post Condition Transition Pipeline 0 (tenant=clarity)] expr.omp (clarity:process_admin:31607228__3AA73057-7F0F-482B-9DC2-9B5C1415EAAD:none) Failed to bind variable using generated query: No records available from specified query.
WARN 2022-08-12 22:47:01,910 [Post Condition Transition Pipeline 2 (tenant=clarity)] expr.omp (clarity:process_admin:31607228__3AA73057-7F0F-482B-9DC2-9B5C1415EAAD:none) Failed to bind variable using generated query: No records available from specified query.
WARN 2022-08-12 22:47:01,914 [Post Condition Transition Pipeline 1 (tenant=clarity)] expr.omp (clarity:process_admin:31607228__3AA73057-7F0F-482B-9DC2-9B5C1415EAAD:none) Failed to bind variable using generated query: No records available from specified query.
WARN 2022-08-12 22:47:01,914 [Post Condition Transition Pipeline 0 (tenant=clarity)] expr.omp (clarity:process_admin:31607228__3AA73057-7F0F-482B-9DC2-9B5C1415EAAD:none) Failed to bind variable using generated query: No records available from specified query.
WARN 2022-08-12 22:47:01,923 [Post Condition Transition Pipeline 2 (tenant=clarity)] expr.omp (clarity:process_admin:31607228__3AA73057-7F0F-482B-9DC2-9B5C1415EAAD:none) Failed to bind variable using generated query: No records available from specified query.
WARN 2022-08-12 22:47:01,924 [Post Condition Transition Pipeline 1 (tenant=clarity)] expr.omp (clarity:process_admin:31607228__3AA73057-7F0F-482B-9DC2-9B5C1415EAAD:none) Failed to bind variable using generated query: No records available from specified query.
WARN 2022-08-12 22:47:01,925 [Post Condition Transition Pipeline 0 (tenant=clarity)] expr.omp (clarity:process_admin:31607228__3AA73057-7F0F-482B-9DC2-9B5C1415EAAD:none) Failed to bind variable using generated query: No records available from specified query.
WARN 2022-08-12 22:47:01,929 [Post Condition Transition Pipeline 2 (tenant=clarity)] expr.omp (clarity:process_admin:31607228__3AA73057-7F0F-482B-9DC2-9B5C1415EAAD:none) Failed to bind variable using generated query: No records available from specified query.
WARN 2022-08-12 22:47:01,930 [Post Condition Transition Pipeline 1 (tenant=clarity)] expr.omp (clarity:process_admin:31607228__3AA73057-7F0F-482B-9DC2-9B5C1415EAAD:none) Failed to bind variable using generated query: No records available from specified query.
WARN 2022-08-12 22:47:01,930 [Post Condition Transition Pipeline 0 (tenant=clarity)] expr.omp (clarity:process_admin:31607228__3AA73057-7F0F-482B-9DC2-9B5C1415EAAD:none) Failed to bind variable using generated query: No records available from specified query.
WARN 2022-08-12 22:47:01,935 [Post Condition Transition Pipeline 2 (tenant=clarity)] expr.omp (clarity:process_admin:31607228__3AA73057-7F0F-482B-9DC2-9B5C1415EAAD:none) Failed to bind variable using generated query: No records available from specified query.
WARN 2022-08-12 22:47:01,935 [Post Condition Transition Pipeline 1 (tenant=clarity)] expr.omp (clarity:process_admin:31607228__3AA73057-7F0F-482B-9DC2-9B5C1415EAAD:none) Failed to bind variable using generated query: No records available from specified query.
WARN 2022-08-12 22:47:01,935 [Post Condition Transition Pipeline 0 (tenant=clarity)] expr.omp (clarity:process_admin:31607228__3AA73057-7F0F-482B-9DC2-9B5C1415EAAD:none) Failed to bind variable using generated query: No records available from specified query.
WARN 2022-08-12 22:47:01,938 [Post Condition Transition Pipeline 1 (tenant=clarity)] expr.omp (clarity:process_admin:31607228__3AA73057-7F0F-482B-9DC2-9B5C1415EAAD:none) Failed to bind variable using generated query: No records available from specified query.
WARN 2022-08-12 22:47:01,950 [Post Condition Transition Pipeline 2 (tenant=clarity)] expr.omp (clarity:process_admin:31607228__3AA73057-7F0F-482B-9DC2-9B5C1415EAAD:none) Failed to bind variable using generated query: No records available from specified query.
WARN 2022-08-12 22:47:01,950 [Post Condition Transition Pipeline 1 (tenant=clarity)] expr.omp (clarity:process_admin:31607228__3AA73057-7F0F-482B-9DC2-9B5C1415EAAD:none) Failed to bind variable using generated query: No records available from specified query.
WARN 2022-08-12 22:47:01,955 [Post Condition Transition Pipeline 1 (tenant=clarity)] expr.omp (clarity:process_admin:31607228__3AA73057-7F0F-482B-9DC2-9B5C1415EAAD:none) Failed to bind variable using generated query: No records available from specified query.
WARN 2022-08-12 22:47:01,955 [Post Condition Transition Pipeline 2 (tenant=clarity)] expr.omp (clarity:process_admin:31607228__3AA73057-7F0F-482B-9DC2-9B5C1415EAAD:none) Failed to bind variable using generated query: No records available from specified query.
WARN 2022-08-12 22:47:01,961 [Post Condition Transition Pipeline 2 (tenant=clarity)] expr.omp (clarity:process_admin:31607228__3AA73057-7F0F-482B-9DC2-9B5C1415EAAD:none) Failed to bind variable using generated query: No records available from specified query.
WARN 2022-08-12 22:47:01,962 [Post Condition Transition Pipeline 1 (tenant=clarity)] expr.omp (clarity:process_admin:31607228__3AA73057-7F0F-482B-9DC2-9B5C1415EAAD:none) Failed to bind variable using generated query: No records available from specified query.
WARN 2022-08-12 22:47:02,040 [Post Condition Transition Pipeline 2 (tenant=clarity)] expr.omp (clarity:process_admin:31607228__3AA73057-7F0F-482B-9DC2-9B5C1415EAAD:none) Failed to bind variable using generated query: No records available from specified query.
WARN 2022-08-12 22:47:02,045 [Post Condition Transition Pipeline 2 (tenant=clarity)] expr.omp (clarity:process_admin:31607228__3AA73057-7F0F-482B-9DC2-9B5C1415EAAD:none) Failed to bind variable using generated query: No records available from specified query.
WARN 2022-08-12 22:47:02,050 [Post Condition Transition Pipeline 2 (tenant=clarity)] expr.omp (clarity:process_admin:31607228__3AA73057-7F0F-482B-9DC2-9B5C1415EAAD:none) Failed to bind variable using generated query: No records available from specified query.
ERROR 2022-08-12 23:25:09,203 [Custom script execution pool-6-thread-2] utilities.BpmErrors (clarity:admin:31607229__23B24CB9-AAAA-415E-B067-198D67457587:none) ----> Cannot set Process Error Message -
Begin Error Information:
Step Action Id: 5079576
Process Instance Id: 29787926
Step Instance Id: 46178654
Error Code: bpm.raw.message
Exception Trace: ERROR: null:45:81: <sql:update> UPDATE odf_ca_idea
SET z_t_esf_leg_exc_da = 0
WHERE id = 5113037: [CA Clarity][SQLServer JDBC Driver][SQLServer]The transaction log for database 'PPMTEST' is full due to 'ACTIVE_TRANSACTION'.
End Error Information
com.niku.bpm.BpmException: addError - Cannot add Error.
at com.niku.bpm.utilities.PersistenceUtils.addError(PersistenceUtils.java:270)
at com.niku.bpm.utilities.BpmErrors.setError(BpmErrors.java:462)
at com.niku.bpm.utilities.BpmErrors.setRuntimeMessage(BpmErrors.java:321)
at com.niku.bpm.utilities.BusinessProcessUtilsImpl.setProcessInstanceMessage(BusinessProcessUtilsImpl.java:577)
at com.niku.union.gel.tags.LogTag.doTag(LogTag.java:135)
at org.apache.commons.jelly.impl.TagScript.run(TagScript.java:248)
at org.apache.commons.jelly.impl.ScriptBlock.run(ScriptBlock.java:96)
at org.apache.commons.jelly.TagSupport.invokeBody(TagSupport.java:187)
at org.apache.commons.jelly.tags.core.IfTag.doTag(IfTag.java:43)
at org.apache.commons.jelly.impl.TagScript.run(TagScript.java:248)
at org.apache.commons.jelly.impl.ScriptBlock.run(ScriptBlock.java:96)
at org.apache.commons.jelly.TagSupport.invokeBody(TagSupport.java:187)
at com.niku.union.gel.tags.ScriptTag.doTag(ScriptTag.java:20)
at org.apache.commons.jelly.impl.TagScript.run(TagScript.java:248)
at com.niku.union.gel.GELScript.run(GELScript.java:58)
at com.niku.union.gel.GELController.invoke(GELController.java:74)
at com.niku.bpm.services.ExecuteCustomAction.run(ExecuteCustomAction.java:207)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: com.niku.union.persistence.PersistenceException:
SQL error code: 9002
Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]The transaction log for database 'PPMTEST' is full due to 'ACTIVE_TRANSACTION'.
Executed:
INSERT INTO BPM_ERRORS (
ID, PROCESS_VERSION_ID, STEP_ID,
STEP_ACTION_ID, STEP_ACTION_RESULT_ID, STEP_CONDITION_ID, PROCESS_INSTANCE_ID,
STEP_INSTANCE_ID, TYPE_CODE, MESSAGE_CODE, ATTRIBUTE1, ATTRIBUTE2,
EXCEPTION_TRACE2, CREATED_DATE,
CREATED_BY, LAST_UPDATED_DATE, LAST_UPDATED_BY)
VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
Derived from statement:
<?xml version="1.0" encoding="UTF-8"?>
<statement location="commonPMD.xml" id="bpm.cmn.addError" batchable="true" sortColumnPath="/data/header/sortInfo/@sortColumn" sortDirectionPath="/data/header/sortInfo/@sortDirection" slicePath="/data/header/pagination/sliceInfo/@slice" sliceSizePath="/data/header/pagination/sliceInfo/@sliceSize" inputSource="none" xmlns="http://schemas.niku.com/2002/pmd">
<sql dbVendor="all">
<text>
INSERT INTO BPM_ERRORS (
ID, PROCESS_VERSION_ID, STEP_ID,
STEP_ACTION_ID, STEP_ACTION_RESULT_ID, STEP_CONDITION_ID, PROCESS_INSTANCE_ID,
STEP_INSTANCE_ID, TYPE_CODE, MESSAGE_CODE, ATTRIBUTE1, ATTRIBUTE2,
EXCEPTION_TRACE2, CREATED_DATE,
CREATED_BY, LAST_UPDATED_DATE, LAST_UPDATED_BY)
VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
</text>
<param name="error_id" direction="INOUT" expressionListDelimiter="," sequenceName="BPM_ERRORS_S1" tableName="BPM_ERRORS" sequenceType="nextValue"/>
<param name="process_version_id" path="@process_version_id" type="long" direction="IN" expressionListDelimiter=","/>
<param name="step_id" path="@step_id" type="long" direction="IN" defaultValue="-1" expressionListDelimiter=","/>
<param name="step_action_id" path="@step_action_id" type="long" direction="IN" expressionListDelimiter=","/>
<param name="step_action_result_id" path="@step_action_result_id" type="long" direction="IN" expressionListDelimiter=","/>
<param name="step_condition_id" path="@step_condition_id" type="long" direction="IN" expressionListDelimiter=","/>
<param name="process_instance_id" path="@process_instance_id" type="long" direction="IN" expressionListDelimiter=","/>
<param name="step_instance_id" path="@step_instance_id" type="long" direction="IN" expressionListDelimiter=","/>
<param name="type_code" path="@type_code" type="string" direction="IN" expressionListDelimiter=","/>
<param name="message_code" path="@message_code" type="string" direction="IN" expressionListDelimiter=","/>
<param name="attribute1" path="@attribute1" type="string" direction="IN" expressionListDelimiter=","/>
<param name="attribute2" path="@attribute2" type="string" direction="IN" expressionListDelimiter=","/>
<param name="exception_trace2" path="@exception_trace2" type="string" direction="IN" expressionListDelimiter=","/>
<param replace="timestamp" direction="IN" expressionListDelimiter=","/>
<param type="long" direction="IN" constantValue="1" expressionListDelimiter=","/>
<param replace="timestamp" direction="IN" expressionListDelimiter=","/>
<param type="long" direction="IN" constantValue="1" expressionListDelimiter=","/>
</sql>
</statement>
Referenced by:
<?xml version="1.0" encoding="UTF-8"?>
<statementRef id="bpm.cmn.addError" inputSource="map" sortColumnPath="/data/header/sortInfo/@sortColumn" sortDirectionPath="/data/header/sortInfo/@sortDirection" slicePath="/data/header/pagination/sliceInfo/@slice" sliceSizePath="/data/header/pagination/sliceInfo/@sliceSize" xmlns="http://schemas.niku.com/2002/pmd"/>
Using input:
{process_version_id=-1, step_condition_id=-1, step_action_result_id=30020840, exception_trace2=ERROR: null:45:81: <sql:update> UPDATE odf_ca_idea
SET z_t_esf_leg_exc_da = 0
WHERE id = 5113037: [CA Clarity][SQLServer JDBC Driver][SQLServer]The transaction log for database 'PPMTEST' is full due to 'ACTIVE_TRANSACTION'., message_code=bpm.raw.message, step_action_id=5079576, process_instance_id=29787926, attribute1=null, step_instance_id=46178654, attribute2=null, step_id=-1, type_code=BPM_PMT_INFO} sequences[BPM_ERRORS: 598430034]
at com.niku.union.persistence.PersistenceController.createException(PersistenceController.java:2196)
at com.niku.union.persistence.PersistenceController.handleSQLException(PersistenceController.java:2376)
at com.niku.union.persistence.PersistenceController.processSql(PersistenceController.java:3063)
at com.niku.union.persistence.PersistenceController.processStatement(PersistenceController.java:888)
at com.niku.union.persistence.PersistenceController.processStatements(PersistenceController.java:786)
at com.niku.union.persistence.PersistenceController.doProcessRequest(PersistenceController.java:588)
at com.niku.union.persistence.PersistenceController.processRequest(PersistenceController.java:311)
at com.niku.bpm.utilities.PersistenceUtils.addError(PersistenceUtils.java:242)
... 19 more
Caused by: java.sql.SQLException: [CA Clarity][SQLServer JDBC Driver][SQLServer]The transaction log for database 'PPMTEST' is full due to 'ACTIVE_TRANSACTION'.
at com.ca.clarity.jdbc.sqlserverbase.ddco.a(Unknown Source)
at com.ca.clarity.jdbc.sqlserverbase.ddco.a(Unknown Source)
at com.ca.clarity.jdbc.sqlserverbase.ddco.a(Unknown Source)
at com.ca.clarity.jdbc.sqlserver.tds.ddr.v(Unknown Source)
at com.ca.clarity.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at com.ca.clarity.jdbc.sqlserver.tds.ddq.a(Unknown Source)
at com.ca.clarity.jdbc.sqlserver.tds.ddr.c(Unknown Source)
at com.ca.clarity.jdbc.sqlserver.dda4.m(Unknown Source)
at com.ca.clarity.jdbc.sqlserverbase.ddev.e(Unknown Source)
at com.ca.clarity.jdbc.sqlserverbase.ddev.a(Unknown Source)
at com.ca.clarity.jdbc.sqlserverbase.dddv.a(Unknown Source)
at com.ca.clarity.jdbc.sqlserverbase.ddev.x(Unknown Source)
at com.ca.clarity.jdbc.sqlserverbase.ddev.z(Unknown Source)
at com.ca.clarity.jdbc.sqlserverbase.dddv.executeUpdate(Unknown Source)
at jdk.internal.reflect.GeneratedMethodAccessor25.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114)
at com.sun.proxy.$Proxy11.executeUpdate(Unknown Source)
at com.niku.union.persistence.PersistenceController.processSql(PersistenceController.java:2956)
... 24 more
ERROR 2022-08-12 23:25:10,216 [Custom script execution pool-6-thread-2] services.ExecuteCustomAction (clarity:admin:31607229__23B24CB9-AAAA-415E-B067-198D67457587:none) Cannot save CustomActionContext to the database.
ERROR 2022-08-12 23:25:10,238 [Custom script execution pool-6-thread-2] utilities.BpmErrors (clarity:admin:31607229__23B24CB9-AAAA-415E-B067-198D67457587:none) BpmErrors::getExceptionTrace(String arg) =>
com.niku.union.utility.MessageKeyException: BPM-0545: An error occurred when executing custom action.
at com.niku.bpm.services.ExecuteCustomAction.run(ExecuteCustomAction.java:281)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: com.niku.bpm.BpmException: Cannot save CustomActionContext to the database
at com.niku.bpm.services.ExecuteCustomAction.run(ExecuteCustomAction.java:251)
... 3 more
Caused by: com.niku.bpm.BpmException: callPMD - Cannot execute statement: bpm.insertCustomActionContext_set
at com.niku.bpm.customaction.persistence.CustomActionPersistenceUtils.callPMD(CustomActionPersistenceUtils.java:677)
at com.niku.bpm.customaction.persistence.CustomActionPersistenceUtils.createCustomActionContext(CustomActionPersistenceUtils.java:411)
at com.niku.bpm.services.ExecuteCustomAction.run(ExecuteCustomAction.java:226)
... 3 more
Caused by: com.niku.union.persistence.PersistenceException:
SQL error code: 9002
Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]The transaction log for database 'PPMTEST' is full due to 'ACTIVE_TRANSACTION'.
Executed:
INSERT INTO BPM_SESSION_DATA(ID, VALUE, CREATED_DATE, CREATED_BY, LAST_UPDATED_DATE, LAST_UPDATED_BY)
VALUES(?,?,?,?,?,?)
Derived from statement:
<?xml version="1.0" encoding="UTF-8"?>
<statement sortColumnPath="/data/header/sortInfo/@sortColumn" sortDirectionPath="/data/header/sortInfo/@sortDirection" slicePath="/data/header/pagination/sliceInfo/@slice" sliceSizePath="/data/header/pagination/sliceInfo/@sliceSize" inputSource="map" xmlns="http://schemas.niku.com/2002/pmd">
<sql dbVendor="all">
<text>
INSERT INTO BPM_SESSION_DATA(ID, VALUE, CREATED_DATE, CREATED_BY, LAST_UPDATED_DATE, LAST_UPDATED_BY)
VALUES(?,?,?,?,?,?)
</text>
<param name="session_data_id" direction="IN" expressionListDelimiter="," tableName="BPM_SESSION_DATA" sequenceType="nextValue"/>
<param name="value" type="blob" direction="IN" expressionListDelimiter=","/>
<param replace="timestamp" direction="IN" expressionListDelimiter=","/>
<param replace="userId" direction="IN" expressionListDelimiter=","/>
<param replace="timestamp" direction="IN" expressionListDelimiter=","/>
<param replace="userId" direction="IN" expressionListDelimiter=","/>
</sql>
<outputMapping rowElementName="customaction_context"/>
</statement>
Referenced by:
<?xml version="1.0" encoding="UTF-8"?>
<statementRef id="bpm.insertCustomActionContext_set_nested_1" inputSource="map" inputMapIndex="0" sortColumnPath="/data/header/sortInfo/@sortColumn" sortDirectionPath="/data/header/sortInfo/@sortDirection" slicePath="/data/header/pagination/sliceInfo/@slice" sliceSizePath="/data/header/pagination/sliceInfo/@sliceSize" defaultSliceSize="20" ignoreIfError="false" hideResultSets="false" xmlns="http://schemas.niku.com/2002/pmd"/>
Using input:
{value=[B@bc3244a} sequences[BPM_SESSION_DATA: 26104714]
at com.niku.union.persistence.PersistenceController.createException(PersistenceController.java:2196)
at com.niku.union.persistence.PersistenceController.handleSQLException(PersistenceController.java:2376)
at com.niku.union.persistence.PersistenceController.processSql(PersistenceController.java:3063)
at com.niku.union.persistence.PersistenceController.processStatement(PersistenceController.java:888)
at com.niku.union.persistence.PersistenceController.processStatements(PersistenceController.java:786)
at com.niku.union.persistence.PersistenceController.doProcessRequest(PersistenceController.java:588)
at com.niku.union.persistence.PersistenceController.processRequest(PersistenceController.java:311)
at com.niku.bpm.customaction.persistence.CustomActionPersistenceUtils.callPMD(CustomActionPersistenceUtils.java:665)
... 5 more
Caused by: java.sql.SQLException: [CA Clarity][SQLServer JDBC Driver][SQLServer]The transaction log for database 'PPMTEST' is full due to 'ACTIVE_TRANSACTION'.
at com.ca.clarity.jdbc.sqlserverbase.ddco.a(Unknown Source)
at com.ca.clarity.jdbc.sqlserverbase.ddco.a(Unknown Source)
at com.ca.clarity.jdbc.sqlserverbase.ddco.a(Unknown Source)
at com.ca.clarity.jdbc.sqlserver.tds.ddr.v(Unknown Source)
at com.ca.clarity.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at com.ca.clarity.jdbc.sqlserver.tds.ddq.a(Unknown Source)
at com.ca.clarity.jdbc.sqlserver.tds.ddr.c(Unknown Source)
at com.ca.clarity.jdbc.sqlserver.dda4.m(Unknown Source)
at com.ca.clarity.jdbc.sqlserverbase.ddev.e(Unknown Source)
at com.ca.clarity.jdbc.sqlserverbase.ddev.a(Unknown Source)
at com.ca.clarity.jdbc.sqlserverbase.dddv.a(Unknown Source)
at com.ca.clarity.jdbc.sqlserverbase.ddev.x(Unknown Source)
at com.ca.clarity.jdbc.sqlserverbase.ddev.t(Unknown Source)
at com.ca.clarity.jdbc.sqlserverbase.dddv.execute(Unknown Source)
at jdk.internal.reflect.GeneratedMethodAccessor15.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114)
at com.sun.proxy.$Proxy11.execute(Unknown Source)
at com.niku.union.persistence.PersistenceController.processSql(PersistenceController.java:3016)
... 10 more
ERROR 2022-08-12 23:25:10,240 [Custom script execution pool-6-thread-2] services.ExecuteCustomAction (clarity:admin:31607229__23B24CB9-AAAA-415E-B067-198D67457587:none) Failed to handle custom action execution error.
java.lang.NullPointerException
at com.niku.bpm.engine.ProcessLoader.getProcessInstance(ProcessLoader.java:618)
at com.niku.bpm.services.ExecuteCustomAction.handleError(ExecuteCustomAction.java:497)
at com.niku.bpm.services.ExecuteCustomAction.handleError(ExecuteCustomAction.java:483)
at com.niku.bpm.services.ExecuteCustomAction.run(ExecuteCustomAction.java:281)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:834)