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)
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
Applying a patch and doing
rigorous testing on test Environment needs significant amount of time. Below we
will discuss some simple work around solutions.
2) Reference OTN: https://community.oracle.com/thread/2410026
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