Friday, May 30, 2014

Error while updating task Cannot delete Comments



For Oracle Business Process Management Suite - Version 11.1.1.6.0 you might end with below error while working on a task. This Error occurs when you try to click on any button.

Error:

Error while updating task Cannot delete Comments.
Check the underlying exception and the database connection information. If the error persists, contact Oracle Support Services.
 ORABPEL-10101

Error while updating task .
Error while updating task Cannot delete Comments.
Check the underlying exception and the database connection information. If the error persists, contact Oracle Support Services.

at oracle.bpel.services.workflow.repos.driver.WFTask.updateComments(WFTask.java:5385)


Solution:

1) This issue has been identified as a bug in Oracle and Oracle has released a patch for the same 
(ORABPEL-10101 Reassign Error while Updating a Human Task (Doc ID 1562528.1) and
patch number Patch 16521896 ).
Applying a patch and doing rigorous testing on test Environment needs significant amount of time. Below we will discuss some simple work around solutions.



The above thread discussion suggests to check table wfcomments for any row with column wfcomment with a null value.The drawback with this approach is that if you encounter this issue on production , you might not have access to system table and Oracle suggests not to perform any operations on system tables


3) The simplest workaround solution to the problem : try to write a comment for the task. Once you have written a comment (say : Test/fix comment issue) try to click on the buttons for the task. Now you won’t get the error .


Regards,
LetsLearnOracleSOA Team