I am trying to upload data using data project for one of my custom entity. the requirement is like i have one runbasebatch class where one parameter is processing group name and one is file upload. when i am uploading it i am getting error in DMFgenerateSSISpackage class. After debugging i found exact place where i am getting the error which is dmfEntityProxy.MigrateEntity(helper). (Error on Line number 2947)
Error description on view execution log:
Exception from HRESULT: 0xC0202042'0' 'CustomVendorCreditReturnHeaderLinesEntity' record(s) inserted in staging
Target status: didn;t run
Error seen at the time of debugging
at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFEntity.LogAndThrowNonByodException(Exception ex)\r\n at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFEntity.MigrateEntityImpl(Boolean IsComposite)\r\n at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFEntity.MigrateEntity(Boolean IsComposite)\r\n at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelperService.Service.ServiceHelper.MigrateEntity(DMFEntity entity)" string Type "General Exception" string
I also compared what is passing in helper class when direct importing with data management and via runbasebatch code. the only difference i found is sheetlookup value is not passing in helper call via code.
Note: I have created one template in data management and added my custom entity there. then I created Import data project in Data management and attached template in that. I am not getting any value in sheetlookup as i attaching template here.
I am trying to upload Excel File. even tried with CSV as well.(but requirement is for excel).
any suggession or help would be appreciated.