Skip to main content
S
sureshs276515
March 4, 2025
Question

JDBC begin transaction failed

  • March 4, 2025
  • 9 replies
  • 0 views

Hi All,

we are getting JDBC begin transaction failed: in the process model when one record going to store in database.

and another process  model we are getting -Unable to write to or delete from the source due to system error.
Error Details: Failed to update database "TN_Transaction" because the database is read-only.

note : both error happening at same time. 

could you please someone help me on which scenario we wil get this error.

thanks!

    9 replies

    stefanhelzle0001
    stefanhelzle0001
    March 4, 2025
    because the database is read-only

    This smells like an issue on the DB side. I suggest to contact your DB admin team.

    mpoojas0001
    mpoojas0001
    March 4, 2025

     [mention:cb656964172a4c65ba07f4d4ada5a0c6:e9ed411860ed4f2ba0265705b8793d05] ,It could be due to connectivity issues with the database, incorrect credentials, or database settings that restrict write operations, probably when database is being backed up or during maintenance periods. check with your admin if you have been given 'write' access. check if you have appropriate permissions to write to the "TN_Transaction" database.

    karumurua531442
    karumurua531442
    March 4, 2025

    Hi  [mention:cb656964172a4c65ba07f4d4ada5a0c6:e9ed411860ed4f2ba0265705b8793d05], As [mention:a11f77a729fb4db2af76b09948583328:e9ed411860ed4f2ba0265705b8793d05]  mentioned, it would be a failure from the database side—database in read-only mode, transaction locking, and connection loss. I suspect there might be an issue with the Appian connection pool. Did you check the system logs? Did you find any information in the logs?

      S
      sureshs276515Author
      March 4, 2025

      HI [mention:3510a5189ce1477eaf2e09f5858c87e9:e9ed411860ed4f2ba0265705b8793d05]  thanks for response, this is issue happens in the production, that to its not happening for all all records its happens for only 2 records in the specific data source.

      karumurua531442
      karumurua531442
      March 4, 2025

      Did you check the data for those two records? Is the data correct? Are there any triggers set up for that database table? Also, please check if any processes are running in the background.

      Terms & ConditionsAccessibility statement