Upgrade to Liferay 7 from 6.2

[Manish Jha, modificado 6 Anos atrás.]

I am getting following error while upgrading from 6.2 to 7.
Data base is oracle 12 .

03:34:14,394 ERROR [localhost-startStop-1][JDBCExceptionReporter:234] ORA-00904: "CLASSNAMEI0_"."MVCCVERSION": invalid identifier_ [Sanitized]
03:34:14,397 ERROR [localhost-startStop-1][MainServlet:272] com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query

[David H Nebinger, modificado 6 Anos atrás.]

Liferay 7 CE does not support enterprise databases, you'll need to step up to Liferay DXP for oracle usage.








Come meet me at the 2017 LSNA!

[Manish Jha, modificado 6 Anos atrás.]

My Liferay DXP is enterprise version, I downloaded from liferay.com. However, I did not apply the licence before the upgrade.
Should I put the liferay licence in deploy folder before starting upgrade process ?

[Alberto Chaparro, modificado 6 Anos atrás.]

N
Hi Manish,

The exception is not caused by the use of Oracle. The error is caused because the table Classname doesn't contains mvccVersion field. However the process UpgradeMvccVersion which is executed at the beginning of the upgrade should create those fields, could you check the logs just in case there is an error earlier.

Best regards.

[Vamsi Tekuru, modificado 6 Anos atrás.]

Hello I am having the same error message and I am unable to move forward on this.

From
Database :racle 11 g
Liferay :: Liferay 6.1.20

TO
Database :racle 12 c
Liferay :: Liferay DXP SP3

ERROR STACK TRACE

Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "CLASSNAMEI0_"."MVCCVERSION": invalid identifier_ [Sanitized]

Caused by: Error : 904, Position : 51, Sql = select classnamei0_.classNameId as classNam1_229_, classnamei0_.mvccVersion as mvccVers2_229_, classnamei0_.value as value229_ from ClassName_ classnamei0_ where (classnamei0_.value=:1 ), OriginalSql = select classnamei0_.classNameId as classNam1_229_, classnamei0_.mvccVersion as mvccVers2_229_, classnamei0_.value as value229_ from ClassName_ classnamei0_ where (classnamei0_.value=? ), Error Msg = ORA-00904: "CLASSNAMEI0_"."MVCCVERSION": invalid identifier_ [Sanitized]
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)

java.lang.NullPointerException
at com.liferay.util.dao.orm.CustomSQLUtil.reloadCustomSQL(CustomSQLUtil.java:104)

[David H Nebinger, modificado 6 Anos atrás.]

Looks like you didn't do the upgrade of the database before first launch...









Come meet me at the 2017 LSNA!

[Vamsi Tekuru, modificado 6 Anos atrás.]

Hi Dave,

i havent started my liferay Bundled tomcat Server at all. I did setup my Oracle 12c Database. Copied my oracle 11g Database Data into 12c Database. Then followed the guide below and started with Database upgrade Directly ::

https://www.liferay.com/documents/10182/1645493/How+to+Upgrade+to+Liferay+DXP/6d28e96b-7de3-44c7-9692-3631c7d226fc?version=1.5

Here is the java command Line execution that I have used::

java -jar com.liferay.portal.tools.db.upgrade.client.jar -j "-Dfile.encoding=UTF8 -Duser.country=US -Duser.language=en -Duser.timezone=GMT -Xmx1024m"

[David H Nebinger, modificado 6 Anos atrás.]

Okay, that's the right path then.

Have you opened a LESA ticket on this yet?











Come meet me at the 2017 LSNA!