Joel Gilchrist 12 Years Ago Hi I have also just installed LR 6.0.6 with DB2 Version 9 (not express) on Tomcat on Windows. On first inspection the basic things seems to be working but when I check the tomcat log it shows a few errors during what I think is the create table process when first starting LR. Did you see these? Do you think there are any underlying issues that I should look at?Here are the errors:17:18:54,968 INFO [PortalImpl:298] Portal lib directory /D:/liferaybundle-6.0.6/liferay-portal-6.0.6/tomcat-6.0.29/webapps/ROOT/WEB-INF/lib/Starting Liferay Portal Community Edition 6.0.6 CE (Bunyan / Build 6006 / February 17, 2011)17:19:06,625 ERROR [JDBCExceptionReporter:101] DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=LIFERAY.LOCK_, DRIVER=4.9.7817:19:06,625 ERROR [JDBCExceptionReporter:101] DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098, SQLERRMC=2;-204;42704;LIFERAY.LOCK_, DRIVER=4.9.7817:19:06,625 ERROR [JDBCExceptionReporter:101] DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098, SQLERRMC=2;-204;42704;LIFERAY.LOCK_, DRIVER=4.9.7817:19:07,421 WARN [ReleaseLocalServiceImpl:143] DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=LIFERAY.RELEASE_, DRIVER=4.9.7817:19:07,421 INFO [ReleaseLocalServiceImpl:84] Create tables and populate withdefault data17:19:23,546 WARN [BaseDB:376] DB2 SQL Error: SQLCODE=-614, SQLSTATE=54008, SQLERRMC=IX_7020130F, DRIVER=4.9.78: create index IX_7020130F on SCProductVersion (directDownloadURL);17:19:26,031 WARN [BaseDB:376] DB2 SQL Error: SQLCODE=-614, SQLSTATE=54008, SQLERRMC=IX_89509087, DRIVER=4.9.78: create index IX_89509087 on User_ (companyId,openId);17:19:27,343 INFO [BaseDB:400] Database supports case sensitive queriesAnd later on during the loading of KALEO:17:19:42,500 INFO [ServiceComponentLocalServiceImpl:187] Running Kaleo SQL scripts17:19:42,765 WARN [BaseDB:376] DB2 SQL Error: SQLCODE=-286, SQLSTATE=42727, SQLERRMC=8192;LIFERAY, DRIVER=4.9.78: create table KaleoLog (kaleoLogId LONG not null primary key,groupId LONG,companyId LONG,userId LONG,userName VARCHAR(200) null,createDate DATE null,modifiedDate DATE null,kaleoDefinitionId LONG,kaleoInstanceId LONG,kaleoInstanceTokenId LONG,kaleoTaskInstanceTokenId LONG,kaleoNodeId LONG,kaleoNodeName VARCHAR(200) null,terminalKaleoNode BOOLEAN,kaleoActionId LONG,kaleoActionName VARCHAR(200) null,kaleoActionDescription VARCHAR(2000) null,previousKaleoNodeId LONG,previousKaleoNodeName VARCHAR(200) null,previousAssigneeClassName VARCHAR(200) null,previousAssigneeClassPK LONG,currentAssigneeClassName VARCHAR(200) null,currentAssigneeClassPK LONG,type_ VARCHAR(50) null,comment_ VARCHAR(2000) null,startDate DATE null,endDate DATE null,duration LONG,workflowContext TEXT null);17:19:43,578 WARN [BaseDB:376] DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=LIFERAY.KALEOLOG, DRIVER=4.9.78: create index IX_73B5F4DE on KaleoLog (companyId);17:19:43,578 WARN [BaseDB:376] DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=LIFERAY.KALEOLOG, DRIVER=4.9.78: create index IX_6C64B7D4 on KaleoLog (kaleoDefinitionId);17:19:43,578 WARN [BaseDB:376] DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=LIFERAY.KALEOLOG, DRIVER=4.9.78: create index IX_5BC6AB16 on KaleoLog (kaleoInstanceId);17:19:43,578 WARN [BaseDB:376] DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=LIFERAY.KALEOLOG, DRIVER=4.9.78: create index IX_25157F25 on KaleoLog (kaleoInstanceTokenId, kaleoNodeId, type_);17:19:43,593 WARN [BaseDB:376] DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=LIFERAY.KALEOLOG, DRIVER=4.9.78: create index IX_470B9FF8 on KaleoLog (kaleoInstanceTokenId, type_);17:19:43,593 WARN [BaseDB:376] DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=LIFERAY.KALEOLOG, DRIVER=4.9.78: create index IX_B0CDCA38 on KaleoLog (kaleoTaskInstanceTokenId);17:19:44,343 INFO [HookHotDeployListener:394] Registering hook for kaleo-webBut as I said I am able to get to the portal and add users/content etc. So everything looks fine - I'm just worried that there is something wrong that will show itself later on.Thanks,Joel Please sign in to reply. Reply as... Cancel
Sheetal Sharma 12 Years Ago These are steps I followed with liferay 6.0.5 CE and tried to migrate from HSQL to DB2.1. On local machine, I added following jar files tomcat-6.0.26\lib\ext folder and restarted server. a . db2java.zip b. db2jcc.jar c. db2jcc_license_cu.jar d. db2jcc_license_cisuz.jar e. db2jcc_javax.jar f. db2policy.jar2. Logged in as admin and added following details for migration and clicked on execute button. jdbc.default.driverClassName=com.ibm.db2.jcc.DB2Driver jdbc.default.url=jdbc:db2://Server_Name:port/DB_Name jdbc.default.username=lportal jdbc.default.password=Schema_Password3. It ran successful for some tables but it always throws exception, here is the exception stack-trace.Hi Sandeep, Thanks for your inputs - these are steps I followed.1. On local machine, I added following jar files tomcat-6.0.26\lib\ext folder and restarted server. a. db2java.zip b. db2jcc.jar c. db2jcc_license_cu.jar2. Logged in as admin and added following details for migration and clicked on execute button. jdbc.default.driverClassName=com.ibm.db2.jcc.DB2Driver jdbc.default.url=jdbc:db2://Server_Name:port/DB_Name jdbc.default.username=lportal jdbc.default.password=Schema_Password3. It ran successful for some tables but it always throws exception in Kaleolog migration. Here is the exception stack-trace.12:10:31,754 INFO [Table:407] Finished backup of KaleoDefinition to C:\Liferay\Softwares\Server\liferay-portal-6.0.5\tomcat-6.0.26\temp/temp-db-KaleoDefinition-1325679031754 in 0 ms12:10:32,848 INFO [Table:371] Starting backup of KaleoInstance to C:\Liferay\Softwares\Server\liferay-portal-6.0.5\tomcat-6.0.26\temp/temp-db-KaleoInstance-132567903284812:10:32,848 INFO [Table:407] Finished backup of KaleoInstance to C:\Liferay\Softwares\Server\liferay-portal-6.0.5\tomcat-6.0.26\temp/temp-db-KaleoInstance-1325679032848 in 0 ms12:10:33,301 INFO [Table:371] Starting backup of KaleoInstanceToken to C:\Liferay\Softwares\Server\liferay-portal-6.0.5\tomcat-6.0.26\temp/temp-db-KaleoInstanceToken-132567903330112:10:33,301 INFO [Table:407] Finished backup of KaleoInstanceToken to C:\Liferay\Softwares\Server\liferay-portal-6.0.5\tomcat-6.0.26\temp/temp-db-KaleoInstanceToken-1325679033301 in 0 ms12:10:33,660 INFO [Table:371] Starting backup of KaleoLog to C:\Liferay\Softwares\Server\liferay-portal-6.0.5\tomcat-6.0.26\temp/temp-db-KaleoLog-132567903366012:10:33,660 INFO [Table:407] Finished backup of KaleoLog to C:\Liferay\Softwares\Server\liferay-portal-6.0.5\tomcat-6.0.26\temp/temp-db-KaleoLog-1325679033660 in 0 ms12:10:35,129 WARN [MaintenanceUtil:78] Session 9300F69285EE550A70627E4B59DA19DD is null12:10:35,129 FATAL [ConvertProcessMessageListener:35] Unable to process message {destinationName=liferay/convert_process, responseDestinationName=null, responseId=null, payload=com.liferay.portal.convert.ConvertDatabase, values=null}com.liferay.portal.convert.ConvertException: com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -286, SQLSTATE: 42727, SQLERRMC: 8192;LPORTAL at com.liferay.portal.convert.ConvertProcess.convert(ConvertProcess.java:53) at com.liferay.portal.convert.messaging.ConvertProcessMessageListener.doReceive(ConvertProcessMessageListener.java:47) at com.liferay.portal.convert.messaging.ConvertProcessMessageListener.receive(ConvertProcessMessageListener.java:32) at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:63) at com.liferay.portal.kernel.messaging.SerialDestination$1.run(SerialDestination.java:56) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:619)Caused by: com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -286, SQLSTATE: 42727, SQLERRMC: 8192;LPORTAL at com.ibm.db2.jcc.c.tf.e(tf.java:1680) at com.ibm.db2.jcc.c.tf.b(tf.java:1207) at com.ibm.db2.jcc.b.jb.i(jb.java:225) at com.ibm.db2.jcc.b.jb.b(jb.java:50) at com.ibm.db2.jcc.b.w.b(w.java:36) at com.ibm.db2.jcc.b.cc.e(cc.java:150) at com.ibm.db2.jcc.c.tf.m(tf.java:1204) at com.ibm.db2.jcc.c.tf.a(tf.java:1993) at com.ibm.db2.jcc.c.tf.c(tf.java:566) at com.ibm.db2.jcc.c.tf.executeUpdate(tf.java:551) at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStatement.java:64) at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:227) at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:187) at com.liferay.portal.convert.ConvertDatabase.migrateTable(ConvertDatabase.java:251) at com.liferay.portal.convert.ConvertDatabase.doConvert(ConvertDatabase.java:154) at com.liferay.portal.convert.ConvertProcess.convert(ConvertProcess.java:44) ... 7 more Please sign in to reply. Reply as... Cancel
David Welch 8 Years Ago Deployed 6.2 GA4 on Tomcat 7 (bundled), install fine, but no portlets can install.After going to Marketplace, then Control Panel | Apps | Purchased, try to click Install on any app, just spins and spins. Cannot install any apps using DB2. Have tried this multiple times, same result. DB2 error is relating to cursor, posted this in forums, no solution provided. Any ideas? Please sign in to reply. Reply as... Cancel