web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

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

(0) ShareShare
ReportReport
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:
I have the same question (0)
  • Suggested answer
    lancebrigham Profile Picture
    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
  • Suggested answer
    Lisa at AonC.com Profile Picture
    870 Super User 2025 Season 2 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. 

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 756 Super User 2025 Season 2

#2
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 678

#3
Martin Dráb Profile Picture

Martin Dráb 526 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans