Announcements
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
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.
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.
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.
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.
Hi Nikol,
I am using kingswaysoft flow to do that. There is no code to share.
Thanks.
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?
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)
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.
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
How does the tool communicates with AX? Via web services? Which type?
Where exactly is the exception thrown?
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156