Foros de discusión

Migração 6.0.6 para 6.1.1

thumbnail
Marcelo Guimarães Melo, modificado hace 11 años.

Migração 6.0.6 para 6.1.1

Regular Member Mensajes: 248 Fecha de incorporación: 29/09/08 Mensajes recientes
Pessoal,

Estou tentando executar uma migração do Liferay 6.0.6 para 6.1.1, estou usando o banco de dados (ORACLE) e aparace a seguinte mensagem:

15/11/2012 23:41:14 org.apache.catalina.startup.Catalina initDirs
SEVERE: Cannot find specified temporary folder at C:\liferay-portal-6.1.1-ce-ga2\tomcat-7.0.27/temp
15/11/2012 23:41:14 org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\liferay-portal-6.1.1-ce-ga2\tomcat-7.0.27\jre1.6.0_20\win\bin;.;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:/Arquivos de programas/Java/jre6/bin/client;C:/Arquivos de programas/Java/jre6/bin;C:/Arquivos de programas/Java/jre6/lib/i386;C:\oracle\product\10.2.0\db_1\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Arquivos de programas\MySQL\MySQL Server 5.0\bin;C:\eclipse;
15/11/2012 23:41:14 org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["http-bio-8080"]
15/11/2012 23:41:14 org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["ajp-bio-8009"]
15/11/2012 23:41:14 org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 917 ms
15/11/2012 23:41:15 org.apache.catalina.core.StandardService startInternal
INFO: Starting service Catalina
15/11/2012 23:41:15 org.apache.catalina.core.StandardEngine startInternal
INFO: Starting Servlet Engine: Apache Tomcat/7.0.27
15/11/2012 23:41:15 org.apache.catalina.startup.HostConfig deployDescriptor
INFO: Deploying configuration descriptor C:\liferay-portal-6.1.1-ce-ga2\tomcat-7.0.27\conf\Catalina\localhost\ROOT.xml
Loading jar:file:/C:/liferay-portal-6.1.1-ce-ga2/tomcat-7.0.27/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/system.properties
Loading jar:file:/C:/liferay-portal-6.1.1-ce-ga2/tomcat-7.0.27/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/portal.properties
Loading file:/C:/liferay-portal-6.1.1-ce-ga2/portal-ide.properties
Loading file:/C:/liferay-portal-6.1.1-ce-ga2/tomcat-7.0.27/webapps/ROOT/WEB-INF/classes/portal-developer.properties
Loading file:/C:/liferay-portal-6.1.1-ce-ga2/portal-setup-wizard.properties
Loading file:/C:/liferay-portal-6.1.1-ce-ga2/tomcat-7.0.27/webapps/ROOT/WEB-INF/classes/portal-ext.properties
15/11/2012 23:41:18 org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring root WebApplicationContext
23:41:26,690 INFO  [pool-2-thread-1][DialectDetector:71] Determine dialect for Oracle 10
23:41:26,721 INFO  [pool-2-thread-1][DialectDetector:136] Found dialect org.hibernate.dialect.Oracle10gDialect
Starting Liferay Portal Community Edition 6.1.1 CE GA2 (Paton / Build 6101 / July 31, 2012)
23:42:00,659 INFO  [pool-2-thread-1][BaseDB:452] Database supports case sensitive queries
23:42:00,971 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_1_0
23:42:00,987 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeSchema
23:42:07,393 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeUserName
23:42:08,580 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeAdminPortlets
23:42:10,268 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeBlogs
23:42:10,393 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeCamelCasePortletPreferences
23:42:15,315 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeCountry
23:42:15,596 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeDocumentLibrary
23:42:17,299 INFO  [pool-2-thread-1][Table:174] Starting backup of DLFileVersion to C:\liferay-portal-6.1.1-ce-ga2\tomcat-7.0.27/temp/temp-db-DLFileVersion-1353022937299
23:42:17,330 INFO  [pool-2-thread-1][Table:208] Finished backup of DLFileVersion to C:\liferay-portal-6.1.1-ce-ga2\tomcat-7.0.27/temp/temp-db-DLFileVersion-1353022937299 in 31 ms
23:42:17,502 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeExpando
23:42:17,518 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeGroup
23:42:17,518 INFO  [pool-2-thread-1][Table:174] Starting backup of Group_ to C:\liferay-portal-6.1.1-ce-ga2\tomcat-7.0.27/temp/temp-db-Group_-1353022937518
23:42:17,549 INFO  [pool-2-thread-1][Table:208] Finished backup of Group_ to C:\liferay-portal-6.1.1-ce-ga2\tomcat-7.0.27/temp/temp-db-Group_-1353022937518 in 31 ms
23:42:18,002 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeImageGallery
23:42:21,377 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeJournal
23:42:21,487 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeLayout
23:42:26,737 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeLock
23:42:26,737 INFO  [pool-2-thread-1][Table:174] Starting backup of Lock_ to C:\liferay-portal-6.1.1-ce-ga2\tomcat-7.0.27/temp/temp-db-Lock_-1353022946737
23:42:26,737 INFO  [pool-2-thread-1][Table:208] Finished backup of Lock_ to C:\liferay-portal-6.1.1-ce-ga2\tomcat-7.0.27/temp/temp-db-Lock_-1353022946737 in 0 ms
23:42:26,862 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeMessageBoards
23:43:06,455 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeNavigation
23:43:06,487 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradePermission
23:43:07,377 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradePortletPreferences
23:43:12,002 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeCommunityProperties
23:43:12,315 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeResourcePermission
23:43:12,330 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeScopes
23:43:12,362 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeSocial
23:43:12,721 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeSubscription
23:43:12,737 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeVirtualHost
23:43:12,784 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeWorkflow
23:43:12,799 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeAsset
23:43:12,862 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_1_1
23:43:12,862 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_1.UpgradeSchema
23:43:12,987 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_1.UpgradeDocumentLibrary
23:43:13,002 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_1.UpgradeLayout
23:43:13,018 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_1.UpgradeLayoutSet
23:43:13,018 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_1.UpgradeLayoutSetBranch
23:43:13,424 INFO  [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyProcessSuite
23:43:13,424 INFO  [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyProperties
23:43:13,424 INFO  [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyDB2
23:43:13,440 INFO  [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyMySQL
23:43:13,455 INFO  [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyOracle
23:43:14,237 ERROR [pool-2-thread-1][MainServlet:217] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: java.sql.SQLSyntaxErrorException: ORA-01735: opção ALTER TABLE é inválida

com.liferay.portal.kernel.events.ActionException: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: java.sql.SQLSyntaxErrorException: ORA-01735: opção ALTER TABLE é inválida

	at com.liferay.portal.events.StartupAction.run(StartupAction.java:58)
	at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1306)
	at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:214)
	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:895)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:871)
	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:1585)
	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:619)
Caused by: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: java.sql.SQLSyntaxErrorException: ORA-01735: opção ALTER TABLE é inválida

	at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:87)
	at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:113)
	at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:78)
	at com.liferay.portal.verify.VerifyProcessUtil.verifyProcess(VerifyProcessUtil.java:47)
	at com.liferay.portal.events.StartupHelper.verifyProcess(StartupHelper.java:136)
	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.SQLSyntaxErrorException: ORA-01735: opção ALTER TABLE é inválida

	at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:87)
	at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:92)
	at com.liferay.portal.verify.VerifyProcessSuite.doVerify(VerifyProcessSuite.java:28)
	at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:84)
	... 28 more
Caused by: java.sql.SQLSyntaxErrorException: ORA-01735: opção ALTER TABLE é inválida

	at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
	at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
	at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
	at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)
	at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:942)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
	at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1706)
	at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1674)
	at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:275)
	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:53)
	at com.liferay.portal.verify.VerifyOracle.alterColumns(VerifyOracle.java:67)
	at com.liferay.portal.verify.VerifyOracle.doVerify(VerifyOracle.java:107)
	at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:84)
	... 31 more
Stopping the server due to unexpected startup errors


Alguém pode me ajudar.

Obrigado,

Marcelo Melo
thumbnail
Juan Gonzalez P, modificado hace 11 años.

RE: Migração 6.0.6 para 6.1.1

Liferay Legend Mensajes: 3089 Fecha de incorporación: 28/10/08 Mensajes recientes
Please, search a little first.

Only searching in forums you would have found that issue is this:

http://issues.liferay.com/browse/LPS-29479

And you'd find that is resolved in Liferay community patcher's version:

https://www.lcepatchers.org/downloads