Upgrading to Yellowfin 8.0.4 error: String cannot be cast to Date

Yellowfin FAQ shared this problem 6 months ago
Resolved

When upgrading to Yellowfin 8.0.4, an error is experienced and the upgrade is unable to be completed.

liquibase.exception.LockException: java.lang.ClassCastException: java.lang.String cannot be cast to java.lang.Date


What is happening and how do I resolve it?

Comments (1)

photo
1

This error is experienced by the usage of the JTDS JDBC Driver and Connection String when connecting to a Microsoft SQL Server Configuration Database, that was set up in older releases of Yellowfin.


In order to resolve this upgrade error, the ROOT/WEB-INF/web.xml will need to be updated to reference the MSSQL Driver and Connection string, instead of the JTDS Driver.

Change this:

<init-param>

<param-name>JDBCDriverClass</param-name>

<param-value>net.sourceforge.jtds.jdbc.Driver</param-value>

</init-param>

To this:

<init-param>

<param-name>JDBCDriverClass</param-name>

<param-value>com.microsoft.sqlserver.jdbc.SQLServerDriver</param-value>

</init-param>


And Change this:

<init-param>

<param-name>JDBCUrl</param-name>

<param-value>jdbc:jtds:sqlserver://<host>:<port>/<database></param-value>

</init-param>


To this:

<init-param>

<param-name>JDBCUrl</param-name>

<param-value>jdbc:sqlserver://<host>:<port>;databaseNAme=<database></param-value>

</init-param>


If you are still facing issues, please raise a ticket with our Support Team containing a detailed description of your issue, including any relevant screenshots.


Kind regards,

Yellowfin Support Team