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

(0) Share

Report

Posted on by MaSc4Crm

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

*This post is locked for comments

All responses (15)

Answers (0)

Suggested answer

Rod ABraham 30 on at

Like (0)

Report

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.
Suggested answer

nmaenpaa 101,156 on at

Like (0)

Report

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 30 on at

Like (0)

Report

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 Cal... 291,359 Super User 2024 Season 2 on at

Like (0)

Report

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 30 on at

Like (0)

Report

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 101,156 on at

Like (0)

Report

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 30 on at

Like (0)

Report

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 Cal... 291,359 Super User 2024 Season 2 on at

Like (0)

Report

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 30 on at

Like (0)

Report

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 230,370 Most Valuable Professional on at

Like (0)

Report

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?