Hi,

No I am not using Indexes .

Please find screenshot

I had this exact same error yesterday. I was trying to change a FK to 0 as well. Although zero is the null stardand value, even when the FK is not mandatory, the platform will validate and block the 0 value. So, basically you won't be able to change to zero inside this aggregate trick.

Yes, Same thing happened. I am trying to change the value of FK . 

You'll need to change to a valid FK or use another way to update it... a timer with an SQL query running when published should do the work.

Can you please share me example how can use it

Just set a timer to run when publish. Set a SQL UPDATE like this one bellow.

Be carreful with the conditions or the entire table will be updated.

If the FK is not mandatory it should work fine.

Ok. I will try this, if I am getting any issues, then I will let you know.

Hey there.

If this solution solved you issue, I would be glad if you mark as solution :)

Did it solve you issue?

Hi,

In  entity there is one FK value . and I want to set the value for FK .When I set value this error appeared. 

Hi Purva,

The FK value which you are setting is already exist in the database? because you should see the option of drop down like example below, if you already have data for it.

I have tried to set the FK key in my entity for which I don't have value in it then I got the same error.

can you make sure you have data with same Id in your FK entity and you trying to set the same Id?

Regards,

Manish Jawla

Yes, Same Id I try to use there which is show in dropdown 

this error appear with this record not with other records
when i try to change any values

error report:

1 record couldn't be updated.

90 - No records affected.

For more information, check the Service Center error logs.