GP 2015 R2 errors during upgrade & possible solutions

(2) Share

Report

Posted on by coquisalsa

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

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

All responses (27)

Answers (3)

steveendow 2,281 on at

Like (0)

Report

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
Tanya Henderson on at

Like (0)

Report

RE: GP 2015 R2 errors during upgrade & possible solutions

Thanks so much worked great!
Don Craig 280 on at

Like (0)

Report

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 95 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

RE: GP 2015 R2 errors during upgrade & possible solutions

Worked like a charm..

thanx
Suggested answer

Tim Foster 8,515 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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 769 on at

Like (0)

Report

RE: GP 2015 R2 errors during upgrade & possible solutions

Thank you Chrystal. The trigger saved the day.
Q Factor 105 on at

Like (0)

Report

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 155 on at

Like (0)

Report

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