Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

Moving Dynamics GP Installation to a new server by cloning the old server

Posted on by 26
Does anyone have experience with clients that have moved an existing Dynamics Gp Installation to a new server by cloning the original virtual Sql Server and not following the protocol in the document  /How to transfer an existing Microsoft Dynamics GP, Small Business Financials, or Small Business Manager installation to a new server that 
is running SQL Server/
 
 I originally opened this case because a client's IT dept cloned their server to a new server without consulting anyone.  Five days later they experienced messy posting interruptions with the error 
/Could not allocate space for object /dbo/ PJournal. 
To resolve their problems I tried to upgrade to the latest GP version but wasn't able to complete the it do to unresolved errors, but that's another story.  I ended up doing a fresh install of the original version and restored to a backup prior to the upgrade.  So, I essentially ended up following the procedures in the document listed above.
 
Fast forward to another scenario where a new client, cloned their previous server.  To further complicate things I couldn't do a fresh install because they have 3 3rd party products.  It was over the weekend.  I ended up doing a Dynamics GP Repair until I could open a support request with GP.  I've been running the script to delete the PJournal so they don't bomb during posting.
 
I just heard from GP and their answer was:  If you ran a repair, then you essentially already did a uninstall/reinstall as a repair on GP will remove all third-party products.  I'm just wondering if anyone has cloned their server, run a Dynamics GP Repair successfully and no other action was required?   I don't want to chance just letting it go if the repair was not sufficient.  
 
FYI, from my experience with this scenario, the three 3rd party products were not removed when I ran the /repair/.  It's possible it may remove some but it did not in this case.
 
Categories:
  • Suggested answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 3,141 on at
    Moving Dynamics GP Installation to a new server by cloning the old server
    If you look at the PJOURNAL job in SQL Agent, is there any error when it runs?

    I recently had to recreate the job by scripting it out from one of our demo images and then running it on the client's system to get the GP 18.5 upgrade to complete.
     
    Any chance the old image is still someone in their environment?  I recently had a client rebuilding their environment and we discovered they had a backup image they were using in IT for testing that they forgot to take offline. 
  • Suggested answer
    lancebrigham Profile Picture
    lancebrigham 119 on at
    Moving Dynamics GP Installation to a new server by cloning the old server
    After you cloned the SQL server, did you do a sp_dropserver/sp_addserver so that the internal servername reference is correct? For example:
     
    EXEC sp_dropserver 'OLDSERVER'
    EXEC sp_addserver 'NEWSERVER','local'
     
    You can use this to determine whether the server is referenced properly:
     
    SELECT @@SERVERNAME
     
    Given how GP handles file/table references that might explain the posting issues.
     
    You'd also want to use a "search all" SQL script to scan all tables/columns in DYNAMICS and GP company databases to make sure any references to '%OLDSERVER%' are scrubbed/replaced with correct new server name (i.e. SY40800 may still point to SRS reports on old server).
     
    Thanks,
    Lance Brigham
    Velosio

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 Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans