web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Create record in AX 20...
Microsoft Dynamics AX (Archived)

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

(0) ShareShare
ReportReport
Posted on by MaSc4Crm 6

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 

*This post is locked for comments

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 307,115 Super User 2026 Season 2 on at

    Hi Martin,

    I never heard of KingswaySoft. This is not a standard part of an AX implementation. I don't know how this software connects to AX. Can you provide some more information about this and also the error you get? Probably based on the error, we can help you on the AX part, but don't expect knowledge from volunteers like me on the KingswaySoft part.

  • MaSc4Crm Profile Picture
    MaSc4Crm 6 on at

    Hi André,

    we would like to create a vendor in AX based DirPartyTable, DirOrganisation, VendTable etc.

    In order to this we have to create initially a record in the DirOrganisation table. The problem is, you can't set any fields of which are inherited from DirPartyTable like "Name".

    Any ideas?

    Kind regards,

    Martin

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 307,115 Super User 2026 Season 2 on at

    Hi Martin,

    Please provide information how you are doing it. As said above, I don't have knowledge of KingwaySoft. So, I really don't know if you are trying direct table inserts or if you are using services to connect.

  • Rod ABraham Profile Picture
    Rod ABraham 30 on at

    Hi Martin,

    I have an issue when I am inserting multi records into dirperson , AX inserts just a first record and it gives exception with the rest is "dirpartytable:....already existed".

    So how did you fix it?

    Best regards,

    Rod

  • nmaenpaa Profile Picture
    nmaenpaa 101,172 Moderator on at

    Hi Rod,

    are you using Kingswaysoft? Are there any additional details that you would like to share with us, except the error message? For example the steps that lead to having the error message?

  • Martin Dráb Profile Picture
    Martin Dráb 240,744 Most Valuable Professional on at

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

    Where exactly is the exception thrown?

  • Rod ABraham Profile Picture
    Rod ABraham 30 on at

    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

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 307,115 Super User 2026 Season 2 on at

    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

    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)

  • nmaenpaa Profile Picture
    nmaenpaa 101,172 Moderator on at

    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?

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans