Query structure does not match entity data

(0) Share

Report

Posted on by Community Member

I am going to update the Sales Base Price of some items. For that, I am using Items Entity in DIXF. the thing is when I want to copy from staging table to target database I get this error "Query structure does not match entity data"

The followings are the Fields I am using for importing the data:

DisplayProductNumber

ItemId

InventTableModuleSales_Price

Am I choosing the right entity?

Have you got any Idea why am I getting this error?

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Sort by

André Arnaud de Cal... 304,182 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Mehrdad,

Can you check if recreating the target mapping can solve your issue? Also have a look at the next thread: community.dynamics.com/.../134917

Was this reply helpful? Yes No
Gustgut 175 on at

Like (0)

Report
Copy link

Link copied!

Hello! Did you solve this? I'm getting the same error with product entity. Thank you!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi,

I don't remeber exactly how did I solve this issue. But I think the problem was the changes I made into the project that had been created by DIXF wizard.

if you have done the same thing I recommend to remove the project and all the objects that have been created and create it again from scratch.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Hello,

I have fixed the same issue by deleting the used Target entity(Ex. DIXF>Setup>Target Entities>Entity Name- Items) and import it again to the Target entity master form.

This will work for you!!!

Regards
Atul Jain

Was this reply helpful? Yes No
Sachin Agrawal 150 on at

Like (0)

Report
Copy link

Link copied!
If you are trying to update the existing information like product. System was giving me the error. So, I deleted the same item and upload it again using DIXF.

Was this reply helpful? Yes No