1. Home
  2. Portal
  3. Error in upgrade from 6.2 to 7.1

Error in upgrade from 6.2 to 7.1

Jin suku, modified 6 Years ago.
Error in upgrade from 6.2 to 7.1
New Member Posts: 5 Join Date: 5/17/17 Recent Posts
I am upgrading from Liferay 6.2-ce-GA5 to Liferay 7.1-GA3.  I get  error like these : 
  1. 2019-06-26 10:56:22.150 INFO  [main][UpgradeProcess:107] Completed upgrade process com.liferay.portal.upgrade.v7_0_0.UpgradeKernelPackage in 173 ms
  2. 2019-06-26 10:56:22.151 INFO  [main][UpgradeProcess:93] Upgrading com.liferay.portal.upgrade.v7_0_0.UpgradeSharding
  3. 2019-06-26 10:56:22.151 INFO  [main][LoggingTimer:83] Starting com.liferay.portal.upgrade.v7_0_0.UpgradeSharding#getShardNames
  4. 2019-06-26 10:56:22.152 INFO  [main][LoggingTimer:43] Completed com.liferay.portal.upgrade.v7_0_0.UpgradeSharding#getShardNames in 1 ms
  5. 2019-06-26 10:56:22.153 INFO  [main][UpgradeProcess:107] Completed upgrade process com.liferay.portal.upgrade.v7_0_0.UpgradeSharding in 2 ms
  6. 2019-06-26 10:56:22.153 INFO  [main][UpgradeProcess:93] Upgrading com.liferay.portal.upgrade.v7_0_0.UpgradeAddress
  7. 2019-06-26 10:56:22.155 INFO  [main][LoggingTimer:83] Starting com.liferay.portal.kernel.upgrade.UpgradeProcess#alter
  8. 2019-06-26 10:56:22.320 INFO  [main][LoggingTimer:43] Completed com.liferay.portal.kernel.upgrade.UpgradeProcess#alter in 165 ms
  9. 2019-06-26 10:56:22.320 INFO  [main][UpgradeProcess:107] Failed upgrade process com.liferay.portal.upgrade.v7_0_0.UpgradeAddress in 167 ms
  10. 2019-06-26 10:56:22.321 INFO  [main][UpgradeProcess:107] Failed upgrade process com.liferay.portal.upgrade.UpgradeProcess_7_0_0 in 17995 ms
  11. com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.lang.NullPointerException
  12.     at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:101)
  13.     at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:176)
  14.     at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:143)
  15.     at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:125)
  16.     at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:151)
  17.     at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:85)
  18.     at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:174)
  19.     at com.liferay.portal.tools.DBUpgrader.main(DBUpgrader.java:107)
  20.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  21.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  22.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  23.     at java.lang.reflect.Method.invoke(Method.java:498)
  24.     at com.liferay.portal.tools.db.upgrade.client.DBUpgraderLauncher.main(DBUpgraderLauncher.java:55)
  25. Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: java.lang.NullPointerException
  26.     at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:101)
  27.     at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:142)
  28.     at com.liferay.portal.upgrade.UpgradeProcess_7_0_0.doUpgrade(UpgradeProcess_7_0_0.java:82)
  29.     at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:96)
  30.     ... 12 more
  31. Caused by: java.lang.NullPointerException
  32.     at java.io.Reader.<init>(Reader.java:78)
  33.     at java.io.InputStreamReader.<init>(InputStreamReader.java:72)
  34.     at com.liferay.portal.kernel.upgrade.UpgradeProcess.getIndexesSQL(UpgradeProcess.java:486)
  35.     at com.liferay.portal.kernel.upgrade.UpgradeProcess.alter(UpgradeProcess.java:422)
  36.     at com.liferay.portal.upgrade.v7_0_0.UpgradeAddress.doUpgrade(UpgradeAddress.java:27)
  37.     at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:96)
  38.     ... 15 more

Plz suggest.

Thanks
thumbnail
Alberto Chaparro, modified 6 Years ago.
RE: Error in upgrade from 6.2 to 7.1
Liferay Master Posts: 560 Join Date: 4/25/11 Recent Posts
Hi Jin,The error is caused because this is null:https://github.com/liferay/liferay-portal/blob/master/portal-kernel/src/com/liferay/portal/kernel/upgrade/UpgradeProcess.java#L480
This can only happen when that file or folder (META-INF/sql/indexes.sql) doesn't exist, it should be inside the portal-impl.jar o in classes folder. There could be a problem with the permissions or paths. From my experience, it is a problem with the configuration/files in your environment.Can you check it?Thanks.
Jin suku, modified 6 Years ago.
RE: Error in upgrade from 6.2 to 7.1
New Member Posts: 5 Join Date: 5/17/17 Recent Posts
Alberto Chaparro:

Hi Jin,The error is caused because this is null:https://github.com/liferay/liferay-portal/blob/master/portal-kernel/src/com/liferay/portal/kernel/upgrade/UpgradeProcess.java#L480
This can only happen when that file or folder (META-INF/sql/indexes.sql) doesn't exist, it should be inside the portal-impl.jar o in classes folder. There could be a problem with the permissions or paths. From my experience, it is a problem with the configuration/files in your environment.Can you check it?Thanks.
1. Added a file called  "com.liferay.portal.upgrade.internal.configuration.ReleaseManagerConfiguration.config" to "[Liferay Home]/osgi/configs" with content :

autoUpgrade="false"

2. "com.liferay.portal.search.configuration.IndexStatusManagerConfiguration.config" with content:

indexReadOnly="true"

3. In "[Liferay Home]/tools/portal-tools-db-upgrade-client/":

. app-server.properties:

dir=/Users/admin/NhanHoang/ws-LIFERAY7/LiferayProjectSDKwithDevStudioCommunityEdition/ws-mocst/portal-7.1/tomcat-9.0.10
extra.lib.dirs=/Users/admin/NhanHoang/ws-LIFERAY7/LiferayProjectSDKwithDevStudioCommunityEdition/ws-mocst/portal-7.1/tomcat-9.0.10/bin
global.lib.dir=/Users/admin/NhanHoang/ws-LIFERAY7/LiferayProjectSDKwithDevStudioCommunityEdition/ws-mocst/portal-7.1/tomcat-9.0.10/lib
portal.dir=/Users/admin/NhanHoang/ws-LIFERAY7/LiferayProjectSDKwithDevStudioCommunityEdition/ws-mocst/portal-7.1/tomcat-9.0.10/webapp/ROOT
server.detector.server.id=tomcat

.portal-upgrade-ext.properties:

liferay.home=/Users/admin/NhanHoang/ws-LIFERAY7/LiferayProjectSDKwithDevStudioCommunityEdition/ws-mocst/portal-7.1
module.framework.base.dir=/Users/admin/NhanHoang/ws-LIFERAY7/LiferayProjectSDKwithDevStudioCommunityEdition/ws-mocst/portal-7.1/osgi
dl.store.impl=com.liferay.portal.store.file.system.FileSystemStore

.portal-upgrade-database.properties:

jdbc.default.driverClassName=com.mysql.jdbc.Driver
jdbc.default.password=s0968abc@
jdbc.default.url=jdbc:mysql://localhost/delcofarm71?characterEncoding=UTF-8&dontTrackOpenResources=true&holdResultsOpenOverStatementClose=true&useFastDateParsing=false&useUnicode=true
jdbc.default.username=root

Which one do i need check more ?