topic Error when accessing the Journal in EE 4.2.2 in Talend Data Catalog

Error when accessing the Journal in EE 4.2.2

Anonymous — Sat, 16 Nov 2024 12:43:12 GMT

Hello,
I recently migrated to MDM EE 4.2.2. The searches and the overall performance is a lot better than 4.1.2 with eXistDB. However, when I try to access the Journal, it never comes back. After spinning for sometime I see the below error.
*** PLEASE NOTE THAT WE HIRED CONSULTANTS FROM TALEND, BUT STILL COULD NOT RESOLVE THIS ISSUE. ANY HELP IS APPRECIATED ****
{code}
2011-08-25 12:53:16,607 WARN - Abort of action id a64f076:b96a:4e563d55:172a invoked while multiple threads active within it.
2011-08-25 12:53:16,607 WARN - CheckedAction::check - atomic action a64f076:b96a:4e563d55:172a aborting with 1 threads active!
2011-08-25 12:54:38,050 ERROR TransactionRolledbackException in method: public com.amalto.core.webservice.WSStringArray com.amalto.core.ejb.XtentisEnterpriseWSBean.getItems(com.amalto.core.webservice.WSGetItems) throws java.rmi.RemoteException, causedBy:
java.lang.IllegalStateException: The transaction is not active!
at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commit(TransactionImple.java:225)
at org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.java:501)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:361)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:168)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138)
at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:648)
at org.jboss.ejb.Container.invoke(Container.java:960)
at sun.reflect.GeneratedMethodAccessor203.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.wsf.container.jboss42.InvocationHandlerEJB21.invoke(InvocationHandlerEJB21.java:147)
at org.jboss.ws.core.server.ServiceEndpointInvoker.invoke(ServiceEndpointInvoker.java:220)
at org.jboss.wsf.stack.jbws.RequestHandlerImpl.processRequest(RequestHandlerImpl.java:408)
at org.jboss.wsf.stack.jbws.RequestHandlerImpl.handleRequest(RequestHandlerImpl.java:272)
at org.jboss.wsf.stack.jbws.RequestHandlerImpl.doPost(RequestHandlerImpl.java:189)
at org.jboss.wsf.stack.jbws.RequestHandlerImpl.handleHttpRequest(RequestHandlerImpl.java:122)
at org.jboss.wsf.stack.jbws.EndpointServlet.service(EndpointServlet.java:84)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:524)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:393)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
at java.lang.Thread.run(Thread.java:619)
2011-08-25 12:54:38,052 ERROR SOAP request exception
org.jboss.tm.JBossTransactionRolledbackException: null; nested exception is:
java.lang.IllegalStateException: The transaction is not active!; - nested throwable: (java.lang.IllegalStateException: The transaction is not active!)
at org.jboss.ejb.plugins.TxInterceptorCMT.throwJBossException(TxInterceptorCMT.java:574)
at org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.java:522)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:361)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:168)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138)
at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:648)
at org.jboss.ejb.Container.invoke(Container.java:960)
at sun.reflect.GeneratedMethodAccessor203.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.wsf.container.jboss42.InvocationHandlerEJB21.invoke(InvocationHandlerEJB21.java:147)
at org.jboss.ws.core.server.ServiceEndpointInvoker.invoke(ServiceEndpointInvoker.java:220)
at org.jboss.wsf.stack.jbws.RequestHandlerImpl.processRequest(RequestHandlerImpl.java:408)
at org.jboss.wsf.stack.jbws.RequestHandlerImpl.handleRequest(RequestHandlerImpl.java:272)
at org.jboss.wsf.stack.jbws.RequestHandlerImpl.doPost(RequestHandlerImpl.java:189)
at org.jboss.wsf.stack.jbws.RequestHandlerImpl.handleHttpRequest(RequestHandlerImpl.java:122)
at org.jboss.wsf.stack.jbws.EndpointServlet.service(EndpointServlet.java:84)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:524)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:393)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
at java.lang.Thread.run(Thread.java:619)
{code}

Re: Error when accessing the Journal in EE 4.2.2

Anonymous — Fri, 26 Aug 2011 12:27:41 GMT

Team Talend! This is happening in our PRODUCTION environment. Could someone suggest something?

Re: Error when accessing the Journal in EE 4.2.2

Anonymous — Mon, 29 Aug 2011 16:02:02 GMT

Can you send us your server.log? The thread / transaction issue might be caused by another error, so this might be consequence, not the root cause. I need more context information to help.

Re: Error when accessing the Journal in EE 4.2.2

Anonymous — Tue, 30 Aug 2011 02:08:55 GMT

I suspect the query performed onto the server is never ending (taking quite a long time), thus causing the Jboss container transaction to abort. Would be interesting to figure out what's the query that is run onto the journal.

Re: Error when accessing the Journal in EE 4.2.2

Anonymous — Tue, 30 Aug 2011 03:47:36 GMT

Ctoum,
I could not upload a file here, so I uploaded it to the BUG i created in Jira http://jira.talendforge.org/browse/TMDM-2404
Let me know if you need any further information.
Pbabin,
I'm not sure what query is executed when I hit the journal, is there anyway i can get that? I can reproduce this problem anytime.

Re: Error when accessing the Journal in EE 4.2.2

Anonymous — Thu, 01 Sep 2011 19:09:51 GMT

It is a long running Qizx journal query that has multiple XPath conditions:
"Concept" equals
AND
"TimeInMillis" >= String.valueOf(TalendDate.addDate(TalendDate.getCurrentDate(),context.mdmTimeInterval,"dd").getTime())
for Document example:
<II>
<C>UpdateReport</C>
<N>Update</N>
<DMN>UpdateReport</DMN>
<DMR></DMR>
<SP></SP>
TOS
1294608477766
<T>1294608477769</T>

<UPDATE>
<USERNAME>user</USERNAME>
<SOURCE>TOS</SOURCE>
<TIMEINMILLIS>1294608477766</TIMEINMILLIS>
<OPERATIONTYPE>UPDATE</OPERATIONTYPE>
<REVISIONID>null</REVISIONID>
<DATACLUSTER>SecurityMaster</DATACLUSTER>
<DATAMODEL>SecurityMaster</DATAMODEL>
<CONCEPT>ReferenceEntity</CONCEPT>
<KEY>704</KEY>
<ITEM>
<PATH>sector_class_id</PATH>
<OLDVALUE></OLDVALUE>
<NEWVALUE></NEWVALUE>
</ITEM>
</UPDATE>

Re: Error when accessing the Journal in EE 4.2.2

Anonymous — Thu, 01 Sep 2011 19:13:51 GMT

We have found the the arjuna timeout setting in
talend422/mdm/jboss-4.2.2.GA/server/default/conf/jbossjta-properties.xml and will be increasing it.
<TRANSACTION-SERVICE>
<PROPERTIES depends="common" name="arjuna">

Re: Error when accessing the Journal in EE 4.2.2

Anonymous — Tue, 06 Sep 2011 15:47:57 GMT

We are able to increase the arjuna transaction timeout enough that the MDM component is now failing on a more general socket timeout:
Exception in component tMDMInput_1_In
AxisFault
faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException
faultSubcode:
faultString: java.net.SocketTimeoutException: Read timed out
faultActor:
faultNode:
faultDetail:
{http://xml.apache.org/axis/}stackTrace:java.net.SocketTimeoutException: Read timed out
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:129)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:218)
at java.io.BufferedInputStream.read(BufferedInputStream.java:237)
at org.apache.axis.transport.http.HTTPSender.readHeadersFromSocket(HTTPSender.java:583)
at org.apache.axis.transport.http.HTTPSender.invoke(HTTPSender.java:143)
at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
at org.apache.axis.client.AxisClient.invoke(AxisClient.java:165)
at org.apache.axis.client.Call.invokeEngine(Call.java:2784)
at org.apache.axis.client.Call.invoke(Call.java:2767)
at org.apache.axis.client.Call.invoke(Call.java:2443)
at org.apache.axis.client.Call.invoke(Call.java:2366)
at org.apache.axis.client.Call.invoke(Call.java:1812)
at org.talend.mdm.webservice.XtentisBindingStub.getItems(XtentisBindingStub.java:5979)
at securitymaster.m_journal_report_0_4.m_Journal_Report.tMDMInput_1_InProcess(m_Journal_Report.java:2089)

Re: Error when accessing the Journal in EE 4.2.2

Anonymous — Mon, 12 Sep 2011 18:29:15 GMT

For a standalone Qizx server with default indexing, importing the db root as a Library, the same query returns in 15.3 ms:
for $a in collection('/UpdateReport')//ii/p/Update
return
<UPDATE>
{
xlib:get-property(xlib:document($a), "path"),
$a/Source,
$a/OperationType,
$a/RevisionID,
$a/Concept,
$a/Key
}