[LPS-69844] SqlSyntaxErrorException when 6.2 SP17 started with DB2 10.5 - Liferay Issues

XML

Word

Printable

Details

Type: Bug
Status: Closed
Resolution: Won't Fix
Affects Version/s: 6.2.10 EE GA1
Fix Version/s: None
Component/s: Calendar > Upgrade, Environments, Environments > Databases
Labels:
None

Fix Priority:
5

QA Test Name:
- LocalFile.PortalSmoke#Smoke
QA Test Score:
5

Description

Steps to reproduce:

Download the DB2 10.5 from here.
Get the DB2 driver form wiki's attachments.

Set the database connection property in the portal-ext.properties

jdbc.default.driverClassName=com.ibm.db2.jcc.DB2Driver
	jdbc.default.url=jdbc:db2://[VM ipaddress]:50000/[dbname]:deferPrepares=false;fullyMaterializeInputStreams=true;fullyMaterializeLobData=true;progresssiveLocators=2;progressiveStreaming=2;
	jdbc.default.username=administrator
	jdbc.default.password=password

To create a database, run:*
```
CREATE database lportal PAGESIZE 32 k
```
Start 6.2 SP17 with DB2 10.5

Expected Result:
Start up without errors.

Actual Result:
The console throws the following error:

07:24:58,103 INFO  [localhost-startStop-1][DialectDetector:71] Determine dialect for DB2/NT64 10
07:24:58,155 INFO  [localhost-startStop-1][DialectDetector:136] Found dialect com.liferay.portal.dao.orm.hibernate.DB2Dialect
07:25:17,042 INFO  [localhost-startStop-1][StartupAction:103] The following patches are installed: portal-128-6210
07:25:17,139 ERROR [localhost-startStop-1][JDBCExceptionReporter:82] DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=ADMINISTRATOR.LOCK_, DRIVER=4.13.127
07:25:17,139 ERROR [localhost-startStop-1][JDBCExceptionReporter:82] DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098, SQLERRMC=2;-204;42704;ADMINISTRATOR.LOCK_, DRIVER=4.13.127
07:25:17,143 WARN  [localhost-startStop-1][StartupAction:150] Unable to clear locks because Lock table does not exist
07:25:17,484 WARN  [localhost-startStop-1][ReleaseLocalServiceImpl:171] DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=ADMINISTRATOR.RELEASE_, DRIVER=4.13.127
07:25:17,486 INFO  [localhost-startStop-1][ReleaseLocalServiceImpl:84] Create tables and populate with default data
07:25:45,466 INFO  [localhost-startStop-1][BaseDB:486] Database supports case sensitive queries
07:25:46,184 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyProcessSuite
07:25:46,185 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyProperties
07:25:46,210 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyDB2
07:25:46,612 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyMySQL
07:25:46,614 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyOracle
07:25:46,616 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyPostgreSQL
07:25:46,619 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifySQLServer
07:25:46,623 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyUUID
07:25:46,730 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyPermission
07:25:48,556 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyGroup
07:25:48,601 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyRole
07:25:48,603 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyAsset
07:25:48,609 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.portal.upgrade.util.UpgradeAssetPublisherManualEntries
07:25:48,618 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyAuditedModel
07:25:48,673 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyBlogs
07:25:48,688 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyBookmarks
07:25:48,706 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyCalendar
07:25:48,722 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyDocumentLibrary
07:25:48,878 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyDynamicDataMapping
07:25:48,920 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyGroupId
07:25:48,938 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyJournal
07:25:48,988 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyLayout
07:25:49,017 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyMessageBoards
07:25:49,047 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyOrganization
07:25:49,062 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyPortalPreferences
07:25:49,075 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyPortletPreferences
07:25:49,101 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyRegion
07:25:49,110 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyResourcePermissions
07:25:49,113 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyUser
07:25:49,134 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyWiki
07:25:49,153 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyWorkflow
07:25:50,612 INFO  [localhost-startStop-1][LicenseManager:?] Failed to find directory D:\release-bundle\liferay-portal-6.2-ee-sp17\data\license
07:25:50,612 ERROR [localhost-startStop-1][LicenseManager:?] No binary licenses found
07:25:50,622 INFO  [localhost-startStop-1][ServerDetector:140] Server supports hot deploy
07:25:50,632 INFO  [localhost-startStop-1][PluginPackageUtil:1013] Reading plugin package for the root context
07:25:53,278 INFO  [localhost-startStop-1][AutoDeployDir:139] Auto deploy scanner started for D:\release-bundle\liferay-portal-6.2-ee-sp17\deploy
07:26:06,259 INFO  [localhost-startStop-1][HotDeployEvent:145] Plugin calendar-portlet requires marketplace-portlet
07:26:06,310 INFO  [localhost-startStop-1][HotDeployImpl:278] Queueing calendar-portlet for deploy because it is missing marketplace-portlet
07:26:07,320 INFO  [localhost-startStop-1][HotDeployEvent:145] Plugin kaleo-designer-portlet requires kaleo-web, marketplace-portlet
07:26:07,324 INFO  [localhost-startStop-1][HotDeployImpl:278] Queueing kaleo-designer-portlet for deploy because it is missing kaleo-web, marketplace-portlet
07:26:08,299 INFO  [localhost-startStop-1][HotDeployEvent:145] Plugin kaleo-forms-portlet requires kaleo-designer-portlet, kaleo-web, marketplace-portlet
07:26:08,302 INFO  [localhost-startStop-1][HotDeployImpl:278] Queueing kaleo-forms-portlet for deploy because it is missing kaleo-designer-portlet, kaleo-web, marketplace-portlet
07:26:09,154 INFO  [localhost-startStop-1][HotDeployEvent:145] Plugin kaleo-web requires marketplace-portlet
07:26:09,158 INFO  [localhost-startStop-1][HotDeployImpl:278] Queueing kaleo-web for deploy because it is missing marketplace-portlet
07:26:09,918 INFO  [localhost-startStop-1][HotDeployImpl:217] Deploying marketplace-portlet from queue
07:26:09,937 INFO  [localhost-startStop-1][PluginPackageUtil:1016] Reading plugin package for marketplace-portlet
07:26:10,063 INFO  [localhost-startStop-1][ServiceComponentLocalServiceImpl:323] Running Marketplace SQL scripts
07:26:10,652 INFO  [localhost-startStop-1][HookHotDeployListener:715] Registering hook for marketplace-portlet
07:26:10,695 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.marketplace.hook.upgrade.UpgradeProcess_1_0_0
07:26:10,697 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.marketplace.hook.upgrade.v1_0_0.UpgradeExpando
07:26:10,704 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.marketplace.hook.upgrade.UpgradeProcess_1_0_1
07:26:10,706 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.marketplace.hook.upgrade.v1_0_1.UpgradeModule
07:26:10,807 INFO  [localhost-startStop-1][HookHotDeployListener:857] Hook for marketplace-portlet is available for use
07:26:10,812 INFO  [localhost-startStop-1][PortletHotDeployListener:344] Registering portlets for marketplace-portlet
07:26:10,985 INFO  [localhost-startStop-1][PortletHotDeployListener:497] 3 portlets for marketplace-portlet are available for use
07:26:10,987 INFO  [localhost-startStop-1][HotDeployImpl:217] Deploying calendar-portlet from queue
07:26:10,988 INFO  [localhost-startStop-1][PluginPackageUtil:1016] Reading plugin package for calendar-portlet
07:26:11,092 INFO  [localhost-startStop-1][ServiceComponentLocalServiceImpl:323] Running Calendar SQL scripts
07:26:12,625 INFO  [localhost-startStop-1][HookHotDeployListener:715] Registering hook for calendar-portlet
07:26:12,642 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.calendar.hook.upgrade.UpgradeProcess_1_0_2
07:26:12,644 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.calendar.hook.upgrade.v1_0_2.UpgradeCalendarResource
07:26:12,679 ERROR [localhost-startStop-1][HotDeployImpl:233] com.liferay.portal.kernel.deploy.hot.HotDeployException: Error registering hook for calendar-portletcalendar-portlet
com.liferay.portal.kernel.deploy.hot.HotDeployException: Error registering hook for calendar-portletcalendar-portlet
	at com.liferay.portal.kernel.deploy.hot.BaseHotDeployListener.throwHotDeployException(BaseHotDeployListener.java:46)
	at com.liferay.portal.deploy.hot.HookHotDeployListener.invokeDeploy(HookHotDeployListener.java:323)
	at com.liferay.portal.deploy.hot.HotDeployImpl.doFireDeployEvent(HotDeployImpl.java:230)
	at com.liferay.portal.deploy.hot.HotDeployImpl.doFireDeployEvent(HotDeployImpl.java:257)
	at com.liferay.portal.deploy.hot.HotDeployImpl.fireDeployEvent(HotDeployImpl.java:96)
	at com.liferay.portal.kernel.deploy.hot.HotDeployUtil.fireDeployEvent(HotDeployUtil.java:28)
	at com.liferay.portal.kernel.servlet.PluginContextListener.fireDeployEvent(PluginContextListener.java:164)
	at com.liferay.portal.kernel.servlet.PluginContextListener.doPortalInit(PluginContextListener.java:154)
	at com.liferay.portal.kernel.util.BasePortalLifecycle.portalInit(BasePortalLifecycle.java:44)
	at com.liferay.portal.kernel.util.PortalLifecycleUtil.register(PortalLifecycleUtil.java:74)
	at com.liferay.portal.kernel.util.PortalLifecycleUtil.register(PortalLifecycleUtil.java:58)
	at com.liferay.portal.kernel.util.BasePortalLifecycle.registerPortalLifecycle(BasePortalLifecycle.java:54)
	at com.liferay.portal.kernel.servlet.PluginContextListener.contextInitialized(PluginContextListener.java:116)
	at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5528)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652)
	at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1263)
	at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1948)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:745)
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=CalendarResource;lendarResource where;ON, DRIVER=4.13.127
	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:170)
	at com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:167)
	at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:115)
	at com.liferay.portal.deploy.hot.HookHotDeployListener.updateRelease(HookHotDeployListener.java:2918)
	at com.liferay.portal.deploy.hot.HookHotDeployListener.initPortalProperties(HookHotDeployListener.java:2300)
	at com.liferay.portal.deploy.hot.HookHotDeployListener.initPortalProperties(HookHotDeployListener.java:1789)
	at com.liferay.portal.deploy.hot.HookHotDeployListener.doInvokeDeploy(HookHotDeployListener.java:726)
	at com.liferay.portal.deploy.hot.HookHotDeployListener.invokeDeploy(HookHotDeployListener.java:320)
	... 24 more
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=CalendarResource;lendarResource where;ON, DRIVER=4.13.127
	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:170)
	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:184)
	at com.liferay.calendar.hook.upgrade.UpgradeProcess_1_0_2.doUpgrade(UpgradeProcess_1_0_2.java:33)
	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:167)
	... 31 more
Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=CalendarResource;lendarResource where;ON, DRIVER=4.13.127
	at com.ibm.db2.jcc.am.id.a(id.java:677)
	at com.ibm.db2.jcc.am.id.a(id.java:60)
	at com.ibm.db2.jcc.am.id.a(id.java:127)
	at com.ibm.db2.jcc.am.no.c(no.java:2653)
	at com.ibm.db2.jcc.am.no.d(no.java:2641)
	at com.ibm.db2.jcc.am.no.a(no.java:2090)
	at com.ibm.db2.jcc.am.oo.a(oo.java:7671)
	at com.ibm.db2.jcc.t4.cb.h(cb.java:141)
	at com.ibm.db2.jcc.t4.cb.b(cb.java:41)
	at com.ibm.db2.jcc.t4.q.a(q.java:32)
	at com.ibm.db2.jcc.t4.sb.i(sb.java:135)
	at com.ibm.db2.jcc.am.no.ib(no.java:2059)
	at com.ibm.db2.jcc.am.oo.sc(oo.java:3559)
	at com.ibm.db2.jcc.am.oo.yc(oo.java:3691)
	at com.ibm.db2.jcc.am.oo.a(oo.java:598)
	at com.ibm.db2.jcc.am.kb.a(kb.java:2326)
	at com.ibm.db2.jcc.am.kb.a(kb.java:2284)
	at com.ibm.db2.jcc.am.kb.prepareStatement(kb.java:866)
	at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:469)
	at sun.reflect.GeneratedMethodAccessor64.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy$LazyConnectionInvocationHandler.invoke(LazyConnectionDataSourceProxy.java:376)
	at com.sun.proxy.$Proxy5.prepareStatement(Unknown Source)
	at com.liferay.portal.kernel.upgrade.dao.orm.UpgradeOptimizedConnectionHandler.prepareStatement(UpgradeOptimizedConnectionHandler.java:79)
	at com.liferay.portal.kernel.upgrade.dao.orm.UpgradeOptimizedConnectionHandler.invoke(UpgradeOptimizedConnectionHandler.java:59)
	at com.sun.proxy.$Proxy433.prepareStatement(Unknown Source)
	at com.liferay.calendar.hook.upgrade.v1_0_2.UpgradeCalendarResource.updateCalendarUserIds(UpgradeCalendarResource.java:89)
	at com.liferay.calendar.hook.upgrade.v1_0_2.UpgradeCalendarResource.upgradeCalendarResourceUserIds(UpgradeCalendarResource.java:147)
	at com.liferay.calendar.hook.upgrade.v1_0_2.UpgradeCalendarResource.doUpgrade(UpgradeCalendarResource.java:42)
	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:167)
	... 34 more
07:26:13,046 INFO  [localhost-startStop-1][PortletHotDeployListener:344] Registering portlets for calendar-portlet
07:26:13,377 INFO  [localhost-startStop-1][PortletHotDeployListener:492] 1 portlet for calendar-portlet is available for use
07:26:13,379 INFO  [localhost-startStop-1][SocialHotDeployListener:94] Registering social for calendar-portlet
07:26:13,383 INFO  [localhost-startStop-1][SocialHotDeployListener:103] Social for calendar-portlet is available for use
07:26:13,385 INFO  [localhost-startStop-1][HotDeployImpl:296] kaleo-designer-portlet is still in queue because it is missing kaleo-web
07:26:13,389 INFO  [localhost-startStop-1][HotDeployImpl:296] kaleo-designer-portlet is still in queue because it is missing kaleo-designer-portlet, kaleo-web
07:26:13,391 INFO  [localhost-startStop-1][HotDeployImpl:296] kaleo-designer-portlet is still in queue because it is missing 
07:26:13,397 INFO  [localhost-startStop-1][HotDeployImpl:296] kaleo-forms-portlet is still in queue because it is missing kaleo-web
07:26:13,401 INFO  [localhost-startStop-1][HotDeployImpl:296] kaleo-forms-portlet is still in queue because it is missing kaleo-designer-portlet, kaleo-web
07:26:13,407 INFO  [localhost-startStop-1][HotDeployImpl:296] kaleo-forms-portlet is still in queue because it is missing 
07:26:13,414 INFO  [localhost-startStop-1][HotDeployImpl:217] Deploying kaleo-web from queue
07:26:13,417 INFO  [localhost-startStop-1][PluginPackageUtil:1016] Reading plugin package for kaleo-web
07:26:13,568 INFO  [localhost-startStop-1][ServiceComponentLocalServiceImpl:323] Running Kaleo SQL scripts
07:26:17,450 INFO  [localhost-startStop-1][HookHotDeployListener:715] Registering hook for kaleo-web
07:26:17,480 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.portal.workflow.kaleo.hook.upgrade.UpgradeProcess_1_0_0
07:26:17,482 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.portal.workflow.kaleo.hook.upgrade.v1_0_0.UpgradeKaleoTaskInstanceToken
07:26:17,497 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.portal.workflow.kaleo.hook.upgrade.UpgradeProcess_1_1_0
07:26:17,499 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.portal.workflow.kaleo.hook.upgrade.v1_1_0.UpgradeWorkflowContext
07:26:17,548 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.portal.workflow.kaleo.hook.upgrade.UpgradeProcess_1_2_0
07:26:17,550 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.portal.workflow.kaleo.hook.upgrade.v1_2_0.UpgradeKaleoLog
07:26:17,562 INFO  [localhost-startStop-1][Table:156] Starting backup of KaleoLog to D:\release-bundle\liferay-portal-6.2-ee-sp17\tomcat-7.0.62\temp/temp-db-KaleoLog-1482305177562
07:26:17,574 INFO  [localhost-startStop-1][Table:190] Finished backup of KaleoLog to D:\release-bundle\liferay-portal-6.2-ee-sp17\tomcat-7.0.62\temp/temp-db-KaleoLog-1482305177562 in 12 ms
07:26:17,681 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.portal.workflow.kaleo.hook.upgrade.v1_2_0.UpgradeKaleoNotificationRecipient
07:26:17,710 INFO  [localhost-startStop-1][HookHotDeployListener:857] Hook for kaleo-web is available for use
07:26:17,718 INFO  [localhost-startStop-1][HotDeployImpl:217] Deploying kaleo-designer-portlet from queue
07:26:17,721 INFO  [localhost-startStop-1][PluginPackageUtil:1016] Reading plugin package for kaleo-designer-portlet
07:26:17,887 INFO  [localhost-startStop-1][ServiceComponentLocalServiceImpl:323] Running KaleoDesigner SQL scripts
07:26:18,421 INFO  [localhost-startStop-1][HookHotDeployListener:715] Registering hook for kaleo-designer-portlet
07:26:18,870 INFO  [localhost-startStop-1][HookHotDeployListener:857] Hook for kaleo-designer-portlet is available for use
07:26:18,873 INFO  [localhost-startStop-1][PortletHotDeployListener:344] Registering portlets for kaleo-designer-portlet
07:26:18,963 INFO  [localhost-startStop-1][PortletHotDeployListener:497] 2 portlets for kaleo-designer-portlet are available for use
07:26:18,964 INFO  [localhost-startStop-1][HotDeployImpl:217] Deploying kaleo-forms-portlet from queue
07:26:18,966 INFO  [localhost-startStop-1][PluginPackageUtil:1016] Reading plugin package for kaleo-forms-portlet
07:26:19,072 INFO  [localhost-startStop-1][ServiceComponentLocalServiceImpl:323] Running KaleoForms SQL scripts
07:26:19,531 INFO  [localhost-startStop-1][HookHotDeployListener:715] Registering hook for kaleo-forms-portlet
07:26:19,549 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.portal.workflow.kaleo.forms.hook.upgrade.UpgradeProcess_1_0_0
07:26:19,552 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.portal.workflow.kaleo.forms.hook.upgrade.v1_0_0.UpgradeKaleoProcess
07:26:19,616 INFO  [localhost-startStop-1][HookHotDeployListener:857] Hook for kaleo-forms-portlet is available for use
07:26:19,621 INFO  [localhost-startStop-1][PortletHotDeployListener:344] Registering portlets for kaleo-forms-portlet
07:26:19,851 INFO  [localhost-startStop-1][PortletHotDeployListener:497] 2 portlets for kaleo-forms-portlet are available for use
07:26:22,202 INFO  [localhost-startStop-1][HotDeployEvent:145] Plugin notifications-portlet requires marketplace-portlet
07:26:22,204 INFO  [localhost-startStop-1][HotDeployImpl:217] Deploying notifications-portlet from queue
07:26:22,207 INFO  [localhost-startStop-1][PluginPackageUtil:1016] Reading plugin package for notifications-portlet
07:26:22,273 INFO  [localhost-startStop-1][ServiceComponentLocalServiceImpl:323] Running Ntfctns SQL scripts
07:26:22,587 INFO  [localhost-startStop-1][HookHotDeployListener:715] Registering hook for notifications-portlet
07:26:22,602 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.notifications.hook.upgrade.UpgradeProcess_1_0_0
07:26:22,604 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.notifications.hook.upgrade.v1_0_0.UpgradeUserNotificationEvent
07:26:22,623 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.notifications.hook.upgrade.UpgradeProcess_1_1_0
07:26:22,627 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.notifications.hook.upgrade.v1_1_0.UpgradeUserNotificationEvent
07:26:22,632 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.notifications.hook.upgrade.UpgradeProcess_1_2_0
07:26:22,635 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.notifications.hook.upgrade.v1_2_0.UpgradeUserNotificationEvent
07:26:22,677 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.notifications.hook.upgrade.UpgradeProcess_1_3_0
07:26:22,679 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.notifications.hook.upgrade.v1_3_0.UpgradeUserNotificationEvent
07:26:22,856 INFO  [localhost-startStop-1][HookHotDeployListener:857] Hook for notifications-portlet is available for use
07:26:22,858 INFO  [localhost-startStop-1][PortletHotDeployListener:344] Registering portlets for notifications-portlet
07:26:23,004 INFO  [localhost-startStop-1][PortletHotDeployListener:497] 2 portlets for notifications-portlet are available for use
07:26:23,845 INFO  [localhost-startStop-1][HotDeployEvent:145] Plugin oauth-portlet requires marketplace-portlet
07:26:23,848 INFO  [localhost-startStop-1][HotDeployImpl:217] Deploying oauth-portlet from queue
07:26:23,855 INFO  [localhost-startStop-1][PluginPackageUtil:1016] Reading plugin package for oauth-portlet
07:26:23,933 INFO  [localhost-startStop-1][ServiceComponentLocalServiceImpl:323] Running OAuth SQL scripts
07:26:24,440 INFO  [localhost-startStop-1][HookHotDeployListener:715] Registering hook for oauth-portlet
07:26:24,545 INFO  [localhost-startStop-1][HookHotDeployListener:857] Hook for oauth-portlet is available for use
07:26:24,549 INFO  [localhost-startStop-1][PortletHotDeployListener:344] Registering portlets for oauth-portlet
07:26:24,742 INFO  [localhost-startStop-1][PortletHotDeployListener:497] 3 portlets for oauth-portlet are available for use
07:26:26,183 INFO  [localhost-startStop-1][HotDeployEvent:145] Plugin opensocial-portlet requires marketplace-portlet
07:26:26,186 INFO  [localhost-startStop-1][HotDeployImpl:217] Deploying opensocial-portlet from queue
07:26:26,190 INFO  [localhost-startStop-1][PluginPackageUtil:1016] Reading plugin package for opensocial-portlet
07:26:26,283 INFO  [localhost-startStop-1][ServiceComponentLocalServiceImpl:323] Running OpenSocial SQL scripts
07:26:27,354 INFO  [localhost-startStop-1][HookHotDeployListener:715] Registering hook for opensocial-portlet
07:26:27,400 INFO  [localhost-startStop-1][HookHotDeployListener:857] Hook for opensocial-portlet is available for use
07:26:27,404 INFO  [localhost-startStop-1][PortletHotDeployListener:344] Registering portlets for opensocial-portlet
07:26:27,645 INFO  [localhost-startStop-1][PortletHotDeployListener:497] 4 portlets for opensocial-portlet are available for use
07:26:28,885 INFO  [localhost-startStop-1][HotDeployEvent:145] Plugin resources-importer-web requires marketplace-portlet
07:26:28,887 INFO  [localhost-startStop-1][HotDeployImpl:217] Deploying resources-importer-web from queue
07:26:28,896 INFO  [localhost-startStop-1][PluginPackageUtil:1016] Reading plugin package for resources-importer-web
07:26:29,017 INFO  [localhost-startStop-1][HookHotDeployListener:715] Registering hook for resources-importer-web
07:26:29,021 INFO  [localhost-startStop-1][HookHotDeployListener:857] Hook for resources-importer-web is available for use
07:26:29,764 INFO  [localhost-startStop-1][HotDeployEvent:145] Plugin sync-admin-portlet requires marketplace-portlet, sync-web
07:26:29,766 INFO  [localhost-startStop-1][HotDeployImpl:278] Queueing sync-admin-portlet for deploy because it is missing sync-web
07:26:31,063 INFO  [localhost-startStop-1][HotDeployEvent:145] Plugin sync-web requires marketplace-portlet
07:26:31,065 INFO  [localhost-startStop-1][HotDeployImpl:217] Deploying sync-web from queue
07:26:31,072 INFO  [localhost-startStop-1][PluginPackageUtil:1016] Reading plugin package for sync-web
07:26:31,220 INFO  [localhost-startStop-1][ServiceComponentLocalServiceImpl:323] Running Sync SQL scripts
07:26:32,391 INFO  [localhost-startStop-1][HookHotDeployListener:715] Registering hook for sync-web
07:26:32,403 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.sync.hook.upgrade.v1_0_0.UpgradeIndex
07:26:32,420 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.sync.hook.upgrade.v1_0_2.UpgradeIndex
07:26:32,454 ERROR [localhost-startStop-1][HotDeployImpl:233] com.liferay.portal.kernel.deploy.hot.HotDeployException: Error registering hook for sync-websync-web
com.liferay.portal.kernel.deploy.hot.HotDeployException: Error registering hook for sync-websync-web
	at com.liferay.portal.kernel.deploy.hot.BaseHotDeployListener.throwHotDeployException(BaseHotDeployListener.java:46)
	at com.liferay.portal.deploy.hot.HookHotDeployListener.invokeDeploy(HookHotDeployListener.java:323)
	at com.liferay.portal.deploy.hot.HotDeployImpl.doFireDeployEvent(HotDeployImpl.java:230)
	at com.liferay.portal.deploy.hot.HotDeployImpl.fireDeployEvent(HotDeployImpl.java:96)
	at com.liferay.portal.kernel.deploy.hot.HotDeployUtil.fireDeployEvent(HotDeployUtil.java:28)
	at com.liferay.portal.kernel.servlet.PluginContextListener.fireDeployEvent(PluginContextListener.java:186)
	at com.liferay.portal.kernel.servlet.PluginContextListener.doPortalInit(PluginContextListener.java:170)
	at com.liferay.portal.kernel.util.BasePortalLifecycle.portalInit(BasePortalLifecycle.java:44)
	at com.liferay.portal.kernel.util.PortalLifecycleUtil.register(PortalLifecycleUtil.java:74)
	at com.liferay.portal.kernel.util.PortalLifecycleUtil.register(PortalLifecycleUtil.java:58)
	at com.liferay.portal.kernel.util.BasePortalLifecycle.registerPortalLifecycle(BasePortalLifecycle.java:54)
	at com.liferay.portal.kernel.servlet.PluginContextListener.contextInitialized(PluginContextListener.java:120)
	at com.liferay.portal.kernel.servlet.SecurePluginContextListener.contextInitialized(SecurePluginContextListener.java:151)
	at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5528)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652)
	at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1263)
	at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1948)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:745)
Caused by: com.liferay.portal.kernel.events.ActionException: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=END-OF-STATEMENT;e table SYNCDLOBJECT;IMMEDIATE, DRIVER=4.13.127
	at com.liferay.sync.hook.events.StartupAction.run(StartupAction.java:33)
	at com.liferay.portal.kernel.events.InvokerSimpleAction.run(InvokerSimpleAction.java:42)
	at com.liferay.portal.deploy.hot.HookHotDeployListener.initEvent(HookHotDeployListener.java:1400)
	at com.liferay.portal.deploy.hot.HookHotDeployListener.initEvents(HookHotDeployListener.java:1463)
	at com.liferay.portal.deploy.hot.HookHotDeployListener.initPortalProperties(HookHotDeployListener.java:1806)
	at com.liferay.portal.deploy.hot.HookHotDeployListener.doInvokeDeploy(HookHotDeployListener.java:726)
	at com.liferay.portal.deploy.hot.HookHotDeployListener.invokeDeploy(HookHotDeployListener.java:320)
	... 24 more
Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=END-OF-STATEMENT;e table SYNCDLOBJECT;IMMEDIATE, DRIVER=4.13.127
	at com.ibm.db2.jcc.am.id.a(id.java:677)
	at com.ibm.db2.jcc.am.id.a(id.java:60)
	at com.ibm.db2.jcc.am.id.a(id.java:127)
	at com.ibm.db2.jcc.am.no.b(no.java:2310)
	at com.ibm.db2.jcc.am.no.c(no.java:2293)
	at com.ibm.db2.jcc.t4.cb.l(cb.java:370)
	at com.ibm.db2.jcc.t4.cb.a(cb.java:62)
	at com.ibm.db2.jcc.t4.q.a(q.java:50)
	at com.ibm.db2.jcc.t4.tb.b(tb.java:220)
	at com.ibm.db2.jcc.am.oo.oc(oo.java:3428)
	at com.ibm.db2.jcc.am.oo.b(oo.java:4383)
	at com.ibm.db2.jcc.am.oo.gc(oo.java:784)
	at com.ibm.db2.jcc.am.oo.executeUpdate(oo.java:763)
	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:1449)
	at com.liferay.sync.util.VerifyUtil.doVerify(VerifyUtil.java:67)
	at com.liferay.sync.util.VerifyUtil.verify(VerifyUtil.java:55)
	at com.liferay.sync.hook.events.StartupAction.doRun(StartupAction.java:44)
	at com.liferay.sync.hook.events.StartupAction.run(StartupAction.java:30)
	... 30 more
07:26:32,731 INFO  [localhost-startStop-1][HotDeployImpl:217] Deploying sync-admin-portlet from queue
07:26:32,765 INFO  [localhost-startStop-1][PluginPackageUtil:1016] Reading plugin package for sync-admin-portlet
07:26:32,941 INFO  [localhost-startStop-1][HookHotDeployListener:715] Registering hook for sync-admin-portlet
07:26:32,992 INFO  [localhost-startStop-1][HookHotDeployListener:857] Hook for sync-admin-portlet is available for use
07:26:32,996 INFO  [localhost-startStop-1][PortletHotDeployListener:344] Registering portlets for sync-admin-portlet
07:26:33,119 INFO  [localhost-startStop-1][PortletHotDeployListener:497] 2 portlets for sync-admin-portlet are available for use
07:26:34,260 INFO  [localhost-startStop-1][HotDeployEvent:145] Plugin web-form-portlet requires marketplace-portlet
07:26:34,270 INFO  [localhost-startStop-1][HotDeployImpl:217] Deploying web-form-portlet from queue
07:26:34,278 INFO  [localhost-startStop-1][PluginPackageUtil:1016] Reading plugin package for web-form-portlet
07:26:34,440 INFO  [localhost-startStop-1][PortletHotDeployListener:344] Registering portlets for web-form-portlet
07:26:34,576 INFO  [localhost-startStop-1][PortletHotDeployListener:492] 1 portlet for web-form-portlet is available for use
07:44:06,760 INFO  [localhost-startStop-2][HotDeployEvent:145] Plugin web-form-portlet requires marketplace-portlet
07:44:06,767 INFO  [localhost-startStop-2][PortletHotDeployListener:525] Unregistering portlets for web-form-portlet
07:44:06,776 INFO  [localhost-startStop-2][PortletHotDeployListener:560] 1 portlet for web-form-portlet was unregistered
07:44:06,787 INFO  [localhost-startStop-2][PluginPackageUtil:1016] Reading plugin package for web-form-portlet
07:44:06,811 INFO  [localhost-startStop-2][HotDeployEvent:145] Plugin sync-web requires marketplace-portlet
07:44:06,813 INFO  [localhost-startStop-2][HookHotDeployListener:988] Hook for sync-web was unregistered
07:44:06,826 INFO  [localhost-startStop-2][PluginPackageUtil:1016] Reading plugin package for sync-web
07:44:06,832 INFO  [localhost-startStop-2][HotDeployEvent:145] Plugin sync-admin-portlet requires marketplace-portlet, sync-web
07:44:06,838 INFO  [localhost-startStop-2][PortletHotDeployListener:525] Unregistering portlets for sync-admin-portlet
07:44:06,847 INFO  [localhost-startStop-2][PortletHotDeployListener:565] 2 portlets for sync-admin-portlet were unregistered
07:44:06,911 INFO  [localhost-startStop-2][HookHotDeployListener:988] Hook for sync-admin-portlet was unregistered
07:44:06,914 INFO  [localhost-startStop-2][PluginPackageUtil:1016] Reading plugin package for sync-admin-portlet
07:44:06,922 INFO  [localhost-startStop-2][HotDeployEvent:145] Plugin resources-importer-web requires marketplace-portlet
07:44:06,930 INFO  [localhost-startStop-2][HookHotDeployListener:988] Hook for resources-importer-web was unregistered
07:44:06,945 INFO  [localhost-startStop-2][PluginPackageUtil:1016] Reading plugin package for resources-importer-web
07:44:06,967 INFO  [localhost-startStop-2][HotDeployEvent:145] Plugin opensocial-portlet requires marketplace-portlet
07:44:06,968 INFO  [localhost-startStop-2][PortletHotDeployListener:525] Unregistering portlets for opensocial-portlet
07:44:06,972 INFO  [localhost-startStop-2][PortletHotDeployListener:565] 4 portlets for opensocial-portlet were unregistered
07:44:07,012 INFO  [localhost-startStop-2][HookHotDeployListener:988] Hook for opensocial-portlet was unregistered
07:44:07,017 INFO  [localhost-startStop-2][PluginPackageUtil:1016] Reading plugin package for opensocial-portlet
07:44:07,027 INFO  [localhost-startStop-2][HotDeployEvent:145] Plugin oauth-portlet requires marketplace-portlet
07:44:07,035 INFO  [localhost-startStop-2][PortletHotDeployListener:525] Unregistering portlets for oauth-portlet
07:44:07,046 INFO  [localhost-startStop-2][PortletHotDeployListener:565] 3 portlets for oauth-portlet were unregistered
07:44:07,051 INFO  [localhost-startStop-2][HookHotDeployListener:988] Hook for oauth-portlet was unregistered
07:44:07,062 INFO  [localhost-startStop-2][PluginPackageUtil:1016] Reading plugin package for oauth-portlet
07:44:07,074 INFO  [localhost-startStop-2][HotDeployEvent:145] Plugin notifications-portlet requires marketplace-portlet
07:44:07,079 INFO  [localhost-startStop-2][PortletHotDeployListener:525] Unregistering portlets for notifications-portlet
07:44:07,088 INFO  [localhost-startStop-2][PortletHotDeployListener:565] 2 portlets for notifications-portlet were unregistered
07:44:07,148 INFO  [localhost-startStop-2][HookHotDeployListener:988] Hook for notifications-portlet was unregistered
07:44:07,152 INFO  [localhost-startStop-2][PluginPackageUtil:1016] Reading plugin package for notifications-portlet
07:44:07,158 INFO  [localhost-startStop-2][PortletHotDeployListener:525] Unregistering portlets for marketplace-portlet
07:44:07,166 INFO  [localhost-startStop-2][PortletHotDeployListener:565] 3 portlets for marketplace-portlet were unregistered
07:44:07,171 INFO  [localhost-startStop-2][HookHotDeployListener:988] Hook for marketplace-portlet was unregistered
07:44:07,189 INFO  [localhost-startStop-2][PluginPackageUtil:1016] Reading plugin package for marketplace-portlet
07:44:07,207 INFO  [localhost-startStop-2][HotDeployEvent:145] Plugin kaleo-web requires marketplace-portlet
07:44:07,213 INFO  [localhost-startStop-2][HookHotDeployListener:988] Hook for kaleo-web was unregistered
07:44:07,238 INFO  [localhost-startStop-2][PluginPackageUtil:1016] Reading plugin package for kaleo-web
07:44:07,276 INFO  [localhost-startStop-2][HotDeployEvent:145] Plugin kaleo-forms-portlet requires kaleo-designer-portlet, kaleo-web, marketplace-portlet
07:44:07,293 INFO  [localhost-startStop-2][PortletHotDeployListener:525] Unregistering portlets for kaleo-forms-portlet
07:44:07,297 INFO  [localhost-startStop-2][PortletHotDeployListener:565] 2 portlets for kaleo-forms-portlet were unregistered
07:44:07,354 INFO  [localhost-startStop-2][HookHotDeployListener:988] Hook for kaleo-forms-portlet was unregistered
07:44:07,359 INFO  [localhost-startStop-2][PluginPackageUtil:1016] Reading plugin package for kaleo-forms-portlet
07:44:07,368 INFO  [localhost-startStop-2][HotDeployEvent:145] Plugin kaleo-designer-portlet requires kaleo-web, marketplace-portlet
07:44:07,373 INFO  [localhost-startStop-2][PortletHotDeployListener:525] Unregistering portlets for kaleo-designer-portlet
07:44:07,376 INFO  [localhost-startStop-2][PortletHotDeployListener:565] 2 portlets for kaleo-designer-portlet were unregistered
07:44:07,433 INFO  [localhost-startStop-2][HookHotDeployListener:988] Hook for kaleo-designer-portlet was unregistered
07:44:07,436 INFO  [localhost-startStop-2][PluginPackageUtil:1016] Reading plugin package for kaleo-designer-portlet
07:44:07,454 INFO  [localhost-startStop-2][HotDeployEvent:145] Plugin calendar-portlet requires marketplace-portlet
07:44:07,455 INFO  [localhost-startStop-2][SocialHotDeployListener:159] Social for calendar-portlet was unregistered
07:44:07,457 INFO  [localhost-startStop-2][PortletHotDeployListener:525] Unregistering portlets for calendar-portlet
07:44:07,465 INFO  [localhost-startStop-2][PortletHotDeployListener:560] 1 portlet for calendar-portlet was unregistered
07:44:07,467 INFO  [localhost-startStop-2][HookHotDeployListener:988] Hook for calendar-portlet was unregistered
07:44:07,481 INFO  [localhost-startStop-2][PluginPackageUtil:1016] Reading plugin package for calendar-portlet
07:52:38,891 INFO  [localhost-startStop-1][DialectDetector:71] Determine dialect for DB2/NT64 10
07:52:38,916 INFO  [localhost-startStop-1][DialectDetector:136] Found dialect com.liferay.portal.dao.orm.hibernate.DB2Dialect
07:52:55,491 INFO  [localhost-startStop-1][StartupAction:103] The following patches are installed: portal-128-6210
07:52:55,574 ERROR [localhost-startStop-1][JDBCExceptionReporter:82] DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=ADMINISTRATOR.LOCK_, DRIVER=4.13.127
07:52:55,579 ERROR [localhost-startStop-1][JDBCExceptionReporter:82] DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098, SQLERRMC=2;-204;42704;ADMINISTRATOR.LOCK_, DRIVER=4.13.127
07:52:55,583 WARN  [localhost-startStop-1][StartupAction:150] Unable to clear locks because Lock table does not exist
07:52:55,874 WARN  [localhost-startStop-1][ReleaseLocalServiceImpl:171] DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=ADMINISTRATOR.RELEASE_, DRIVER=4.13.127
07:52:55,877 INFO  [localhost-startStop-1][ReleaseLocalServiceImpl:84] Create tables and populate with default data
07:53:16,383 INFO  [localhost-startStop-1][BaseDB:486] Database supports case sensitive queries
07:53:17,064 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyProcessSuite
07:53:17,066 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyProperties
07:53:17,096 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyDB2
07:53:17,466 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyMySQL
07:53:17,467 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyOracle
07:53:17,468 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyPostgreSQL
07:53:17,474 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifySQLServer
07:53:17,482 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyUUID
07:53:17,572 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyPermission
07:53:19,304 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyGroup
07:53:19,355 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyRole
07:53:19,357 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyAsset
07:53:19,364 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.portal.upgrade.util.UpgradeAssetPublisherManualEntries
07:53:19,377 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyAuditedModel
07:53:19,429 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyBlogs
07:53:19,449 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyBookmarks
07:53:19,465 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyCalendar
07:53:19,488 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyDocumentLibrary
07:53:19,653 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyDynamicDataMapping
07:53:19,699 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyGroupId
07:53:19,725 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyJournal
07:53:19,795 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyLayout
07:53:19,824 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyMessageBoards
07:53:19,847 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyOrganization
07:53:19,864 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyPortalPreferences
07:53:19,873 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyPortletPreferences
07:53:19,915 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyRegion
07:53:19,921 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyResourcePermissions
07:53:19,924 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyUser
07:53:19,955 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyWiki
07:53:19,973 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyWorkflow
07:53:21,532 INFO  [localhost-startStop-1][LicenseManager:?] Failed to find directory D:\release-bundle\liferay-portal-6.2-ee-sp17\data\license
07:53:21,532 ERROR [localhost-startStop-1][LicenseManager:?] No binary licenses found
07:53:21,542 INFO  [localhost-startStop-1][ServerDetector:140] Server supports hot deploy
07:53:21,560 INFO  [localhost-startStop-1][PluginPackageUtil:1013] Reading plugin package for the root context
07:53:24,409 INFO  [localhost-startStop-1][AutoDeployDir:139] Auto deploy scanner started for D:\release-bundle\liferay-portal-6.2-ee-sp17\deploy
07:53:37,854 INFO  [localhost-startStop-1][HotDeployEvent:145] Plugin calendar-portlet requires marketplace-portlet
07:53:37,893 INFO  [localhost-startStop-1][HotDeployImpl:278] Queueing calendar-portlet for deploy because it is missing marketplace-portlet
07:53:38,770 INFO  [localhost-startStop-1][HotDeployEvent:145] Plugin kaleo-designer-portlet requires kaleo-web, marketplace-portlet
07:53:38,771 INFO  [localhost-startStop-1][HotDeployImpl:278] Queueing kaleo-designer-portlet for deploy because it is missing kaleo-web, marketplace-portlet
07:53:39,517 INFO  [localhost-startStop-1][HotDeployEvent:145] Plugin kaleo-forms-portlet requires kaleo-designer-portlet, kaleo-web, marketplace-portlet
07:53:39,521 INFO  [localhost-startStop-1][HotDeployImpl:278] Queueing kaleo-forms-portlet for deploy because it is missing kaleo-designer-portlet, kaleo-web, marketplace-portlet
07:53:40,332 INFO  [localhost-startStop-1][HotDeployEvent:145] Plugin kaleo-web requires marketplace-portlet
07:53:40,335 INFO  [localhost-startStop-1][HotDeployImpl:278] Queueing kaleo-web for deploy because it is missing marketplace-portlet
07:53:41,090 INFO  [localhost-startStop-1][HotDeployImpl:217] Deploying marketplace-portlet from queue
07:53:41,095 INFO  [localhost-startStop-1][PluginPackageUtil:1016] Reading plugin package for marketplace-portlet
07:53:41,211 INFO  [localhost-startStop-1][ServiceComponentLocalServiceImpl:323] Running Marketplace SQL scripts
07:53:41,857 INFO  [localhost-startStop-1][HookHotDeployListener:715] Registering hook for marketplace-portlet
07:53:41,907 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.marketplace.hook.upgrade.UpgradeProcess_1_0_0
07:53:41,908 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.marketplace.hook.upgrade.v1_0_0.UpgradeExpando
07:53:41,915 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.marketplace.hook.upgrade.UpgradeProcess_1_0_1
07:53:41,917 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.marketplace.hook.upgrade.v1_0_1.UpgradeModule
07:53:42,020 INFO  [localhost-startStop-1][HookHotDeployListener:857] Hook for marketplace-portlet is available for use
07:53:42,024 INFO  [localhost-startStop-1][PortletHotDeployListener:344] Registering portlets for marketplace-portlet
07:53:42,195 INFO  [localhost-startStop-1][PortletHotDeployListener:497] 3 portlets for marketplace-portlet are available for use
07:53:42,198 INFO  [localhost-startStop-1][HotDeployImpl:217] Deploying calendar-portlet from queue
07:53:42,199 INFO  [localhost-startStop-1][PluginPackageUtil:1016] Reading plugin package for calendar-portlet
07:53:42,345 INFO  [localhost-startStop-1][ServiceComponentLocalServiceImpl:323] Running Calendar SQL scripts
07:53:43,587 INFO  [localhost-startStop-1][HookHotDeployListener:715] Registering hook for calendar-portlet
07:53:43,603 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.calendar.hook.upgrade.UpgradeProcess_1_0_2
07:53:43,606 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.calendar.hook.upgrade.v1_0_2.UpgradeCalendarResource
07:53:43,655 ERROR [localhost-startStop-1][HotDeployImpl:233] com.liferay.portal.kernel.deploy.hot.HotDeployException: Error registering hook for calendar-portletcalendar-portlet
com.liferay.portal.kernel.deploy.hot.HotDeployException: Error registering hook for calendar-portletcalendar-portlet
	at com.liferay.portal.kernel.deploy.hot.BaseHotDeployListener.throwHotDeployException(BaseHotDeployListener.java:46)
	at com.liferay.portal.deploy.hot.HookHotDeployListener.invokeDeploy(HookHotDeployListener.java:323)
	at com.liferay.portal.deploy.hot.HotDeployImpl.doFireDeployEvent(HotDeployImpl.java:230)
	at com.liferay.portal.deploy.hot.HotDeployImpl.doFireDeployEvent(HotDeployImpl.java:257)
	at com.liferay.portal.deploy.hot.HotDeployImpl.fireDeployEvent(HotDeployImpl.java:96)
	at com.liferay.portal.kernel.deploy.hot.HotDeployUtil.fireDeployEvent(HotDeployUtil.java:28)
	at com.liferay.portal.kernel.servlet.PluginContextListener.fireDeployEvent(PluginContextListener.java:164)
	at com.liferay.portal.kernel.servlet.PluginContextListener.doPortalInit(PluginContextListener.java:154)
	at com.liferay.portal.kernel.util.BasePortalLifecycle.portalInit(BasePortalLifecycle.java:44)
	at com.liferay.portal.kernel.util.PortalLifecycleUtil.register(PortalLifecycleUtil.java:74)
	at com.liferay.portal.kernel.util.PortalLifecycleUtil.register(PortalLifecycleUtil.java:58)
	at com.liferay.portal.kernel.util.BasePortalLifecycle.registerPortalLifecycle(BasePortalLifecycle.java:54)
	at com.liferay.portal.kernel.servlet.PluginContextListener.contextInitialized(PluginContextListener.java:116)
	at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5528)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652)
	at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1263)
	at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1948)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:745)
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=CalendarResource;lendarResource where;ON, DRIVER=4.13.127
	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:170)
	at com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:167)
	at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:115)
	at com.liferay.portal.deploy.hot.HookHotDeployListener.updateRelease(HookHotDeployListener.java:2918)
	at com.liferay.portal.deploy.hot.HookHotDeployListener.initPortalProperties(HookHotDeployListener.java:2300)
	at com.liferay.portal.deploy.hot.HookHotDeployListener.initPortalProperties(HookHotDeployListener.java:1789)
	at com.liferay.portal.deploy.hot.HookHotDeployListener.doInvokeDeploy(HookHotDeployListener.java:726)
	at com.liferay.portal.deploy.hot.HookHotDeployListener.invokeDeploy(HookHotDeployListener.java:320)
	... 24 more
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=CalendarResource;lendarResource where;ON, DRIVER=4.13.127
	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:170)
	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:184)
	at com.liferay.calendar.hook.upgrade.UpgradeProcess_1_0_2.doUpgrade(UpgradeProcess_1_0_2.java:33)
	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:167)
	... 31 more
Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=CalendarResource;lendarResource where;ON, DRIVER=4.13.127
	at com.ibm.db2.jcc.am.id.a(id.java:677)
	at com.ibm.db2.jcc.am.id.a(id.java:60)
	at com.ibm.db2.jcc.am.id.a(id.java:127)
	at com.ibm.db2.jcc.am.no.c(no.java:2653)
	at com.ibm.db2.jcc.am.no.d(no.java:2641)
	at com.ibm.db2.jcc.am.no.a(no.java:2090)
	at com.ibm.db2.jcc.am.oo.a(oo.java:7671)
	at com.ibm.db2.jcc.t4.cb.h(cb.java:141)
	at com.ibm.db2.jcc.t4.cb.b(cb.java:41)
	at com.ibm.db2.jcc.t4.q.a(q.java:32)
	at com.ibm.db2.jcc.t4.sb.i(sb.java:135)
	at com.ibm.db2.jcc.am.no.ib(no.java:2059)
	at com.ibm.db2.jcc.am.oo.sc(oo.java:3559)
	at com.ibm.db2.jcc.am.oo.yc(oo.java:3691)
	at com.ibm.db2.jcc.am.oo.a(oo.java:598)
	at com.ibm.db2.jcc.am.kb.a(kb.java:2326)
	at com.ibm.db2.jcc.am.kb.a(kb.java:2284)
	at com.ibm.db2.jcc.am.kb.prepareStatement(kb.java:866)
	at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:469)
	at sun.reflect.GeneratedMethodAccessor64.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy$LazyConnectionInvocationHandler.invoke(LazyConnectionDataSourceProxy.java:376)
	at com.sun.proxy.$Proxy5.prepareStatement(Unknown Source)
	at com.liferay.portal.kernel.upgrade.dao.orm.UpgradeOptimizedConnectionHandler.prepareStatement(UpgradeOptimizedConnectionHandler.java:79)
	at com.liferay.portal.kernel.upgrade.dao.orm.UpgradeOptimizedConnectionHandler.invoke(UpgradeOptimizedConnectionHandler.java:59)
	at com.sun.proxy.$Proxy433.prepareStatement(Unknown Source)
	at com.liferay.calendar.hook.upgrade.v1_0_2.UpgradeCalendarResource.updateCalendarUserIds(UpgradeCalendarResource.java:89)
	at com.liferay.calendar.hook.upgrade.v1_0_2.UpgradeCalendarResource.upgradeCalendarResourceUserIds(UpgradeCalendarResource.java:147)
	at com.liferay.calendar.hook.upgrade.v1_0_2.UpgradeCalendarResource.doUpgrade(UpgradeCalendarResource.java:42)
	at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:167)
	... 34 more
07:53:44,074 INFO  [localhost-startStop-1][PortletHotDeployListener:344] Registering portlets for calendar-portlet
07:53:44,460 INFO  [localhost-startStop-1][PortletHotDeployListener:492] 1 portlet for calendar-portlet is available for use
07:53:44,461 INFO  [localhost-startStop-1][SocialHotDeployListener:94] Registering social for calendar-portlet
07:53:44,465 INFO  [localhost-startStop-1][SocialHotDeployListener:103] Social for calendar-portlet is available for use
07:53:44,467 INFO  [localhost-startStop-1][HotDeployImpl:296] kaleo-designer-portlet is still in queue because it is missing kaleo-web
07:53:44,471 INFO  [localhost-startStop-1][HotDeployImpl:296] kaleo-designer-portlet is still in queue because it is missing kaleo-designer-portlet, kaleo-web
07:53:44,474 INFO  [localhost-startStop-1][HotDeployImpl:296] kaleo-designer-portlet is still in queue because it is missing 
07:53:44,487 INFO  [localhost-startStop-1][HotDeployImpl:296] kaleo-forms-portlet is still in queue because it is missing kaleo-web
07:53:44,488 INFO  [localhost-startStop-1][HotDeployImpl:296] kaleo-forms-portlet is still in queue because it is missing kaleo-designer-portlet, kaleo-web
07:53:44,494 INFO  [localhost-startStop-1][HotDeployImpl:296] kaleo-forms-portlet is still in queue because it is missing 
07:53:44,497 INFO  [localhost-startStop-1][HotDeployImpl:217] Deploying kaleo-web from queue
07:53:44,504 INFO  [localhost-startStop-1][PluginPackageUtil:1016] Reading plugin package for kaleo-web
07:53:44,613 INFO  [localhost-startStop-1][ServiceComponentLocalServiceImpl:323] Running Kaleo SQL scripts
07:53:48,594 INFO  [localhost-startStop-1][HookHotDeployListener:715] Registering hook for kaleo-web
07:53:48,609 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.portal.workflow.kaleo.hook.upgrade.UpgradeProcess_1_0_0
07:53:48,611 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.portal.workflow.kaleo.hook.upgrade.v1_0_0.UpgradeKaleoTaskInstanceToken
07:53:48,625 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.portal.workflow.kaleo.hook.upgrade.UpgradeProcess_1_1_0
07:53:48,628 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.portal.workflow.kaleo.hook.upgrade.v1_1_0.UpgradeWorkflowContext
07:53:48,696 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.portal.workflow.kaleo.hook.upgrade.UpgradeProcess_1_2_0
07:53:48,697 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.portal.workflow.kaleo.hook.upgrade.v1_2_0.UpgradeKaleoLog
07:53:48,723 INFO  [localhost-startStop-1][Table:156] Starting backup of KaleoLog to D:\release-bundle\liferay-portal-6.2-ee-sp17\tomcat-7.0.62\temp/temp-db-KaleoLog-1482306828723
07:53:48,732 INFO  [localhost-startStop-1][Table:190] Finished backup of KaleoLog to D:\release-bundle\liferay-portal-6.2-ee-sp17\tomcat-7.0.62\temp/temp-db-KaleoLog-1482306828723 in 9 ms
07:53:48,895 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.portal.workflow.kaleo.hook.upgrade.v1_2_0.UpgradeKaleoNotificationRecipient
07:53:48,927 INFO  [localhost-startStop-1][HookHotDeployListener:857] Hook for kaleo-web is available for use
07:53:48,931 INFO  [localhost-startStop-1][HotDeployImpl:217] Deploying kaleo-designer-portlet from queue
07:53:48,935 INFO  [localhost-startStop-1][PluginPackageUtil:1016] Reading plugin package for kaleo-designer-portlet
07:53:49,038 INFO  [localhost-startStop-1][ServiceComponentLocalServiceImpl:323] Running KaleoDesigner SQL scripts
07:53:49,594 INFO  [localhost-startStop-1][HookHotDeployListener:715] Registering hook for kaleo-designer-portlet
07:53:50,020 INFO  [localhost-startStop-1][HookHotDeployListener:857] Hook for kaleo-designer-portlet is available for use
07:53:50,024 INFO  [localhost-startStop-1][PortletHotDeployListener:344] Registering portlets for kaleo-designer-portlet
07:53:50,111 INFO  [localhost-startStop-1][PortletHotDeployListener:497] 2 portlets for kaleo-designer-portlet are available for use
07:53:50,112 INFO  [localhost-startStop-1][HotDeployImpl:217] Deploying kaleo-forms-portlet from queue
07:53:50,114 INFO  [localhost-startStop-1][PluginPackageUtil:1016] Reading plugin package for kaleo-forms-portlet
07:53:50,206 INFO  [localhost-startStop-1][ServiceComponentLocalServiceImpl:323] Running KaleoForms SQL scripts
07:53:50,629 INFO  [localhost-startStop-1][HookHotDeployListener:715] Registering hook for kaleo-forms-portlet
07:53:50,644 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.portal.workflow.kaleo.forms.hook.upgrade.UpgradeProcess_1_0_0
07:53:50,651 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.portal.workflow.kaleo.forms.hook.upgrade.v1_0_0.UpgradeKaleoProcess
07:53:50,711 INFO  [localhost-startStop-1][HookHotDeployListener:857] Hook for kaleo-forms-portlet is available for use
07:53:50,715 INFO  [localhost-startStop-1][PortletHotDeployListener:344] Registering portlets for kaleo-forms-portlet
07:53:50,844 INFO  [localhost-startStop-1][PortletHotDeployListener:497] 2 portlets for kaleo-forms-portlet are available for use
07:53:52,170 INFO  [localhost-startStop-1][HotDeployEvent:145] Plugin notifications-portlet requires marketplace-portlet
07:53:52,174 INFO  [localhost-startStop-1][HotDeployImpl:217] Deploying notifications-portlet from queue
07:53:52,183 INFO  [localhost-startStop-1][PluginPackageUtil:1016] Reading plugin package for notifications-portlet
07:53:52,263 INFO  [localhost-startStop-1][ServiceComponentLocalServiceImpl:323] Running Ntfctns SQL scripts
07:53:52,600 INFO  [localhost-startStop-1][HookHotDeployListener:715] Registering hook for notifications-portlet
07:53:52,616 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.notifications.hook.upgrade.UpgradeProcess_1_0_0
07:53:52,619 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.notifications.hook.upgrade.v1_0_0.UpgradeUserNotificationEvent
07:53:52,638 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.notifications.hook.upgrade.UpgradeProcess_1_1_0
07:53:52,641 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.notifications.hook.upgrade.v1_1_0.UpgradeUserNotificationEvent
07:53:52,651 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.notifications.hook.upgrade.UpgradeProcess_1_2_0
07:53:52,654 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.notifications.hook.upgrade.v1_2_0.UpgradeUserNotificationEvent
07:53:52,700 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.notifications.hook.upgrade.UpgradeProcess_1_3_0
07:53:52,702 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.notifications.hook.upgrade.v1_3_0.UpgradeUserNotificationEvent
07:53:52,891 INFO  [localhost-startStop-1][HookHotDeployListener:857] Hook for notifications-portlet is available for use
07:53:52,893 INFO  [localhost-startStop-1][PortletHotDeployListener:344] Registering portlets for notifications-portlet
07:53:53,033 INFO  [localhost-startStop-1][PortletHotDeployListener:497] 2 portlets for notifications-portlet are available for use
07:53:54,654 INFO  [localhost-startStop-1][HotDeployEvent:145] Plugin oauth-portlet requires marketplace-portlet
07:53:54,657 INFO  [localhost-startStop-1][HotDeployImpl:217] Deploying oauth-portlet from queue
07:53:54,660 INFO  [localhost-startStop-1][PluginPackageUtil:1016] Reading plugin package for oauth-portlet
07:53:54,772 INFO  [localhost-startStop-1][ServiceComponentLocalServiceImpl:323] Running OAuth SQL scripts
07:53:55,263 INFO  [localhost-startStop-1][HookHotDeployListener:715] Registering hook for oauth-portlet
07:53:55,365 INFO  [localhost-startStop-1][HookHotDeployListener:857] Hook for oauth-portlet is available for use
07:53:55,368 INFO  [localhost-startStop-1][PortletHotDeployListener:344] Registering portlets for oauth-portlet
07:53:55,580 INFO  [localhost-startStop-1][PortletHotDeployListener:497] 3 portlets for oauth-portlet are available for use
07:53:57,198 INFO  [localhost-startStop-1][HotDeployEvent:145] Plugin opensocial-portlet requires marketplace-portlet
07:53:57,199 INFO  [localhost-startStop-1][HotDeployImpl:217] Deploying opensocial-portlet from queue
07:53:57,199 INFO  [localhost-startStop-1][PluginPackageUtil:1016] Reading plugin package for opensocial-portlet
07:53:57,267 INFO  [localhost-startStop-1][ServiceComponentLocalServiceImpl:323] Running OpenSocial SQL scripts
07:53:58,203 INFO  [localhost-startStop-1][HookHotDeployListener:715] Registering hook for opensocial-portlet
07:53:58,234 INFO  [localhost-startStop-1][HookHotDeployListener:857] Hook for opensocial-portlet is available for use
07:53:58,236 INFO  [localhost-startStop-1][PortletHotDeployListener:344] Registering portlets for opensocial-portlet
07:53:58,443 INFO  [localhost-startStop-1][PortletHotDeployListener:497] 4 portlets for opensocial-portlet are available for use
07:53:59,779 INFO  [localhost-startStop-1][HotDeployEvent:145] Plugin resources-importer-web requires marketplace-portlet
07:53:59,779 INFO  [localhost-startStop-1][HotDeployImpl:217] Deploying resources-importer-web from queue
07:53:59,780 INFO  [localhost-startStop-1][PluginPackageUtil:1016] Reading plugin package for resources-importer-web
07:53:59,917 INFO  [localhost-startStop-1][HookHotDeployListener:715] Registering hook for resources-importer-web
07:53:59,921 INFO  [localhost-startStop-1][HookHotDeployListener:857] Hook for resources-importer-web is available for use
07:54:00,828 INFO  [localhost-startStop-1][HotDeployEvent:145] Plugin sync-admin-portlet requires marketplace-portlet, sync-web
07:54:00,828 INFO  [localhost-startStop-1][HotDeployImpl:278] Queueing sync-admin-portlet for deploy because it is missing sync-web
07:54:02,155 INFO  [localhost-startStop-1][HotDeployEvent:145] Plugin sync-web requires marketplace-portlet
07:54:02,155 INFO  [localhost-startStop-1][HotDeployImpl:217] Deploying sync-web from queue
07:54:02,155 INFO  [localhost-startStop-1][PluginPackageUtil:1016] Reading plugin package for sync-web
07:54:02,232 INFO  [localhost-startStop-1][ServiceComponentLocalServiceImpl:323] Running Sync SQL scripts
07:54:03,392 INFO  [localhost-startStop-1][HookHotDeployListener:715] Registering hook for sync-web
07:54:03,402 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.sync.hook.upgrade.v1_0_0.UpgradeIndex
07:54:03,411 INFO  [localhost-startStop-1][UpgradeProcess:164] Upgrading com.liferay.sync.hook.upgrade.v1_0_2.UpgradeIndex
07:54:03,455 ERROR [localhost-startStop-1][HotDeployImpl:233] com.liferay.portal.kernel.deploy.hot.HotDeployException: Error registering hook for sync-websync-web
com.liferay.portal.kernel.deploy.hot.HotDeployException: Error registering hook for sync-websync-web
	at com.liferay.portal.kernel.deploy.hot.BaseHotDeployListener.throwHotDeployException(BaseHotDeployListener.java:46)
	at com.liferay.portal.deploy.hot.HookHotDeployListener.invokeDeploy(HookHotDeployListener.java:323)
	at com.liferay.portal.deploy.hot.HotDeployImpl.doFireDeployEvent(HotDeployImpl.java:230)
	at com.liferay.portal.deploy.hot.HotDeployImpl.fireDeployEvent(HotDeployImpl.java:96)
	at com.liferay.portal.kernel.deploy.hot.HotDeployUtil.fireDeployEvent(HotDeployUtil.java:28)
	at com.liferay.portal.kernel.servlet.PluginContextListener.fireDeployEvent(PluginContextListener.java:186)
	at com.liferay.portal.kernel.servlet.PluginContextListener.doPortalInit(PluginContextListener.java:170)
	at com.liferay.portal.kernel.util.BasePortalLifecycle.portalInit(BasePortalLifecycle.java:44)
	at com.liferay.portal.kernel.util.PortalLifecycleUtil.register(PortalLifecycleUtil.java:74)
	at com.liferay.portal.kernel.util.PortalLifecycleUtil.register(PortalLifecycleUtil.java:58)
	at com.liferay.portal.kernel.util.BasePortalLifecycle.registerPortalLifecycle(BasePortalLifecycle.java:54)
	at com.liferay.portal.kernel.servlet.PluginContextListener.contextInitialized(PluginContextListener.java:120)
	at com.liferay.portal.kernel.servlet.SecurePluginContextListener.contextInitialized(SecurePluginContextListener.java:151)
	at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5528)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652)
	at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1263)
	at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1948)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:745)
Caused by: com.liferay.portal.kernel.events.ActionException: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=END-OF-STATEMENT;e table SYNCDLOBJECT;IMMEDIATE, DRIVER=4.13.127
	at com.liferay.sync.hook.events.StartupAction.run(StartupAction.java:33)
	at com.liferay.portal.kernel.events.InvokerSimpleAction.run(InvokerSimpleAction.java:42)
	at com.liferay.portal.deploy.hot.HookHotDeployListener.initEvent(HookHotDeployListener.java:1400)
	at com.liferay.portal.deploy.hot.HookHotDeployListener.initEvents(HookHotDeployListener.java:1463)
	at com.liferay.portal.deploy.hot.HookHotDeployListener.initPortalProperties(HookHotDeployListener.java:1806)
	at com.liferay.portal.deploy.hot.HookHotDeployListener.doInvokeDeploy(HookHotDeployListener.java:726)
	at com.liferay.portal.deploy.hot.HookHotDeployListener.invokeDeploy(HookHotDeployListener.java:320)
	... 24 more
Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=END-OF-STATEMENT;e table SYNCDLOBJECT;IMMEDIATE, DRIVER=4.13.127
	at com.ibm.db2.jcc.am.id.a(id.java:677)
	at com.ibm.db2.jcc.am.id.a(id.java:60)
	at com.ibm.db2.jcc.am.id.a(id.java:127)
	at com.ibm.db2.jcc.am.no.b(no.java:2310)
	at com.ibm.db2.jcc.am.no.c(no.java:2293)
	at com.ibm.db2.jcc.t4.cb.l(cb.java:370)
	at com.ibm.db2.jcc.t4.cb.a(cb.java:62)
	at com.ibm.db2.jcc.t4.q.a(q.java:50)
	at com.ibm.db2.jcc.t4.tb.b(tb.java:220)
	at com.ibm.db2.jcc.am.oo.oc(oo.java:3428)
	at com.ibm.db2.jcc.am.oo.b(oo.java:4383)
	at com.ibm.db2.jcc.am.oo.gc(oo.java:784)
	at com.ibm.db2.jcc.am.oo.executeUpdate(oo.java:763)
	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:1449)
	at com.liferay.sync.util.VerifyUtil.doVerify(VerifyUtil.java:67)
	at com.liferay.sync.util.VerifyUtil.verify(VerifyUtil.java:55)
	at com.liferay.sync.hook.events.StartupAction.doRun(StartupAction.java:44)
	at com.liferay.sync.hook.events.StartupAction.run(StartupAction.java:30)
	... 30 more
07:54:03,703 INFO  [localhost-startStop-1][HotDeployImpl:217] Deploying sync-admin-portlet from queue
07:54:03,705 INFO  [localhost-startStop-1][PluginPackageUtil:1016] Reading plugin package for sync-admin-portlet
07:54:03,903 INFO  [localhost-startStop-1][HookHotDeployListener:715] Registering hook for sync-admin-portlet
07:54:03,976 INFO  [localhost-startStop-1][HookHotDeployListener:857] Hook for sync-admin-portlet is available for use
07:54:03,977 INFO  [localhost-startStop-1][PortletHotDeployListener:344] Registering portlets for sync-admin-portlet
07:54:04,105 INFO  [localhost-startStop-1][PortletHotDeployListener:497] 2 portlets for sync-admin-portlet are available for use
07:54:05,129 INFO  [localhost-startStop-1][HotDeployEvent:145] Plugin web-form-portlet requires marketplace-portlet
07:54:05,224 INFO  [localhost-startStop-1][HotDeployImpl:217] Deploying web-form-portlet from queue
07:54:05,233 INFO  [localhost-startStop-1][PluginPackageUtil:1016] Reading plugin package for web-form-portlet
07:54:05,421 INFO  [localhost-startStop-1][PortletHotDeployListener:344] Registering portlets for web-form-portlet
07:54:05,546 INFO  [localhost-startStop-1][PortletHotDeployListener:492] 1 portlet for web-form-portlet is available for use
08:06:41,689 INFO  [localhost-startStop-2][HotDeployEvent:145] Plugin web-form-portlet requires marketplace-portlet
08:06:41,697 INFO  [localhost-startStop-2][PortletHotDeployListener:525] Unregistering portlets for web-form-portlet
08:06:41,706 INFO  [localhost-startStop-2][PortletHotDeployListener:560] 1 portlet for web-form-portlet was unregistered
08:06:41,717 INFO  [localhost-startStop-2][PluginPackageUtil:1016] Reading plugin package for web-form-portlet
08:06:41,752 INFO  [localhost-startStop-2][HotDeployEvent:145] Plugin sync-web requires marketplace-portlet
08:06:41,755 INFO  [localhost-startStop-2][HookHotDeployListener:988] Hook for sync-web was unregistered
08:06:41,774 INFO  [localhost-startStop-2][PluginPackageUtil:1016] Reading plugin package for sync-web
08:06:41,783 INFO  [localhost-startStop-2][HotDeployEvent:145] Plugin sync-admin-portlet requires marketplace-portlet, sync-web
08:06:41,785 INFO  [localhost-startStop-2][PortletHotDeployListener:525] Unregistering portlets for sync-admin-portlet
08:06:41,801 INFO  [localhost-startStop-2][PortletHotDeployListener:565] 2 portlets for sync-admin-portlet were unregistered
08:06:41,865 INFO  [localhost-startStop-2][HookHotDeployListener:988] Hook for sync-admin-portlet was unregistered
08:06:41,868 INFO  [localhost-startStop-2][PluginPackageUtil:1016] Reading plugin package for sync-admin-portlet
08:06:41,873 INFO  [localhost-startStop-2][HotDeployEvent:145] Plugin resources-importer-web requires marketplace-portlet
08:06:41,875 INFO  [localhost-startStop-2][HookHotDeployListener:988] Hook for resources-importer-web was unregistered
08:06:41,895 INFO  [localhost-startStop-2][PluginPackageUtil:1016] Reading plugin package for resources-importer-web
08:06:41,926 INFO  [localhost-startStop-2][HotDeployEvent:145] Plugin opensocial-portlet requires marketplace-portlet
08:06:41,927 INFO  [localhost-startStop-2][PortletHotDeployListener:525] Unregistering portlets for opensocial-portlet
08:06:41,935 INFO  [localhost-startStop-2][PortletHotDeployListener:565] 4 portlets for opensocial-portlet were unregistered
08:06:41,997 INFO  [localhost-startStop-2][HookHotDeployListener:988] Hook for opensocial-portlet was unregistered
08:06:42,002 INFO  [localhost-startStop-2][PluginPackageUtil:1016] Reading plugin package for opensocial-portlet
08:06:42,012 INFO  [localhost-startStop-2][HotDeployEvent:145] Plugin oauth-portlet requires marketplace-portlet
08:06:42,016 INFO  [localhost-startStop-2][PortletHotDeployListener:525] Unregistering portlets for oauth-portlet
08:06:42,026 INFO  [localhost-startStop-2][PortletHotDeployListener:565] 3 portlets for oauth-portlet were unregistered
08:06:42,031 INFO  [localhost-startStop-2][HookHotDeployListener:988] Hook for oauth-portlet was unregistered
08:06:42,044 INFO  [localhost-startStop-2][PluginPackageUtil:1016] Reading plugin package for oauth-portlet
08:06:42,055 INFO  [localhost-startStop-2][HotDeployEvent:145] Plugin notifications-portlet requires marketplace-portlet
08:06:42,059 INFO  [localhost-startStop-2][PortletHotDeployListener:525] Unregistering portlets for notifications-portlet
08:06:42,084 INFO  [localhost-startStop-2][PortletHotDeployListener:565] 2 portlets for notifications-portlet were unregistered
08:06:42,153 INFO  [localhost-startStop-2][HookHotDeployListener:988] Hook for notifications-portlet was unregistered
08:06:42,168 INFO  [localhost-startStop-2][PluginPackageUtil:1016] Reading plugin package for notifications-portlet
08:06:42,191 INFO  [localhost-startStop-2][PortletHotDeployListener:525] Unregistering portlets for marketplace-portlet
08:06:42,206 INFO  [localhost-startStop-2][PortletHotDeployListener:565] 3 portlets for marketplace-portlet were unregistered
08:06:42,324 INFO  [localhost-startStop-2][HookHotDeployListener:988] Hook for marketplace-portlet was unregistered
08:06:42,333 INFO  [localhost-startStop-2][PluginPackageUtil:1016] Reading plugin package for marketplace-portlet
08:06:42,356 INFO  [localhost-startStop-2][HotDeployEvent:145] Plugin kaleo-web requires marketplace-portlet
08:06:42,358 INFO  [localhost-startStop-2][HookHotDeployListener:988] Hook for kaleo-web was unregistered
08:06:42,473 INFO  [localhost-startStop-2][PluginPackageUtil:1016] Reading plugin package for kaleo-web
08:06:42,548 INFO  [localhost-startStop-2][HotDeployEvent:145] Plugin kaleo-forms-portlet requires kaleo-designer-portlet, kaleo-web, marketplace-portlet
08:06:42,549 INFO  [localhost-startStop-2][PortletHotDeployListener:525] Unregistering portlets for kaleo-forms-portlet
08:06:42,553 INFO  [localhost-startStop-2][PortletHotDeployListener:565] 2 portlets for kaleo-forms-portlet were unregistered
08:06:42,620 INFO  [localhost-startStop-2][HookHotDeployListener:988] Hook for kaleo-forms-portlet was unregistered
08:06:42,626 INFO  [localhost-startStop-2][PluginPackageUtil:1016] Reading plugin package for kaleo-forms-portlet
08:06:42,794 INFO  [localhost-startStop-2][HotDeployEvent:145] Plugin kaleo-designer-portlet requires kaleo-web, marketplace-portlet
08:06:42,795 INFO  [localhost-startStop-2][PortletHotDeployListener:525] Unregistering portlets for kaleo-designer-portlet
08:06:42,799 INFO  [localhost-startStop-2][PortletHotDeployListener:565] 2 portlets for kaleo-designer-portlet were unregistered
08:06:42,854 INFO  [localhost-startStop-2][HookHotDeployListener:988] Hook for kaleo-designer-portlet was unregistered
08:06:42,907 INFO  [localhost-startStop-2][PluginPackageUtil:1016] Reading plugin package for kaleo-designer-portlet
08:06:42,946 INFO  [localhost-startStop-2][HotDeployEvent:145] Plugin calendar-portlet requires marketplace-portlet
08:06:42,947 INFO  [localhost-startStop-2][SocialHotDeployListener:159] Social for calendar-portlet was unregistered
08:06:42,948 INFO  [localhost-startStop-2][PortletHotDeployListener:525] Unregistering portlets for calendar-portlet
08:06:42,968 INFO  [localhost-startStop-2][PortletHotDeployListener:560] 1 portlet for calendar-portlet was unregistered
08:06:42,991 INFO  [localhost-startStop-2][HookHotDeployListener:988] Hook for calendar-portlet was unregistered
08:06:42,996 INFO  [localhost-startStop-2][PluginPackageUtil:1016] Reading plugin package for calendar-portlet

Attachments

Issue Links

is duplicated by

LPS-71873 When using HSQL to upgrade from 6.1 to 6.2, Calendar portlet fails to deploy and upgrade properly

Verified

Activity

People

Assignee:: SE Support

Reporter:: Felix Zhang

Participants of an Issue:: Adam Brandizzi, Felix Zhang, Leide Mangueira, SE Support

Recent user:: Leide Mangueira

Votes:: 0 Vote for this issue

Watchers:: 0 Start watching this issue

Dates

Created:: 21/Dec/16 11:18 PM

Updated:: 18/Aug/21 7:43 AM

Resolved:: 18/Aug/21 7:43 AM

Days since last comment:: 4 weeks, 3 days ago

Packages

Version	Package