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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / SQL error while upgrad...
Microsoft Dynamics GP (Archived)

SQL error while upgrading the company database from 11.00.2044 to V 11.00.2390

(0) ShareShare
ReportReport
Posted on by Alaa Ramadan 4,130

I'm receiving this error while upgrading GP2010

 Current version is 11.00.2044 - upgrade to  V 11.00.2390

After running the utility, the dynamics database has been upgraded, but during the company upgrade I got the following error:

The following SQL statement produced an error:
 CREATE NONCLUSTERED INDEX [ACINDXPerfAAG20001] ON [dbo].[AAG20001] ([ACTINDX] ASC,[POSTED] ASC) ON [PRIMARY] 

Not sure if this more about data issue.

Any help please? 

*This post is locked for comments

I have the same question (0)
  • Jothi Krishnan N Profile Picture
    Jothi Krishnan N 1,897 on at

    Did you try running this statement directly on SSMS and see if it still errors out.   if no error, then try resuming the upgrade if it's interrupted .

  • Derek Albaugh Profile Picture
    Derek Albaugh on at

    Usually when we see this type of message, it is followed by a "Cannot find the object "dbo.XXX######" because it does not exist or you do not have permissions."  In this case, I'm wondering if the AAG20001 table actually exists in this company database that is failing with this error?

    You can run a dexsql.log and look at the error there to find out whether this is what its mentioning or not, then verify the missing table(s) exist or not.

    If you actually do not use Analytical Accounting at all, or used it in the past but don't plan on using it going forward, you'll need to use the KB 915903 to completely remove AA from the GP databases before upgrading, otherwise Utilities sees remnants of AA and expects it to be present.

    Thank you,

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans