"Could not save change - data was changed after query. - System will re-query record " error..

101 views
Skip to first unread message

Adi Mulyo

unread,
Jun 12, 2018, 2:50:32 AM6/12/18
to iDempiere
i have created "z_wifipricelist_id" column to c_project table and  synchronized the column. 
but when  i want to edit or create new record of project, the error (Could not save changes - data was changed after query. - System will re-query record.: z_wifipricelist_ID= 1000000(java.lang.Integer) != DB: null -> New: 1000001(java.lang.Integer)) is appear. how to fix it ?

i have deleted from database and  synchronize again, but the error still appear. 

thanks you, sorry for my bad english.

Nicolas Micoud

unread,
Jun 12, 2018, 3:27:11 AM6/12/18
to iDempiere
Do a Reset Cache (from idempiere monitor)

That should solve the issue

Nicolas

Adi Mulyo

unread,
Jun 12, 2018, 3:48:12 AM6/12/18
to iDempiere
thank for your suggestion, but the error still appear when edit  project data.. 
 
i guess the problem is in my field, because when i create new record, the error is : Database Error.: DBExecuteError:ERROR: null value in column "z_wifipricelist_id" , 
the field is not give the value, but null value.. 
Reply all
Reply to author
Forward
0 new messages