Skip to main content
Microsoft Dynamics GP forum
Answered

Duplicates in ASIEXP86

editSubscribe (0) ShareShare
ReportReport
Posted on by 1,130

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

  • PGS Profile Picture
    PGS 1,130 on at
    RE: Duplicates in ASIEXP86

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

    David

  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    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 Profile Picture
    PGS 1,130 on at
    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 Profile Picture
    Nanook Software 587 on at
    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

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,068 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,591 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans