I was trying to use SQL Server database instead of H2 database for my Camunda Application. I have executed the create script as described in the document and have also successfully changed the server.xml file. I tried to re-start the tomcat server which also worked fine and I was also able to view the Admin web application successfully but then suddenly because of some issue an error occurred and the connection got aborted. Attached is the Stack trace:
log.txt (39.1 KB)
I figured that I also have to run the following commands for SQL Server as per the documentation-
Command 1 - ALTER DATABASE CAMUNDA_BPM
SET ALLOW_SNAPSHOT_ISOLATION ON
Command 2 - ALTER DATABASE CAMUNDA_BPM
SET READ_COMMITTED_SNAPSHOT ON
Question 1: The first command executed successfully but the second command is taking very long to execute. It has already been 30 minutes and it is still executing. How long can this take?
Question 2: Can my issue be actually because of non-execution of the above stated commands?
I am not sure if this is actually a Camunda question or not but any help or suggestion would be deeply helpful for me.
Thanks in advance.