Skip navigation
Adam_Chojnacki
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.

952 Views   10 Replies   Latest reply: Adam_Chojnacki, Feb 11, 2011 6:19 AM
 
Replies
  • Jon Bionda
    Currently Being Moderated
    1. Jon Bionda,
    Feb 1, 2011 7:48 AM   in reply to Adam_Chojnacki
    Report

    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:
  • Adam_Chojnacki
    Currently Being Moderated
    2. Adam_Chojnacki,
    Feb 1, 2011 8:12 AM   in reply to Jon Bionda
    Report

    Thanks for reply,

     

    I have 3  variables which are marked visible and searchable.

     

    One is long, two others are strings.

     

    All my string variables have max length property set (no unlimited length ).

     

     

    P.S.

     

    When I undelpoyed my application - tracking data started to working for that process.


    When process is deployed - tracking fails.

     
    |
    Mark as:
  • Jon Bionda
    Currently Being Moderated
    3. Jon Bionda,
    Feb 1, 2011 8:22 AM   in reply to Adam_Chojnacki
    Report

    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:
  • Adam_Chojnacki
    Currently Being Moderated
    4. Adam_Chojnacki,
    Feb 1, 2011 10:58 AM   in reply to Jon Bionda
    Report

    Yes I am looking at  the right process (I changed process name when pasting this post).

     

     

    I think I  am woking with Oracle 10g -  I will check it tomorrow.

    I also checked that in adminui (process managemt) - process searching works well.

     

    My process is quite big (77 activities) and it works fine - the only problem is with "tracking"

     
    |
    Mark as:
  • Jon Bionda
    Currently Being Moderated
    5. Jon Bionda,
    Feb 1, 2011 11:12 AM   in reply to Adam_Chojnacki
    Report

    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:
  • Adam_Chojnacki
    Currently Being Moderated
    6. Adam_Chojnacki,
    Feb 1, 2011 12:29 PM   in reply to Jon Bionda
    Report

    Thanks for determination.

     

    So I have around 20 process variables (7 of them are configuration parameters type string with max length 100 or 255).

     

    As I was saying 3 of my variables are searchable and visible.

    1st is Long - default value 0

    2nd string max 100 (It might have been changed ... even from unlimited)

    3rd string max 20 (It might have been changed also ... from 200 ..)

     

    I have one variable with xml type and other with type TaskResult.

    The rest are string variables with max set to 100 or 255.

     

    Right now I am not able to check tb_pt_ tables.

     

    Question:

    How to find which tb_pt table is for my process (this magical <somenumber> is random generated?)

     
    |
    Mark as:
  • Jon Bionda
    Currently Being Moderated
    7. Jon Bionda,
    Feb 1, 2011 6:52 PM   in reply to Adam_Chojnacki
    Report

    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:
  • Jasmin Charbonneau
    Currently Being Moderated
    8. Jasmin Charbonneau,
    Feb 2, 2011 5:08 AM   in reply to Jon Bionda
    Report

    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:
  • Adam_Chojnacki
    Currently Being Moderated
    9. Adam_Chojnacki,
    Feb 10, 2011 12:09 AM   in reply to Jasmin Charbonneau
    Report

    Thanks for tip.

     

    So I checked my LC server is running with Oracle 10g.

     

    And I found out that the root of my problem is process variable:

    customerName - type string - max length 100 - marked visible

     

    It previously was defined as unlimited.

     

    In LC data base (in porcess table) column customerName is type NCLOB - but it should be NVARCHAR(100).

     

    After changing variable definition form unlimited to max 100 - tracking (and process searching) started to work.

    But process workflow itsefl - freezes after 3rd step - no error, in adminui state of the process is running (it si not stalled).

     

    I even changed variable name (old column NCLOB still remains) and I chaged process name - no luck.

     

    Is there any solution to fix this process - purge data form tb_ table ? change column definiftion for customerName ?

    Should I create new application and copy process definfion to fix this  ?

     
    |
    Mark as:
  • Adam_Chojnacki
    Currently Being Moderated
    10. Adam_Chojnacki,
    Feb 11, 2011 6:19 AM   in reply to Adam_Chojnacki
    Report

    So I finally have solved my problem.

     

    I set variable (customerName) length back to unlimited and unmark "visible in UI" option".

    I could not rename or delete it because those operations were causing that process freezes.

    The reason of this freeze behavior was that "customerName" was used in task description text (Xpath expresion).

     

    And i created new variable customerDisplayName max chars 100 and visible in UI.

     

    Tracking is workig and process is working.

     
    |
    Mark as:
Actions

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