Error while upgrading LabKey

LabKey Support Forum
Error while upgrading LabKey Jon (LabKey DevOps)  2017-12-18 15:19
Status: Closed
 
Hi Eva,

Thank you for providing the error.

The SQL error you're seeing is due to a bug that was fixed in a later version of LabKey. Unless you have a very large search index, you should be able to just clear the tables from your SQL database before you attempt the upgrade and then you would need to let the server rebuild the search index.

To clear your database tables, login as an admin to your SQL database and run the following:

DELETE FROM search.CrawlResources;

DELETE FROM search.CrawlCollections;

This should clear the indexes and then allow you to do the upgrade.

Regards,

Jon