**This is an Oracle-specific issue and does NOT occur for upgrades from 6.0.12 to 6.1.x or 6.2.x.

The upgrade from 5.2.3 or 6.0.6 to 6.1.x and 6.2.x fails. There are exceptions in the console and the server shuts down due to startup errors. I have attached the full console output for both errors.

This issue PASSED on:

• Tomcat 7.0.23 + Oracle 10. 6.2.x Revision: 97949.

This issue FAILED on:

• Tomcat 7.0.23 + Oracle 10. 6.2.x Revision: 97950.

Steps to reproduce:

1. Start up Liferay 6.1.x or 6.2.x referencing a 5.2.3 or 6.0.6 oracle database. Be sure to include all the necessary legacy properties.

   • When upgrading from 5.2.3 to 6.1.x or 6.2.x, there will be an "invalid modification of columns" error.

     22:55:29,968 ERROR [MainServlet:198] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: ORA-22859: invalid modification of columns com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: ORA-22859: invalid modification of columns at com.liferay.portal.events.StartupAction.run(StartupAction.java:58) at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1267) at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:195) 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.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: ORA-22859: invalid modification of columns at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:213) at com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:93) at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:46) at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:81) at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:48) at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:119) at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:144) at com.liferay.portal.events.StartupAction.run(StartupAction.java:52) ... 20 more Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: ORA-22859: invalid modification of columns at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:213) at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:227) at com.liferay.portal.upgrade.UpgradeProcess_6_1_0.doUpgrade(UpgradeProcess_6_1_0.java:64) at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:210) ... 27 more Caused by: java.sql.SQLException: ORA-22859: invalid modification of columns 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:222) at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:242) at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:235) at com.liferay.portal.kernel.upgrade.UpgradeProcess.runSQL(UpgradeProcess.java:117) at com.liferay.portal.upgrade.v6_1_0.UpgradeDocumentLibrary.updateFileVersions(UpgradeDocumentLibrary.java:292) at com.liferay.portal.upgrade.v6_1_0.UpgradeDocumentLibrary.doUpgrade(UpgradeDocumentLibrary.java:88) at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:210) ... 30 more Stopping the server due to unexpected startup errors

   • When upgrading from 6.0.6 to 6.1.x or 6.2.x, there will be an "invalid alteration of datatype" error.

     00:28:32,855 ERROR [MainServlet:198] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: ORA-22858: invalid alteration of datatype com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: ORA-22858: invalid alteration of datatype at com.liferay.portal.events.StartupAction.run(StartupAction.java:58) at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1267) at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:195) 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.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: ORA-22858: invalid alteration of datatype at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:213) at com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:93) at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:46) at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:81) at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:48) at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:119) at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:144) at com.liferay.portal.events.StartupAction.run(StartupAction.java:52) ... 20 more Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: ORA-22858: invalid alteration of datatype at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:213) at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:227) at com.liferay.portal.upgrade.UpgradeProcess_6_1_0.doUpgrade(UpgradeProcess_6_1_0.java:64) at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:210) ... 27 more Caused by: java.sql.SQLException: ORA-22858: invalid alteration of datatype 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:222) at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:242) at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:235) at com.liferay.portal.kernel.upgrade.UpgradeProcess.runSQL(UpgradeProcess.java:117) at com.liferay.portal.upgrade.v6_1_0.UpgradeDocumentLibrary.updateFileVersions(UpgradeDocumentLibrary.java:292) at com.liferay.portal.upgrade.v6_1_0.UpgradeDocumentLibrary.doUpgrade(UpgradeDocumentLibrary.java:88) at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:210) ... 30 more Stopping the server due to unexpected startup errors