This is the error Message I received when upgrading from 2016.0.0864 to 2018.3.1162. However
I ran check links on all tables in the database before launching the upgrade and there were no problems. I restored back to the backup point 2016.0.0864 and tried again and got the same error. It indicates there is a temp table that needs to be removed and I don't know what that would be or how to remove it.
Sidenote: The error indicates the table is trying to update to 18.3.1162 however when I launch GP the version shows 18.5.1635.
Is there anyone that can help?
Peggy Aitken
Peggy, glad to hear you had backups and could start over until you found the correct path.That is why we house dozens of images with various versions of GP and SQL. We never know what the client may be using.
Thank you Joe! I'm going to upgrade to the code I've used before successfully FALL2020 and see if that works. Then upgrade from there. I didn't have any problems with tables not being created with that version either so (with a backup of course) I'm going to try it without running the scripts. I'll let you know the outcome. Thanks again for taking your Saturday to help me out!!!
Thank you Richard once AGAIN! I've successfully upgraded from 2016 to 2018 before but it was the Fall 2020 code. Guess I'll go back to that and then upgrade from there as you've suggested.
Hi Peggy-
Did you get this error in your testing of the upgrade?
I agree with Richard about doing the upgrade in two segments: I would upgrade to 18.3.1200 first, stop and take a breath (and have a glass of wine) and then another upgrade to get you to latest and greatest of 18.5.
Joe
I have not seen this particular error message before. I would suggest these two things:
1) Try doing the upgrade in two hops. Go to GP 18.3.1173. Then to 18.5.1635.
2) Before upgrading for and tables beginning with GL30000. There should only be one. Drop any others.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,900 Super User 2024 Season 2
Martin Dráb 229,275 Most Valuable Professional
nmaenpaa 101,156