[opencms-dev] Installation issue with DB2 v9.1

[Soobaek Jang]

Hello,

I am having trouble installing OpenCMS with DB2 v9.1. During the setup wizard, I get the following error.

If anyone has any idea how to resolve this issue, I would really appreciate it.

Thank you very much in advance!!!

 

 


Alkacon OpenCms Setup Wizard - Create database & tables
Creating tables ...
     

Tables could not be created!
Error executing SQL statement: CREATE TABLE CMS_PROJECTRESOURCES ( PROJECT_ID VARCHAR(36) NOT NULL, RESOURCE_PATH VARCHAR(1024) NOT NULL, CONSTRAINT PK_PRJRESOURCES PRIMARY KEY(PROJECT_ID, RESOURCE_PATH) )
-------------------------------------------
com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -613, SQLSTATE: 54008, SQLERRMC: PK_PRJRESOURCES at com.ibm.db2.jcc.b.hh.c(hh.java:1662) at com.ibm.db2.jcc.b.hh.d(hh.java:1650) at com.ibm.db2.jcc.b.hh.b(hh.java:1173) at com.ibm.db2.jcc.c.db.h(db.java:219) at com.ibm.db2.jcc.c.db.b(db.java:46) at com.ibm.db2.jcc.c.t.b(t.java:40) at com.ibm.db2.jcc.c.sb.e(sb.java:121) at com.ibm.db2.jcc.b.hh.m(hh.java:1168) at com.ibm.db2.jcc.b.hh.a(hh.java:1934) at com.ibm.db2.jcc.b.hh.e(hh.java:749) at com.ibm.db2.jcc.b.hh.execute(hh.java:733) at org.opencms.setup.CmsSetupDb.executeStatement(CmsSetupDb.java:735) at org.opencms.setup.CmsSetupDb.executeSql(CmsSetupDb.java:650) at org.opencms.setup.CmsSetupDb.executeSql(CmsSetupDb.java:713) at org.opencms.setup.CmsSetupDb.createTables(CmsSetupDb.java:215) at com.ibm._jsp._step_5F_5_5F_database_5F_creation._jspService(_step_5F_5_5F_database_5F_creation.java:306) at com.ibm.ws.jsp.runtime.HttpJspBase.service(HttpJspBase.java:98) at javax.servlet.http.HttpServlet.service(HttpServlet.java:831) at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1455) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:793) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:444) at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:175) at com.ibm.wsspi.webcontainer.servlet.GenericServletWrapper.handleRequest(GenericServletWrapper.java:121) at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionServletWrapper.handleRequest(AbstractJSPExtensionServletWrapper.java:234) at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionProcessor.handleRequest(AbstractJSPExtensionProcessor.java:337) at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3622) at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:276) at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:927) at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1566) at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:175) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:455) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:384) at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:83) at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165) at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217) at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161) at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138) at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204) at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775) at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1527)
-------------------------------------------

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20090601/b1117dbb/attachment.htm>