Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

Create record in AX 2012 which is based on table inheritance like DirOrganisation table by SSIS Kingswaysoft

Posted on by 247

Hi there,

currently I try to use the latest KingswaySoft SSIS Toolkit to create a record (account) which is based on DirPartyTable and so on.

I can't create the record, because AX throws an exception when I use the "DirOrganization" or "DirPartyTable" table? How is the approach to handle table inheritance for AX destination connector?

Kind regards,

Martin 

Categories:
  • Suggested answer
    Rod ABraham Profile Picture
    Rod ABraham 30 on at
    RE: Create record in AX 2012 which is based on table inheritance like DirOrganisation table by SSIS Kingswaysoft

    Hi all,

    I fixed it by using foreach loop because with inherited tables we must insert records one by one .

    Thank you all for your time.
    85064.Capture.PNG

  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,148 on at
    RE: Create record in AX 2012 which is based on table inheritance like DirOrganisation table by SSIS Kingswaysoft

    I also agree that you should contact KingswaySoft directly since it's their product and they should have the best knowledge about it. You can't see what happens under the hood, and we don't know what happens under the hood, so it's hard to say why this third party software gives you these results.

  • Rod ABraham Profile Picture
    Rod ABraham 30 on at
    RE: Create record in AX 2012 which is based on table inheritance like DirOrganisation table by SSIS Kingswaysoft

    Hi all,

    It's ok I will , but Martin had this problem with inherited tables.

    So I want to know did you fix it, or it is could with kingswaysoft Martin?

    I really need some help.

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,537 Super User 2024 Season 2 on at
    RE: Create record in AX 2012 which is based on table inheritance like DirOrganisation table by SSIS Kingswaysoft

    Hi Rod,

    Probably, you can contact Kingwaysoft to get some support here. I have no experience with their product. I only got triggered by your comment that the first record was inserted and others not.

  • Rod ABraham Profile Picture
    Rod ABraham 30 on at
    RE: Create record in AX 2012 which is based on table inheritance like DirOrganisation table by SSIS Kingswaysoft

    Hi Nikol,

    I am using kingswaysoft flow to do that.  There is no code to share.

    Thanks.

  • nmaenpaa Profile Picture
    nmaenpaa 101,148 on at
    RE: Create record in AX 2012 which is based on table inheritance like DirOrganisation table by SSIS Kingswaysoft

    Hi Rod,

    you didn't yet share your code so it's not really possible to guess what could be wrong with it. Could you please share your code?

  • Rod ABraham Profile Picture
    Rod ABraham 30 on at
    RE: Create record in AX 2012 which is based on table inheritance like DirOrganisation table by SSIS Kingswaysoft

    Hi Andre,

    Thanks for your reply. dirperson table doesn't get a Part Id from Dynamics AX Next Sequence Number .

    It gets the last number of Dynamics AX Next Sequence Number +1, so I moved it after the inserting and it is still not.

    why?

    ........................
    When I tried reinserting on error output . The exception was:

    .................................
    [Create DirPerson 1 [733]] Error: Microsoft.Dynamics.BusinessConnectorNet.XppException: RecordInsertList or RecordSortedList operations are not allowed with tables participating in table inheritance.
    Object 'RecordInsertList' could not be created
       at oyt.box(String amt, Type[] amu, Object[] amv)
       at oyt.bon(String amh, Object[] ami)
       at oys..ctor(oyl ala, oxl alb)
       at oyl.lqi(oxl cpk)
       at KingswaySoft.IntegrationToolkit.DynamicsAx.AxDestinationComponent.PreExecute()
       at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPreExecute(IDTSManagedComponentWrapper100 wrapper)

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,537 Super User 2024 Season 2 on at
    RE: Create record in AX 2012 which is based on table inheritance like DirOrganisation table by SSIS Kingswaysoft

    Hi Rod,

    Can you check if the Party field is getting an ID from the number sequence in AX? If not, this might be causing the issue after the first record as it will then be considered as duplicates.

  • Rod ABraham Profile Picture
    Rod ABraham 30 on at
    RE: Create record in AX 2012 which is based on table inheritance like DirOrganisation table by SSIS Kingswaysoft

    Hi All,

    Thanks for your reply. Yes, I am working on kingswaysoft and I used "Business Connector" to connect to AX.

    The exception raises when I inserted records in dirperson table by using "Destination AX".

    a first record inserted well but others failed "partyNumber existed......".

    I hope it sense.
    I don't want to use a web service to call a class from AX.

    Rod

  • Martin Dráb Profile Picture
    Martin Dráb 228,520 Most Valuable Professional on at
    RE: Create record in AX 2012 which is based on table inheritance like DirOrganisation table by SSIS Kingswaysoft

    How does the tool communicates with AX? Via web services? Which type?

    Where exactly is the exception thrown?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,537 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,520 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans