topic Configuration of Alfresco with DB2 in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/configuration-of-alfresco-with-db2/m-p/288525#M241655 <HTML><HEAD></HEAD><BODY><SPAN>Hello Everyone!</SPAN><BR /><BR /><SPAN>I am using alfesco community Edition 4.0d. It is working on postgres SQL.I am trying to configure alfresco with DB2.</SPAN><BR /><SPAN>I have changed the alfresco global properties file and repository file.</SPAN><BR /><SPAN>I have made changes in this files:-</SPAN><BR /><SPAN>(1)Alfersco global properties:-</SPAN><BR /><SPAN>C:/alfresco/tomacat/shared/classe/alfresco-global properties and</SPAN><BR /><SPAN>C:/alfresco/tomacat/webapps/alfresco/webinf/classes/alfresco golbal properties</SPAN><BR /><SPAN>(2)Hibernate.cfg file which lies in this path</SPAN><BR /><SPAN>C:/Alfresco/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/domain/hibernare-cfg file</SPAN><BR /><SPAN>(3)Repository file </SPAN><BR /><SPAN>C:/Alfresco/tomcat/webapps/alfresco/WEB-INF/classes/alfresco</SPAN><BR /><SPAN>&lt;code&gt;</SPAN><BR /><SPAN>When i restrt the server i got the error like this</SPAN><BR /><SPAN>org.alfresco.error.AlfrescoRuntimeException: 08160039 Keystores are invalid</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.encryption.EncryptionChecker$1.execute(EncryptionChecker.java:71)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.encryption.EncryptionChecker$1.execute(EncryptionChecker.java:61)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:388)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:259)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.encryption.EncryptionChecker.onBootstrap(EncryptionChecker.java:60)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:209)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:180)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:303)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:911)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:428)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4135)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardContext.start(StandardContext.java:4630)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:445)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardService.start(StandardService.java:519)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Catalina.start(Catalina.java:581)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:597)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)</SPAN><BR /><SPAN>Caused by: org.springframework.dao.DataIntegrityViolationException: </SPAN><BR /><SPAN>### Error updating database.&nbsp; Cause: com.ibm.db2.jcc.am.SqlIntegrityConstraintViolationException: DB2 SQL Error: SQLCODE=-407, SQLSTATE=23502, SQLERRMC=TBSPACEID=2, TABLEID=21, COLNO=0, DRIVER=3.63.75</SPAN><BR /><SPAN>### The error may involve alfresco.propval.parameter_PropertyRoot</SPAN><BR /><SPAN>### The error occurred while setting parameters</SPAN><BR /><SPAN>### Cause: com.ibm.db2.jcc.am.SqlIntegrityConstraintViolationException: DB2 SQL Error: SQLCODE=-407, SQLSTATE=23502, SQLERRMC=TBSPACEID=2, TABLEID=21, COLNO=0, DRIVER=3.63.75</SPAN><BR /><SPAN>; SQL []; DB2 SQL Error: SQLCODE=-407, SQLSTATE=23502, SQLERRMC=TBSPACEID=2, TABLEID=21, COLNO=0, DRIVER=3.63.75; nested exception is com.ibm.db2.jcc.am.SqlIntegrityConstraintViolationException: DB2 SQL Error: SQLCODE=-407, SQLSTATE=23502, SQLERRMC=TBSPACEID=2, TABLEID=21, COLNO=0, DRIVER=3.63.75</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:245)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:71)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:346)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at $Proxy6.insert(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:231)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.propval.ibatis.PropertyValueDAOImpl.createPropertyRoot(PropertyValueDAOImpl.java:496)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.propval.AbstractPropertyValueDAOImpl$PropertyCallbackDAO.createValue(AbstractPropertyValueDAOImpl.java:845)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.propval.AbstractPropertyValueDAOImpl$PropertyCallbackDAO.createValue(AbstractPropertyValueDAOImpl.java:840)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.cache.lookup.EntityLookupCache.getOrCreateByValue(EntityLookupCache.java:447)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.propval.AbstractPropertyValueDAOImpl.createProperty(AbstractPropertyValueDAOImpl.java:823)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.propval.AbstractPropertyValueDAOImpl.createPropertyUniqueContext(AbstractPropertyValueDAOImpl.java:1103)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.attributes.AttributeServiceImpl.createAttribute(AttributeServiceImpl.java:197)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.encryption.EncryptionKeysRegistryImpl.registerKey(EncryptionKeysRegistryImpl.java:115)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.encryption.AlfrescoKeyStoreImpl.validateKeys(AlfrescoKeyStoreImpl.java:899)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.encryption.AlfrescoKeyStoreImpl.validateKeys(AlfrescoKeyStoreImpl.java:187)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.encryption.KeyStoreChecker.validateKeyStores(KeyStoreChecker.java:47)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.encryption.EncryptionChecker$1.execute(EncryptionChecker.java:66)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;… 38 more</SPAN><BR /><SPAN>Caused by: com.ibm.db2.jcc.am.SqlIntegrityConstraintViolationException: DB2 SQL Error: SQLCODE=-407, SQLSTATE=23502, SQLERRMC=TBSPACEID=2, TABLEID=21, COLNO=0, DRIVER=3.63.75</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.ibm.db2.jcc.am.fd.a(fd.java:675)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.ibm.db2.jcc.am.fd.a(fd.java:60)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.ibm.db2.jcc.am.fd.a(fd.java:127)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.ibm.db2.jcc.am.yn.b(yn.java:2317)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.ibm.db2.jcc.am.yn.c(yn.java:2300)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.ibm.db2.jcc.t4.cb.l(cb.java:370)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.ibm.db2.jcc.t4.cb.a(cb.java:62)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.ibm.db2.jcc.t4.q.a(q.java:50)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.ibm.db2.jcc.t4.tb.b(tb.java:220)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.ibm.db2.jcc.am.zn.lc(zn.java:3314)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.ibm.db2.jcc.am.zn.b(zn.java:4271)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.ibm.db2.jcc.am.zn.fc(zn.java:2670)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.ibm.db2.jcc.am.zn.execute(zn.java:2654)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:22)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:51)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:29)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:87)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:46)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:118)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:107)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.GeneratedMethodAccessor218.invoke(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:597)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:338)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;… 52 more</SPAN><BR /><SPAN>&lt;code&gt;</SPAN><BR /><BR /><SPAN>Can anybody have any idea what should be the wrong?</SPAN><BR /><SPAN>Please reply.</SPAN></BODY></HTML> Mon, 16 Sep 2013 08:32:18 GMT rutaveejshah 2013-09-16T08:32:18Z Configuration of Alfresco with DB2 https://connect.hyland.com/t5/alfresco-archive/configuration-of-alfresco-with-db2/m-p/288525#M241655 Hello Everyone!I am using alfesco community Edition 4.0d. It is working on postgres SQL.I am trying to configure alfresco with DB2.I have changed the alfresco global properties file and repository file.I have made changes in this files:-(1)Alfersco global properties:-C:/alfresco/tomacat/shared/class Mon, 16 Sep 2013 08:32:18 GMT https://connect.hyland.com/t5/alfresco-archive/configuration-of-alfresco-with-db2/m-p/288525#M241655 rutaveejshah 2013-09-16T08:32:18Z Re: Configuration of Alfresco with DB2 https://connect.hyland.com/t5/alfresco-archive/configuration-of-alfresco-with-db2/m-p/288526#M241656 <HTML><HEAD></HEAD><BODY><SPAN>Alfresco community does not support non open source databases, in particular DB2.</SPAN><BR /><BR /><SPAN>It is supported by Alfresco Enterprise.</SPAN></BODY></HTML> Mon, 16 Sep 2013 09:46:30 GMT https://connect.hyland.com/t5/alfresco-archive/configuration-of-alfresco-with-db2/m-p/288526#M241656 mrogers 2013-09-16T09:46:30Z