APAC SD Team
Category
Installation & Upgrades
Product Version
7.2
Upgrade to 7.2 fails 'Error Excecuting Update'
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.
Files:
ErrorUpdate.txt
The same problem 
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
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
Replies have been locked on this page!