Receiving Sporadic Error on Workflow

Document ID : KB000124016
Last Modified Date : 28/12/2018
Show Technical Document Details
Issue:
We have a process that send an action item for idea to get approved and sometimes process is failing on an manual action that attempts to create an action item. When checking the process error message we see below error.
Receiving the following error when executing some of the workflows: com.niku.union.odf.exception.ODFValidationException: System error. Contact system administrator. at com.niku.odf.object.Utils.execService(Utils.java:218) at com.niku.odf.object.Utils.execService(Utils.java:276) at com.niku.odf.object.ODFObjectImpl.insert(ODFObjectImpl.java:2840) at com.niku.odf.object.ODFObjectImpl.insertWrapper(ODFObjectImpl.java:2908) at com.niku.odf.object.ODFAbstractObjectImpl.update(ODFAbstractObjectImpl.java:3823) at com.niku.odf.object.ObjectInstanceImpl.update(ObjectInstanceImpl.java:2622) at com.niku.odf.object.ObjectInstanceImpl.update(ObjectInstanceImpl.java:2548) at com.niku.odf.object.ObjectInstanceImpl.update(ObjectInstanceImpl.java:2536) at com.niku.calendar.service.ActionItemService.createActionItem(ActionItemService.java:279) at com.niku.calendar.service.ActionItemService.createActionItem(ActionItemService.java:96) at com.niku.bpm.services.ExecuteManualAction.sendActionItem(ExecuteManualAction.java:433) at com.niku.bpm.services.ExecuteManualAction.execute(ExecuteManualAction.java:96) at com.niku.bpm.services.ProcessEngine.executeStepAction(ProcessEngine.java:150) at com.niku.bpm.engine.rules.ActionExecutionPipeline.processActions(ActionExecutionPipeline.java:141) at com.niku.bpm.engine.rules.ActionExecutionPipeline.execute(ActionExecutionPipeline.java:71) at com.niku.bpm.engine.rules.Pipeline.run(Pipeline.java:280)
Resolution:
Upon reviewing bg-ca.log we saw an error below indicating that data it was trying to insert is too large for that filed. Description field for an Action Item message is 2000 character limit, so you would need to ensure what is put into description does not go over that limit.

[CA Clarity][Oracle JDBC Driver][Oracle]ORA-12899: value too large for column "SCHEMA"."CAL_ACTION_ITEMS"."DESCRIPTION" (actual: 2016, maximum: 2000)