Skip navigation
Adam_Chojnacki
Currently Being Moderated

Tracking - ALC-WKS-007-044 Error

Feb 1, 2011 4:25 AM

Hi all.

 

I have problem with my process.

 

When I click ok "Tracking" tab in workspace messagebox is presented with text:

 

An error occurred retrieving process instances (process MyApp/Processes/MyProcessWorkflow). (ALC-WKS-007-044);

 

And on server log exception is thrown:

 

com.adobe.idp.dsc.transaction.impl.ejb.adapter.EjbTransactionCMTAdapte r_z73hg_LocalHomeImpl@5eaa69f9 threw exception: com.adobe.idp.taskmanager.dsc.client.task.TaskManagerRuntimeException : A non-retryable Exception has occured: EJB Exception: : java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected - got NCLOB

 

    at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.ja va:91)
    at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:1 12)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java :173)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement. java:194)
    at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPrepare dStatement.java:785)
    at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPrepa redStatement.java:860)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme nt.java:1186)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrep aredStatement.java:3381)
    at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePrepare dStatement.java:3425)
    at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(Oracle PreparedStatementWrapper.java:1490)
    at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatemen t.java:128)
    at com.adobe.pof.adapter.oracle.Oracle9iAdapter.retrieveObjectSet(Oracle 9iAdapter.java:1067)
    at com.adobe.pof.adapter.oracle.Oracle9iAdapter.retrieveObjectSet(Oracle 9iAdapter.java:892)
    at com.adobe.pof.omapi.POFObjectManagerImpl.retrieveObjectSet(POFObjectM anagerImpl.java:148)
    at com.adobe.pof.omapi.POFObjectManagerRemoteBean.retrieveObjectSet(POFO bjectManagerRemoteBean.java:228)
    at com.adobe.pof.omapi.POFObjectManagerLocalBean_j8d0wl_ELOImpl.retrieve ObjectSet(POFObjectManagerLocalBean_j8d0wl_ELOImpl.java:1418)
    at com.adobe.pof.omapi.POFObjectManagerLocalEJBAdapter.retrieveObjectSet (POFObjectManagerLocalEJBAdapter.java:115)
    at com.adobe.pof.omapi.POFObjectManagerAbstractAdapter.retrieveObjectSet (POFObjectManagerAbstractAdapter.java:481)
    at com.adobe.idp.taskmanager.dsc.queryservice.TaskManagerQueryServiceImp l.processSearch(TaskManagerQueryServiceImpl.java:1016)
    at sun.reflect.GeneratedMethodAccessor9630.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at com.adobe.idp.dsc.component.impl.DefaultPOJOInvokerImpl.invoke(Defaul tPOJOInvokerImpl.java:118)
    at com.adobe.idp.dsc.interceptor.impl.InvocationInterceptor.intercept(In vocationInterceptor.java:140)
    at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.procee d(RequestInterceptorChainImpl.java:60)
    at com.adobe.idp.dsc.interceptor.impl.DocumentPassivationInterceptor.int ercept(DocumentPassivationInterceptor.java:53)
    at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.procee d(RequestInterceptorChainImpl.java:60)
    at com.adobe.idp.dsc.transaction.interceptor.TransactionInterceptor$1.do InTransaction(TransactionInterceptor.java:74)
    at com.adobe.idp.dsc.transaction.impl.ejb.adapter.EjbTransactionCMTAdapt erBean.execute(EjbTransactionCMTAdapterBean.java:357)
    at com.adobe.idp.dsc.transaction.impl.ejb.adapter.EjbTransactionCMTAdapt erBean.doSupports(EjbTransactionCMTAdapterBean.java:227)
    at com.adobe.idp.dsc.transaction.impl.ejb.adapter.EjbTransactionCMTAdapt er_z73hg_ELOImpl.doSupports(EjbTransactionCMTAdapter_z73hg_ELOImpl.jav a:457)
    at com.adobe.idp.dsc.transaction.impl.ejb.EjbTransactionProvider.execute (EjbTransactionProvider.java:104)
    at com.adobe.idp.dsc.transaction.interceptor.TransactionInterceptor.inte rcept(TransactionInterceptor.java:72)
    at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.procee d(RequestInterceptorChainImpl.java:60)
    at com.adobe.idp.dsc.interceptor.impl.InvocationStrategyInterceptor.inte rcept(InvocationStrategyInterceptor.java:55)
    at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.procee d(RequestInterceptorChainImpl.java:60)
    at com.adobe.idp.dsc.interceptor.impl.InvalidStateInterceptor.intercept( InvalidStateInterceptor.java:37)
    at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.procee d(RequestInterceptorChainImpl.java:60)
    at com.adobe.idp.dsc.interceptor.impl.AuthorizationInterceptor.intercept (AuthorizationInterceptor.java:165)
    at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.procee d(RequestInterceptorChainImpl.java:60)
    at com.adobe.idp.dsc.interceptor.impl.JMXInterceptor.intercept(JMXInterc eptor.java:48)
    at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.procee d(RequestInterceptorChainImpl.java:60)
    at com.adobe.idp.dsc.engine.impl.ServiceEngineImpl.invoke(ServiceEngineI mpl.java:115)
    at com.adobe.idp.dsc.routing.Router.routeRequest(Router.java:129)
    at com.adobe.idp.dsc.provider.impl.base.AbstractMessageReceiver.routeMes sage(AbstractMessageReceiver.java:93)
    at com.adobe.idp.dsc.provider.impl.vm.VMMessageDispatcher.doSend(VMMessa geDispatcher.java:198)
    at com.adobe.idp.dsc.provider.impl.base.AbstractMessageDispatcher.send(A bstractMessageDispatcher.java:66)
    at com.adobe.idp.dsc.clientsdk.ServiceClient.invoke(ServiceClient.java:2 08)
    at com.adobe.idp.taskmanager.dsc.client.TypedTaskManagerQueryService.inv okeWithRetry(TypedTaskManagerQueryService.java:108)
    at com.adobe.idp.taskmanager.dsc.client.TypedTaskManagerQueryService.pro cessSearch(TypedTaskManagerQueryService.java:294)
    at com.adobe.workspace.processes.TrackingQueries.getProcessInstances(Tra ckingQueries.java:142)
    at sun.reflect.GeneratedMethodAccessor10050.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at flex.messaging.services.remoting.adapters.JavaAdapter.invoke(JavaAdap ter.java:421)
    at flex.messaging.services.RemotingService.serviceMessage(RemotingServic e.java:183)
    at flex.messaging.MessageBroker.routeMessageToService(MessageBroker.java :1406)
    at flex.messaging.AsyncMessageBroker.routeMessageToService(AsyncMessageB roker.java:571)
    at flex.messaging.endpoints.AbstractEndpoint.serviceMessage(AbstractEndp oint.java:1005)
    at flex.messaging.endpoints.amf.MessageBrokerFilter.invoke(MessageBroker Filter.java:103)
    at flex.messaging.endpoints.amf.LegacyFilter.invoke(LegacyFilter.java:15 8)
    at flex.messaging.endpoints.amf.SessionFilter.invoke(SessionFilter.java: 44)
    at flex.messaging.endpoints.amf.BatchProcessFilter.invoke(BatchProcessFi lter.java:67)
    at flex.messaging.endpoints.amf.SerializationFilter.invoke(Serialization Filter.java:165)
    at flex.messaging.endpoints.BaseHTTPEndpoint.service(BaseHTTPEndpoint.ja va:293)
    at flex.messaging.MessageBrokerServlet.service(MessageBrokerServlet.java :364)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
    at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run (StubSecurityHelper.java:227)
    at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecuri tyHelper.java:125)
    at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.jav a:292)
    at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.ja va:42)
    at com.adobe.workspace.events.RemoteEventClientLifeCycle.doFilter(Remote EventClientLifeCycle.java:152)
    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.ja va:42)
    at weblogic.servlet.internal.WebAppServletContext$ServletInvocationActio n.run(WebAppServletContext.java:3496)
    at weblogic.security.acl.internal.AuthenticatedSubject.doAs(Authenticate dSubject.java:321)
    at weblogic.security.service.SecurityManager.runAs(Unknown Source)
    at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppS ervletContext.java:2180)
    at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletC ontext.java:2086)
    at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.j ava:1406)
    at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
    at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
; nested exception is: java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected - got NCLOB
>
####<2011-02-01 13:12:27 CET> <Error> <com.adobe.workspace.processes.TrackingQueries> <server_url> <lc_server> <[ACTIVE] ExecuteThread: '10' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <> <1296562347606> <BEA-000000> <ALC-WKS-005-059: An error occurred while retrieving the list of process instances for process "myApp/Processes/MyProcessWorkflow".
com.adobe.idp.taskmanager.dsc.client.task.TaskManagerRuntimeException: A non-retryable Exception has occured: EJB Exception: : java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected - got NCLOB

 

    at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.ja va:91)
    at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:1 12)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java :173)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement. java:194)
    at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPrepare dStatement.java:785)
    at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPrepa redStatement.java:860)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme nt.java:1186)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrep aredStatement.java:3381)
    at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePrepare dStatement.java:3425)
    at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(Oracle PreparedStatementWrapper.java:1490)
    at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatemen t.java:128)
    at com.adobe.pof.adapter.oracle.Oracle9iAdapter.retrieveObjectSet(Oracle 9iAdapter.java:1067)
    at com.adobe.pof.adapter.oracle.Oracle9iAdapter.retrieveObjectSet(Oracle 9iAdapter.java:892)
    at com.adobe.pof.omapi.POFObjectManagerImpl.retrieveObjectSet(POFObjectM anagerImpl.java:148)
    at com.adobe.pof.omapi.POFObjectManagerRemoteBean.retrieveObjectSet(POFO bjectManagerRemoteBean.java:228)
    at com.adobe.pof.omapi.POFObjectManagerLocalBean_j8d0wl_ELOImpl.retrieve ObjectSet(POFObjectManagerLocalBean_j8d0wl_ELOImpl.java:1418)
    at com.adobe.pof.omapi.POFObjectManagerLocalEJBAdapter.retrieveObjectSet (POFObjectManagerLocalEJBAdapter.java:115)
    at com.adobe.pof.omapi.POFObjectManagerAbstractAdapter.retrieveObjectSet (POFObjectManagerAbstractAdapter.java:481)
    at com.adobe.idp.taskmanager.dsc.queryservice.TaskManagerQueryServiceImp l.processSearch(TaskManagerQueryServiceImpl.java:1016)
    at sun.reflect.GeneratedMethodAccessor9630.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at com.adobe.idp.dsc.component.impl.DefaultPOJOInvokerImpl.invoke(Defaul tPOJOInvokerImpl.java:118)
    at com.adobe.idp.dsc.interceptor.impl.InvocationInterceptor.intercept(In vocationInterceptor.java:140)
    at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.procee d(RequestInterceptorChainImpl.java:60)
    at com.adobe.idp.dsc.interceptor.impl.DocumentPassivationInterceptor.int ercept(DocumentPassivationInterceptor.java:53)
    at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.procee d(RequestInterceptorChainImpl.java:60)
    at com.adobe.idp.dsc.transaction.interceptor.TransactionInterceptor$1.do InTransaction(TransactionInterceptor.java:74)
    at com.adobe.idp.dsc.transaction.impl.ejb.adapter.EjbTransactionCMTAdapt erBean.execute(EjbTransactionCMTAdapterBean.java:357)
    at com.adobe.idp.dsc.transaction.impl.ejb.adapter.EjbTransactionCMTAdapt erBean.doSupports(EjbTransactionCMTAdapterBean.java:227)
    at com.adobe.idp.dsc.transaction.impl.ejb.adapter.EjbTransactionCMTAdapt er_z73hg_ELOImpl.doSupports(EjbTransactionCMTAdapter_z73hg_ELOImpl.jav a:457)
    at com.adobe.idp.dsc.transaction.impl.ejb.EjbTransactionProvider.execute (EjbTransactionProvider.java:104)
    at com.adobe.idp.dsc.transaction.interceptor.TransactionInterceptor.inte rcept(TransactionInterceptor.java:72)
    at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.procee d(RequestInterceptorChainImpl.java:60)
    at com.adobe.idp.dsc.interceptor.impl.InvocationStrategyInterceptor.inte rcept(InvocationStrategyInterceptor.java:55)
    at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.procee d(RequestInterceptorChainImpl.java:60)
    at com.adobe.idp.dsc.interceptor.impl.InvalidStateInterceptor.intercept( InvalidStateInterceptor.java:37)
    at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.procee d(RequestInterceptorChainImpl.java:60)
    at com.adobe.idp.dsc.interceptor.impl.AuthorizationInterceptor.intercept (AuthorizationInterceptor.java:165)
    at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.procee d(RequestInterceptorChainImpl.java:60)
    at com.adobe.idp.dsc.interceptor.impl.JMXInterceptor.intercept(JMXInterc eptor.java:48)
    at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.procee d(RequestInterceptorChainImpl.java:60)
    at com.adobe.idp.dsc.engine.impl.ServiceEngineImpl.invoke(ServiceEngineI mpl.java:115)
    at com.adobe.idp.dsc.routing.Router.routeRequest(Router.java:129)
    at com.adobe.idp.dsc.provider.impl.base.AbstractMessageReceiver.routeMes sage(AbstractMessageReceiver.java:93)
    at com.adobe.idp.dsc.provider.impl.vm.VMMessageDispatcher.doSend(VMMessa geDispatcher.java:198)
    at com.adobe.idp.dsc.provider.impl.base.AbstractMessageDispatcher.send(A bstractMessageDispatcher.java:66)
    at com.adobe.idp.dsc.clientsdk.ServiceClient.invoke(ServiceClient.java:2 08)
    at com.adobe.idp.taskmanager.dsc.client.TypedTaskManagerQueryService.inv okeWithRetry(TypedTaskManagerQueryService.java:108)
    at com.adobe.idp.taskmanager.dsc.client.TypedTaskManagerQueryService.pro cessSearch(TypedTaskManagerQueryService.java:294)
    at com.adobe.workspace.processes.TrackingQueries.getProcessInstances(Tra ckingQueries.java:142)
    at sun.reflect.GeneratedMethodAccessor10050.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at flex.messaging.services.remoting.adapters.JavaAdapter.invoke(JavaAdap ter.java:421)
    at flex.messaging.services.RemotingService.serviceMessage(RemotingServic e.java:183)
    at flex.messaging.MessageBroker.routeMessageToService(MessageBroker.java :1406)
    at flex.messaging.AsyncMessageBroker.routeMessageToService(AsyncMessageB roker.java:571)
    at flex.messaging.endpoints.AbstractEndpoint.serviceMessage(AbstractEndp oint.java:1005)
    at flex.messaging.endpoints.amf.MessageBrokerFilter.invoke(MessageBroker Filter.java:103)
    at flex.messaging.endpoints.amf.LegacyFilter.invoke(LegacyFilter.java:15 8)
    at flex.messaging.endpoints.amf.SessionFilter.invoke(SessionFilter.java: 44)
    at flex.messaging.endpoints.amf.BatchProcessFilter.invoke(BatchProcessFi lter.java:67)
    at flex.messaging.endpoints.amf.SerializationFilter.invoke(Serialization Filter.java:165)
    at flex.messaging.endpoints.BaseHTTPEndpoint.service(BaseHTTPEndpoint.ja va:293)
    at flex.messaging.MessageBrokerServlet.service(MessageBrokerServlet.java :364)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
    at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run (StubSecurityHelper.java:227)
    at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecuri tyHelper.java:125)
    at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.jav a:292)
    at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.ja va:42)
    at com.adobe.workspace.events.RemoteEventClientLifeCycle.doFilter(Remote EventClientLifeCycle.java:152)
    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.ja va:42)
    at weblogic.servlet.internal.WebAppServletContext$ServletInvocationActio n.run(WebAppServletContext.java:3496)
    at weblogic.security.acl.internal.AuthenticatedSubject.doAs(Authenticate dSubject.java:321)
    at weblogic.security.service.SecurityManager.runAs(Unknown Source)
    at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppS ervletContext.java:2180)
    at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletC ontext.java:2086)
    at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.j ava:1406)
    at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
    at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
; nested exception is: java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected - got NCLOB

 

    at weblogic.ejb.container.internal.EJBRuntimeUtils.throwEJBException(EJB RuntimeUtils.java:151)
    at weblogic.ejb.container.internal.BaseLocalObject.handleSystemException (BaseLocalObject.java:850)
    at weblogic.ejb.container.internal.BaseLocalObject.handleSystemException (BaseLocalObject.java:791)
    at weblogic.ejb.container.internal.BaseLocalObject.postInvoke1(BaseLocal Object.java:486)
    at weblogic.ejb.container.internal.BaseLocalObject.postInvokeTxRetry(Bas eLocalObject.java:424)
    at com.adobe.pof.omapi.POFObjectManagerLocalBean_j8d0wl_ELOImpl.retrieve ObjectSet(POFObjectManagerLocalBean_j8d0wl_ELOImpl.java:1433)
    at com.adobe.pof.omapi.POFObjectManagerLocalEJBAdapter.retrieveObjectSet (POFObjectManagerLocalEJBAdapter.java:115)
    at com.adobe.pof.omapi.POFObjectManagerAbstractAdapter.retrieveObjectSet (POFObjectManagerAbstractAdapter.java:481)
    at com.adobe.idp.taskmanager.dsc.queryservice.TaskManagerQueryServiceImp l.processSearch(TaskManagerQueryServiceImpl.java:1016)
    at sun.reflect.GeneratedMethodAccessor9630.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at com.adobe.idp.dsc.component.impl.DefaultPOJOInvokerImpl.invoke(Defaul tPOJOInvokerImpl.java:118)
    at com.adobe.idp.dsc.interceptor.impl.InvocationInterceptor.intercept(In vocationInterceptor.java:140)
    at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.procee d(RequestInterceptorChainImpl.java:60)
    at com.adobe.idp.dsc.interceptor.impl.DocumentPassivationInterceptor.int ercept(DocumentPassivationInterceptor.java:53)
    at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.procee d(RequestInterceptorChainImpl.java:60)
    at com.adobe.idp.dsc.transaction.interceptor.TransactionInterceptor$1.do InTransaction(TransactionInterceptor.java:74)
    at com.adobe.idp.dsc.transaction.impl.ejb.adapter.EjbTransactionCMTAdapt erBean.execute(EjbTransactionCMTAdapterBean.java:357)
    at com.adobe.idp.dsc.transaction.impl.ejb.adapter.EjbTransactionCMTAdapt erBean.doSupports(EjbTransactionCMTAdapterBean.java:227)
    at com.adobe.idp.dsc.transaction.impl.ejb.adapter.EjbTransactionCMTAdapt er_z73hg_ELOImpl.doSupports(EjbTransactionCMTAdapter_z73hg_ELOImpl.jav a:457)
    at com.adobe.idp.dsc.transaction.impl.ejb.EjbTransactionProvider.execute (EjbTransactionProvider.java:104)
    at com.adobe.idp.dsc.transaction.interceptor.TransactionInterceptor.inte rcept(TransactionInterceptor.java:72)
    at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.procee d(RequestInterceptorChainImpl.java:60)
    at com.adobe.idp.dsc.interceptor.impl.InvocationStrategyInterceptor.inte rcept(InvocationStrategyInterceptor.java:55)
    at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.procee d(RequestInterceptorChainImpl.java:60)
    at com.adobe.idp.dsc.interceptor.impl.InvalidStateInterceptor.intercept( InvalidStateInterceptor.java:37)
    at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.procee d(RequestInterceptorChainImpl.java:60)
    at com.adobe.idp.dsc.interceptor.impl.AuthorizationInterceptor.intercept (AuthorizationInterceptor.java:165)
    at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.procee d(RequestInterceptorChainImpl.java:60)
    at com.adobe.idp.dsc.interceptor.impl.JMXInterceptor.intercept(JMXInterc eptor.java:48)
    at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.procee d(RequestInterceptorChainImpl.java:60)
    at com.adobe.idp.dsc.engine.impl.ServiceEngineImpl.invoke(ServiceEngineI mpl.java:115)
    at com.adobe.idp.dsc.routing.Router.routeRequest(Router.java:129)
    at com.adobe.idp.dsc.provider.impl.base.AbstractMessageReceiver.routeMes sage(AbstractMessageReceiver.java:93)
    at com.adobe.idp.dsc.provider.impl.vm.VMMessageDispatcher.doSend(VMMessa geDispatcher.java:198)
    at com.adobe.idp.dsc.provider.impl.base.AbstractMessageDispatcher.send(A bstractMessageDispatcher.java:66)
    at com.adobe.idp.dsc.clientsdk.ServiceClient.invoke(ServiceClient.java:2 08)
    at com.adobe.idp.taskmanager.dsc.client.TypedTaskManagerQueryService.inv okeWithRetry(TypedTaskManagerQueryService.java:108)
    at com.adobe.idp.taskmanager.dsc.client.TypedTaskManagerQueryService.pro cessSearch(TypedTaskManagerQueryService.java:294)
    at com.adobe.workspace.processes.TrackingQueries.getProcessInstances(Tra ckingQueries.java:142)
    at sun.reflect.GeneratedMethodAccessor10050.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at flex.messaging.services.remoting.adapters.JavaAdapter.invoke(JavaAdap ter.java:421)
    at flex.messaging.services.RemotingService.serviceMessage(RemotingServic e.java:183)
    at flex.messaging.MessageBroker.routeMessageToService(MessageBroker.java :1406)
    at flex.messaging.AsyncMessageBroker.routeMessageToService(AsyncMessageB roker.java:571)
    at flex.messaging.endpoints.AbstractEndpoint.serviceMessage(AbstractEndp oint.java:1005)
    at flex.messaging.endpoints.amf.MessageBrokerFilter.invoke(MessageBroker Filter.java:103)
    at flex.messaging.endpoints.amf.LegacyFilter.invoke(LegacyFilter.java:15 8)
    at flex.messaging.endpoints.amf.SessionFilter.invoke(SessionFilter.java: 44)
    at flex.messaging.endpoints.amf.BatchProcessFilter.invoke(BatchProcessFi lter.java:67)
    at flex.messaging.endpoints.amf.SerializationFilter.invoke(Serialization Filter.java:165)
    at flex.messaging.endpoints.BaseHTTPEndpoint.service(BaseHTTPEndpoint.ja va:293)
    at flex.messaging.MessageBrokerServlet.service(MessageBrokerServlet.java :364)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
    at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run (StubSecurityHelper.java:227)
    at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecuri tyHelper.java:125)
    at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.jav a:292)
    at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.ja va:42)
    at com.adobe.workspace.events.RemoteEventClientLifeCycle.doFilter(Remote EventClientLifeCycle.java:152)
    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.ja va:42)
    at weblogic.servlet.internal.WebAppServletContext$ServletInvocationActio n.run(WebAppServletContext.java:3496)
    at weblogic.security.acl.internal.AuthenticatedSubject.doAs(Authenticate dSubject.java:321)
    at weblogic.security.service.SecurityManager.runAs(Unknown Source)
    at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppS ervletContext.java:2180)
    at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletC ontext.java:2086)
    at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.j ava:1406)
    at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
    at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
>

 

 

 

Any ideas?

Tracking on other processes and applications is working fine.

 
Replies
  • Currently Being Moderated
    Feb 1, 2011 7:48 AM   in reply to Adam_Chojnacki

    I would look at the process variable definitions you have that are marked Searchable / Visible.  Maybe a string type with unlimited size or something like that.  Looks like Oracle is having a problem with something that is defined as an NCLOB.  If using a string, try to give it an appropriate upper size.

     
    |
    Mark as:
  • Currently Being Moderated
    Feb 1, 2011 8:22 AM   in reply to Adam_Chojnacki

    Just double checking, the stack says the error is occurring with a different process than you mentioned in the bug.

     

    ==> An error occurred while retrieving the list of process instances for process "dbCreditCounter/Processes/CC01_CreditWorkflow".

     

    Are you looking at the right process?

     

    Also, which version of Oracle are you using ( I found some hits says oracle 11g throws this in some cases where 10g didn't).

     

    Jon

     
    |
    Mark as:
  • Currently Being Moderated
    Feb 1, 2011 11:12 AM   in reply to Adam_Chojnacki

    i'm not ready to give up on those process variable strings yet.  what are the max lengths and were they ever changed.  also check the database table for that process (name will be tb_pt_<somenumber>) and see how the columns are defined - do they match your defs.

     
    |
    Mark as:
  • Currently Being Moderated
    Feb 1, 2011 6:52 PM   in reply to Adam_Chojnacki

    I'm pretty sure there is a way to find the process to db tablename mapping but I don't recall what it is.  Maybe someone else reading this can chime in.  F
    I don't usually have that many processes defined so I just get the table schema for each one at a time until I see the columns that match and then use a processinstanceid from the table to confirm it is the correct process by looking it up in the tb_processinstance table.  Not elegant but it works for a small number of tables.

     

    Also, I have a correction on the tablename format.  it is just tb_<some_number>.

     
    |
    Mark as:
  • Currently Being Moderated
    Feb 2, 2011 5:08 AM   in reply to Jon Bionda

    The following sql statement will give you the table name for a particular process:

     

    SELECT database_table FROM omd_object_type where name = processName;

     

    Jasmin

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points