Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Install of database GP...
Microsoft Dynamics GP (Archived)

Install of database GPXX failed! Microsoft Dynamics GP Utilities will now shut down

(0) ShareShare
ReportReport
Posted on by Ian Grieve 22,782

I'm getting the above error on GP 9 SP3 when I try to create a new company with db name of GPXX (where XX has been several different things as I have tried a few times with different names).

KB920832 (support.microsoft.com/.../920832) refers to using a SQL key word in the DB name but this is not the problem I am seeing.

Has anyone else seen this problem?

As an aside, this company has more than 1 GP installation and I have successfully created a new company recently for one of the other installations without a problem.

*This post is locked for comments

  • Verified answer
    Ian Grieve Profile Picture
    Ian Grieve 22,782 on at
    RE: Install of database GPXX failed! Microsoft Dynamics GP Utilities will now shut down

    In my case the problem was a corrupt server component install.

    I installed another GP 9 client with the server components and I was able to create the company without any errors.

    Ian

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Install of database GPXX failed! Microsoft Dynamics GP Utilities will now shut down

    The ClearCompany script will remove all references to company databases that no longer exist in the SY01500. No harm will come to your good 12 companies. Also make sure a database does not already exist in your SQL data folder. Database names must be unique. You obtain the Clear Company script from here:

    support.microsoft.com/.../855361

  • Ian Richardson Profile Picture
    Ian Richardson 4,150 on at
    RE: Install of database GPXX failed! Microsoft Dynamics GP Utilities will now shut down

    i found this

    support.microsoft.com/.../920832

    in my case my dbase name KEY turns out to be a sql command so it is an invalid dbase name.  Any GP install script sees KEY and thinks it is the command not the dbase name so fails.

    The kb reviews how to properly remove reference to the dbase.

    ian

  • Suggested answer
    Ian Richardson Profile Picture
    Ian Richardson 4,150 on at
    RE: Install of database GPXX failed! Microsoft Dynamics GP Utilities will now shut down

    HI Richard

    I just had the same thing happen to me today.

    Utilities did not close as the message stated it would.  It took me back to what would you like to do.  I tried to create a new company again.  This time I got Database GPXX already in use.

    So something has saved somewhere.

    GP Utilities can see the dbase and wants to upgrade it.  Trying to upgrade I get instant error messages cannot drop xxxx.

    So ok I think the dbase must be empty and (foolishly?) I have asked IT to drop the dbase thinking that I would then be able to create it again.

    Utilities can still see the dbase somewhere and still wants to upgrade it.

    what is the clear companies script that you refer to above?  Can I run it against a company with 12+ good dbases?

    thanks

    ian

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Install of database GPXX failed! Microsoft Dynamics GP Utilities will now shut down

    If you look in the DYNAMICS..SY01500 table do you see any spuriuous companies? Try running the ClearCompanies script. Perhaps there is a remnant of a failed installation somewhere in one of the databases.

  • Ian Grieve Profile Picture
    Ian Grieve 22,782 on at
    RE: Install of database GPXX failed! Microsoft Dynamics GP Utilities will now shut down

    Hi Richard,

    Yes, there is space.

    I'm logged in as a Domain Admin.

    Logged into SQL as sa

    SQL is 2000 SP4

    I'm checking a SQL Log I've just made by switching it on in the dex.ini file.

    I'll check in the morning when there are no other users logged into GP.

    Ian

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Install of database GPXX failed! Microsoft Dynamics GP Utilities will now shut down

    Have you tried running SQL Profiler while the creation fails? What version of SQL are you using with GP 9? Is there sufficient space to create the new database? Are you logged in as someone with admin rights on the server? It may be a permission problem and the database files cannot be created.

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