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

I have the same question (0)

All responses (27)

Answers (3)

Suggested answer

Tim Foster 8,515 on at

Like (1)

Report

RE: Errors Upgrading GP2015 to GP2015 R2

I had the same problems yesterday as well. My solutions were slightly different.

In the case of ASIEXP86, I deleted the offending (duplicate key) rows.

For SY07240, I forced the SQL INSERTS that the R2 Upgrade wanted to do.

There is another thread on this.

community.dynamics.com/.../162174

A Hotfix can't come soon enough.

TIm

Was this reply helpful? Yes No
coquisalsa 2,725 on at

Like (0)

Report

RE: Errors Upgrading GP2015 to GP2015 R2

I also looked for duplicates in table ASIEXP86 for both indexes but I couldn't find any.

Did you upgrade run successfully after running the updated SQL for table SY07240?

Was this reply helpful? Yes No
Tim Foster 8,515 on at

Like (0)

Report

RE: Errors Upgrading GP2015 to GP2015 R2

Yes, it did. No error in the Company upgrades.

I am getting a trigger registration error on startup. I haven't determined if it is GP or a third party.

Tim

Was this reply helpful? Yes No
coquisalsa 2,725 on at

Like (0)

Report

RE: Errors Upgrading GP2015 to GP2015 R2

I think all these workarounds are ok only for testing purposes and for exploring GP2015 R2, but I wouldn't risk to install it in a production environment.

I haven't tried installing GP2015 R2 using the full installer 'MDGP2015_R2_DVD_ENUS' yet, it might work better.

Was this reply helpful? Yes No
Bridget Cattie 170 on at

Like (0)

Report

RE: GP2015 R2 errors during update

For the ASIEXP86 error, once I dropped and recreated the non-clustered index [AK2ASIEXP86] to include only these fields I was okay.

[ASI_Favorite_Dict_ID] ASC,
[ASI_Favorite_Type] ASC,
[ASI_Favorite_Save_Level] ASC,
[CMPANYID] ASC,
[USRCLASS] ASC,
[USERID] ASC,
[ASI_Favorite_Name] ASC,
[ASI_Field_Sequence] ASC

Still haven't been able to get past the SY07240 issue.

Was this reply helpful? Yes No
coquisalsa 2,725 on at

Like (0)

Report

RE: GP2015 R2 errors during update

Hi Bridget, Microsoft team is looking into this, I hope we will have a fix soon.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: GP2015 R2 errors during update

Have the same problems, I managed to fix the ASIEXP86 by removing the duplicates by comparing the ASIEXP86 and ASIEXP86T tables. Also get the SY07240 error and after some troubleshooting can't work out how to fix the problem.

Can someone from Microsoft confirm a bug or a fix/workaround to get the SY07240 through the upgrade

Was this reply helpful? Yes No
Verified answer

coquisalsa 2,725 on at

Like (1)

Report

RE: GP2015 R2 errors during update

Problem solved! Just follow these steps:

1. Take a backup of table SY07240

SELECT * INTO SY07240Backup FROM SY07240

2. Delete all rows from SY07240

DELETE FROM SY07240

3. Run Dynamics GP Utilities. You will get this error:

4. Click “Close” on the above window. You will presented with the following window:

5. Restore rows into table SY07240 by running this SQL script:

INSERT INTO SY07240 (ListDictID, ListID, ViewID, CmdParentDictID, CmdParentFormID, CmdParentCmdID, CmdSequence, CmdDictID, CmdFormID, CmdID, Priority, ButtonSize, CmdCaption, Visible)
SELECT ListDictID, ListID, ViewID, CmdParentDictID, CmdParentFormID, CmdParentCmdID, CmdSequence, CmdDictID, CmdFormID, CmdID, Priority, ButtonSize, CmdCaption, Visible
FROM SY07240Backup

6. Click “Update” in the window from step 4.

7. That’s it

Thanks

Jorge Mejia

Was this reply helpful? Yes No
Bridget Cattie 170 on at

Like (1)

Report

RE: GP 2015 R2 errors during update & Fixes

I should add that I was updating from the latest build of GP2010 to GP2015 R2 using the full installer and even with an empty SY07240 table to start, I could not get it to upgrade successfully (despite the table definitions being identical between versions). I ended up updating the DU000030 directly to set the table upgrade status. The table populates in GP2015 R2 without issue when clicking on the navigation pane objects.

Also, I did not have any duplicates in the ASIEXP86 table but got the error because the non-clustered index did not match the primary keys.

Was this reply helpful? Yes No
Tim Foster 8,515 on at

Like (1)

Report

RE: GP 2015 R2 errors during update & Fixes

I disagree (respectfully) with your approach to ASIEXP86.

You will find no duplicate records (pre-upgrade) because of the Primary Key/Index applied to the table.

The "duplicate" records are being inserted by the upgrade script. This problem seems to affects only "default" Smartlist favorites (i.e. the one with the stars at the end that are included with a default install on the product). It looks like the upgrade assumes that no changes were made to these column objects. In my system, someone may have changed the default or my default doesn't meet the expectation because of the version hops.

Redefining the Index may have got you past the upgrade challenge, but may cause you some real grief during UAT.

Tim

Was this reply helpful? Yes No