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

[Soobaek Jang]

Georgi,

 

Yup, that was it! Thank you very much!

 

Regards,

Soobaek
 
> Date: Mon, 1 Jun 2009 20:27:10 +0300
> From: gosho at oles.biz
> To: opencms-dev at opencms.org
> Subject: Re: [opencms-dev] Installation issue with DB2 v9.1
> 
> 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
> 
> 
> _______________________________________________
> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20090602/a22293ad/attachment.htm>