MDM Server GUI ERROR

One Star

MDM Server GUI ERROR

I am trying to use the Web UI for Talend MDM Server to browse through the record and following through the below webinar.

However when i try to 'Generate the default views on the MDM Perpective for my table and come back to the portal to look at the dataset I am getting below error. I have attached the screenshot for the same. Can you please let me know if anyone had similar issue and how to get through this one?
null; nested exception is: com.amalto.core.util.xtentis Exception: unable to build the query
Employee

Re: MDM Server GUI ERROR

Hi, 
What is the version of the product you are using and on which database ?
Employee

Re: MDM Server GUI ERROR

Also could you provide the error stacktrace on server side log ?
One Star

Re: MDM Server GUI ERROR

Hi - 
The version of Talend I am using is "TOS_MDM-Studio-20150508_1414-V5.6.2"
The database is Postgres Version 1.20.0
Below is the trace on the server side that I have setup on my localmachine.

10:31:05,463 ERROR Line=2 Document root element "dwr", must match DOCTYPE root "null".
10:31:05,463 ERROR Line=2 Document is invalid: no grammar found.
10:31:23,669 ERROR null; nested exception is: 
com.amalto.core.util.XtentisException: Unable to build the query
java.rmi.RemoteException: null; nested exception is: 
com.amalto.core.util.XtentisException: Unable to build the query
at com.amalto.core.delegator.IXtentisWSDelegator.getItemsSort(IXtentisWSDelegator.java:647)
at com.amalto.core.ejb.local.XtentisWSBean.getItemsSort(XtentisWSBean.java:395)
at com.amalto.webapp.core.util.XtentisWebPort.getItemsSort(XtentisWebPort.java:296)
at org.talend.mdm.webapp.journal.server.service.WebServiceImp.getItemsBySort(WebServiceImp.java:45)
at org.talend.mdm.webapp.journal.server.service.JournalDBService.getResultListByCriteria(JournalDBService.java:79)
at org.talend.mdm.webapp.journal.server.JournalAction.getJournalList(JournalAction.java:69)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:569)
at org.talend.mdm.webapp.general.gwt.ProxyGWTServiceImpl.doProcessCall(ProxyGWTServiceImpl.java:103)
at org.talend.mdm.webapp.base.server.AbstractService.processCall(AbstractService.java:52)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:248)
at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
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:420)
at org.apache.catalina.authenticator.MDMSingleSignOn.invoke(MDMSingleSignOn.java:66)
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:745)
Caused by: com.amalto.core.util.XtentisException: Unable to build the query
at com.amalto.core.ejb.XmlServerSLWrapperBean.getItemsQuery(XmlServerSLWrapperBean.java:502)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.jboss.invocation.Invocation.performCall(Invocation.java:359)
at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:237)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158)
at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:169)
at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)
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 org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:430)
at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:103)
at com.sun.proxy.$Proxy169.getItemsQuery(Unknown Source)
at com.amalto.core.delegator.IItemCtrlDelegator.runItemsQuery(IItemCtrlDelegator.java:614)
at com.amalto.core.delegator.IItemCtrlDelegator.getItems(IItemCtrlDelegator.java:555)
at com.amalto.core.ejb.ItemCtrl2Bean.getItems(ItemCtrl2Bean.java:1244)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.jboss.invocation.Invocation.performCall(Invocation.java:359)
at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:237)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158)
at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:169)
at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)
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 org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:430)
at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:103)
at com.sun.proxy.$Proxy184.getItems(Unknown Source)
at com.amalto.core.delegator.IXtentisWSDelegator.getItemsSort(IXtentisWSDelegator.java:639)
... 37 more
Caused by: java.lang.UnsupportedOperationException
at com.amalto.core.storage.StorageWrapper.getItemsQuery(StorageWrapper.java:497)
at com.amalto.core.storage.DispatchWrapper.getItemsQuery(DispatchWrapper.java:341)
at com.amalto.core.ejb.XmlServerSLWrapperBean.getItemsQuery(XmlServerSLWrapperBean.java:484)
... 81 more
Employee

Re: MDM Server GUI ERROR

MDM OS with Postgres is not supported. You have to use H2.
Four Stars

Re: MDM Server GUI ERROR

Hi pbabin -
I have tried using the H2 that comes with default with the community edition of the below version of Talend. However I am still getting the same error. 
TOS_MDM-Studio-20150508_1414-V5.6.2
I have attached the screenshots for your reference. Can you please help me with what might be causing this? 
Also when i try to create new records it says 'No Storage available for "Update Report"'
Below is the trace from the server side for the same.
java.rmi.RemoteException: null; nested exception is: 
com.amalto.core.util.XtentisException: Unable to build the query
at com.amalto.core.delegator.IXtentisWSDelegator.getItemsSort(IXtentisWSDelegator.java:647)
at com.amalto.core.ejb.local.XtentisWSBean.getItemsSort(XtentisWSBean.java:395)
at com.amalto.webapp.core.util.XtentisWebPort.getItemsSort(XtentisWebPort.java:296)
at org.talend.mdm.webapp.journal.server.service.WebServiceImp.getItemsBySort(WebServiceImp.java:45)
at org.talend.mdm.webapp.journal.server.service.JournalDBService.getResultListByCriteria(JournalDBService.java:79)
at org.talend.mdm.webapp.journal.server.JournalAction.getJournalList(JournalAction.java:69)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:569)
at org.talend.mdm.webapp.general.gwt.ProxyGWTServiceImpl.doProcessCall(ProxyGWTServiceImpl.java:103)
at org.talend.mdm.webapp.base.server.AbstractService.processCall(AbstractService.java:52)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:248)
at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
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:420)
at org.apache.catalina.authenticator.MDMSingleSignOn.invoke(MDMSingleSignOn.java:66)
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:745)
Caused by: com.amalto.core.util.XtentisException: Unable to build the query
at com.amalto.core.ejb.XmlServerSLWrapperBean.getItemsQuery(XmlServerSLWrapperBean.java:502)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.jboss.invocation.Invocation.performCall(Invocation.java:359)
at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:237)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158)
at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:169)
at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)
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 org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:430)
at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:103)
at com.sun.proxy.$Proxy170.getItemsQuery(Unknown Source)
at com.amalto.core.delegator.IItemCtrlDelegator.runItemsQuery(IItemCtrlDelegator.java:614)
at com.amalto.core.delegator.IItemCtrlDelegator.getItems(IItemCtrlDelegator.java:555)
at com.amalto.core.ejb.ItemCtrl2Bean.getItems(ItemCtrl2Bean.java:1244)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.jboss.invocation.Invocation.performCall(Invocation.java:359)
at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:237)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158)
at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:169)
at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)
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 org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:430)
at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:103)
at com.sun.proxy.$Proxy215.getItems(Unknown Source)
at com.amalto.core.delegator.IXtentisWSDelegator.getItemsSort(IXtentisWSDelegator.java:639)
... 37 more
Caused by: java.lang.UnsupportedOperationException
at com.amalto.core.storage.StorageWrapper.getItemsQuery(StorageWrapper.java:497)
at com.amalto.core.storage.DispatchWrapper.getItemsQuery(DispatchWrapper.java:341)
at com.amalto.core.ejb.XmlServerSLWrapperBean.getItemsQuery(XmlServerSLWrapperBean.java:484)
... 81 more
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
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:420)
at org.apache.catalina.authenticator.MDMSingleSignOn.invoke(MDMSingleSignOn.java:66)
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:745)
Caused by: com.amalto.webapp.core.util.WebCoreException: java.lang.IllegalArgumentException: No storage available for 'UpdateReport'.
at com.amalto.webapp.core.util.XtentisWebPort.handleException(XtentisWebPort.java:100)
... 39 more
Caused by: java.lang.IllegalArgumentException: No storage available for 'UpdateReport'.
at com.amalto.core.save.context.StorageSaverSource.getMetadataRepository(StorageSaverSource.java:119)
at com.amalto.core.save.context.Save.saveUpdateReport(Save.java:53)
at com.amalto.core.save.context.Save.save(Save.java:48)
at com.amalto.core.save.context.Validation.save(Validation.java:58)
at com.amalto.core.save.context.BeforeSaving.save(BeforeSaving.java:130)
at com.amalto.core.save.context.ApplyActions.save(ApplyActions.java:47)
at com.amalto.core.save.context.UpdateReport.save(UpdateReport.java:83)
at com.amalto.core.save.context.Security.save(Security.java:115)
at com.amalto.core.save.context.GenerateActions.save(GenerateActions.java:171)
at com.amalto.core.save.context.ID.save(ID.java:120)
at com.amalto.core.save.context.Init.save(Init.java:56)
at com.amalto.core.save.SaverHelper.saveItemWithReport(SaverHelper.java:72)
at com.amalto.core.save.SaverHelper.saveItemWithReport(SaverHelper.java:52)
at com.amalto.core.delegator.IXtentisWSDelegator.putItemWithReport(IXtentisWSDelegator.java:993)
at com.amalto.core.ejb.local.XtentisWSBean.putItemWithReport(XtentisWSBean.java:497)
at com.amalto.webapp.core.util.XtentisWebPort.putItemWithReport(XtentisWebPort.java:388)
... 34 more
Four Stars

Re: MDM Server GUI ERROR

After re-installing Talend 6 this issue didnt resurface in the MDM Portal