Upgrade from 6.2 to 7.0, error occurred

[hungt tp，修改在7 年前。]

HI everyone,
I'm new to Liferay. I am testing the upgrading from 6.2 to 7.0. After do database upgrade with upgrade tool (com.liferay.portal.tools.db.upgrade.client), I used command upgrade:check and it produced this:

Dry run upgrade com.liferay.sync.service from 1.0.2-step-1 to 1.0.2 and its dependent modules

Then, I used command upgrade:execute com.liferay.sync.service and it throw exception like this:

INFO - Upgrading com.liferay.sync.upgrade.v1_0_2.UpgradeSyncDLObject
INFO - Starting com.liferay.sync.upgrade.v1_0_2.UpgradeSyncDLObject#doUpgrade
INFO - Completed com.liferay.sync.upgrade.v1_0_2.UpgradeSyncDLObject#doUpgrade in 102 ms
INFO - Completed upgrade process com.liferay.sync.upgrade.v1_0_2.UpgradeSyncDLObject in 104ms
gogo: RuntimeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.exception.PortalException: java.sql.BatchUpdateException: Batch entry 0 insert into SyncDLObject (syncDLObjectId, companyId, userId, userName, createTime, modifiedTime, repositoryId, parentFolderId, treePath, name, extension, mimeType, description, changeLog, version, versionId, size_, event, type_, typePK, typeUuid) values (24986, 20154, 20433, 'hungtp ttm', 1469679579107, 1469679579107, 20181, 0, '/', 'chart.png', 'png', 'image/png', NULL, NULL, '1.0', 21260, 6055, 'add', 'file', 21259, '8a3d327b-9ec6-4e2a-a643-0275441a4c87') was aborted.  Call getNextException to see the cause.

May someone explains this exception for me? I checked SyncDLObject table, the record existed, why did this process insert query for this record? How to fix it?

Thanks.

[Thirumal Reddy，修改在7 年前。]

Hi hungt,
can you explain me what steps you have done.

Thirumal.

[hungt tp，修改在7 年前。]

Thirumal Reddy:

Hi hungt,
can you explain me what steps you have done.

Thirumal.

Thanks for your reply.
This is steps I have done to upgrade:
1. Download Liferay 7 bundle with Tomcat then unzip it.
2. Copy folder 'data' and file portal-ext.properties from Liferay 6.2 to Liferay 7.
3. Run com.liferay.portal.tools.db.upgrade.client.jar to upgrade database.
4. After upgrade tool completed, it shows Gogo Shell and I use 'upgrade:check' to see modules failed to upgrade.
After I executed com.liferay.sync.service, it throws this exception.

[Thirumal Reddy，修改在7 年前。]

Hi
create a file inside bundles\osgi\configs with the name
com.liferay.portal.search.configuration.IndexStatusManagerConfiguration.cfg
in that add this property
indexReadOnly=true

and before running upgradation tool please make sure following things,
1) JDK 1.8(for confirming open cmd and check java version with this cmd "javac -version")
2) u r database with utf-8 charset and tables also in utf-8 charset format.(if you have so many tables in anotherr charset format then inform me
i will give a query it will convert all into utf-8 format.)

now run upgradation tool (java -jar com.liferay.portal.tools.db.upgrade.client.jar -j "-Dfile.encoding=UTF8 -Duser.country=US -Duser.language=en -Duser.timezone=GMT -Xmx4096m")

for more info clearly see this link

Thirumal.

[hung tp，修改在7 年前。]

Hi Thirumal,
I did as you said but it still did not work . I uploaded my log file for more details.

[Thirumal Reddy，修改在7 年前。]

Hi
which version of liferay 7 are using ,
i think this issue was closed in Liferay 7 GA2.
if your migrating some other try to migrate into 7 GA2.

[hung tp，修改在7 年前。]

Hi,

Thanks for your reply .
I'm using liferay-ce-portal-tomcat-7.0-ga2-20160610113014153 version. I think maybe we got error with class UpgradeSyncDLObject from package com.liferay.sync.upgrade.v1_0_2. Is there newer build I can download?

[hung tp，修改在7 年前。]

Hi

Before I have used PostgreSQL to do the upgrading and it have failed. So I tried to do it with MySQL and it did successfully. So I think we have problem with query for PostgreSQL?

Here are details on my environment for each time I do upgrading:
-MySQL: Tomcat 8.0.32, MySQL 5.6, from Liferay 6.2 CE GA 6 to Liferay 7 CE GA 2 build 20160610113014153.
-PostgreSQL: Tomcat 8.0.32, PostgreSQL 9.4, from Liferay 6.2 CE GA 6 to Liferay 7 CE GA 2 build 20160610113014153.

I also attached log for each time.

Thanks.

[Jorge Díaz，修改在7 年前。]

hung tp:

Before I have used PostgreSQL to do the upgrading and it have failed. So I tried to do it with MySQL and it did successfully. So I think we have problem with query for PostgreSQL?

That upgrade problem is caused by following Liferay Sync issue: https://issues.liferay.com/browse/SYNC-1666

If you want to use Postgresql and you don't use Liferay Sync, you can ignore the error and remove Liferay Sync osgi modules.