Cannot drop the index

[presgar]

I am getting this error when I try to run the 3.2 to 3.5 upgrade script. How can I fix and move on?

'tblSoftware.tblSoftware30', because it does not exist or you do not have permission


I have the permissions for sure - I don't see tblSoftware30 just tblSoftware


Haven't had any issues with 3.2 - love it

[Hemoco]

Start the service and look for errors in errorlog.txt

[presgar]

So am I to assume the script now completed in it's entirety? Is there something I should check or is it safe to move on to the next step?

[presgar]

OK I did that and now I get this "There is already an object named 'TsysConfig' in the database"

[Hemoco]

presgar wrote:
OK I did that and now I get this "There is already an object named 'TsysConfig' in the database"

Don't worry about it, this is because the first part of the script already created it (before when you had the error)

[Hemoco]

Delete this line from the upgrade script :

DROP INDEX [tblSoftware].[tblSoftware30]
GO

[Matt_Sullivan]

Good question. I didn't think about that. I'm getting a Runtime error on the web interface... Could be the cause. Is your interface working?

[presgar]

does the script continue after an error or does it stop? How do I know that it finished processing even after it got this error?

[Matt_Sullivan]

I got the same thing today when running the 3.2 to 3.5 script. I guess it doesn't hurt anything to leave that table there though, it shouldn't affect the upgrade.