Upgrading to Yellowfin error: String cannot be cast to Date

Yellowfin FAQ shared this problem 2 years ago
Resolved

When upgrading, 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 occurs when the jTDS Driver is used to connect to a SQL Server Yellowfin Configuration Database.

In order to resolve this upgrade error, you need to change the jTDS Driver to a SQL Server Driver. The ~/ROOT/WEB-INF/web.xml will need to be updated to reference the SQL Driver and Connection string.


Change this:

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

To this:

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

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