Hi,
Concerns an ODC application.
When trying to do something wrong with the database (e.g. to store an entity record without mandatory foreign keys) I get messages like this one:
OS-BERT-00000 - 23503: insert or update on table "model_y6brwh_qa0jngx2q3cl3wga3" violates foreign key constraint "osfrk_yamcgvftiau_model_y6brwx2q3cl3wga3_model_y6brwywx5q2t6jm0"
DETAIL: Detail redacted as it may contain sensitive data. Specify 'Include Error Detail' in the connection string to include this information.
The database, which I'm dealing with, is not an external one. So where can I "Specify 'Include Error Detail' "? I tried to find such a place in the ODC Portal but I failed...
Regards
Tomasz
Hi @Tomasz M Lipinski ,
my guess would be that this error comes fromy PostgreSQL, not OutSystems
I don't think we have any say in the connection string between ODC application and postgreSQL database.
This is PostgreSQL documentation, you can see the option 'include error detail'
Dorine
Could you figure out a way to get more details about the error messages coming from PostgreSQL?
Hello,
Here is a detailed list of PostgreSQL error codes along with their descriptions. You can check it to better understand the error you're encountering: https://www.postgresql.org/docs/current/errcodes-appendix.html
Hope it helps.
Thank you.