Upgrade to 7.2 fails 'Error Excecuting Update'

David Registro shared this problem 2 years ago
Resolved

Upgrading from 6.1 > 7.2 on SQL Server and the upgrade fails with :

Error Excecuting Update


Opening the 'YellowfinPatchLog' shows:


UPDATE ReportViewSourceParameter SET ParameterValue ='net.sourceforge.jtds.jdbc.Driver' WHERE ParameterKey = 'DRIVER' ANDParameterValue = 'JTDS'

Caused by:java.sql.SQLException: The data types ntext and varchar are incompatible in theequal to operator.

Full error attached.

Comments (1)

photo
1

This issue is caused by some older tables created in an older release of Yellowfin and not being handled correctly via the upgrade.

Good news is there is an easy fix.

1. Run the script in file 'Pre Patch - Copy and rename table.txt' against your Yellowfin DB.

2. Run the upgrade

3. Run the script in file '72.Post Patch - Reset tables.txt' against your Yellowfin DB.

That's it, you're done.

If you still have issues with this, please shoot across your YellowfinPatchLog and any related screenshots.

Regards,

David