getting error while Importing data through DMF data project using x++ in d365fo

Hi All,

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 

code: "DMF043"

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). 

Link followed:

any suggession or help would be appreciated.