Question

PostgreSQL synchronisation error

2

We've been changing our model like crazy but on synchronizing the PostgreSQL database we are treated to the following error: ALTER TABLE "documentmanager$mxversion_user" ADD "system$userid" int4 NOT NULL; ERROR: column "system$userid" contains null values (SQL State: 23502, Error Code: 0) All changes are rolled back. 2009-12-24 10:32:13.938 INFO - CONNECTIONBUS: The commands are written to file 'D:\source\projects\ANTProject\WEB-INF\model\20091224103213all database_commands.sql'. 1: Exception raised: org.postgresql.util.PSQLException: ERROR: column "system$userid" contains null values b: Back x: Shutdown Type your choice and press <enter> to continue: 1: Exception raised: org.postgresql.util.PSQLException: ERROR: column "system$userid" contains null values b: Back x: Shutdown Any thoughts???

asked 2009-12-24

Michel Vermeer

1 answers

Jonathan Veldhuizen · Accepted Answer · 2009-12-24

The table "documentmanager$mxversion_user" is in use to store the association DocumentManager.MxVersion_User. Because of extensive renames or moves of the metaobjects of this association, the Mendix Runtime cannot define how the changes must being reflected in this table. The Runtime now tries to create the new database column "system$userid". However, there are rows in this table which block this column addition.

Is it necessary that the data of this association still exist or can it safely being removed? In the last case, remove all rows of the table "documentmanager$mxversion_user" and synchronize again.

When the association may not be emptied, check if you can see which column in the association must be renamed to "system$userid". When you know this, do it manually with a database tool and synchronize again.