362
Hi All,
I have a field in target table which is mandatory and will be filled through some business logic. Now i have created an entity for the same table and would like to fill the same mandatory field value by the business logic.I have written the logic in mapEntitytoDataSource. However i am getting the error as The data value violates integrity constraints.Could you please suggest.
Thanks
Venky
Hi All,
It was the data issue and giving correct data has resolved it.Thanks All
Have you regenerated the staging table? Did you synchronize the database after this change? Have you also regenerated field mapping or the entity in the entity list?
What's the data type of that field . I saw this error on multiple times one of the reason I remember is, when your length of data is actually greater than field length.
Hi Andre,
I have checked the field on entity and respective staging table and made the mandatory property as No. But still i am getting the same issue. Please share you thoughts on this...
Hi Venky,
Please check your staging table and data entity settings for this field. If you have added this field on the entity itself, make sure it is not mandatory on the data entity.
#1
André Arnaud de Cal...
291,759
Super User 2024 Season 2
#2
Martin Dráb
230,468
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
