Process engine persistence exception

Camunda 7 Topics Discussion & Questions
1

Hi,

Process engine persistence exception is thrown sometimes by the Camunda engine

What is the solution for this?

2

Hi @deepti,

Could you please attach the complete stacktrace of the error.

Best regards,
Yana

1 Like
3

catalina.2017-09-26.log (757.6 KB)

Here is the log file.

4

Hello @deepti,

Thank you for the logs.

  1. Which version of the camunda engine do you use?
  2. Also which db driver do you use?

Best regards,
Yana

5
  1. I am using camunda v7.7.0
  2. ms sql jdbc driver
6

Hi,

Sorry for the late response. Which version of this driver do you use?

Best regards,
Yana

7

Hi Yana,

mssql-jdbc-6.2.1

8

Hi @deepti,

Could you please share your database configuration or more specifically tomcat connection pool configuration. It is possible that you have not valid connections in the pool. (Similar issue)

Best regards,
Yana

9

Hi Yana,

I have added the below keys to my tomcat connection pool configuration. :
testOnBorrow=“true”
validationQuery=“SELECT 1”

After adding these 2 keys , I dont seem to have the problem. Here is my updated connection pool configuration:

<Resource name="jdbc/ProcessEngine"
          auth="Container"
          type="javax.sql.DataSource" 
          factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
		  testOnBorrow="true"
		  validationQuery="SELECT 1"
          uniqueResourceName="Camunda"
          driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver" 
          url="jdbc:sqlserver://LAPTOP-28BCF54R\SQLEXPRESS;databaseName=Camunda;integratedSecurity=true"
          defaultTransactionIsolation="READ_COMMITTED"
          username="sa"  
          password="mypassword"
          maxActive="20"
          minIdle="5" />

Is this okay?

10

Hi Deepti,

I am happy that the issue has been resolved.
This seems to be common problem among the tomcat users however with this configuration everything is ok.
Monitor your system for couple of days and come back to us if you notice the error again.

Best regards,
Yana

1 Like
11

Hi Yana,
Thanks a lot for your help.

12

excellent, solved, thank you