Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Major
-
Resolution: No Longer Reproducible
-
Affects Version/s: 6.1.X EE, 6.2.0 CE M2
-
Fix Version/s: 6.1.X EE
-
Component/s: Infrastructure, Infrastructure > DBs, Upgrades
-
Labels:None
-
Environment:Tomcat 7.0. + Oracle 10. Portal 6.1.x EE GIT ID: 0194e5337a7371291163a76a24d98f2417adaa27.
Tomcat 7.0. + Oracle 10. Portal 6.2.x GIT ID: e8ab3317581dbeea86bd69bf8965bd898de5b282.
-
Epic/Theme:
-
Fix Priority:3
-
Similar Issues:
Description
1. Config oracle in ext.properties in 5.2.8:
permissions.user.check.algorithm=5
jdbc.default.driverClassName=oracle.jdbc.driver.OracleDriver
jdbc.default.url=jdbc:oracle:thin:@localhost:1521:xe
jdbc.default.username=lportal
jdbc.default.password=password
jdbc.default.acquireIncrement=5
jdbc.default.maxPoolSize=100
jdbc.default.minPoolSize=10
jdbc.default.numHelperThreads=10
liferay.home=d:/home
2. Add 2 Asset Publishers to a page, one as the default view, another with Title View
3. Add a Web Content so the Asset Publishers have something to display.
4. Shutdown 5.2.8
5. Config oracle in ext.properties in 6.1.x or trunk:
permissions.user.check.algorithm=5
jdbc.default.driverClassName=oracle.jdbc.driver.OracleDriver
jdbc.default.url=jdbc:oracle:thin:@localhost:1521:xe
jdbc.default.username=lportal
jdbc.default.password=password
jdbc.default.acquireIncrement=5
jdbc.default.maxPoolSize=100
jdbc.default.minPoolSize=10
jdbc.default.numHelperThreads=10
liferay.home=d:/home
6. Upgrade to 6.1.x or trunk
Console error message:
03:19:47,585 ERROR [MainServlet:205] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.verify.VerifyException: com.liferay.portal.v
erify.VerifyException: java.sql.SQLException: ORA-01735: 鏃犳晥鐨?ALTER TABLE 閫夐」
com.liferay.portal.kernel.events.ActionException: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: java.sql.SQLEx
ception: ORA-01735: 鏃犳晥鐨?ALTER TABLE 閫夐」
at com.liferay.portal.events.StartupAction.run(StartupAction.java:58)
at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1465)
at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:202)
at javax.servlet.GenericServlet.init(GenericServlet.java:160)
at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1266)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1185)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1080)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5015)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5302)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:897)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:873)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:615)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:649)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1581)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
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:662)
Caused by: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: java.sql.SQLException: ORA-01735: 鏃犳晥鐨?ALTER TABL
E 閫夐」
at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:82)
at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:117)
at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:78)
at com.liferay.portal.verify.VerifyProcessUtil.verifyProcess(VerifyProcessUtil.java:46)
at com.liferay.portal.events.StartupHelper.verifyProcess(StartupHelper.java:137)
at com.liferay.portal.events.StartupHelperUtil.verifyProcess(StartupHelperUtil.java:52)
at com.liferay.portal.tools.DBUpgrader.verify(DBUpgrader.java:210)
at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:182)
at com.liferay.portal.events.StartupAction.run(StartupAction.java:52)
... 20 more
Caused by: com.liferay.portal.verify.VerifyException: java.sql.SQLException: ORA-01735: 鏃犳晥鐨?ALTER TABLE 閫夐」
at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:82)
at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:89)
at com.liferay.portal.verify.VerifyProcessSuite.doVerify(VerifyProcessSuite.java:28)
at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:79)
... 28 more
Caused by: java.sql.SQLException: ORA-01735: 鏃犳晥鐨?ALTER TABLE 閫夐」
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:961)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190)
at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1657)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1626)
at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStatement.java:64)
at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:264)
at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:284)
at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:277)
at com.liferay.portal.verify.VerifyProcess.runSQL(VerifyProcess.java:48)
at com.liferay.portal.verify.VerifyOracle.doVerify(VerifyOracle.java:69)
at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:79)
... 31 more
Stopping the server due to unexpected startup errors
D:\Git\Liferay-6.1.x\liferay-portal-6.1.x1\tomcat-7.0.25\bin>

I got the same error and in my case the problem was that the upgrade process
tried to update tables in the oracle recycle bin (since the database has been used before the recycle bin was not empty).
After I changed the select statement to fetch the tables to update in com.liferay.portal.verify.VerifyOracle
not to receive tables from the recycle bin like
ps = con.prepareStatement(
"select table_name, column_name, data_length from " +
"user_tab_columns where data_type = 'VARCHAR2' and " +
"char_used = 'B' and table_name not like 'BIN$'");
everything works fine.