<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
</style>
</head>
<body class='hmmessage'>
Georgi,<BR>
<BR>
Yup, that was it! Thank you very much!<BR>
<BR>
Regards,<BR>
Soobaek<BR> <BR>> Date: Mon, 1 Jun 2009 20:27:10 +0300<BR>> From: gosho@oles.biz<BR>> To: opencms-dev@opencms.org<BR>> Subject: Re: [opencms-dev] Installation issue with DB2 v9.1<BR>> <BR>> Hello Soobaek,<BR>> <BR>> may be the page size of the database is too small. Try to create a <BR>> database with page size 32KB or more.<BR>> <BR>> error 613 - THE PRIMARY KEY OR A UNIQUE CONSTRAINT IS TOO LONG OR HAS <BR>> TOO MANY COLUMNS<BR>> <BR>> Best regards<BR>> Georgi<BR>> <BR>> Soobaek Jang wrote:<BR>> > Hello,<BR>> > I am having trouble installing OpenCMS with DB2 v9.1. During the setup <BR>> > wizard, I get the following error.<BR>> > If anyone has any idea how to resolve this issue, I would really <BR>> > appreciate it.<BR>> > Thank you very much in advance!!!<BR>> > <BR>> > <BR>> ><BR>> > Alkacon OpenCms Setup Wizard - Create database & tables<BR>> > Creating tables ...<BR>> > <BR>> > Tables could not be created!<BR>> > Error executing SQL statement: CREATE TABLE CMS_PROJECTRESOURCES ( <BR>> > PROJECT_ID VARCHAR(36) NOT NULL, RESOURCE_PATH VARCHAR(1024) NOT NULL, <BR>> > CONSTRAINT PK_PRJRESOURCES PRIMARY KEY(PROJECT_ID, RESOURCE_PATH) )<BR>> > -------------------------------------------<BR>> > com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -613, <BR>> > SQLSTATE: 54008, SQLERRMC: PK_PRJRESOURCES at <BR>> > com.ibm.db2.jcc.b.hh.c(hh.java:1662) at <BR>> > com.ibm.db2.jcc.b.hh.d(hh.java:1650) at <BR>> > com.ibm.db2.jcc.b.hh.b(hh.java:1173) at <BR>> > com.ibm.db2.jcc.c.db.h(db.java:219) at <BR>> > com.ibm.db2.jcc.c.db.b(db.java:46) at com.ibm.db2.jcc.c.t.b(t.java:40) <BR>> > at com.ibm.db2.jcc.c.sb.e(sb.java:121) at <BR>> > com.ibm.db2.jcc.b.hh.m(hh.java:1168) at <BR>> > com.ibm.db2.jcc.b.hh.a(hh.java:1934) at <BR>> > com.ibm.db2.jcc.b.hh.e(hh.java:749) at <BR>> > com.ibm.db2.jcc.b.hh.execute(hh.java:733) at <BR>> > org.opencms.setup.CmsSetupDb.executeStatement(CmsSetupDb.java:735) at <BR>> > org.opencms.setup.CmsSetupDb.executeSql(CmsSetupDb.java:650) at <BR>> > org.opencms.setup.CmsSetupDb.executeSql(CmsSetupDb.java:713) at <BR>> > org.opencms.setup.CmsSetupDb.createTables(CmsSetupDb.java:215) at <BR>> > com.ibm._jsp._step_5F_5_5F_database_5F_creation._jspService(_step_5F_5_5F_database_5F_creation.java:306) <BR>> > at com.ibm.ws.jsp.runtime.HttpJspBase.service(HttpJspBase.java:98) at <BR>> > javax.servlet.http.HttpServlet.service(HttpServlet.java:831) at <BR>> > com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1455) <BR>> > at <BR>> > com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:793) <BR>> > at <BR>> > com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:444) <BR>> > at <BR>> > com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:175) <BR>> > at <BR>> > com.ibm.wsspi.webcontainer.servlet.GenericServletWrapper.handleRequest(GenericServletWrapper.java:121) <BR>> > at <BR>> > com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionServletWrapper.handleRequest(AbstractJSPExtensionServletWrapper.java:234) <BR>> > at <BR>> > com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionProcessor.handleRequest(AbstractJSPExtensionProcessor.java:337) <BR>> > at <BR>> > com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3622) <BR>> > at <BR>> > com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:276) <BR>> > at <BR>> > com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:927) <BR>> > at <BR>> > com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1566) <BR>> > at <BR>> > com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:175) <BR>> > at <BR>> > com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:455) <BR>> > at <BR>> > com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:384) <BR>> > at <BR>> > com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:83) <BR>> > at <BR>> > com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165) <BR>> > at <BR>> > com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217) <BR>> > at <BR>> > com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161) <BR>> > at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138) at <BR>> > com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204) at <BR>> > com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775) <BR>> > at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905) at <BR>> > com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1527)<BR>> > -------------------------------------------<BR>> > <BR>> ><BR>> > ------------------------------------------------------------------------<BR>> ><BR>> ><BR>> > _______________________________________________<BR>> > This mail is sent to you from the opencms-dev mailing list<BR>> > To change your list options, or to unsubscribe from the list, please visit<BR>> > http://lists.opencms.org/mailman/listinfo/opencms-dev<BR>> <BR>> <BR>> _______________________________________________<BR>> This mail is sent to you from the opencms-dev mailing list<BR>> To change your list options, or to unsubscribe from the list, please visit<BR>> http://lists.opencms.org/mailman/listinfo/opencms-dev<BR></body>
</html>