Upgrading from Portal 5.2.8 to Portal 6.1.10 with JNDI datasource in Weblogic fails

This article is a legacy article. It applies to previous versions of the Liferay product. While the article is no longer maintained, the information may still be applicable.

Setting the JNDI datasource in Weblogic and upgrading from Portal 5.2.8. to Portal 6.1 causes upgrades to fail with messages like:

ERROR [MainServlet:201] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected NUMBER got TIMESTAMP

or

ERROR [MainServlet:201] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: Protocol violation

Resolution

This issue results from an inconsistent datatype error when using a JNDI (LPS-27043). The following are two available options to work around the issue:

  1. Upgrade to an updated version of Liferay Portal 6.1 (resolved via hotfix or a later version of the portal)

    OR

  2. Use the portal-ext.properties to manage the database settings rather than datasource.

Was this article helpful?
0 out of 0 found this helpful