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
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 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?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,537
Super User 2024 Season 2
#2
Martin Dráb
228,520
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (