Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Upgrade from GP 2013 SP2 to 2013 R2 and then on to GP2016 R2-- during testing on a new server no problems encountered, then when production databases were moved to the new server-- all kinds of odd issues

(0) ShareShare
ReportReport
Posted on by 45

I have a very in depth description of the upgrade testing before produciton upgrade and the  issues that I encountered during the upgrade of the production data.  I will give a short description here and if someone wants the full detail I can upload it.

I have a feeling I know what the issue is, but need someone else's opinion please.

So a new server windows sql 2016 w sql 2014 running was created so the production machine could be moved to this new server.  Normally I will not do an upgrade and server move at the same time-- but the client was persuasive and I gave in!

So basically I did a test upgrade on the new server ( 30 databases) and all was flawless

upgraded to GP2013 R2 and added the last year end sp so it would take me to a version that could then be directly upgraded to Gp2016 R2 and then added latest service pack.

Then a month later after accounting gave me the go ahead, I followed all the upgrade instructions, moved the databases to the new server, updating sql compatibilty, running grant sql scripts,  updating DB owner to DYNSA and then proceeded with the produciton upgrades.   All kinds of errors " coudl not drop temp table" .  I worked on it all weekend and had one remaining database to upgrade but it was still running at 7 AM so the accounting team said they cannot loose any productive time, so the upgrade was cancelled and I waited another 2 weeks to get to a time frame that worked for them and started again.

In the mean time I removed GP 2016 install and 2013 install and reinstalled fresh.  The client is only  using GL and about 4 companies are using PM so not a complicated system at all.    I ran all the checklinks and datamaintenance on all databases and started the upgrade.  ent pretty smooth but 4 companies had error messages.  3 of the 4 only used GL and not PM and no company used POP.  The same error was encountered on all 4

unable to upgarde  PM40100, PM10000, PM20000, PM30200, UPR00100

I could not get past the error even though those tables had no data to convert.   after research I  tried to drop and create the tables-- the process indicated it worked but restarting the upgrade on these companies, the same error occurred.

Yes I did delete the DU00030 table before doing the last upgrade--

So then I did more research and since these tables were not used, I updated the file status to 15 and tried again on these 4 databases.   Well this time a different message which I am sure is due to the status change

create view(dbo) popWork Transactions  blah blah blah failed, you say okay and it says workflow_status is not a valid column

so after thinking about the issue I decided to copy the view from a company that did sucessfully upgrade and script it as a create, then create the view in these 4 companies--  same error  workflow_status is invalid column.   

I researched  POP10300 tablepurchasing receipt work table,purchase order work and every table that I found listed in the create error... worflow_status is a valid column name

SO

Why did some companies upgrade without issue and others did not?

I have all the detailed messages and process outlined in a 13 page document if you want more detail but I really need assistance.   I have never had to tell a client the upgrade failed!

On the second upgrade attempt the errors occured during the first step- upgrading to gp2013 R2 and year end service pack.  I never got to the GP2016 upgrade!

so it worked twice before but not the last time!!!

Thank you in advance for any assistance you can provide

Carolyn

*This post is locked for comments

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans