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.
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
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
Thanks so much worked great!
Thank you for posting the change to the trigger. This corrected the problem I was having with the upgrade process.
Thanks
Don
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.
Worked like a charm..
thanx
Bill,
Please look at:
There are scripts there that I believe should help.
Tim
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
Thank you Chrystal. The trigger saved the day.
Crystal,
The script for removing the duplicates did not work for me. I got a syntax error.
Hi Jorge
We will have to wait as it was a test for a potential production upgrade.
Haseet
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,113 Super User 2024 Season 2
Martin Dráb 229,918 Most Valuable Professional
nmaenpaa 101,156