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

Announcements

Introducing our New Video Series: Community Spotlight
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 Microsoft Employee 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

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans