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