Fóruns

Início » Liferay Portal » Português

Visualização combinada Visão plana Exibição em árvore
Tópicos [ Anterior | Próximo ]
toggle
Marcelo Guimarães Melo
Migração 6.0.6 para 6.1.1
15 de Novembro de 2012 15:56
Resposta

Marcelo Guimarães Melo

Ranking: Regular Member

Mensagens: 216

Data de entrada: 29 de Setembro de 2008

Mensagens recentes

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:

  115/11/2012 23:41:14 org.apache.catalina.startup.Catalina initDirs
  2SEVERE: Cannot find specified temporary folder at C:\liferay-portal-6.1.1-ce-ga2\tomcat-7.0.27/temp
  315/11/2012 23:41:14 org.apache.catalina.core.AprLifecycleListener init
  4INFO: 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;
  515/11/2012 23:41:14 org.apache.coyote.AbstractProtocol init
  6INFO: Initializing ProtocolHandler ["http-bio-8080"]
  715/11/2012 23:41:14 org.apache.coyote.AbstractProtocol init
  8INFO: Initializing ProtocolHandler ["ajp-bio-8009"]
  915/11/2012 23:41:14 org.apache.catalina.startup.Catalina load
 10INFO: Initialization processed in 917 ms
 1115/11/2012 23:41:15 org.apache.catalina.core.StandardService startInternal
 12INFO: Starting service Catalina
 1315/11/2012 23:41:15 org.apache.catalina.core.StandardEngine startInternal
 14INFO: Starting Servlet Engine: Apache Tomcat/7.0.27
 1515/11/2012 23:41:15 org.apache.catalina.startup.HostConfig deployDescriptor
 16INFO: Deploying configuration descriptor C:\liferay-portal-6.1.1-ce-ga2\tomcat-7.0.27\conf\Catalina\localhost\ROOT.xml
 17Loading jar:file:/C:/liferay-portal-6.1.1-ce-ga2/tomcat-7.0.27/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/system.properties
 18Loading jar:file:/C:/liferay-portal-6.1.1-ce-ga2/tomcat-7.0.27/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/portal.properties
 19Loading file:/C:/liferay-portal-6.1.1-ce-ga2/portal-ide.properties
 20Loading file:/C:/liferay-portal-6.1.1-ce-ga2/tomcat-7.0.27/webapps/ROOT/WEB-INF/classes/portal-developer.properties
 21Loading file:/C:/liferay-portal-6.1.1-ce-ga2/portal-setup-wizard.properties
 22Loading file:/C:/liferay-portal-6.1.1-ce-ga2/tomcat-7.0.27/webapps/ROOT/WEB-INF/classes/portal-ext.properties
 2315/11/2012 23:41:18 org.apache.catalina.core.ApplicationContext log
 24INFO: Initializing Spring root WebApplicationContext
 2523:41:26,690 INFO  [pool-2-thread-1][DialectDetector:71] Determine dialect for Oracle 10
 2623:41:26,721 INFO  [pool-2-thread-1][DialectDetector:136] Found dialect org.hibernate.dialect.Oracle10gDialect
 27Starting Liferay Portal Community Edition 6.1.1 CE GA2 (Paton / Build 6101 / July 31, 2012)
 2823:42:00,659 INFO  [pool-2-thread-1][BaseDB:452] Database supports case sensitive queries
 2923:42:00,971 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_1_0
 3023:42:00,987 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeSchema
 3123:42:07,393 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeUserName
 3223:42:08,580 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeAdminPortlets
 3323:42:10,268 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeBlogs
 3423:42:10,393 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeCamelCasePortletPreferences
 3523:42:15,315 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeCountry
 3623:42:15,596 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeDocumentLibrary
 3723: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
 3823: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
 3923:42:17,502 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeExpando
 4023:42:17,518 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeGroup
 4123: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
 4223: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
 4323:42:18,002 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeImageGallery
 4423:42:21,377 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeJournal
 4523:42:21,487 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeLayout
 4623:42:26,737 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeLock
 4723: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
 4823: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
 4923:42:26,862 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeMessageBoards
 5023:43:06,455 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeNavigation
 5123:43:06,487 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradePermission
 5223:43:07,377 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradePortletPreferences
 5323:43:12,002 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeCommunityProperties
 5423:43:12,315 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeResourcePermission
 5523:43:12,330 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeScopes
 5623:43:12,362 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeSocial
 5723:43:12,721 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeSubscription
 5823:43:12,737 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeVirtualHost
 5923:43:12,784 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeWorkflow
 6023:43:12,799 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeAsset
 6123:43:12,862 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_1_1
 6223:43:12,862 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_1.UpgradeSchema
 6323:43:12,987 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_1.UpgradeDocumentLibrary
 6423:43:13,002 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_1.UpgradeLayout
 6523:43:13,018 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_1.UpgradeLayoutSet
 6623:43:13,018 INFO  [pool-2-thread-1][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_1.UpgradeLayoutSetBranch
 6723:43:13,424 INFO  [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyProcessSuite
 6823:43:13,424 INFO  [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyProperties
 6923:43:13,424 INFO  [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyDB2
 7023:43:13,440 INFO  [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyMySQL
 7123:43:13,455 INFO  [pool-2-thread-1][VerifyProcess:81] Verifying com.liferay.portal.verify.VerifyOracle
 7223: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
 73
 74com.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
 75
 76    at com.liferay.portal.events.StartupAction.run(StartupAction.java:58)
 77    at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1306)
 78    at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:214)
 79    at javax.servlet.GenericServlet.init(GenericServlet.java:160)
 80    at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1266)
 81    at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1185)
 82    at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1080)
 83    at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5015)
 84    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5302)
 85    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
 86    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:895)
 87    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:871)
 88    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:615)
 89    at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:649)
 90    at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1585)
 91    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
 92    at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
 93    at java.util.concurrent.FutureTask.run(FutureTask.java:138)
 94    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
 95    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
 96    at java.lang.Thread.run(Thread.java:619)
 97Caused by: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: java.sql.SQLSyntaxErrorException: ORA-01735: opção ALTER TABLE é inválida
 98
 99    at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:87)
100    at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:113)
101    at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:78)
102    at com.liferay.portal.verify.VerifyProcessUtil.verifyProcess(VerifyProcessUtil.java:47)
103    at com.liferay.portal.events.StartupHelper.verifyProcess(StartupHelper.java:136)
104    at com.liferay.portal.events.StartupHelperUtil.verifyProcess(StartupHelperUtil.java:52)
105    at com.liferay.portal.tools.DBUpgrader.verify(DBUpgrader.java:210)
106    at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:182)
107    at com.liferay.portal.events.StartupAction.run(StartupAction.java:52)
108    ... 20 more
109Caused by: com.liferay.portal.verify.VerifyException: java.sql.SQLSyntaxErrorException: ORA-01735: opção ALTER TABLE é inválida
110
111    at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:87)
112    at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:92)
113    at com.liferay.portal.verify.VerifyProcessSuite.doVerify(VerifyProcessSuite.java:28)
114    at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:84)
115    ... 28 more
116Caused by: java.sql.SQLSyntaxErrorException: ORA-01735: opção ALTER TABLE é inválida
117
118    at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
119    at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
120    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
121    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
122    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
123    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
124    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)
125    at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:942)
126    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
127    at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1706)
128    at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1674)
129    at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:275)
130    at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStatement.java:64)
131    at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:264)
132    at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:284)
133    at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:277)
134    at com.liferay.portal.verify.VerifyProcess.runSQL(VerifyProcess.java:53)
135    at com.liferay.portal.verify.VerifyOracle.alterColumns(VerifyOracle.java:67)
136    at com.liferay.portal.verify.VerifyOracle.doVerify(VerifyOracle.java:107)
137    at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:84)
138    ... 31 more
139Stopping the server due to unexpected startup errors


Alguém pode me ajudar.

Obrigado,

Marcelo Melo
Juan Gonzalez
RE: Migração 6.0.6 para 6.1.1
15 de Novembro de 2012 23:13
Resposta

Juan Gonzalez

LIFERAY STAFF

Ranking: Liferay Legend

Mensagens: 1762

Data de entrada: 28 de Outubro de 2008

Mensagens recentes

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