Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

GP 2015 R2 errors during upgrade & possible solutions

Posted on by 2,725

I came across 2 errors while I was trying to upgrade GP 2015 (14.0.661) to GP 2015 R2 (14.0.725).

After running the Dynamics GP 2015 R2 Utilities got this error related to table ASIEXP86 - SmartList Favorites Columns.

 

8103.a.png
And from the DEXSQL.LOG

Cannot insert duplicate key row in object 'dbo.ASIEXP86' with unique index 'AK2ASIEXP86'. The duplicate key value is…

I resolved the problem related to table ASIEXP86 by creating a table backup

SELECT * INTO ASIEXP86Backup FROM ASIEXP86

And then deleting all rows:

DELETE FROM ASIEXP86

The plan was to restore the data from table ASIEXP86Backup into table ASIEXP86 after the Dynamics GP 2015 R2 upgrade using this TSQL

 

INSERT INTO ASIEXP86 (ASI_Favorite_Dict_ID, ASI_Favorite_Type, ASI_Favorite_Save_Level, CMPANYID, USRCLASS, USERID, ASI_Favorite_Name, ASI_Field_Sequence, ASI_Include_Column, ASI_Display_Column, ASI_Field_Number_Dict_ID, ASI_Field_Number, ASI_Column_Display_Name, ASI_Display_Column_Width)

SELECT ASI_Favorite_Dict_ID, ASI_Favorite_Type, ASI_Favorite_Save_Level, CMPANYID, USRCLASS, USERID, ASI_Favorite_Name, ASI_Field_Sequence, ASI_Include_Column, ASI_Display_Column, ASI_Field_Number_Dict_ID, ASI_Field_Number, ASI_Column_Display_Name, ASI_Display_Column_Width FROM ASIEXP86Backup

 

After deleting all rows from table ASIEXP86 y run Dynamics GP2015 R2 Utilities, I didn’t get an error on table ASIEXP86. Success!!! Unfortunately I claimed victory too early…I came across a second error related to table SY07240 - List View Action Pane

 

6765.c.jpg

0488.D.jpg 

2555.E.jpg

And from the DEXSQL.LOG

Cannot insert the value NULL into column 'CmdSequence', table 'DYNAMICS.dbo.SY07240'; column does not allow nulls. INSERT fails

I hope Microsoft will release a hotfix soon.

*This post is locked for comments

  • steveendow Profile Picture
    steveendow 2,281 on at
    RE: GP 2015 R2 errors during upgrade & possible solutions

    Thanks for this thread. I too ran into this while trying to upgrade a customer's test environment from GP 2010 to 2015.  I just enabled SQL logging, found the SY07240 statements that were failing, and added the ISNULL statement to them.

    I ran the inserts and the upgrade appears to be progressing now.

    SELECT ISNULL(MAX(CmdSequence), 1)
    FROM SY07240
    WHERE ListDictID = 0
    AND ListID = 300
    AND ViewID = 3
    AND CmdParentDictID = 0
    AND CmdParentFormID = 1576

  • RE: GP 2015 R2 errors during upgrade & possible solutions

    Thanks so much worked great!

  • Don Craig Profile Picture
    Don Craig 280 on at
    RE: GP 2015 R2 errors during upgrade & possible solutions

    Thank you for posting the change to the trigger.  This corrected the problem I was having with the upgrade process.

    Thanks

    Don

  • michelle brayton Profile Picture
    michelle brayton 95 on at
    RE: GP 2015 R2 errors during upgrade & possible solutions

    It doesnt work better.  :)  I decided to "hop" from 2010 to 2013 then 2015 R2.  I experienced these same issue with the full installer.  The funny thing is that if I bypass 2013 altogether, I don't have these issues.  Even though the navigation pane didn't exist in 2010, I still didn't receive any upgrade errors.  I had applied the new service pack for the Canadian Payroll update to see if that would bypass the errors and it did the one error.  However, I am having a whole different issue and am now rolling back the service pack to see if it corrects it.  The functionality for workflow, Payables transactions is not present.  The screens are totally different.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: GP 2015 R2 errors during upgrade & possible solutions

    Worked like a charm..

    thanx

  • Suggested answer
    Tim Foster Profile Picture
    Tim Foster 8,515 on at
    RE: GP 2015 R2 errors during upgrade & possible solutions

    Bill,

    Please look at:

    community.dynamics.com/.../draft-known-upgrade-issues-when-upgrading-to-microsoft-dynamics-gp-2015-r2

    There are scripts there that I believe should help.

    Tim

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: GP 2015 R2 errors during upgrade & possible solutions

    Hi Chrystal,

    Just ran into this problem when doing a test upgrade from GP10 to GP2015 for a customer. Had no problems upgrading from GP10 to GP2013. When trying to upgrade from GP2013 to GP2015(not R2) the error appears.

    So what you are saying is to drop the index and then continue with the upgrade and I should be able to get past the error. Once the upgrade is done then go ahead and remove the duplicates and then add the index back. Is that correct?

    FYI, one of my colleagues is having the same problem upgrading to GP2015 R2 at another customer.

    Thanks

    Bill

  • Suggested answer
    olegvi Profile Picture
    olegvi 769 on at
    RE: GP 2015 R2 errors during upgrade & possible solutions

    Thank you Chrystal. The trigger saved the day.

  • Q Factor Profile Picture
    Q Factor 105 on at
    RE: GP 2015 R2 errors during upgrade & possible solutions

    Crystal,

    The script for removing the duplicates did not work for me. I got a syntax error.

  • Teesah Profile Picture
    Teesah 155 on at
    RE: GP 2015 R2 errors during update & Fixes

    Hi Jorge

    We will have to wait as it was a test for a potential production upgrade.

    Haseet

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,113 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,918 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans