Finance | Project Operations, Human Resources, ...

Data Import export framework

(1) Share

Report

Posted on by Lathi

Hi experts,

I have created an entity to load the cost price of the item in the material master data when importing by the legal entity using the data import-export framework for entry attributes did not receive any error at source (get stagging data) run file from the path, am facing the below error,

I also checked that the price field is already present in the source-target mapping.

can anyone please suggest a reason why I am getting this error? how is able to fix it

your reply is highly appreciated

Thanks in advance

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (1)

Report

Hi Lathi,

Are you using csv as input format? If so, please check this thread. You might be facing the same issue.

Was this reply helpful? Yes No
Lathi on at

Like (1)

Report

HI Gunjan,

Yes, I'm using the CSV file format to import the data, so what should I check did you meant the file?

sorry but i didn't get your point

Was this reply helpful? Yes No
WillWU 22,361 on at

Like (1)

Report

Hi Lathi,

Yes, please check if you have a space there at the "price" filed in your CSV file header,

Was this reply helpful? Yes No
Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

You can check source file. If there is a space after "Price". You may also try to re-generate the source file and check if that takes care of this error.

Was this reply helpful? Yes No
Lathi on at

Like (0)

Report

Thank you so much Gunjan for the great assistance,

I fixed the above error but now I have encountered this new error at the time of (copy data to target), please also suggest me to fix it

Thanks

Was this reply helpful? Yes No
Lathi on at

Like (0)

Report

Thank you so much Will, for the great assistance,

I fixed the above error but now I have encountered this new error at the time of (copy data to target), please also suggest me to fix it

Thanks

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi Lathi,

Looks like it is trying to convert the Cost field from string to int which is causing the error. Can you try synchronizing the table "InventItemPriceSim" and check if you get any errors?

Was this reply helpful? Yes No
WillWU 22,361 on at

Like (0)

Report

Hi Lathi,

Please also check this old thread, you have to convert some enum values in your table by yourself.

community.dynamics.com/.../data-migration-sql-error-description-microsoft-sql-server-native-client-11-0-sql-server-conversion-failed-when-converting-the-nvarchar-value-string-to-data-type-int

Was this reply helpful? Yes No