07-27-2018 09:01 AM
Hi guys,
I'm attempting to upgrade our DA from 10 to 11. I'm recieiving the following error when I go to upgrade the our database and the custodionmanager database:
Cannot drop the index 'tblVaultSamples.IX_tblVaultSamples_Lookup', because it does not exist or you do not have permission.
Any help would be much appreciated. Thank you!
Solved! Go to Solution.
07-30-2018 07:54 AM
It didn't exist. I commented out the line in the SQL script to get it to run.
Thanks!
07-29-2018 11:03 PM
Hi,
So I am going to assume that your permissions are in place. So the obvious question is have you looked in SQL to see if this index does indeed exist on tblVaultSamples?
Paul.
07-30-2018 07:54 AM
It didn't exist. I commented out the line in the SQL script to get it to run.
Thanks!