Dual write project validation issue

(1) Share

Report

Posted on by Community member

I am getting the below error - I have searched for solutions but cannot ascertain the cause of the issue.

Project validation failed. [DIPV1033] Environment(True), Schema(True), and Integration Keys (False) must not be null.

It is saying that the integration keys for this dual write connection is null but I have a column that is the integration key so I am not sure why this error is persisting.

I have the same question (0)

All responses (4)

Answers (0)

Layan Jwei 8,097 Super User 2025 Season 2 on at

Like (0)

Report

Hi CommunityUser,

Here's what the Microsoft documentation says about integration keys (not sure if it will help)

Integration keys for the entity should match in both environments. If the entity key isn't available on either side, be sure to create entity keys. The integration key fields should be mapped to each other in the map.

Thanks,

Layan Jweihan

Was this reply helpful? Yes No
Weaveriski 23,618 Moderator on at

Like (0)

Report

Go back to the list of maps, in the top menu there is a connections option, and in there there is an integrations tab. For this entity check which integration keys are set.

Was this reply helpful? Yes No
Sachin Chandrashekar 23 on at

Like (0)

Report

Even I am facing same issue for few entities, with same configuration working in other environments, Let me know if you have any solutions?

Was this reply helpful? Yes No
Suggested answer

PerezAguiar Microsoft Employee on at

Like (0)

Report

Hey

Keyword on the message is the last part: "integration keys (False) must not be null". So if you login to your Dynamics FnO environment, go to Dual Write and then on top select "Integration keys", you should be able to navigate to the table that threw the error. Most likely, you will have the table on the list of keys but no field selected:

Error:

And if I go to IntegrationKeys, I will see this:

To which We should generate a value:

Best regards,

Was this reply helpful? Yes No