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

[Georgi Naplatanov]

Hello Soobaek,

may be the page size of the database is too small. Try to create a 
database with page size 32KB or more.

error 613 - THE PRIMARY KEY OR A UNIQUE CONSTRAINT IS TOO LONG OR HAS 
TOO MANY COLUMNS

Best regards
Georgi

Soobaek Jang wrote:
> 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)
> -------------------------------------------
>  
>
> ------------------------------------------------------------------------
>
>
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/mailman/listinfo/opencms-dev