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)