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.

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

ORABPEL-30701: Insufficient privileges to access metadata for another user

Error:

<Error> <oracle.soa.services.workflow.user> <BEA-000000> <<.> Insufficient privileges to access metadata for another user.

User USER A attempted to access metadata for user USER B without having appropriate administrator privileges.

Ensure that the appropriate privileges have been granted before attempting to access metadata belonging to another user.

ORABPEL-30701

Error Stack:

Insufficient privileges to access metadata for another user.

User USER1 attempted to access metadata for user USER2 without having appropriate administrator privileges.

Ensure that the appropriate privileges have been granted before attempting to access metadata belonging to another user.

        at oracle.bpel.services.workflow.user.impl.UserMetadataService.validateOperation(UserMetadataService.java:2401)

        at oracle.bpel.services.workflow.user.impl.UserMetadataService.updateGrantedTaskView(UserMetadataService.java:1339)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)

        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)

        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)

        at oracle.bpel.services.workflow.common.WorkflowServiceCacheEventAdvice.invoke(WorkflowServiceCacheEventAdvice.java:91)

        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)

        at oracle.bpel.services.workflow.test.workflow.ExceptionTestCaseBuilder.invoke(ExceptionTestCaseBuilder.java:155)

        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)

        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)

        at $Proxy251.updateGrantedTaskView(Unknown Source)

        at oracle.bpel.services.workflow.user.ejb.UserMetadataServiceBean.updateGrantedTaskView(UserMetadataServiceBean.java:202)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)

        at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)

        at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)

        at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)

        at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)

        at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)

        at com.oracle.pitchfork.spi.MethodInvocationVisitorImpl.visit(MethodInvocationVisitorImpl.java:34)

        at weblogic.ejb.container.injection.EnvironmentInterceptorCallbackImpl.callback(EnvironmentInterceptorCallbackImpl.java:54)

        at com.oracle.pitchfork.spi.EnvironmentInterceptor.invoke(EnvironmentInterceptor.java:42)

        at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)

        at com.bea.core.repackaged.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)

        at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)

        at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)

        at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)

        at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)

        at com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)

        at $Proxy311.updateGrantedTaskView(Unknown Source)

        at oracle.bpel.services.workflow.user.ejb.UserMetadataService_5ksc1c_EOImpl.__WL_invoke(Unknown Source)

        at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:40)

        at oracle.bpel.services.workflow.user.ejb.UserMetadataService_5ksc1c_EOImpl.updateGrantedTaskView(Unknown Source)

        at oracle.bpel.services.workflow.user.ejb.UserMetadataService_5ksc1c_EOImpl_WLSkel.invoke(Unknown Source)

        at weblogic.rmi.internal.ServerRequest.sendReceive(ServerRequest.java:174)

        at weblogic.rmi.cluster.ClusterableRemoteRef.invoke(ClusterableRemoteRef.java:345)

        at weblogic.rmi.cluster.ClusterableRemoteRef.invoke(ClusterableRemoteRef.java:259)

        at oracle.bpel.services.workflow.user.ejb.UserMetadataService_5ksc1c_EOImpl_1036_WLStub.updateGrantedTaskView(Unknown Source)

        at oracle.bpel.services.workflow.user.client.UserMetadataServiceRemoteClient.updateGrantedTaskView(UserMetadataServiceRemoteClient.java:102

Problem:

--------
Let's say a user A shares a view, user B logs into worklist application and goes to shared view. User B clicks on a column to sort but receives an error message.
Error displayed to user: Error occured while sorting task list.
Insufficient privileges to access metadata for another user.Ensure that the appropriate privileges have been granted before attempting to access metadata belonging to another user.
 

Resolution:

--------------------
1) Issue does NOT happen when both users (UserA and UserB) are part of the Administrators group.

2) you should either look for a patch patch 12693265 and apply it, or contact support about obtaining a fix that is suitable for your environment (incase you have any conflicting patches that already exist in your environment).

 

[Note:] The base bug 12693265 fixed for 11.1.1.6.0 but may also have the problem. Other users can sort the columns now, but can see an error in the logs.

Workaround: Ignore the error.

 

References:

Bug 12693265 : UNABLE TO SORT TASKS IN BPM WORKLIST SHARED VIEWS

Bug 12870530 - SORTING A COLUMN FROM A VIEW GRANTED BY ANOTHER USER RESULTS IN ORABPEL-30701

Bug 13036746 : ORABPEL-30701 ERROR WHEN TRYING TO SORT COLUMNS BUT SORT WORKS FINE

Error Creating Instance for target process BPM11g

Hi,

When you deploy your BPM process which has a initiator task and try to instantiate the process from BPM workspace, You might get this error   “Error Creating Instance for target process”

Cause :  There might be some business object hanging, means You might have created a business object  but haven’t used in any of the human task, then you get this error

Solution : Delete the business object if it is not required or use the business object as an input to any of the human task.

Cheers,

Letslearnoraclesoa team

Email : letslearnoraclesoa@gmail.com