Ask Questions and Find Answers
Important:
Ask is now read-only. You can review any existing questions and answers, but not add anything new.
But - don't panic! While ask is no more, we've replaced it with discuss - the new Liferay Discussion Forum! Read more here here or just visit the site here:
discuss.liferay.com
RE: Database Upgrade Error (Liferay 6.2 CE GA6 to Liferay 7.1.2 GA)
I am preparing to upgrade Liferay 6.2 CE GA6 (Build 6205) to Liferay 7.1.2 GA3 then finally to Liferay 7.2 GA1. I receive the following error when attempting to upgrade the MSSQL database. I know MSSQL support was dropped in Liferay 7, but I do have the MSSQL support drivers (sqljdbc42.jar, liferay-portal-sqlserverdb-support-1.0-SNAPSHOT) installed. Java version installed: jdk1.8.0_211
Command: \liferay-7.1\tools\portal-tools-db-upgrade-client>
.\db_upgrade.bat -j "-Dfile.encoding=UTF-8 -Duser.country=US -Duser.language=en -Duser.timezone=GMT -Xmx12288m"
Upgrade Log:
Loading jar:file:/E:/liferay-7.1/tomcat-9.0.10/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/system.properties
Exception in thread "main" java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.liferay.portal.tools.db.upgrade.client.DBUpgraderLauncher.main(DBUpgraderLauncher.java:55)
Caused by: java.lang.NoSuchMethodError: com.liferay.portal.kernel.util.ServerDetector.isGeronimo()Z
at com.liferay.portal.util.PropsUtil._getDefaultLiferayHome(PropsUtil.java:255)
at com.liferay.portal.util.PropsUtil.<init>(PropsUtil.java:103)
at com.liferay.portal.util.PropsUtil.<clinit>(PropsUtil.java:343)
at com.liferay.portal.util.PropsImpl.get(PropsImpl.java:36)
at com.liferay.portal.kernel.util.PropsUtil.get(PropsUtil.java:31)
at com.liferay.util.log4j.Log4JUtil._getLiferayHome(Log4JUtil.java:247)
at com.liferay.util.log4j.Log4JUtil._getURLContent(Log4JUtil.java:256)
at com.liferay.util.log4j.Log4JUtil.configureLog4J(Log4JUtil.java:101)
at com.liferay.util.log4j.Log4JUtil.configureLog4J(Log4JUtil.java:60)
at com.liferay.portal.util.InitUtil.init(InitUtil.java:97)
at com.liferay.portal.util.InitUtil.initWithSpring(InitUtil.java:187)
at com.liferay.portal.util.InitUtil.initWithSpring(InitUtil.java:162)
at com.liferay.portal.tools.DBUpgrader.main(DBUpgrader.java:72)
Command: \liferay-7.1\tools\portal-tools-db-upgrade-client>
.\db_upgrade.bat -j "-Dfile.encoding=UTF-8 -Duser.country=US -Duser.language=en -Duser.timezone=GMT -Xmx12288m"
Upgrade Log:
Loading jar:file:/E:/liferay-7.1/tomcat-9.0.10/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/system.properties
Exception in thread "main" java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.liferay.portal.tools.db.upgrade.client.DBUpgraderLauncher.main(DBUpgraderLauncher.java:55)
Caused by: java.lang.NoSuchMethodError: com.liferay.portal.kernel.util.ServerDetector.isGeronimo()Z
at com.liferay.portal.util.PropsUtil._getDefaultLiferayHome(PropsUtil.java:255)
at com.liferay.portal.util.PropsUtil.<init>(PropsUtil.java:103)
at com.liferay.portal.util.PropsUtil.<clinit>(PropsUtil.java:343)
at com.liferay.portal.util.PropsImpl.get(PropsImpl.java:36)
at com.liferay.portal.kernel.util.PropsUtil.get(PropsUtil.java:31)
at com.liferay.util.log4j.Log4JUtil._getLiferayHome(Log4JUtil.java:247)
at com.liferay.util.log4j.Log4JUtil._getURLContent(Log4JUtil.java:256)
at com.liferay.util.log4j.Log4JUtil.configureLog4J(Log4JUtil.java:101)
at com.liferay.util.log4j.Log4JUtil.configureLog4J(Log4JUtil.java:60)
at com.liferay.portal.util.InitUtil.init(InitUtil.java:97)
at com.liferay.portal.util.InitUtil.initWithSpring(InitUtil.java:187)
at com.liferay.portal.util.InitUtil.initWithSpring(InitUtil.java:162)
at com.liferay.portal.tools.DBUpgrader.main(DBUpgrader.java:72)
Hi Broody,
It's important to recall a few things:
- You can go directly from 6.2 to 7.2 without stopping in 7.1
- MS SQL Server is not supported in CE version, even adding the driver. If you still need it I think there is a plugin for it in the marketplace (at least for 7.1)
- The error you show seems to be related with the liferay.home and server properties, please check them carefully.
I hope it helps.
It's important to recall a few things:
- You can go directly from 6.2 to 7.2 without stopping in 7.1
- MS SQL Server is not supported in CE version, even adding the driver. If you still need it I think there is a plugin for it in the marketplace (at least for 7.1)
- The error you show seems to be related with the liferay.home and server properties, please check them carefully.
I hope it helps.
Environment: Liferay 6.2 CE GA6 (Build 6205), Windows Server 2012 R2, MSSQL Server 2014, Java 1.80_211Issue: Error when attempting to upgrade from Liferay 6.2 CE GA6 to Liferay 7.2 GA1
I receive the same error when attempting to upgrade the database. Below are contents of the app-server, portal-upgrade-ext, and portal-upgrade-database properties. I have tried both backslash and forwardslash and receive the same error. Thank you.
app-server.properties:
dir=E:/liferay-7.2/tomcat-9.0.17
extra.lib.dirs=/bin
global.lib.dir=/lib
portal.dir=/webapps/ROOT
server.detector.server.id=tomcat
portal-upgrade-database.properties:
jdbc.default.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbc.default.url=jdbc:sqlserver://X.X.X.X:1433;databaseName=dbname
jdbc.default.username=myuser
jdbc.default.password=mypass
portal-upgrade-ext.properties:
liferay.home=E:/liferay-7.2
dl.store.impl=com.liferay.portal.store.file.system.AdvancedFileSystemStoremodule.framework.base.dir=E:/liferay-7.2/osgi
Upgrade.log Output:
.\db_upgrade.bat -j "-Dfile.encoding=UTF-8 -Duser.country=US -Duser.language=en -Duser.timezone=GMT -Xmx12288m"
JVM arguments: -Dfile.encoding=UTF-8 -Duser.country=US -Duser.language=en -Duser.timezone=GMT -Xmx12288m -Dexternal-properties=portal-upgrade.properties -Dserver.detector.server.id=tomcat
Loading jar:file:/E:/liferay-7.2/tools/portal-tools-db-upgrade-client/lib/portal-impl.jar!/system.properties
Loading jar:file:/E:/liferay-7.2/tools/portal-tools-db-upgrade-client/lib/portal-impl.jar!/system.properties
Loading jar:file:/E:/liferay-7.2/tomcat-9.0.17/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/system.properties
Exception in thread "main" java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.liferay.portal.tools.db.upgrade.client.DBUpgraderLauncher.main(DBUpgraderLauncher.java:55)Caused by: java.lang.NoSuchMethodError: com.liferay.portal.kernel.util.ServerDetector.isGeronimo()Zat com.liferay.portal.util.PropsUtil._getDefaultLiferayHome(PropsUtil.java:255)
at com.liferay.portal.util.PropsUtil.<init>(PropsUtil.java:103)
at com.liferay.portal.util.PropsUtil.<clinit>(PropsUtil.java:343)
at com.liferay.portal.util.PropsImpl.get(PropsImpl.java:36)
at com.liferay.portal.kernel.util.PropsUtil.get(PropsUtil.java:31)
at com.liferay.util.log4j.Log4JUtil._getLiferayHome(Log4JUtil.java:247)
at com.liferay.util.log4j.Log4JUtil._getURLContent(Log4JUtil.java:256)
at com.liferay.util.log4j.Log4JUtil.configureLog4J(Log4JUtil.java:101)
at com.liferay.util.log4j.Log4JUtil.configureLog4J(Log4JUtil.java:60)
at com.liferay.portal.util.InitUtil.init(InitUtil.java:97)
at com.liferay.portal.util.InitUtil.initWithSpring(InitUtil.java:187)
at com.liferay.portal.util.InitUtil.initWithSpring(InitUtil.java:162)
at com.liferay.portal.tools.DBUpgrader.main(DBUpgrader.java:72)
I receive the same error when attempting to upgrade the database. Below are contents of the app-server, portal-upgrade-ext, and portal-upgrade-database properties. I have tried both backslash and forwardslash and receive the same error. Thank you.
app-server.properties:
dir=E:/liferay-7.2/tomcat-9.0.17
extra.lib.dirs=/bin
global.lib.dir=/lib
portal.dir=/webapps/ROOT
server.detector.server.id=tomcat
portal-upgrade-database.properties:
jdbc.default.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbc.default.url=jdbc:sqlserver://X.X.X.X:1433;databaseName=dbname
jdbc.default.username=myuser
jdbc.default.password=mypass
portal-upgrade-ext.properties:
liferay.home=E:/liferay-7.2
dl.store.impl=com.liferay.portal.store.file.system.AdvancedFileSystemStoremodule.framework.base.dir=E:/liferay-7.2/osgi
Upgrade.log Output:
.\db_upgrade.bat -j "-Dfile.encoding=UTF-8 -Duser.country=US -Duser.language=en -Duser.timezone=GMT -Xmx12288m"
JVM arguments: -Dfile.encoding=UTF-8 -Duser.country=US -Duser.language=en -Duser.timezone=GMT -Xmx12288m -Dexternal-properties=portal-upgrade.properties -Dserver.detector.server.id=tomcat
Loading jar:file:/E:/liferay-7.2/tools/portal-tools-db-upgrade-client/lib/portal-impl.jar!/system.properties
Loading jar:file:/E:/liferay-7.2/tools/portal-tools-db-upgrade-client/lib/portal-impl.jar!/system.properties
Loading jar:file:/E:/liferay-7.2/tomcat-9.0.17/webapps/ROOT/WEB-INF/lib/portal-impl.jar!/system.properties
Exception in thread "main" java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.liferay.portal.tools.db.upgrade.client.DBUpgraderLauncher.main(DBUpgraderLauncher.java:55)Caused by: java.lang.NoSuchMethodError: com.liferay.portal.kernel.util.ServerDetector.isGeronimo()Zat com.liferay.portal.util.PropsUtil._getDefaultLiferayHome(PropsUtil.java:255)
at com.liferay.portal.util.PropsUtil.<init>(PropsUtil.java:103)
at com.liferay.portal.util.PropsUtil.<clinit>(PropsUtil.java:343)
at com.liferay.portal.util.PropsImpl.get(PropsImpl.java:36)
at com.liferay.portal.kernel.util.PropsUtil.get(PropsUtil.java:31)
at com.liferay.util.log4j.Log4JUtil._getLiferayHome(Log4JUtil.java:247)
at com.liferay.util.log4j.Log4JUtil._getURLContent(Log4JUtil.java:256)
at com.liferay.util.log4j.Log4JUtil.configureLog4J(Log4JUtil.java:101)
at com.liferay.util.log4j.Log4JUtil.configureLog4J(Log4JUtil.java:60)
at com.liferay.portal.util.InitUtil.init(InitUtil.java:97)
at com.liferay.portal.util.InitUtil.initWithSpring(InitUtil.java:187)
at com.liferay.portal.util.InitUtil.initWithSpring(InitUtil.java:162)
at com.liferay.portal.tools.DBUpgrader.main(DBUpgrader.java:72)
Copyright © 2025 Liferay, Inc
• Privacy Policy
Powered by Liferay™