Hi @ani2409 ,
So you need to do as they stated in error message. Column that is chosen to be primary key needs to be defined as NOT NULL.
Additionaly, could you check if on DEV environement you don't have null values in x_key column? Because, in this case, the null values wiill violate NOT NULL constraint.
And it can explain why on UAT the same code works. On UAT you have either:
- differently defined x_key column (with NOT NULL)
- different data compared to DEV environment (they don't contain NULL values in key column)