Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Install issues with SafePay and GP2010

Posted on by

Our client had SafePay installed at some point when they were on version 9.0.

They are now on 2010R2 and would like to have this feature re-installed. I attempted to install, but when running Utilities, I get the message:

 Error:  Product 1235 does not support upgrading from version 9.0.258.

I see references to this product in DB_Upgrade and DU000020 reflecting 9.0 build 258. There is no reference to this product in the DU000030 table.

I would like to run a script similar to the one below to remove the product. Is there anything else I am missing?

Delete DYNAMICS..DB_Upgrade where PRODID = 1235 and db_name = 'xxxx'

Delete DYNAMICS..DU000020 where PRODID = 1235 and companyID = 'xxxx'

Thanks!

 

Tom

 

 

 

*This post is locked for comments

  • Tom Keller Profile Picture
    Tom Keller on at
    Re: Install issues with SafePay and GP2010

    Thanks Dan and Jonathan.

  • Re: Install issues with SafePay and GP2010

    These scripts will fix our issue:

    Delete DYNAMICS..DB_Upgrade where PRODID = 1235 and db_name = 'xxxx'

    Delete DYNAMICS..DU000020 where PRODID = 1235 and companyID = xx

    Delete DYNAMICS..DU000030 where PRODID = 1235 and companyID = xx

    You can find the Companyid by running the following script:

    select CMPANYID,CMPNYNAM,INTERID from Dynamics..SY01500

    Last you need to run the following drop scripts against each company you need to reinstall the module for:

    Drop Table ME123515

    Drop Table ME234602

  • Dan Liebl Profile Picture
    Dan Liebl 7,320 on at
    Re: Install issues with SafePay and GP2010

    You may  want to drop all the Safe Pay tables first.   They may be dropped during the install process if any exist, but I would think dropping them prior, then clearing Dynamics db tables would help to make things go smoother.   I would have backups of all databases prior just in case.

    Dan Liebl, CMA CPIM | Senior Consultant | OTT,Inc | DLiebl@OTT-inc.com  

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,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans