Primary data with date cannot be uploaded even though validation was successful

Issue

The Primary Data contain values of the type Date and the system stops during the upload, although the validation was successful.

Explanation

Bexis 2 works in the database with the date format: ISO MDY. If you install postgres on a German speaking server, it is possible that the format for postgres is set to ISO DMY by default. Regardless of the date in the primary data, all date values are internally converted to ISO MDY.

Solution

1. Open the data folder in the installation folder of Postgres eg.: C:\Program Files\PostgreSQL\10\data
2. Open the file postgresql.conf with a text editor
3. Search for datestyle
4. Change the datestyle to 'iso, mdy'
5. Save config
6. Now postgres has to be restarted. For this the program pgadmin has to be started. On the left side, all servers are listed. With a right click on the server, you get the option to close and reconnect the server connection.