DataGrid2 Error whenever a user accesses it for the first time.

0
Hi   I am using the newest 2.13.0 version of DataWidgets with personalisation to remember both column sizes and filter options.  This is working perfectly for all users apart from the very first time they access the page with the DataGrid2 in it, they are given an error message but after reopening the page the error is no longer there and everything functions as intended.   My DGPersonalisation Entity is associated to Account and all DG2s are wrapped in a DataView which searches and returns DGPersonalisation if it exists and creates one if it doesn't.  This seems to run correctly when debugging but afterwards the error pops up.      
asked
1 answers
0

Hi Grant

 

The cause of the error appears to be a unique constraint violation: duplicate column value violates its unique constraint.

This indicates that two items with the same id are created in your association table (as the table where the issue occurs is 'homepage$dgpersonalisation'.

This forum post has a similar issue, but perhaps it could be helpful: https://community.mendix.com/link/space/databases/questions/89644 

Good luck

answered