Visualização combinada Visão plana Exibição em árvore
Tópicos [ Anterior | Próximo ]
toggle
Upgrade Liferay 5.2.3 -> 6.0.3 Leon Schaeps 19 de Julho de 2010 02:00
RE: Upgrade Liferay 5.2.3 -> 6.0.3 Marek Wianecki 19 de Julho de 2010 05:57
RE: Upgrade Liferay 5.2.3 -> 6.0.3 Leon Schaeps 19 de Julho de 2010 06:36
RE: Upgrade Liferay 5.2.3 -> 6.0.3 Marek Wianecki 19 de Julho de 2010 09:27
RE: Upgrade Liferay 5.2.3 -> 6.0.3 Leon Schaeps 19 de Julho de 2010 11:25
RE: Upgrade Liferay 5.2.3 -> 6.0.3 JR Houn 19 de Julho de 2010 11:21
RE: Upgrade Liferay 5.2.3 -> 6.0.3 Leon Schaeps 19 de Julho de 2010 12:34
RE: Upgrade Liferay 5.2.3 -> 6.0.3 Bryan Nylander 19 de Julho de 2010 17:13
RE: Upgrade Liferay 5.2.3 -> 6.0.3 Leon Schaeps 20 de Julho de 2010 00:26
RE: Upgrade Liferay 5.2.3 -> 6.0.3 Marek Wianecki 20 de Julho de 2010 01:39
RE: Upgrade Liferay 5.2.3 -> 6.0.3 Leon Schaeps 20 de Julho de 2010 22:44
RE: Upgrade Liferay 5.2.3 -> 6.0.3 Leon Schaeps 21 de Julho de 2010 23:41
RE: Upgrade Liferay 5.2.3 -> 6.0.3 Marek Wianecki 22 de Julho de 2010 03:42
RE: Upgrade Liferay 5.2.3 -> 6.0.3 Dennis Greiffenberg 18 de Outubro de 2010 08:56
RE: Upgrade Liferay 5.2.3 -> 6.0.3 Jatin Panchal 1 de Dezembro de 2010 22:10
RE: Upgrade Liferay 5.2.3 -> 6.0.3 Dennis Greiffenberg 1 de Dezembro de 2010 23:10
RE: Upgrade Liferay 5.2.3 -> 6.0.3 Matthieu Levesque 7 de Dezembro de 2010 03:19
RE: Upgrade Liferay 5.2.3 -> 6.0.3 Jatin Panchal 10 de Dezembro de 2010 00:07
RE: Upgrade Liferay 5.2.3 -> 6.0.3 Bryan Nylander 20 de Julho de 2010 09:27
RE: Upgrade Liferay 5.2.3 -> 6.0.3 Mudasar Kalwar 13 de Setembro de 2012 05:57
RE: Upgrade Liferay 5.2.3 -> 6.0.3 Mudasar Kalwar 14 de Setembro de 2012 06:00
RE: Upgrade Liferay 5.2.3 -> 6.0.3 Tom Thomas 2 de Fevereiro de 2011 15:43
RE: Upgrade Liferay 5.2.3 -> 6.0.3 Ali Faisal 1 de Junho de 2011 08:51
Leon Schaeps
Upgrade Liferay 5.2.3 -> 6.0.3
19 de Julho de 2010 02:00
Resposta

Leon Schaeps

Ranking: New Member

Mensagens: 9

Data de entrada: 17 de Junho de 2009

Mensagens recentes

I want to update from Liferay 5.2.3 to Liferay 6.0.3
For this upgrade I changed the portal-ext.properties to

permissions.user.check.algorithm=5
image.hook.impl=com.liferay.portal.image.DatabaseHook

The upgrade results in an Duplicate entry error within:
Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeDocumentLibrary

08:35:52,169 ERROR [JDBCExceptionReporter:101] Table 'lportal6.lock_' doesn't exist
08:35:53,092 INFO [BaseDB:393] Database does not support case sensitive queries
08:35:53,109 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_0_0
08:35:53,110 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeSchema
08:37:59,743 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeAsset
08:41:34,656 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeAssetPublisher
08:41:42,203 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeBlogs
08:41:42,233 INFO [Table:371] Starting backup of BlogsEntry to C:\ontwikkel\liferay-portal-6.0.3\tomcat-6.0.26/temp/temp-db-BlogsEntry-1279528902232
08:41:43,329 INFO [Table:407] Finished backup of BlogsEntry to C:\ontwikkel\liferay-portal-6.0.3\tomcat-6.0.26/temp/temp-db-BlogsEntry-1279528902232 in 1096 ms
08:41:51,110 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeDocumentLibrary
08:41:55,995 ERROR [MainServlet:196] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '24814-DLFE-1752.doc-1' for key 'IX_6C5E6512'
com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '24814-DLFE-1752.doc-1' for key 'IX_6C5E6512'
at com.liferay.portal.events.StartupAction.run(StartupAction.java:53)
at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1159)
at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:193)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4187)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4496)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:519)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:592)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '24814-DLFE-1752.doc-1' for key 'IX_6C5E6512'
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:114)
at com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:80)
at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:37)
at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:73)
at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:40)
at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:94)
at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:117)
at com.liferay.portal.events.StartupAction.run(StartupAction.java:47)
... 29 more
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '24814-DLFE-1752.doc-1' for key 'IX_6C5E6512'
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:114)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:130)
at com.liferay.portal.upgrade.UpgradeProcess_6_0_0.doUpgrade(UpgradeProcess_6_0_0.java:48)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:111)
... 36 more
Caused by: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '24814-DLFE-1752.doc-1' for key 'IX_6C5E6512'
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1313)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1585)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1500)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1485)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
at com.liferay.portal.upgrade.v6_0_0.UpgradeDocumentLibrary.addFileVersion(UpgradeDocumentLibrary.java:86)
at com.liferay.portal.upgrade.v6_0_0.UpgradeDocumentLibrary.doUpgrade(UpgradeDocumentLibrary.java:133)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:111)
... 39 more


Any idea?

Kind regards,

Leon
Marek Wianecki
RE: Upgrade Liferay 5.2.3 -> 6.0.3
19 de Julho de 2010 05:57
Resposta

Marek Wianecki

Ranking: New Member

Mensagens: 15

Data de entrada: 10 de Maio de 2010

Mensagens recentes

well, I have put image.hook.impl=com.liferay.portal.image.DatabaseHook to portal-ext.properties after upgrade and images work fine. Maybe try this:
1. permissions.user.check.algorithm=5
2. upgrade
3. #permissions.user.check.algorithm=5
4. image.hook.impl=com.liferay.portal.image.DatabaseHook
5. test emoticon
Leon Schaeps
RE: Upgrade Liferay 5.2.3 -> 6.0.3
19 de Julho de 2010 06:36
Resposta

Leon Schaeps

Ranking: New Member

Mensagens: 9

Data de entrada: 17 de Junho de 2009

Mensagens recentes

Marek Wianecki:
well, I have put image.hook.impl=com.liferay.portal.image.DatabaseHook to portal-ext.properties after upgrade and images work fine. Maybe try this:
1. permissions.user.check.algorithm=5
2. upgrade
3. #permissions.user.check.algorithm=5
4. image.hook.impl=com.liferay.portal.image.DatabaseHook
5. test emoticon


Thanks for your answer, but I already tried that.
Marek Wianecki
RE: Upgrade Liferay 5.2.3 -> 6.0.3
19 de Julho de 2010 09:27
Resposta

Marek Wianecki

Ranking: New Member

Mensagens: 15

Data de entrada: 10 de Maio de 2010

Mensagens recentes

it worked ? if not, do you have the same exception ? for me Your exception looks like You have upgraded, upgrade failed and you try to run it again. I dont know if it would work this way but when I had similar exception I did database recovery to the version before upgrade and then I've tried these steps ...
JR Houn
RE: Upgrade Liferay 5.2.3 -> 6.0.3
19 de Julho de 2010 11:21
Resposta

JR Houn

LIFERAY STAFF

Ranking: Expert

Mensagens: 489

Data de entrada: 19 de Novembro de 2007

Mensagens recentes

Since it looks like your upgrade is failing on document library you may need to configure liferay portal 6 to use the proper document library hook that your previous installation was using see this section in the 6.0.3 portal-ext.properties:


##
## Document Library Portlet
##

#
# Set the name of a class that implements
# com.liferay.documentlibrary.util.Hook. The
# document library server will use this persist documents.
#
#dl.hook.impl=com.liferay.documentlibrary.util.AdvancedFileSystemHook
#dl.hook.impl=com.liferay.documentlibrary.util.CMISHook
dl.hook.impl=com.liferay.documentlibrary.util.FileSystemHook
#dl.hook.impl=com.liferay.documentlibrary.util.JCRHook
#dl.hook.impl=com.liferay.documentlibrary.util.S3Hook

#
# FileSystemHook
#
dl.hook.file.system.root.dir=${liferay.home}/data/document_library

#
# JCRHook
#
dl.hook.jcr.fetch.delay=500
dl.hook.jcr.fetch.max.failures=5

#
# S3Hook
#
dl.hook.s3.access.key=
dl.hook.s3.secret.key=
dl.hook.s3.bucket.name=

#
# S3Hook
#
dl.hook.s3.access.key=
dl.hook.s3.secret.key=
dl.hook.s3.bucket.name=


The settings you enter for the 6.0.3 portal-ext.properties installation should match the same document library hook that your 5.2.3 installation used.

-jr
Leon Schaeps
RE: Upgrade Liferay 5.2.3 -> 6.0.3
19 de Julho de 2010 11:25
Resposta

Leon Schaeps

Ranking: New Member

Mensagens: 9

Data de entrada: 17 de Junho de 2009

Mensagens recentes

Marek Wianecki:
it worked ? if not, do you have the same exception ? for me Your exception looks like You have upgraded, upgrade failed and you try to run it again. I dont know if it would work this way but when I had similar exception I did database recovery to the version before upgrade and then I've tried these steps ...


Hi,

Not successfully so far emoticon
When the upgrade fails I allways restart with a fresh import. So i don't run it again.
When I run it again, the number of errors is very huge.
After the failure I decided to delete the Document Library content and do a new import.
But that import resulted in a new failure:

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

After I manually fixed the portal-impl.jar the update, without DL-entries, runs ok.
But the site crashes with an null pointer exception.

Looks like the upgrade scenario hasn't be tested very well.

Kind regards,

Leon
Leon Schaeps
RE: Upgrade Liferay 5.2.3 -> 6.0.3
19 de Julho de 2010 12:34
Resposta

Leon Schaeps

Ranking: New Member

Mensagens: 9

Data de entrada: 17 de Junho de 2009

Mensagens recentes

Hi JR,

My portal-ext.properties:

jdbc.default.driverClassName=com.mysql.jdbc.Driver
jdbc.default.url=jdbc:mysql://localhost/lportal6?useUnicode=true&characterEncoding=UTF-8&
useFastDateParsing=false
jdbc.default.username=root
jdbc.default.password=admin
com.liferay.portal.servlet.filters.gzip.GZipFilter=false
com.liferay.portal.servlet.filters.header.HeaderFilter=true
axis.servlet.hosts.allowed=127.0.0.1
axis.servlet.https.required=false


permissions.user.check.algorithm=5
image.hook.impl=com.liferay.portal.image.DatabaseHook


We started at Liferay 5.2.3 so this should be fine, I think.

Still very strange to get an duplicate key entry while updating a database.

Kind regards,

Leon
Bryan Nylander
RE: Upgrade Liferay 5.2.3 -> 6.0.3
19 de Julho de 2010 17:13
Resposta

Bryan Nylander

Ranking: New Member

Mensagens: 2

Data de entrada: 19 de Julho de 2010

Mensagens recentes

I am also attempting to upgrade liferay CE addition from 5.2.3 -> 6.0.3 and receiving a similar error condition but in a different location and infrastructure.

App server Linux. DB Server Oracle 10.

Im willing to post all the errors however the log output to the catalina.out is very long.

For my upgrade, I opened a copy of the liferay6.0.3 under a bundle directory and pointed a symbolic link called current from the 5.2.3 to the 6.0.3 directory. I copied over the portal-ext.properties to the new 6.0.3 directory as well as move over a copy of ojdbc6.jar to the new tomcat-6.0.26/lib so that the OJDB jar will be found within the path.

When running the startup.sh script under the new tomcat-6.0.26/bin I get sever errors which do not seam to sync up.

Here is a copy of what I have defined within the protal-ext.properties file

=================================================
jdbc.default.jndi.name=jdbc/LiferayPool
jdbc.default.driverClassName=oracle.jdbc.driver.OracleDriver
jdbc.default.url=jdbc:oracle:thin:@server1.maximus.com:1000:LIFERAY
jdbc.default.username=liferay
jdbc.default.password=LIFERAY

# Mail server configuration
mail.session.mail.pop3.host=localhost
mail.session.mail.pop3.password=
mail.session.mail.pop3.port=110
mail.session.mail.pop3.user=
mail.session.mail.smtp.auth=false
mail.session.mail.smtp.host=localhost
mail.session.mail.smtp.password=
mail.session.mail.smtp.port=25

# Remove Chat option at the bottom of all pages
layout.static.portlets.all=
=================================================


First set of errors I see is:
=================================================
Loading jar:file:/u01/maximus/liferay-dev/bundle/liferay-portal-6.0.3/tomcat-6.0.26/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/system.properties
Loading jar:file:/u01/maximus/liferay-dev/bundle/liferay-portal-6.0.3/tomcat-6.0.26/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/portal.properties
Loading file:/u01/maximus/liferay-dev/bundle/current/portal-ext.properties
17:16:39,500 ERROR [DataSourceFactoryBean:74] Unable to lookup jdbc/LiferayPool
javax.naming.NameNotFoundException: Name jdbc is not bound in this Context
at org.apache.naming.NamingContext.lookup(NamingContext.java:770)
at org.apache.naming.NamingContext.lookup(NamingContext.java:140)
at org.apache.naming.NamingContext.lookup(NamingContext.java:781)
=================================================

This indicates that jdbc/LiferayPool could not be found. The log files continue with 30 or so pages worth of stack traces shown below.

=================================================
17:17:00,073 WARN [DriverManagerDataSource:107] Could not load driverClass oracle.jdbc.driver.OracleDriver
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1516)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1361)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at com.mchange.v2.c3p0.DriverManagerDataSource.ensureDriverLoaded(DriverManagerDataSource.java:100)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:132)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:148)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)

=================================================

This would seam to be a driver location issue until the following errors are shown further in the log file

=================================================
17:17:58,557 INFO [HotDeployUtil:62] Initializing hot deploy manager 16785420
Jul 19, 2010 5:17:58 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: A web application appears to have started a thread named [Dispatch-Thread-for-com.mchange.v2.async.ThreadPerTaskAsynchronousRunner@1473a2e] but has failed to stop it. This is very likely to create a memory leak.
Jul 19, 2010 5:17:58 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: A web application appears to have started a thread named [Task-Thread-for-com.mchange.v2.async.ThreadPerTaskAsynchronousRunner@1473a2e] but has failed to stop it. This is very likely to create a memory leak.
Jul 19, 2010 5:17:58 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: A web application appears to have started a thread named [Task-Thread-for-com.mchange.v2.async.ThreadPerTaskAsynchronousRunner@1473a2e] but has failed to stop it. This is very likely to create a memory leak.
=================================================

Further in the catalina.out log file I see a shift within the logging where it appears that an Update to the Schema starts. What is strange is that after a dump of the DML is presented, We see ORA errors which looks like an Oracle version of the issue reported on this thread.

=================================================
Starting Liferay Portal Community Edition 6.0.3 CE (Bunyan / Build 6003 / July 15, 2010)
17:19:46,468 INFO [BaseDB:390] Database supports case sensitive queries
17:19:46,492 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_0_0
17:19:46,495 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeSchema
17:19:46,537 WARN [BaseDB:366] ORA-00955: name is already used by an existing object: create table AssetCategory ( uuid_ VARCHAR(75) null, categoryId LONG not null primary key, groupId LONG, companyId LONG, userId LONG, userName VARCHAR(75) null, createDate DATE null, modifiedDate DATE null, parentCategoryId LONG, leftCategoryId LONG, rightCategoryId LONG, name VARCHAR(75) null, title STRING null, vocabularyId LONG);
17:19:46,552 WARN [BaseDB:366] ORA-00955: name is already used by an existing object: create table AssetCategoryProperty ( categoryPropertyId LONG not null primary key, companyId LONG, userId LONG, userName VARCHAR(75) null, createDate DATE null, modifiedDate DATE null, categoryId LONG, key_ VARCHAR(75) null, value VARCHAR(75) null);
17:19:46,564 WARN [BaseDB:366] ORA-00955: name is already used by an existing object: create table AssetEntries_AssetCategories ( entryId LONG not null, categoryId LONG not null, primary key (entryId, categoryId));
17:19:46,579 WARN [BaseDB:366] ORA-00955: name is already used by an existing object: create table AssetEntries_AssetTags ( entryId LONG not null, tagId LONG not null, primary key (entryId, tagId));
17:19:46,606 WARN [BaseDB:366] ORA-00955: name is already used by an existing object: create table AssetEntry ( entryId LONG not null primary key, groupId LONG, companyId LONG, userId LONG, userName VARCHAR(75) null, createDate DATE null, modifiedDate DATE null, classNameId LONG, classPK LONG, visible BOOLEAN, startDate DATE null, endDate DATE null, publishDate DATE null, expirationDate DATE null, mimeType VARCHAR(75) null, title VARCHAR(255) null, description STRING null, summary STRING null, url STRING null, height INTEGER, width INTEGER, priority DOUBLE, viewCount INTEGER);
17:19:46,617 WARN [BaseDB:366] ORA-00955: name is already used by an existing object: create table AssetTag ( tagId LONG not null primary key, groupId LONG, companyId LONG, userId LONG, userName VARCHAR(75) null, createDate DATE null, modifiedDate DATE null, name VARCHAR(75) null, assetCount INTEGER);
17:19:46,626 WARN [BaseDB:366] ORA-00955: name is already used by an existing object: create table AssetTagProperty ( tagPropertyId LONG not null primary key, companyId LONG, userId LONG, userName VARCHAR(75) null, createDate DATE null, modifiedDate DATE null, tagId LONG, key_ VARCHAR(75) null, value VARCHAR(255) null);
17:19:46,634 WARN [BaseDB:366] ORA-00955: name is already used by an existing object: create table AssetTagStats ( tagStatsId LONG not null primary key, tagId LONG, classNameId LONG, assetCount INTEGER);
17:19:46,642 WARN [BaseDB:366] ORA-00955: name is already used by an existing object: create table AssetVocabulary ( uuid_ VARCHAR(75) null, vocabularyId LONG not null primary key, groupId LONG, companyId LONG, userId LONG, userName VARCHAR(75) null, createDate DATE null, modifiedDate DATE null, name VARCHAR(75) null, title STRING null, description STRING null, settings_ STRING null);
17:19:46,650 WARN [BaseDB:366] ORA-01430: column being added already exists in table: alter table BlogsEntry add allowPingbacks BOOLEAN;
17:19:46,683 WARN [BaseDB:366] ORA-01430: column being added already exists in table: alter table BlogsEntry add status INTEGER;
17:19:46,715 WARN [BaseDB:366] ORA-01430: column being added already exists in table: alter table BlogsEntry add statusByUserId LONG;
17:19:46,745 WARN [BaseDB:366] ORA-01430: column being added already exists in table: alter table BlogsEntry add statusByUserName VARCHAR(75);
17:19:46,776 WARN [BaseDB:366] ORA-01430: column being added already exists in table: alter table BlogsEntry add statusDate DATE;
=================================================
Further in log
=================================================
17:19:47,744 INFO [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeAsset
17:19:47,754 ERROR [MainServlet:196] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (LRAY.IX_A32C097E) violated

com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (LRAY.IX_A32C097E) violated

at com.liferay.portal.events.StartupAction.run(StartupAction.java:53)
at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1159)
at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:193)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4187)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4496)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:519)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLIntegrityConstraintViolation
=================================================


Where the process starts with not being able to find the ojdb driver, further in the process clearly finds something as it returns oracle related errors.

Sorry kept it short as I could. Let me know what you think may have happened or things which I should try out.

Thanks for the help.
Leon Schaeps
RE: Upgrade Liferay 5.2.3 -> 6.0.3
20 de Julho de 2010 00:26
Resposta

Leon Schaeps

Ranking: New Member

Mensagens: 9

Data de entrada: 17 de Junho de 2009

Mensagens recentes

Hi Bryan,

did you restart the upgrade procedure after it failed the first time?
Because you always should start with a clean 5.2.3 database.

Kind regards,

Leon
Marek Wianecki
RE: Upgrade Liferay 5.2.3 -> 6.0.3
20 de Julho de 2010 01:39
Resposta

Marek Wianecki

Ranking: New Member

Mensagens: 15

Data de entrada: 10 de Maio de 2010

Mensagens recentes

Leo,
I have 2 Liferay nodes (cluster) with mod_jk, and mysql. We have some webcontent and some documents in document library so installation isn't pure test. This is my upgrade procedure which worked:
1. Liferay emoticon and DB backup
2. extract liferay to destination folder
3. start liferay on its defaults (it looks like you have to do it before upgrade)
4. liferay shutdown
5. configure Liferay
#portal-ext.properties
jdbc.default.jndi.name=jdbc/LiferayPool
dl.file.max.size=15728640
dl.file.extensions=.bmp,.css,.doc,.dot,.gif,.gz,.htm,.html,.jpg,.js,.lar,.odb,.odf,.odg,.odp,.ods,.odt,.pdf,.png,.ppt,.rtf,.swf,.sxc,.sxi,.sxw,.tar,.tiff,.tgz,.txt,.vsd,.xls,.xml,.zip,.flv
permissions.user.check.algorithm=5

#modify files:
/data/jackrabbit/repository.xml (my jackrabbit uses mysql)
/tomcat-6.0.26/conf/context.xml (cluster)
/tomcat-6.0.26/conf/server.xml (cluster)
/tomcat-6.0.26/conf/Catalina/localhost/ROOT.xml (mysql data source config)

6. remove all sevencogs apps (upgrade always fails because of it)
7. start liferay, watch catalina.out for errors
8. shutdown
9. remove permissions.user.check.algorithm=5
10. add image.hook.impl=com.liferay.portal.image.DatabaseHook
11. startup liferay

I hope it helps ...
Bryan Nylander
RE: Upgrade Liferay 5.2.3 -> 6.0.3
20 de Julho de 2010 09:27
Resposta

Bryan Nylander

Ranking: New Member

Mensagens: 2

Data de entrada: 19 de Julho de 2010

Mensagens recentes

Hello there. I have tried several different attempts. First started to upgrade using the latest available (6.0.2) and received same errors.

I am able to bring 5.2.3 backup and us it without errors against this DB. So is the expectations now that there are some irreversible damage which leaves this DB stuck at 5.2.3?

Thanks for the help all.

B
Leon Schaeps
RE: Upgrade Liferay 5.2.3 -> 6.0.3
20 de Julho de 2010 22:44
Resposta

Leon Schaeps

Ranking: New Member

Mensagens: 9

Data de entrada: 17 de Junho de 2009

Mensagens recentes

Marek Wianecki:
Leo,
I have 2 Liferay nodes (cluster) with mod_jk, and mysql. We have some webcontent and some documents in document library so installation isn't pure test. This is my upgrade procedure which worked:
1. Liferay emoticon and DB backup
2. extract liferay to destination folder
3. start liferay on its defaults (it looks like you have to do it before upgrade)
4. liferay shutdown
5. configure Liferay
#portal-ext.properties
jdbc.default.jndi.name=jdbc/LiferayPool
dl.file.max.size=15728640
dl.file.extensions=.bmp,.css,.doc,.dot,.gif,.gz,.htm,.html,.jpg,.js,.lar,.odb,.odf,.odg,.odp,.ods,.odt,.pdf,.png,.ppt,.rtf,.swf,.sxc,.sxi,.sxw,.tar,.tiff,.tgz,.txt,.vsd,.xls,.xml,.zip,.flv
permissions.user.check.algorithm=5

#modify files:
/data/jackrabbit/repository.xml (my jackrabbit uses mysql)
/tomcat-6.0.26/conf/context.xml (cluster)
/tomcat-6.0.26/conf/server.xml (cluster)
/tomcat-6.0.26/conf/Catalina/localhost/ROOT.xml (mysql data source config)

6. remove all sevencogs apps (upgrade always fails because of it)
7. start liferay, watch catalina.out for errors
8. shutdown
9. remove permissions.user.check.algorithm=5
10. add image.hook.impl=com.liferay.portal.image.DatabaseHook
11. startup liferay

I hope it helps ...


Didn't really help.
I'm able to upgrade a default 5.2.3 database with sevencogs to 6.0.3 but not with the production database.
Leon Schaeps
RE: Upgrade Liferay 5.2.3 -> 6.0.3
21 de Julho de 2010 23:41
Resposta

Leon Schaeps

Ranking: New Member

Mensagens: 9

Data de entrada: 17 de Junho de 2009

Mensagens recentes

Marek Wianecki:
Leo,
I have 2 Liferay nodes (cluster) with mod_jk, and mysql. We have some webcontent and some documents in document library so installation isn't pure test. This is my upgrade procedure which worked:
1. Liferay emoticon and DB backup
2. extract liferay to destination folder
3. start liferay on its defaults (it looks like you have to do it before upgrade)
4. liferay shutdown
5. configure Liferay
#portal-ext.properties
jdbc.default.jndi.name=jdbc/LiferayPool
dl.file.max.size=15728640
dl.file.extensions=.bmp,.css,.doc,.dot,.gif,.gz,.htm,.html,.jpg,.js,.lar,.odb,.odf,.odg,.odp,.ods,.odt,.pdf,.png,.ppt,.rtf,.swf,.sxc,.sxi,.sxw,.tar,.tiff,.tgz,.txt,.vsd,.xls,.xml,.zip,.flv
permissions.user.check.algorithm=5

#modify files:
/data/jackrabbit/repository.xml (my jackrabbit uses mysql)
/tomcat-6.0.26/conf/context.xml (cluster)
/tomcat-6.0.26/conf/server.xml (cluster)
/tomcat-6.0.26/conf/Catalina/localhost/ROOT.xml (mysql data source config)

6. remove all sevencogs apps (upgrade always fails because of it)
7. start liferay, watch catalina.out for errors
8. shutdown
9. remove permissions.user.check.algorithm=5
10. add image.hook.impl=com.liferay.portal.image.DatabaseHook
11. startup liferay

I hope it helps ...


Thanks Marek,

I was able to upgrade emoticon
This upgrade is without the content of the Document Library, this is probably hitting http://issues.liferay.com/browse/LPS-11099

I followed your procedure.

Thanks
Marek Wianecki
RE: Upgrade Liferay 5.2.3 -> 6.0.3
22 de Julho de 2010 03:42
Resposta

Marek Wianecki

Ranking: New Member

Mensagens: 15

Data de entrada: 10 de Maio de 2010

Mensagens recentes

well, our content library was upgraded but we've hit LPS-11286. Im glad I helped emoticon
Dennis Greiffenberg
RE: Upgrade Liferay 5.2.3 -> 6.0.3
18 de Outubro de 2010 08:56
Resposta

Dennis Greiffenberg

Ranking: Regular Member

Mensagens: 222

Data de entrada: 30 de Abril de 2007

Mensagens recentes

Hi Marek,

unfortunately your solutions doesn't work for me.
I'm trying to upgrade from 5.2.3 to 6.0.5 on MySQL and whenever I run tomcat for the first time (pointing to a copy of the 5.2.3 database) i get the following error:

 1Starting Liferay Portal Community Edition 6.0.5 CE (Bunyan / Build 6005 / August 16, 2010)
 215:51:49,208 ERROR [JDBCExceptionReporter:101] Table 'tpliferay6.lock_' doesn't exist
 315:51:49,997 INFO  [BaseDB:399] Database does not support case sensitive queries
 415:51:50,008 INFO  [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.UpgradeProcess_6_0_0
 515:51:50,009 INFO  [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeSchema
 615:51:51,358 INFO  [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v6_0_0.UpgradeAsset
 715:51:51,840 ERROR [MainServlet:202] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'tagId' in 'field list'
 8com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'tagId' in 'field list'
 9        at com.liferay.portal.events.StartupAction.run(StartupAction.java:53)
10        at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1166)
11        at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:199)
12        at javax.servlet.GenericServlet.init(GenericServlet.java:212)
13        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
14        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
15        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4187)
16        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4496)
17        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
18        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
19        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
20        at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
21        at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
22        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
23        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
24        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
25        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
26        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
27        at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
28        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
29        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
30        at org.apache.catalina.core.StandardService.start(StandardService.java:519)
31        at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
32        at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
33        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
34        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
35        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
36        at java.lang.reflect.Method.invoke(Method.java:597)
37        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
38        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
39Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'tagId' in 'field list'
40        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:114)
41        at com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:80)
42        at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:37)
43        at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:73)
44        at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:40)
45        at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:94)
46        at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:117)
47        at com.liferay.portal.events.StartupAction.run(StartupAction.java:47)
48        ... 29 more
49Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'tagId' in 'field list'
50        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:114)
51        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:130)
52        at com.liferay.portal.upgrade.UpgradeProcess_6_0_0.doUpgrade(UpgradeProcess_6_0_0.java:45)
53        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:111)
54        ... 36 more
55Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'tagId' in 'field list'
56        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
57        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
58        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
59        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
60        at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)
61        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1313)
62        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1585)
63        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1500)
64        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1485)
65        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
66        at com.liferay.portal.upgrade.v6_0_0.UpgradeAsset.addProperty(UpgradeAsset.java:180)
67        at com.liferay.portal.upgrade.v6_0_0.UpgradeAsset.copyProperties(UpgradeAsset.java:374)
68        at com.liferay.portal.upgrade.v6_0_0.UpgradeAsset.copyEntriesToCategories(UpgradeAsset.java:330)
69        at com.liferay.portal.upgrade.v6_0_0.UpgradeAsset.updateAssetCategories(UpgradeAsset.java:421)
70        at com.liferay.portal.upgrade.v6_0_0.UpgradeAsset.doUpgrade(UpgradeAsset.java:387)
71        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:111)
72        ... 39 more
73Stopping the server due to unexpected startup errors


I'd appreciate any help on that.

Many thanks,
Dennis
Jatin Panchal
RE: Upgrade Liferay 5.2.3 -> 6.0.3
1 de Dezembro de 2010 22:10
Resposta

Jatin Panchal

Ranking: New Member

Mensagens: 15

Data de entrada: 26 de Julho de 2010

Mensagens recentes

Hi Dennis,

I am facing the same problem.
kindly help me if someone have complete solution
Dennis Greiffenberg
RE: Upgrade Liferay 5.2.3 -> 6.0.3
1 de Dezembro de 2010 23:10
Resposta

Dennis Greiffenberg

Ranking: Regular Member

Mensagens: 222

Data de entrada: 30 de Abril de 2007

Mensagens recentes

Hi Jatin,

I don't know if there's a solution to this problem. It must be somehow correlated to the data as this seems not to be a general error during the upgrade. However, there's quite a few people out there having this problem.

Best regards,
Dennis
Matthieu Levesque
RE: Upgrade Liferay 5.2.3 -> 6.0.3
7 de Dezembro de 2010 03:19
Resposta

Matthieu Levesque

Ranking: Junior Member

Mensagens: 56

Data de entrada: 13 de Fevereiro de 2009

Mensagens recentes

Hi,

I'm also having the same problem with Liferay EE 6.

After looking at the create database script of Liferay, it looks like they droped this index IX_6C5E6512 to replace it with this new one IX_2F8FED9C:

Old Index:
1UNIQUE KEY `IX_6C5E6512` (`folderId`,`name`,`version`)


New Index:
1create unique index IX_2F8FED9C on DLFileVersion (groupId, folderId, name, version);


They added the field version to the index.

I will try to drop the index IX_6C5E6512 and see if the upgrade will go.

Will post my results.

EDIT:

After dropping the index the upgrade went all the way.

EDIT(2): After specifying the right upgrade.processes. I didn't have to drop the index.


Maybe this post will help too:
http://www.liferay.com/community/forums/-/message_boards/message/6712282

Matthieu
Jatin Panchal
RE: Upgrade Liferay 5.2.3 -> 6.0.3
10 de Dezembro de 2010 00:07
Resposta

Jatin Panchal

Ranking: New Member

Mensagens: 15

Data de entrada: 26 de Julho de 2010

Mensagens recentes

Hi,
I am trying to upgrade liferay version 5.2.3 to 6.0 directly. That causes this error.
Instead of that I have found one solution and that works fine for me.
Follow these steps.
1) do upgrading of liferay version step-by-step.
-->I mean first check your Release_ table and see what values buildNumber have.
-->Let's say if it is 5203 then change it by one step ahead say 6000.
-->Also for build number take reference of ReleaseInfo.java file from liferay portal source.
2) After that restart server again and if it fails again then increament build number in Release_ table by
6001 and again restart.

continue this steps until you upgrade db successfully.

If it successfully done then check your Release_ table and see buildNumber column's value changes from older one to latest version.

Thanks.
Tom Thomas
RE: Upgrade Liferay 5.2.3 -> 6.0.3
2 de Fevereiro de 2011 15:43
Resposta

Tom Thomas

Ranking: Junior Member

Mensagens: 33

Data de entrada: 10 de Setembro de 2009

Mensagens recentes

Same as everyone else, I'm trying to upgrade from the Tomcat 5.2.3 bundle to Tomcat 6.0.5 bundle. The db is SQL Server 2005. I believe I have tried everything above with no luck.

The upgrade works just fine if the db is MySql - for what it's worth.
Ali Faisal
RE: Upgrade Liferay 5.2.3 -> 6.0.3
1 de Junho de 2011 08:51
Resposta

Ali Faisal

Ranking: New Member

Mensagens: 8

Data de entrada: 3 de Fevereiro de 2011

Mensagens recentes

Well I am having this problem as well (SQL Server) did anyone figure out how it was solved? so far I have tried everything recommended above.

Thanks.

This is the error I am having. Clearly its the primary key violation.

15:15:32,088 ERROR [MainServlet:214] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK__AssetEnt__D124D3D52E26C93A'. Cannot insert duplicate key in object 'dbo.AssetEntry'.
com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK__AssetEnt__D124D3D52E26C93A'. Cannot insert duplicate key in object 'dbo.AssetEntry'.
at com.liferay.portal.events.StartupAction.run(StartupAction.java:52)
at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1190)
at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:211)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
Mudasar Kalwar
RE: Upgrade Liferay 5.2.3 -> 6.0.3
13 de Setembro de 2012 05:57
Resposta

Mudasar Kalwar

Ranking: New Member

Mensagens: 23

Data de entrada: 13 de Setembro de 2012

Mensagens recentes

Hi JR Houn,

I have made changes as you mentioned but still getting the following errors.
12:47:57,781 INFO [PortalImpl:3829] Current URL /image/image_gallery?uuid=f718eebc-a933-429a-bfb5-44c89af3a037&groupid=14&t=1325834593850 generates exception: No default image exists for 0
12:48:05,750 ERROR [HookFactory:41] java.lang.ClassNotFoundException: com.liferay.portal.image.FileSystemHook,com.liferay.portal.image.DatabaseHook
java.lang.ClassNotFoundException: com.liferay.portal.image.FileSystemHook,com.liferay.portal.image.DatabaseHook
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1387)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1233)
at com.liferay.portal.image.HookFactory.getInstance(HookFactory.java:37)
at com.liferay.portal.model.impl.ImageImpl.getTextObj(ImageImpl.java:35)
at com.liferay.portal.servlet.ImageServlet.getImageBytes(ImageServlet.java:265)
at com.liferay.portal.servlet.ImageServlet.writeImage(ImageServlet.java:370)
at com.liferay.portal.servlet.ImageServlet.service(ImageServlet.java:121)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:196)
at com.liferay.portal.servlet.filters.cache.CacheFilter.processFilter(CacheFilter.java:399)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:123)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:196)
at com.liferay.portal.servlet.filters.etag.ETagFilter.processFilter(ETagFilter.java:45)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:123)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:196)
at com.liferay.portal.servlet.filters.header.HeaderFilter.processFilter(HeaderFilter.java:129)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:123)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:196)
at com.liferay.portal.servlet.filters.sso.ntlm.NtlmPostFilter.processFilter(NtlmPostFilter.java:81)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:123)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:196)
at com.liferay.portal.sharepoint.SharepointFilter.processFilter(SharepointFilter.java:179)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:123)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:196)
at com.liferay.portal.servlet.filters.virtualhost.VirtualHostFilter.processFilter(VirtualHostFilter.java:240)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:123)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:196)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:126)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:196)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:126)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:738)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:196)
at com.liferay.portal.servlet.filters.threadlocal.ThreadLocalFilter.processFilter(ThreadLocalFilter.java:35)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:123)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
at java.lang.Thread.run(Thread.java:662)
12:48:05,766 ERROR [ImageImpl:40] Error reading image 24710
java.lang.NullPointerException
at com.liferay.portal.model.impl.ImageImpl.getTextObj(ImageImpl.java:37)
at com.liferay.portal.servlet.ImageServlet.getImageBytes(ImageServlet.java:265)
at com.liferay.portal.servlet.ImageServlet.writeImage(ImageServlet.java:370)
at com.liferay.portal.servlet.ImageServlet.service(ImageServlet.java:121)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:196)
at com.liferay.portal.servlet.filters.cache.CacheFilter.processFilter(CacheFilter.java:399)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:123)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:196)
at com.liferay.portal.servlet.filters.etag.ETagFilter.processFilter(ETagFilter.java:45)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:123)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:196)
at com.liferay.portal.servlet.filters.header.HeaderFilter.processFilter(HeaderFilter.java:129)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:123)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:196)
at com.liferay.portal.servlet.filters.sso.ntlm.NtlmPostFilter.processFilter(NtlmPostFilter.java:81)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:123)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:196)
at com.liferay.portal.sharepoint.SharepointFilter.processFilter(SharepointFilter.java:179)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:123)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:196)
at com.liferay.portal.servlet.filters.virtualhost.VirtualHostFilter.processFilter(VirtualHostFilter.java:240)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:123)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:196)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:126)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:196)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:126)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:738)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:196)
at com.liferay.portal.servlet.filters.threadlocal.ThreadLocalFilter.processFilter(ThreadLocalFilter.java:35)
at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:123)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
at java.lang.Thread.run(Thread.java:662)

Here is my changes in the portal-ext.properties file
 1#permissions.user.check.algorithm=5
 2 image.hook.impl=com.liferay.portal.image.DatabaseHook
 3 dl.hook.file.system.root.dir=${liferay.home}/data/document_library
 4#
 5# JCRHook
 6#
 7dl.hook.jcr.fetch.delay=500
 8dl.hook.jcr.fetch.max.failures=5
 9
10#
11# S3Hook
12#
13dl.hook.s3.access.key=
14dl.hook.s3.secret.key=
15dl.hook.s3.bucket.name=
16
17#
18# S3Hook
19#
20dl.hook.s3.access.key=
21dl.hook.s3.secret.key=
22dl.hook.s3.bucket.name=


I am upgrading from liferay 5.2.3 to 6.0.6 , Mysql, tomcat5.
Mudasar Kalwar
RE: Upgrade Liferay 5.2.3 -> 6.0.3
14 de Setembro de 2012 06:00
Resposta

Mudasar Kalwar

Ranking: New Member

Mensagens: 23

Data de entrada: 13 de Setembro de 2012

Mensagens recentes

Hi , every one I just successfully migrated from liferay 5.2.3 to liferay 6.0.6 , but there is a one issue I can't login with any user like I had created admin in liferay 5 and it exists but it can't login. any suggestions ?
here is the error trace:
12:44:57,803 INFO [PortalImpl:3829] Current URL /image/image_gallery?uuid=f718eebc-a933-429a-bfb5-44c89af3a037&groupid=14&t=1325834593850 generates exception: No default image exists for 0
12:45:13,022 INFO [PortalImpl:3829] Current URL /image/image_gallery?uuid=f718eebc-a933-429a-bfb5-44c89af3a037&groupid=14&t=1325834593850 generates exception: No default image exists for 0
12:46:07,336 INFO [PortalImpl:3829] Current URL /image/image_gallery?uuid=f718eebc-a933-429a-bfb5-44c89af3a037&groupid=14&t=1325834593850 generates exception: No default image exists for 0
12:46:42,048 INFO [PortalImpl:3829] Current URL /web/control_panel?doAsGroupId=14&refererPlid=24304 generates exception: {groupId=10116,privateLayout=false} does not have any layouts
12:46:42,048 INFO [PortalImpl:3841] {groupId=10116,privateLayout=false} does not have any layouts
12:46:56,726 INFO [PortalImpl:3829] Current URL /web/guest/control_panel?doAsGroupId=14&refererPlid=24304 generates exception: null
12:46:56,727 INFO [PortalImpl:3841]
12:47:05,687 INFO [PortalImpl:3829] Current URL /group/17/control_panel?doAsGroupId=14&refererPlid=24304 generates exception: null
12:47:05,688 INFO [PortalImpl:3841]
12:48:50,585 INFO [PortalImpl:3829] Current URL /image/image_gallery?uuid=f718eebc-a933-429a-bfb5-44c89af3a037&groupid=14&t=1325834593850 generates exception: No default image exists for 0


when I add the password it shows error like "You have entered invalid data. Please try again ." and "Authentication failed. Please try again. "

any help?
Thanks