One Star

[resolved] Unable to deploy data container AGAIN!

Hi there,
I'm trying to deploy a data container which I had previously successfully deployed and I get the following error:

The server log reads:
2014-08-06 12:31:50,640 WARN   No SQL storage defined for data model 'Media'. No SQL storage to update.
2014-08-06 12:31:50,640 WARN   No SQL staging storage defined for data model 'Media'. No SQL staging storage to update.
2014-08-06 12:31:50,646 INFO   DMUpdateEvent
2014-08-06 12:32:00,209 INFO   Container 'Media' does not exist in revision 'null', creating it.
2014-08-06 12:32:00,210 INFO   Reading from datasource file at 'D:\Program Files\TOS_MDM-Server-r111943-V5.4.1\jboss-4.2.2.GA\server\default\conf\datasources.xml'.
2014-08-06 12:32:00,233 INFO   Reading from datasource file at 'D:\Program Files\TOS_MDM-Server-r111943-V5.4.1\jboss-4.2.2.GA\server\default\conf\datasources.xml'.
2014-08-06 12:32:00,255 INFO   Reading from datasource file at 'D:\Program Files\TOS_MDM-Server-r111943-V5.4.1\jboss-4.2.2.GA\server\default\conf\datasources.xml'.
2014-08-06 12:32:00,301 INFO   Reading from datasource file at 'D:\Program Files\TOS_MDM-Server-r111943-V5.4.1\jboss-4.2.2.GA\server\default\conf\datasources.xml'.
2014-08-06 12:32:00,515 INFO   *NOT* cleaning existing database content.
2014-08-06 12:32:00,515 INFO   Preparing database before schema generation.
2014-08-06 12:32:08,079 ERROR ##### Error during storage preparation (force = true) #####
2014-08-06 12:32:08,079 ERROR TransactionRolledbackLocalException in method: public abstract boolean com.amalto.core.server.XmlServer.existCluster(java.lang.String,java.lang.String) throws com.amalto.core.util.XtentisException, causedBy:
java.lang.RuntimeException: Could not create storage 'Media' with data model 'Media'.
at com.amalto.core.server.StorageAdminImpl.create(StorageAdminImpl.java:117)
at com.amalto.core.server.StorageAdminImpl.exist(StorageAdminImpl.java:320)
at com.amalto.core.storage.StorageWrapper.existCluster(StorageWrapper.java:143)
at com.amalto.core.storage.DispatchWrapper.existCluster(DispatchWrapper.java:185)
at com.amalto.core.ejb.XmlServerSLWrapperBean.existCluster(XmlServerSLWrapperBean.java:268)
at sun.reflect.GeneratedMethodAccessor210.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
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.existCluster(Unknown Source)
at com.amalto.core.objects.datacluster.ejb.DataClusterCtrlBean.putDataCluster(DataClusterCtrlBean.java:118)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
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.$Proxy191.putDataCluster(Unknown Source)
at com.amalto.core.delegator.IXtentisWSDelegator.putDataCluster(IXtentisWSDelegator.java:548)
at com.amalto.core.ejb.XtentisWSBean.putDataCluster(XtentisWSBean.java:328)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.jboss.invocation.Invocation.performCall(Invocation.java:359)
at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:237)
at org.jboss.wsf.container.jboss42.ServiceEndpointInterceptor.invoke(ServiceEndpointInterceptor.java:85)
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 sun.reflect.GeneratedMethodAccessor342.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
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.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:744)
Caused by: java.lang.RuntimeException: Could not create storage for container 'Media' (MASTER) using data model 'Media'.
at com.amalto.core.server.StorageAdminImpl.internalCreateStorage(StorageAdminImpl.java:256)
at com.amalto.core.server.StorageAdminImpl.create(StorageAdminImpl.java:108)
... 101 more
Caused by: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: Exception occurred during initialization of H2 database
at com.amalto.core.storage.StorageLogger.handlePrepareError(StorageLogger.java:64)
at com.amalto.core.storage.StorageLogger.prepare(StorageLogger.java:71)
at com.amalto.core.server.StorageAdminImpl.internalCreateStorage(StorageAdminImpl.java:254)
... 102 more
Caused by: java.lang.RuntimeException: java.lang.RuntimeException: Exception occurred during initialization of H2 database
at com.amalto.core.storage.prepare.JDBCStorageInitializer.initialize(JDBCStorageInitializer.java:52)
at com.amalto.core.storage.hibernate.HibernateStorage.prepare(HibernateStorage.java:240)
at com.amalto.core.storage.SecuredStorage.prepare(SecuredStorage.java:72)
at com.amalto.core.storage.StorageLogger.prepare(StorageLogger.java:69)
... 103 more
Caused by: java.lang.RuntimeException: Exception occurred during initialization of H2 database
at com.amalto.core.storage.prepare.H2StorageInitializer.initialize(H2StorageInitializer.java:64)
at com.amalto.core.storage.prepare.FullTextIndexCleaner.initialize(FullTextIndexCleaner.java:74)
at com.amalto.core.storage.prepare.JDBCStorageInitializer.initialize(JDBCStorageInitializer.java:50)
... 106 more
Caused by: org.h2.jdbc.JdbcSQLException: Database may be already in use: "Locked by another process". Possible solutions: close all other connection(s); use the server mode
at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
at org.h2.message.DbException.get(DbException.java:169)
at org.h2.message.DbException.get(DbException.java:146)
at org.h2.store.FileLock.getExceptionAlreadyInUse(FileLock.java:439)
at org.h2.store.FileLock.lockFile(FileLock.java:336)
at org.h2.store.FileLock.lock(FileLock.java:128)
at org.h2.engine.Database.open(Database.java:542)
at org.h2.engine.Database.openDatabase(Database.java:222)
at org.h2.engine.Database.<init>(Database.java:217)
at org.h2.engine.Engine.openSession(Engine.java:56)
at org.h2.engine.Engine.openSession(Engine.java:159)
at org.h2.engine.Engine.createSessionAndValidate(Engine.java:138)
at org.h2.engine.Engine.createSession(Engine.java:121)
at org.h2.engine.Engine.createSession(Engine.java:28)
at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:305)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:110)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94)
at org.h2.Driver.connect(Driver.java:72)
at java.sql.DriverManager.getConnection(DriverManager.java:571)
at java.sql.DriverManager.getConnection(DriverManager.java:215)
at com.amalto.core.storage.prepare.H2StorageInitializer.initialize(H2StorageInitializer.java:60)
... 108 more
2014-08-06 12:32:08,090 ERROR SOAP request exception
java.rmi.RemoteException: Unable to physically create the data cluster Media: javax.ejb.TransactionRolledbackLocalException: Could not create storage 'Media' with data model 'Media'.; 
: Could not create storage 'Media' with data model 'Media'.
: Could not create storage 'Media' with data model 'Media'.
: Could not create storage for container 'Media' (MASTER) using data model 'Media'.
: java.lang.RuntimeException: java.lang.RuntimeException: Exception occurred during initialization of H2 database
: java.lang.RuntimeException: Exception occurred during initialization of H2 database
: Exception occurred during initialization of H2 database
: Database may be already in use: "Locked by another process". Possible solutions: close all other connection(s); use the server mode ; nested exception is: 
com.amalto.core.util.XtentisException: Unable to physically create the data cluster Media: javax.ejb.TransactionRolledbackLocalException: Could not create storage 'Media' with data model 'Media'.
at com.amalto.core.util.RemoteExceptionFactory.aggregateCauses(RemoteExceptionFactory.java:35)
at com.amalto.core.delegator.IXtentisWSDelegator.putDataCluster(IXtentisWSDelegator.java:551)
at com.amalto.core.ejb.XtentisWSBean.putDataCluster(XtentisWSBean.java:328)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.jboss.invocation.Invocation.performCall(Invocation.java:359)
at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:237)
at org.jboss.wsf.container.jboss42.ServiceEndpointInterceptor.invoke(ServiceEndpointInterceptor.java:85)
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 sun.reflect.GeneratedMethodAccessor342.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
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.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:744)
Caused by: com.amalto.core.util.XtentisException: Unable to physically create the data cluster Media: javax.ejb.TransactionRolledbackLocalException: Could not create storage 'Media' with data model 'Media'.
at com.amalto.core.objects.datacluster.ejb.DataClusterCtrlBean.putDataCluster(DataClusterCtrlBean.java:130)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
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.$Proxy191.putDataCluster(Unknown Source)
at com.amalto.core.delegator.IXtentisWSDelegator.putDataCluster(IXtentisWSDelegator.java:548)
... 56 more
Caused by: javax.ejb.TransactionRolledbackLocalException: Could not create storage 'Media' with data model 'Media'.
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:262)
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.existCluster(Unknown Source)
at com.amalto.core.objects.datacluster.ejb.DataClusterCtrlBean.putDataCluster(DataClusterCtrlBean.java:118)
... 77 more
Caused by: java.lang.RuntimeException: Could not create storage 'Media' with data model 'Media'.
at com.amalto.core.server.StorageAdminImpl.create(StorageAdminImpl.java:117)
at com.amalto.core.server.StorageAdminImpl.exist(StorageAdminImpl.java:320)
at com.amalto.core.storage.StorageWrapper.existCluster(StorageWrapper.java:143)
at com.amalto.core.storage.DispatchWrapper.existCluster(DispatchWrapper.java:185)
at com.amalto.core.ejb.XmlServerSLWrapperBean.existCluster(XmlServerSLWrapperBean.java:268)
at sun.reflect.GeneratedMethodAccessor210.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
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)
... 88 more
Caused by: java.lang.RuntimeException: Could not create storage for container 'Media' (MASTER) using data model 'Media'.
at com.amalto.core.server.StorageAdminImpl.internalCreateStorage(StorageAdminImpl.java:256)
at com.amalto.core.server.StorageAdminImpl.create(StorageAdminImpl.java:108)
... 101 more
Caused by: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: Exception occurred during initialization of H2 database
at com.amalto.core.storage.StorageLogger.handlePrepareError(StorageLogger.java:64)
at com.amalto.core.storage.StorageLogger.prepare(StorageLogger.java:71)
at com.amalto.core.server.StorageAdminImpl.internalCreateStorage(StorageAdminImpl.java:254)
... 102 more
Caused by: java.lang.RuntimeException: java.lang.RuntimeException: Exception occurred during initialization of H2 database
at com.amalto.core.storage.prepare.JDBCStorageInitializer.initialize(JDBCStorageInitializer.java:52)
at com.amalto.core.storage.hibernate.HibernateStorage.prepare(HibernateStorage.java:240)
at com.amalto.core.storage.SecuredStorage.prepare(SecuredStorage.java:72)
at com.amalto.core.storage.StorageLogger.prepare(StorageLogger.java:69)
... 103 more
Caused by: java.lang.RuntimeException: Exception occurred during initialization of H2 database
at com.amalto.core.storage.prepare.H2StorageInitializer.initialize(H2StorageInitializer.java:64)
at com.amalto.core.storage.prepare.FullTextIndexCleaner.initialize(FullTextIndexCleaner.java:74)
at com.amalto.core.storage.prepare.JDBCStorageInitializer.initialize(JDBCStorageInitializer.java:50)
... 106 more
Caused by: org.h2.jdbc.JdbcSQLException: Database may be already in use: "Locked by another process". Possible solutions: close all other connection(s); use the server mode
at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
at org.h2.message.DbException.get(DbException.java:169)
at org.h2.message.DbException.get(DbException.java:146)
at org.h2.store.FileLock.getExceptionAlreadyInUse(FileLock.java:439)
at org.h2.store.FileLock.lockFile(FileLock.java:336)
at org.h2.store.FileLock.lock(FileLock.java:128)
at org.h2.engine.Database.open(Database.java:542)
at org.h2.engine.Database.openDatabase(Database.java:222)
at org.h2.engine.Database.<init>(Database.java:217)
at org.h2.engine.Engine.openSession(Engine.java:56)
at org.h2.engine.Engine.openSession(Engine.java:159)
at org.h2.engine.Engine.createSessionAndValidate(Engine.java:138)
at org.h2.engine.Engine.createSession(Engine.java:121)
at org.h2.engine.Engine.createSession(Engine.java:28)
at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:305)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:110)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94)
at org.h2.Driver.connect(Driver.java:72)
at java.sql.DriverManager.getConnection(DriverManager.java:571)
at java.sql.DriverManager.getConnection(DriverManager.java:215)
at com.amalto.core.storage.prepare.H2StorageInitializer.initialize(H2StorageInitializer.java:60)
... 108 more
Thanks,
Facoda
1 ACCEPTED SOLUTION

Accepted Solutions
Employee

Re: [resolved] Unable to deploy data container AGAIN!

Hi Facoda,
The following exception in your trace 

Caused by: org.h2.jdbc.JdbcSQLException: Database may be already in use: "Locked by another process". Possible solutions: close all other connection(s); use the server mode

would make me say that you may have many Talend MDM processes running at the same time, causing a database file-lock issue (H2 is relying on files with exclusive locks : first-come first-served). Can you double-check that there's only one process related to Talend MDM running ?
Regards,
Cyril.
4 REPLIES
Employee

Re: [resolved] Unable to deploy data container AGAIN!

Hi Facoda,
The following exception in your trace 

Caused by: org.h2.jdbc.JdbcSQLException: Database may be already in use: "Locked by another process". Possible solutions: close all other connection(s); use the server mode

would make me say that you may have many Talend MDM processes running at the same time, causing a database file-lock issue (H2 is relying on files with exclusive locks : first-come first-served). Can you double-check that there's only one process related to Talend MDM running ?
Regards,
Cyril.
One Star

Re: [resolved] Unable to deploy data container AGAIN!

Brilliant! Thanks Cyril. You were correct there was a lock on the H2 database because I had used H2 Console to view the contents of the Media DB. I killed the H2 process by ending the javaw.exe for Windows in task manager. 
One Star

Re: [resolved] Unable to deploy data container AGAIN!

Hi there,
I'm trying to deploy a data container which I am  deploying newly deployed and I got the above error mentioned.

Unable to deploy data container to the cluster ....
Please help me in checking this issue.
Two Stars

Re: [resolved] Unable to deploy data container AGAIN!

Hi AnonymousUser.

 

I was in the same problem like you and the only problem was my grants on database. I got MySQL and when I did check it, my dbuser won't have the appropriate grants.

 

if you have the same database try this:

 

 

mysql> show grants for 'username';

+--------------------------------------------------------------------------------------------------------------------------------------+

| Grants for username@%                                                                                                              |

+--------------------------------------------------------------------------------------------------------------------------------------+

| GRANT ALL PRIVILEGES ON `MDM_STAGING`.* TO 'username'@'%'                                                                |

| GRANT ALL PRIVILEGES ON `MDM_MASTER`.* TO 'username'@'%'                                                                 |

| GRANT ALL PRIVILEGES ON `MDM_MASTER`.* TO 'username'@'%'                                                                  |

| GRANT ALL PRIVILEGES ON `TMDM_DB_SYSTEM`.* TO 'username'@'%'                                                                       |

+--------------------------------------------------------------------------------------------------------------------------------------+

4 rows in set (0.00 sec)

 

Like you notice I just have permission to modify my Database but I don't have permission to create another one.

 

mysql> GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

Restart the MDM Server and try it again.

 

 

So I hope it helps you.

Oscar