Duplicates in ASIEXP86

(0) Share

Report

Posted on by PGS

1,144

Hi All,

I am currently doing an upgrade from 2015 R2 to 2018 R2. The upgrade is failing and it seems to be that there are duplicates in the ASIEXP86 table. Does anyone have a script to identify the duplicates or any suggestions for how to identify them?

Thanks in advance

David

*This post is locked for comments

All responses (4)

Answers (1)

PGS 1,144 on at

Like (0)

Report

RE: Duplicates in ASIEXP86

Thank-you Kerry and Richard for your responses. Greatly appreciated

David
Verified answer

Richard Wheeler 75,842 Moderator on at

Like (0)

Report

RE: Duplicates in ASIEXP86

Here is a more detailed description of this issue.

community.dynamics.com/.../microsoft-dynamics-gp-2018-r2-and-year-end-upgrade-known-upgrade-issues
PGS 1,144 on at

Like (0)

Report

RE: Duplicates in ASIEXP86

Hi Kerry,

Thank-you so much for the reply, you have no idea how much it is appreciated. The query returned no results which I suppose is a good thing but doesn't solve my problem with the upgrade stopping at ASIEXP86. Back to the drawing board for me I'm afraid!
Suggested answer

Nanook Software 2 on at

Like (0)

Report

RE: Duplicates in ASIEXP86

This should give you a quick find...

Then you need to delete / investigate...

SELECT * FROM (

SELECT COUNT(*) as CNT,

ASI_Favorite_Dict_ID,

ASI_Favorite_Type,

ASI_Favorite_Save_Level,

CMPANYID,

USRCLASS,

USERID,

ASI_Favorite_Name,

ASI_Field_Sequence

FROM ASIEXP86

GROUP BY ASI_Favorite_Dict_ID,

ASI_Favorite_Type,

ASI_Favorite_Save_Level,

CMPANYID,

USRCLASS,

USERID,

ASI_Favorite_Name,

ASI_Field_Sequence

) as a

WHERE CNT <> 1