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

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