Article - CS347815

How to modify ChangeWatcher database connection attempts in ThingWorx Platform

Modified: 31-May-2023   


Applies To

  • ThingWorx Platform 9.1 to 9.3

Description

  • Sometimes when deploying OS security patches, the database becomes temporarily unavailable
  • ThingWorx Platform terminates / crashes / shuts down with error
    • com.microsoft.sqlserver.jdbc.SQLServerException: Cannot invoke a rollback operation when the AutoCommit mode is set to "true". ] which will not be reported to listeners!
      Error occurred during commit for the ThingworxPersistenceProvider persistence provider.
      ChangeWatcher failed to sync
      Model sync unable to update database with model changes after 10 attempts due to exception SHUTDOWN is in progress.
      Shutting down after failing to update database with model changes after 10 attempts.
  • Is it possible to increase the number of attempts to cover for the patch installation?
This is a printer-friendly version of Article 347815 and may be out of date. For the latest version click CS347815