10 Replies Latest reply: Feb 11, 2011 6:19 AM by Adam_Chojnacki RSS

    Tracking - ALC-WKS-007-044 Error

    Adam_Chojnacki

      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.EjbTransactionCMTAdapter_z73hg_LocalHomeImp l@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.java:91)
          at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
          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(T4CPreparedStatement.java:785)
          at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:86 0)
          at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
          at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3 381)
          at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3425 )
          at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWra pper.java:1490)
          at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:128)
          at com.adobe.pof.adapter.oracle.Oracle9iAdapter.retrieveObjectSet(Oracle9iAdapter.java:1067)
          at com.adobe.pof.adapter.oracle.Oracle9iAdapter.retrieveObjectSet(Oracle9iAdapter.java:892)
          at com.adobe.pof.omapi.POFObjectManagerImpl.retrieveObjectSet(POFObjectManagerImpl.java:148)
          at com.adobe.pof.omapi.POFObjectManagerRemoteBean.retrieveObjectSet(POFObjectManagerRemoteBe an.java:228)
          at com.adobe.pof.omapi.POFObjectManagerLocalBean_j8d0wl_ELOImpl.retrieveObjectSet(POFObjectM anagerLocalBean_j8d0wl_ELOImpl.java:1418)
          at com.adobe.pof.omapi.POFObjectManagerLocalEJBAdapter.retrieveObjectSet(POFObjectManagerLoc alEJBAdapter.java:115)
          at com.adobe.pof.omapi.POFObjectManagerAbstractAdapter.retrieveObjectSet(POFObjectManagerAbs tractAdapter.java:481)
          at com.adobe.idp.taskmanager.dsc.queryservice.TaskManagerQueryServiceImpl.processSearch(Task ManagerQueryServiceImpl.java:1016)
          at sun.reflect.GeneratedMethodAccessor9630.invoke(Unknown Source)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
          at java.lang.reflect.Method.invoke(Method.java:597)
          at com.adobe.idp.dsc.component.impl.DefaultPOJOInvokerImpl.invoke(DefaultPOJOInvokerImpl.jav a:118)
          at com.adobe.idp.dsc.interceptor.impl.InvocationInterceptor.intercept(InvocationInterceptor. java:140)
          at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.proceed(RequestInterceptor ChainImpl.java:60)
          at com.adobe.idp.dsc.interceptor.impl.DocumentPassivationInterceptor.intercept(DocumentPassi vationInterceptor.java:53)
          at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.proceed(RequestInterceptor ChainImpl.java:60)
          at com.adobe.idp.dsc.transaction.interceptor.TransactionInterceptor$1.doInTransaction(Transa ctionInterceptor.java:74)
          at com.adobe.idp.dsc.transaction.impl.ejb.adapter.EjbTransactionCMTAdapterBean.execute(EjbTr ansactionCMTAdapterBean.java:357)
          at com.adobe.idp.dsc.transaction.impl.ejb.adapter.EjbTransactionCMTAdapterBean.doSupports(Ej bTransactionCMTAdapterBean.java:227)
          at com.adobe.idp.dsc.transaction.impl.ejb.adapter.EjbTransactionCMTAdapter_z73hg_ELOImpl.doS upports(EjbTransactionCMTAdapter_z73hg_ELOImpl.java:457)
          at com.adobe.idp.dsc.transaction.impl.ejb.EjbTransactionProvider.execute(EjbTransactionProvi der.java:104)
          at com.adobe.idp.dsc.transaction.interceptor.TransactionInterceptor.intercept(TransactionInt erceptor.java:72)
          at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.proceed(RequestInterceptor ChainImpl.java:60)
          at com.adobe.idp.dsc.interceptor.impl.InvocationStrategyInterceptor.intercept(InvocationStra tegyInterceptor.java:55)
          at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.proceed(RequestInterceptor ChainImpl.java:60)
          at com.adobe.idp.dsc.interceptor.impl.InvalidStateInterceptor.intercept(InvalidStateIntercep tor.java:37)
          at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.proceed(RequestInterceptor ChainImpl.java:60)
          at com.adobe.idp.dsc.interceptor.impl.AuthorizationInterceptor.intercept(AuthorizationInterc eptor.java:165)
          at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.proceed(RequestInterceptor ChainImpl.java:60)
          at com.adobe.idp.dsc.interceptor.impl.JMXInterceptor.intercept(JMXInterceptor.java:48)
          at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.proceed(RequestInterceptor ChainImpl.java:60)
          at com.adobe.idp.dsc.engine.impl.ServiceEngineImpl.invoke(ServiceEngineImpl.java:115)
          at com.adobe.idp.dsc.routing.Router.routeRequest(Router.java:129)
          at com.adobe.idp.dsc.provider.impl.base.AbstractMessageReceiver.routeMessage(AbstractMessage Receiver.java:93)
          at com.adobe.idp.dsc.provider.impl.vm.VMMessageDispatcher.doSend(VMMessageDispatcher.java:19 8)
          at com.adobe.idp.dsc.provider.impl.base.AbstractMessageDispatcher.send(AbstractMessageDispat cher.java:66)
          at com.adobe.idp.dsc.clientsdk.ServiceClient.invoke(ServiceClient.java:208)
          at com.adobe.idp.taskmanager.dsc.client.TypedTaskManagerQueryService.invokeWithRetry(TypedTa skManagerQueryService.java:108)
          at com.adobe.idp.taskmanager.dsc.client.TypedTaskManagerQueryService.processSearch(TypedTask ManagerQueryService.java:294)
          at com.adobe.workspace.processes.TrackingQueries.getProcessInstances(TrackingQueries.java:14 2)
          at sun.reflect.GeneratedMethodAccessor10050.invoke(Unknown Source)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
          at java.lang.reflect.Method.invoke(Method.java:597)
          at flex.messaging.services.remoting.adapters.JavaAdapter.invoke(JavaAdapter.java:421)
          at flex.messaging.services.RemotingService.serviceMessage(RemotingService.java:183)
          at flex.messaging.MessageBroker.routeMessageToService(MessageBroker.java:1406)
          at flex.messaging.AsyncMessageBroker.routeMessageToService(AsyncMessageBroker.java:571)
          at flex.messaging.endpoints.AbstractEndpoint.serviceMessage(AbstractEndpoint.java:1005)
          at flex.messaging.endpoints.amf.MessageBrokerFilter.invoke(MessageBrokerFilter.java:103)
          at flex.messaging.endpoints.amf.LegacyFilter.invoke(LegacyFilter.java:158)
          at flex.messaging.endpoints.amf.SessionFilter.invoke(SessionFilter.java:44)
          at flex.messaging.endpoints.amf.BatchProcessFilter.invoke(BatchProcessFilter.java:67)
          at flex.messaging.endpoints.amf.SerializationFilter.invoke(SerializationFilter.java:165)
          at flex.messaging.endpoints.BaseHTTPEndpoint.service(BaseHTTPEndpoint.java: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(StubSecurityHelper.java:125)
          at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:292)
          at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
          at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)
          at com.adobe.workspace.events.RemoteEventClientLifeCycle.doFilter(RemoteEventClientLifeCycle .java:152)
          at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)
          at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletC ontext.java:3496)
          at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
          at weblogic.security.service.SecurityManager.runAs(Unknown Source)
          at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2 180)
          at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2086)
          at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java: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.java:91)
          at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
          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(T4CPreparedStatement.java:785)
          at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:86 0)
          at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
          at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3 381)
          at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3425 )
          at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWra pper.java:1490)
          at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:128)
          at com.adobe.pof.adapter.oracle.Oracle9iAdapter.retrieveObjectSet(Oracle9iAdapter.java:1067)
          at com.adobe.pof.adapter.oracle.Oracle9iAdapter.retrieveObjectSet(Oracle9iAdapter.java:892)
          at com.adobe.pof.omapi.POFObjectManagerImpl.retrieveObjectSet(POFObjectManagerImpl.java:148)
          at com.adobe.pof.omapi.POFObjectManagerRemoteBean.retrieveObjectSet(POFObjectManagerRemoteBe an.java:228)
          at com.adobe.pof.omapi.POFObjectManagerLocalBean_j8d0wl_ELOImpl.retrieveObjectSet(POFObjectM anagerLocalBean_j8d0wl_ELOImpl.java:1418)
          at com.adobe.pof.omapi.POFObjectManagerLocalEJBAdapter.retrieveObjectSet(POFObjectManagerLoc alEJBAdapter.java:115)
          at com.adobe.pof.omapi.POFObjectManagerAbstractAdapter.retrieveObjectSet(POFObjectManagerAbs tractAdapter.java:481)
          at com.adobe.idp.taskmanager.dsc.queryservice.TaskManagerQueryServiceImpl.processSearch(Task ManagerQueryServiceImpl.java:1016)
          at sun.reflect.GeneratedMethodAccessor9630.invoke(Unknown Source)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
          at java.lang.reflect.Method.invoke(Method.java:597)
          at com.adobe.idp.dsc.component.impl.DefaultPOJOInvokerImpl.invoke(DefaultPOJOInvokerImpl.jav a:118)
          at com.adobe.idp.dsc.interceptor.impl.InvocationInterceptor.intercept(InvocationInterceptor. java:140)
          at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.proceed(RequestInterceptor ChainImpl.java:60)
          at com.adobe.idp.dsc.interceptor.impl.DocumentPassivationInterceptor.intercept(DocumentPassi vationInterceptor.java:53)
          at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.proceed(RequestInterceptor ChainImpl.java:60)
          at com.adobe.idp.dsc.transaction.interceptor.TransactionInterceptor$1.doInTransaction(Transa ctionInterceptor.java:74)
          at com.adobe.idp.dsc.transaction.impl.ejb.adapter.EjbTransactionCMTAdapterBean.execute(EjbTr ansactionCMTAdapterBean.java:357)
          at com.adobe.idp.dsc.transaction.impl.ejb.adapter.EjbTransactionCMTAdapterBean.doSupports(Ej bTransactionCMTAdapterBean.java:227)
          at com.adobe.idp.dsc.transaction.impl.ejb.adapter.EjbTransactionCMTAdapter_z73hg_ELOImpl.doS upports(EjbTransactionCMTAdapter_z73hg_ELOImpl.java:457)
          at com.adobe.idp.dsc.transaction.impl.ejb.EjbTransactionProvider.execute(EjbTransactionProvi der.java:104)
          at com.adobe.idp.dsc.transaction.interceptor.TransactionInterceptor.intercept(TransactionInt erceptor.java:72)
          at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.proceed(RequestInterceptor ChainImpl.java:60)
          at com.adobe.idp.dsc.interceptor.impl.InvocationStrategyInterceptor.intercept(InvocationStra tegyInterceptor.java:55)
          at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.proceed(RequestInterceptor ChainImpl.java:60)
          at com.adobe.idp.dsc.interceptor.impl.InvalidStateInterceptor.intercept(InvalidStateIntercep tor.java:37)
          at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.proceed(RequestInterceptor ChainImpl.java:60)
          at com.adobe.idp.dsc.interceptor.impl.AuthorizationInterceptor.intercept(AuthorizationInterc eptor.java:165)
          at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.proceed(RequestInterceptor ChainImpl.java:60)
          at com.adobe.idp.dsc.interceptor.impl.JMXInterceptor.intercept(JMXInterceptor.java:48)
          at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.proceed(RequestInterceptor ChainImpl.java:60)
          at com.adobe.idp.dsc.engine.impl.ServiceEngineImpl.invoke(ServiceEngineImpl.java:115)
          at com.adobe.idp.dsc.routing.Router.routeRequest(Router.java:129)
          at com.adobe.idp.dsc.provider.impl.base.AbstractMessageReceiver.routeMessage(AbstractMessage Receiver.java:93)
          at com.adobe.idp.dsc.provider.impl.vm.VMMessageDispatcher.doSend(VMMessageDispatcher.java:19 8)
          at com.adobe.idp.dsc.provider.impl.base.AbstractMessageDispatcher.send(AbstractMessageDispat cher.java:66)
          at com.adobe.idp.dsc.clientsdk.ServiceClient.invoke(ServiceClient.java:208)
          at com.adobe.idp.taskmanager.dsc.client.TypedTaskManagerQueryService.invokeWithRetry(TypedTa skManagerQueryService.java:108)
          at com.adobe.idp.taskmanager.dsc.client.TypedTaskManagerQueryService.processSearch(TypedTask ManagerQueryService.java:294)
          at com.adobe.workspace.processes.TrackingQueries.getProcessInstances(TrackingQueries.java:14 2)
          at sun.reflect.GeneratedMethodAccessor10050.invoke(Unknown Source)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
          at java.lang.reflect.Method.invoke(Method.java:597)
          at flex.messaging.services.remoting.adapters.JavaAdapter.invoke(JavaAdapter.java:421)
          at flex.messaging.services.RemotingService.serviceMessage(RemotingService.java:183)
          at flex.messaging.MessageBroker.routeMessageToService(MessageBroker.java:1406)
          at flex.messaging.AsyncMessageBroker.routeMessageToService(AsyncMessageBroker.java:571)
          at flex.messaging.endpoints.AbstractEndpoint.serviceMessage(AbstractEndpoint.java:1005)
          at flex.messaging.endpoints.amf.MessageBrokerFilter.invoke(MessageBrokerFilter.java:103)
          at flex.messaging.endpoints.amf.LegacyFilter.invoke(LegacyFilter.java:158)
          at flex.messaging.endpoints.amf.SessionFilter.invoke(SessionFilter.java:44)
          at flex.messaging.endpoints.amf.BatchProcessFilter.invoke(BatchProcessFilter.java:67)
          at flex.messaging.endpoints.amf.SerializationFilter.invoke(SerializationFilter.java:165)
          at flex.messaging.endpoints.BaseHTTPEndpoint.service(BaseHTTPEndpoint.java: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(StubSecurityHelper.java:125)
          at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:292)
          at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
          at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)
          at com.adobe.workspace.events.RemoteEventClientLifeCycle.doFilter(RemoteEventClientLifeCycle .java:152)
          at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)
          at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletC ontext.java:3496)
          at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
          at weblogic.security.service.SecurityManager.runAs(Unknown Source)
          at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2 180)
          at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2086)
          at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java: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(EJBRuntimeUtils.java:15 1)
          at weblogic.ejb.container.internal.BaseLocalObject.handleSystemException(BaseLocalObject.jav a:850)
          at weblogic.ejb.container.internal.BaseLocalObject.handleSystemException(BaseLocalObject.jav a:791)
          at weblogic.ejb.container.internal.BaseLocalObject.postInvoke1(BaseLocalObject.java:486)
          at weblogic.ejb.container.internal.BaseLocalObject.postInvokeTxRetry(BaseLocalObject.java:42 4)
          at com.adobe.pof.omapi.POFObjectManagerLocalBean_j8d0wl_ELOImpl.retrieveObjectSet(POFObjectM anagerLocalBean_j8d0wl_ELOImpl.java:1433)
          at com.adobe.pof.omapi.POFObjectManagerLocalEJBAdapter.retrieveObjectSet(POFObjectManagerLoc alEJBAdapter.java:115)
          at com.adobe.pof.omapi.POFObjectManagerAbstractAdapter.retrieveObjectSet(POFObjectManagerAbs tractAdapter.java:481)
          at com.adobe.idp.taskmanager.dsc.queryservice.TaskManagerQueryServiceImpl.processSearch(Task ManagerQueryServiceImpl.java:1016)
          at sun.reflect.GeneratedMethodAccessor9630.invoke(Unknown Source)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
          at java.lang.reflect.Method.invoke(Method.java:597)
          at com.adobe.idp.dsc.component.impl.DefaultPOJOInvokerImpl.invoke(DefaultPOJOInvokerImpl.jav a:118)
          at com.adobe.idp.dsc.interceptor.impl.InvocationInterceptor.intercept(InvocationInterceptor. java:140)
          at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.proceed(RequestInterceptor ChainImpl.java:60)
          at com.adobe.idp.dsc.interceptor.impl.DocumentPassivationInterceptor.intercept(DocumentPassi vationInterceptor.java:53)
          at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.proceed(RequestInterceptor ChainImpl.java:60)
          at com.adobe.idp.dsc.transaction.interceptor.TransactionInterceptor$1.doInTransaction(Transa ctionInterceptor.java:74)
          at com.adobe.idp.dsc.transaction.impl.ejb.adapter.EjbTransactionCMTAdapterBean.execute(EjbTr ansactionCMTAdapterBean.java:357)
          at com.adobe.idp.dsc.transaction.impl.ejb.adapter.EjbTransactionCMTAdapterBean.doSupports(Ej bTransactionCMTAdapterBean.java:227)
          at com.adobe.idp.dsc.transaction.impl.ejb.adapter.EjbTransactionCMTAdapter_z73hg_ELOImpl.doS upports(EjbTransactionCMTAdapter_z73hg_ELOImpl.java:457)
          at com.adobe.idp.dsc.transaction.impl.ejb.EjbTransactionProvider.execute(EjbTransactionProvi der.java:104)
          at com.adobe.idp.dsc.transaction.interceptor.TransactionInterceptor.intercept(TransactionInt erceptor.java:72)
          at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.proceed(RequestInterceptor ChainImpl.java:60)
          at com.adobe.idp.dsc.interceptor.impl.InvocationStrategyInterceptor.intercept(InvocationStra tegyInterceptor.java:55)
          at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.proceed(RequestInterceptor ChainImpl.java:60)
          at com.adobe.idp.dsc.interceptor.impl.InvalidStateInterceptor.intercept(InvalidStateIntercep tor.java:37)
          at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.proceed(RequestInterceptor ChainImpl.java:60)
          at com.adobe.idp.dsc.interceptor.impl.AuthorizationInterceptor.intercept(AuthorizationInterc eptor.java:165)
          at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.proceed(RequestInterceptor ChainImpl.java:60)
          at com.adobe.idp.dsc.interceptor.impl.JMXInterceptor.intercept(JMXInterceptor.java:48)
          at com.adobe.idp.dsc.interceptor.impl.RequestInterceptorChainImpl.proceed(RequestInterceptor ChainImpl.java:60)
          at com.adobe.idp.dsc.engine.impl.ServiceEngineImpl.invoke(ServiceEngineImpl.java:115)
          at com.adobe.idp.dsc.routing.Router.routeRequest(Router.java:129)
          at com.adobe.idp.dsc.provider.impl.base.AbstractMessageReceiver.routeMessage(AbstractMessage Receiver.java:93)
          at com.adobe.idp.dsc.provider.impl.vm.VMMessageDispatcher.doSend(VMMessageDispatcher.java:19 8)
          at com.adobe.idp.dsc.provider.impl.base.AbstractMessageDispatcher.send(AbstractMessageDispat cher.java:66)
          at com.adobe.idp.dsc.clientsdk.ServiceClient.invoke(ServiceClient.java:208)
          at com.adobe.idp.taskmanager.dsc.client.TypedTaskManagerQueryService.invokeWithRetry(TypedTa skManagerQueryService.java:108)
          at com.adobe.idp.taskmanager.dsc.client.TypedTaskManagerQueryService.processSearch(TypedTask ManagerQueryService.java:294)
          at com.adobe.workspace.processes.TrackingQueries.getProcessInstances(TrackingQueries.java:14 2)
          at sun.reflect.GeneratedMethodAccessor10050.invoke(Unknown Source)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
          at java.lang.reflect.Method.invoke(Method.java:597)
          at flex.messaging.services.remoting.adapters.JavaAdapter.invoke(JavaAdapter.java:421)
          at flex.messaging.services.RemotingService.serviceMessage(RemotingService.java:183)
          at flex.messaging.MessageBroker.routeMessageToService(MessageBroker.java:1406)
          at flex.messaging.AsyncMessageBroker.routeMessageToService(AsyncMessageBroker.java:571)
          at flex.messaging.endpoints.AbstractEndpoint.serviceMessage(AbstractEndpoint.java:1005)
          at flex.messaging.endpoints.amf.MessageBrokerFilter.invoke(MessageBrokerFilter.java:103)
          at flex.messaging.endpoints.amf.LegacyFilter.invoke(LegacyFilter.java:158)
          at flex.messaging.endpoints.amf.SessionFilter.invoke(SessionFilter.java:44)
          at flex.messaging.endpoints.amf.BatchProcessFilter.invoke(BatchProcessFilter.java:67)
          at flex.messaging.endpoints.amf.SerializationFilter.invoke(SerializationFilter.java:165)
          at flex.messaging.endpoints.BaseHTTPEndpoint.service(BaseHTTPEndpoint.java: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(StubSecurityHelper.java:125)
          at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:292)
          at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
          at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)
          at com.adobe.workspace.events.RemoteEventClientLifeCycle.doFilter(RemoteEventClientLifeCycle .java:152)
          at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)
          at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletC ontext.java:3496)
          at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
          at weblogic.security.service.SecurityManager.runAs(Unknown Source)
          at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2 180)
          at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2086)
          at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java: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.

        • 1. Re: Tracking - ALC-WKS-007-044 Error
          Jon Bionda techies

          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.

          • 2. Re: Tracking - ALC-WKS-007-044 Error
            Adam_Chojnacki Community Member

            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.

            • 3. Re: Tracking - ALC-WKS-007-044 Error
              Jon Bionda techies

              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

              • 4. Re: Tracking - ALC-WKS-007-044 Error
                Adam_Chojnacki Community Member

                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"

                • 5. Re: Tracking - ALC-WKS-007-044 Error
                  Jon Bionda techies

                  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.

                  • 6. Re: Tracking - ALC-WKS-007-044 Error
                    Adam_Chojnacki Community Member

                    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?)

                    • 7. Re: Tracking - ALC-WKS-007-044 Error
                      Jon Bionda techies

                      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>.

                      • 8. Re: Tracking - ALC-WKS-007-044 Error
                        Jasmin Charbonneau techies

                        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

                        • 9. Re: Tracking - ALC-WKS-007-044 Error
                          Adam_Chojnacki Community Member

                          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  ?

                          • 10. Re: Tracking - ALC-WKS-007-044 Error
                            Adam_Chojnacki Community Member

                            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.