Could not start MDM server

_AnonymousUser — Wed, 26 Oct 2016 09:37:00 GMT

Hello,
I was courious about your MDM solution and I downloaded latest TOS MDM to try it.
I managed to succesfully install TOS MDM Server ( version TOS_MDM-Server-20160704_1411-V6.2.1) on port 8380 with integrated H2 database. But when I try to run the server using apache-tomcat/bin/startup.bat application ends with following exception.
My OS is Windows 10 with Java 1.8.0_101.

10:13:36,971 ERROR  Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'defaultXmlServer' defined in URL : Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate : Constructor threw exception; nested exception is java.lang.ExceptionInInitializerError
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:1093)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1038)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:504)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:762)
        at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:757)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:480)
        at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:403)
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306)
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:106)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4728)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5162)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
        at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:581)
        at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1683)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        at java.util.concurrent.FutureTask.run(FutureTask.java:266)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at java.lang.Thread.run(Thread.java:745)
Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate : Constructor threw exception; nested exception is java.lang.ExceptionInInitializerError
        at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:163)
        at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:89)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:1086)
        ... 26 more
Caused by: java.lang.ExceptionInInitializerError
        at com.amalto.core.server.DefaultXmlServer.<init>(Unknown Source)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
        at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:147)
        ... 28 more
Caused by: java.lang.RuntimeException: java.lang.RuntimeException: Could not prepare '__SYSTEM'.
        at com.amalto.core.storage.StorageLogger.handlePrepareError(Unknown Source)
        at com.amalto.core.storage.StorageLogger.prepare(Unknown Source)
        at com.amalto.core.server.StorageAdminImpl.internalCreateSystemStorage(Unknown Source)
        at com.amalto.core.server.StorageAdminImpl.create(Unknown Source)
        at com.amalto.core.storage.SystemStorageWrapper.<init>(Unknown Source)
        at com.amalto.core.storage.SQLWrapper.<clinit>(Unknown Source)
        ... 34 more
Caused by: java.lang.RuntimeException: Could not prepare '__SYSTEM'.
        at com.amalto.core.storage.hibernate.HibernateStorage.prepare(Unknown Source)
        at com.amalto.core.storage.SecuredStorage.prepare(Unknown Source)
        at com.amalto.core.storage.CacheStorage.prepare(Unknown Source)
        ... 39 more
Caused by: java.lang.RuntimeException: Exception occurred during dynamic classes creation.
        ... 42 more
Caused by: java.lang.RuntimeException: Error during processing of type 'User'
        at com.amalto.core.storage.hibernate.ClassCreator.visit(Unknown Source)
        at com.amalto.core.storage.hibernate.ClassCreator.visit(Unknown Source)
        at org.talend.mdm.commmon.metadata.ComplexTypeMetadataImpl.accept(Unknown Source)
        at com.amalto.core.storage.hibernate.ClassCreator.visit(Unknown Source)
        at com.amalto.core.storage.hibernate.ClassCreator.visit(Unknown Source)
        at org.talend.mdm.commmon.metadata.MetadataRepository.accept(Unknown Source)
        ... 42 more
Caused by: java.lang.RuntimeException: java.lang.UnsupportedOperationException: No support for field typed as 'YESNO'
        at com.amalto.core.storage.hibernate.ClassCreator.handleFieldMetadata(Unknown Source)
        at com.amalto.core.storage.hibernate.ClassCreator.visit(Unknown Source)
        at com.amalto.core.storage.hibernate.ClassCreator.visit(Unknown Source)
        at org.talend.mdm.commmon.metadata.SimpleTypeFieldMetadata.accept(Unknown Source)
        at org.talend.mdm.commmon.metadata.DefaultMetadataVisitor.visit(Unknown Source)
        ... 48 more
Caused by: java.lang.UnsupportedOperationException: No support for field typed as 'YESNO'
        at com.amalto.core.storage.HibernateMetadataUtils.getJavaType(Unknown Source)
        ... 53 more

Do you have any suggestion how to fix this issue?
Thank you
Best Regards
Martin Fabry

Re: Could not start MDM server

Anonymous — Thu, 27 Oct 2016 08:58:06 GMT

Hi,
Could you please take a look at this related forum: https://community.talend.com/t5/Data-and-Metadata-Governance/resolved-Error-creating-bean-with-name-defaultXmlServer-defined/td-p/71614 to see if this solution is OK with you?
Best regards
Sabrina

Re: Could not start MDM server

Anonymous — Wed, 11 Jan 2017 15:09:08 GMT

We have the exact same exception. Using MS SQLServer for database. And Talend DataFabric 6.2.1 The solution in does not work. The exception is exactly the same. The database TALEND_MDM_SYSTEM has been created. The exception comes after that. The database user has admin (sysadmin server role) permissions on the database. We are using the jtds driver 1.3.1
mdm.log.log

Re: Could not start MDM server

Anonymous — Wed, 11 Jan 2017 15:12:30 GMT

Log file attached.
mdm.log_20170111-0712.log

Re: Could not start MDM server

Anonymous — Wed, 11 Jan 2017 15:28:16 GMT

2017-01-11 09:38:16,727 INFO Extracted agent jar to temporary file D:\Talend\6.2.1\mdm\apache-tomcat\temp\ehcache-sizeof-agent477092133637043914.jar
2017-01-11 09:38:16,727 INFO Trying to load agent @ D:\Talend\6.2.1\mdm\apache-tomcat\temp\ehcache-sizeof-agent477092133637043914.jar
2017-01-11 09:38:16,727 INFO using Agent sizeof engine
2017-01-11 09:38:16,821 INFO using Agent sizeof engine
2017-01-11 09:38:18,946 INFO Reading from datasource file at 'D:\Talend\6.2.1\mdm\conf\datasources.xml'.
2017-01-11 09:38:19,149 WARN Storage '__SYSTEM' (SYSTEM) is not configured to support full text queries.
2017-01-11 09:38:19,368 WARN Storage '__SYSTEM' (SYSTEM) is not configured to support full text queries.
2017-01-11 09:38:19,415 INFO *NOT* cleaning existing database content. 2017-01-11 09:38:19,415 INFO Preparing database before schema generation. 2017-01-11 09:38:19,571 INFO&n

To see the whole post, download it here
OriginalPost.pdf

Re: Could not start MDM server

Anonymous — Wed, 11 Jan 2017 21:19:48 GMT

Resolved. Used MSSQL Server driver v42. Used the .dll file for Integrated Authentication. Removed the domain=domainname from the jdbcURL. Then started the Windows service for MDM as the relevant user.

Re: Could not start MDM server

Anonymous — Thu, 12 Jan 2017 08:50:11 GMT

Hi harivartha,

Resolved. Used MSSQL Server driver v42. Used the .dll file for Integrated Authentication. Removed the domain=domainname from the jdbcURL. Then started the Windows service for MDM as the relevant user.

Thanks for sharing your solution with us.
Best regards
Sabrina

topic Re: Could not start MDM server in Talend Data Catalog

Could not start MDM server

Re: Could not start MDM server

Re: Could not start MDM server

Re: Could not start MDM server

Re: Could not start MDM server

Re: Could not start MDM server

Re: Could not start MDM server