[resolved] Unable to create table when using MySQL

One Star

[resolved] Unable to create table when using MySQL

Talend MDM Server is unable to create table for the entity when using MySQL as the repository database. It is throwing the following message: 'Unable to single search::java.lang.IllegalArgumenException:Type '<Object Name>' does not exist in data cluster '<Container/DB name>'.;nested exception is: com.amalto.core.util.XtentisException: Unable to singel search::java.lang.IllegalArgumentException: Type '<Object Name>' does not exist in data cluster '<Container/DB name>'.
Below is the stack trace:
------------------------------------------------------------------------------------

2013-02-19 09:54:02,232 INFO starting event executor threads for event executor 'EventExecutor-10.66.81.209-default'...
2013-02-19 09:54:02,234 INFO starting dispatcher thread for event executor 'EventExecutor-10.66.81.209-default'...
2013-02-19 09:54:02,246 INFO Registered MBean: Bonitasoft:name=JVM,type=JVMMBean
2013-02-19 09:54:13,165 ERROR Unable to single search: : java.lang.IllegalArgumentException: Type 'ResourceType' does not exist in data cluster 'md'.
java.lang.IllegalArgumentException: Type 'ResourceType' does not exist in data cluster 'md'.
at com.amalto.core.delegator.IItemCtrlDelegator.viewSearch(Unknown Source)
at com.amalto.core.ejb.ItemCtrl2Bean.viewSearch(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
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 $Proxy317.viewSearch(Unknown Source)
at com.amalto.webapp.core.util.IXtentisRMIPort.viewSearch(Unknown Source)
at org.talend.mdm.webapp.browserecords.server.actions.BrowseRecordsAction.getItemBeans(BrowseRecordsAction.java:876)
at org.talend.mdm.webapp.browserecords.server.actions.BrowseRecordsAction.queryItemBeans(BrowseRecordsAction.java:848)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.talend.mdm.webapp.general.gwt.GWTRPC.invokeAndEncodeResponse(GWTRPC.java:251)
at org.talend.mdm.webapp.general.gwt.ProxyGWTServiceImpl.doProcessCall(ProxyGWTServiceImpl.java:150)
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:73)
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:662)
2013-02-19 09:54:13,167 ERROR Unable to single search: : java.lang.IllegalArgumentException: Type 'ResourceType' does not exist in data cluster 'md'.; nested exception is:
com.amalto.core.util.XtentisException: Unable to single search: : java.lang.IllegalArgumentException: Type 'ResourceType' does not exist in data cluster 'md'.
java.rmi.RemoteException: Unable to single search: : java.lang.IllegalArgumentException: Type 'ResourceType' does not exist in data cluster 'md'.; nested exception is:
com.amalto.core.util.XtentisException: Unable to single search: : java.lang.IllegalArgumentException: Type 'ResourceType' does not exist in data cluster 'md'.
at com.amalto.webapp.core.util.IXtentisRMIPort.viewSearch(Unknown Source)
at org.talend.mdm.webapp.browserecords.server.actions.BrowseRecordsAction.getItemBeans(BrowseRecordsAction.java:876)
at org.talend.mdm.webapp.browserecords.server.actions.BrowseRecordsAction.queryItemBeans(BrowseRecordsAction.java:848)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.talend.mdm.webapp.general.gwt.GWTRPC.invokeAndEncodeResponse(GWTRPC.java:251)
at org.talend.mdm.webapp.general.gwt.ProxyGWTServiceImpl.doProcessCall(ProxyGWTServiceImpl.java:150)
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:73)
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:662)
Caused by: com.amalto.core.util.XtentisException: Unable to single search: : java.lang.IllegalArgumentException: Type 'ResourceType' does not exist in data cluster 'md'.
at com.amalto.core.delegator.IItemCtrlDelegator.viewSearch(Unknown Source)
at com.amalto.core.ejb.ItemCtrl2Bean.viewSearch(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
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 $Proxy317.viewSearch(Unknown Source)
... 35 more
Caused by: java.lang.IllegalArgumentException: Type 'ResourceType' does not exist in data cluster 'md'.
... 57 more

Accepted Solutions
Employee

Re: [resolved] Unable to create table when using MySQL

It is definitely a source of confusion. It is a legacy. We will enforce the names in the Studio in next versions.

All Replies
Employee

Re: [resolved] Unable to create table when using MySQL

Please attach the full server.log
One Star

Re: [resolved] Unable to create table when using MySQL

Please find the log attached.
One Star

Re: [resolved] Unable to create table when using MySQL

Please find attached the zip for Server.log
Community Manager

Re: [resolved] Unable to create table when using MySQL

hi
It is impossible to attach a file to the forum, you have to copy and paste it to your post.

Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
Employee

Re: [resolved] Unable to create table when using MySQL

MDM cannot seem to find an Entity or a complex type called 'ResourceType'.
I received a full server.log separately. The first time this exception occurs is when performing a ViewSearch, probably by selecting the view in the Web UI. In the code, we explicitly throw this exception when the corresponding Entity to the view doesn't exist in the model:

java.lang.IllegalArgumentException: Type 'ResourceType' does not exist in data cluster 'md'.
at com.amalto.core.delegator.IItemCtrlDelegator.viewSearch(Unknown Source)
at com.amalto.core.ejb.ItemCtrl2Bean.viewSearch(Unknown Source)
(...)
Employee

Re: [resolved] Unable to create table when using MySQL

Also check both MDM data-model and data-container have the same name. It is a requirement in 5.2 + relational storage.
One Star

Re: [resolved] Unable to create table when using MySQL

The issue was I had different names for data model and data container. Thanks for the help!!
Employee

Re: [resolved] Unable to create table when using MySQL

It is definitely a source of confusion. It is a legacy. We will enforce the names in the Studio in next versions.