Skip to main content
Known Participant
Jun 12, 2024 3:47 PM UTC
Question

Data Store error

Hi All,

I have recently updated a data type via a new version XSD , it was successful and I also went in and published my Data Store.

And old PM which works fine in higher environments with the old version of the data type is throwing me this error every time I try to write to DB, 

An error occurred while trying to write to the data store [MOR Data Store].  No values have been written. Details: org.hibernate.exception.ConstraintViolationException: could not execute statement (APNX-1-4208-004)

Was this caused due to the update of the data type?

any suggestions?

thanks in advance

6 replies

stefanhelzle0001
Brainy
Jun 12, 2024 3:50 PM UTC

Any details in the tomcat stdout log file?

Known Participant
Jun 12, 2024 3:52 PM UTC

I do not have access to the log file unfortunately

stefanhelzle0001
Brainy
Jun 12, 2024 3:55 PM UTC

Then I need to start guessing ...

Could it be that in the higher environment, that data story is not published, but saved as a draft?

And I think you should try to get a look at the log files.

karumurua531442
Participating Frequently
Jun 13, 2024 5:22 AM UTC

hi [mention:0ab51f6183f24275bb64f62a11054752:e9ed411860ed4f2ba0265705b8793d05] I believe you will find more detail (including the specific column(s) that are failing to insert and usually the reason ) in the Appian System Logs, specifically tomcat-stdout.log.

Known Participant
Jun 13, 2024 5:45 PM UTC

Hi I have admin access now but I don't see the option to see the logs under monitoring