Announcements
4,096
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
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,
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 .
#1
Almas Mahfooz
3
User Group Leader
Share
Report
All responses (
Answers (
