5
Has anyone experienced upgrade failure on PM00300 and PM40100? The upgrade error details indicate the temp table couldn't be deleted and the recommendation is to remove it manually, however, after attempting to 'upgrade" the table again, the PM00300 ends up totally removed from the database, as does the PM40100 when performing the same attempted re-upgrade. I have no other applications running. Any recommendations on how to troubleshoot and resolve would be greatly appreciated.
I ended up creating a new GP company with the 18.5 code before restoring, so that I had the proper table structures. Then restored my Dynamics and TWO companies. Upgraded again and again until it got down to 1 PM setup table and 2 workflow tables, when it finally finished with success. Then I dropped the 3 bad tables and created new with the proper structures from the new company I had created. I inserted 1 row of data back into the PM setup table and was good to go. 8 hours of fun.
The Utilities error messages are rarely accurate, especially when it mentions having to delete temp tables, which Utilities will do 99% of the time when the upgrade fails on a table.
This 'failed tables' script is better at giving us information as to why a table is failing and why:
SELECT b.fileOSName, a.fileNumber, a.PRODID, a.Status, a.errornum, a.errordes, c.CMPANYID, c.INTERID FROM DU000030 a JOIN DU000010 b ON a.fileNumber = b.fileNumber AND a.PRODID = b.PRODID JOIN SY01500 c ON a.companyID = c.CMPANYID WHERE (a.Status <> 0 or a.errornum <> 0) and a.Status <>15
Additional information can also be found in the dexsql.log as needed.
If you're still working on this upgrade and need help, I'd recommend a support case, as upgrades are usually a little more complex than what can be worked on via these forums.
Thanks
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (