Issue With Oracle Database Connectivity

Camunda 7 Topics Discussion & Questions
6

Hi Thorben,
I stucked in one more thing,
Actually I was connected to oracle database , but all tables are empty(no data).
But I need some default data like users,groups … which present in h2 database.
If possible, please give some suggestions

7

I am running into same issue. I am running Camunda 7.9, Oracle 11.2.0.4.0, I am using ojdbc6 11.2.0.2.0 and I also added the config parameter in my process.xml as below.
process-archive name=“sampleapp-pa”>
process-engine>default
properties
<-property name=“isDeleteUponUndeploy”>false <-/property>
<-property name=“isScanForProcessDefinitions”>true<-/property>
<-property name=“jdbcBatchProcessing”>false<-/property>

/process-archive>

But still getting the error
org.camunda.bpm.engine.rest.exception.RestException: Cannot submit task form 628553ee-b50c-11e8-b2ce-0050568d09f4: ENGINE-03005 Execution of ‘DELETE TaskEntity[628553ee-b50c-11e8-b2ce-0050568d09f4]’ failed. Entity was updated by another transaction concurrently.
at org.camunda.bpm.engine.rest.sub.task.impl.TaskResourceImpl.submit(TaskResourceImpl.java:127)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)

8

Note that this exception is expected if the same entity is modified by two transactions in parallel. See https://docs.camunda.org/manual/7.9/user-guide/process-engine/transactions-in-processes/#optimistic-locking for details.

Cheers,
Thorben

9

Thank you for your response. So what would be the solution for me to get through this error. Right now my application is simple approval request workflow which is same as twitter review sample application. Here after the tweet is approved, I am trying to store it in the database. Right now as soon as I hit the submit after checking the “Approved” flag, its throwing error and not able to proceed further.

10

Hi @ram_perl,

try to disable the JDBC batch processing: https://docs.camunda.org/manual/7.9/user-guide/process-engine/database/#jdbc-batch-processing.

It doesn’t work for Oracle 11.

Hope this helps, Ingo

11

Hi Ingo_Richtsmeier, Thank you for the reply. I already did that and still getting same issue.

13

Any suggestion. I disable the jdbcBatchProcessing parameter inside my processing.xml using the property. Am I doing something wrong or is there any other way of setting it.

14

Hi @ram_perl,

jdbcBatchProcessing is part of the <process-engine> section: https://docs.camunda.org/manual/7.9/reference/deployment-descriptors/tags/process-engine/#configuration-properties

Where did you place it?

Cheers, Ingo

15

Here is my processes.xml file under resources/META-INF directory
process-archive name=“sampleapp-pa”>

process-engine>default

properties

<-property name=“isDeleteUponUndeploy”>false <-/property>

<-property name=“isScanForProcessDefinitions”>true<-/property>

<-property name=“jdbcBatchProcessing”>false<-/property>

/process-archive>
[/quote]

16

You should add the configuration in the bpm-platform.xml (assuming you use the Tomcat distribution).

17

I added bpm-platform.xml in META-INF directory with the following entries. but issue remains same. Still getting the same error. I am using camunda 7.9 version, Ojdbc6-11.2.0.2.0
?xml version=“1.0” encoding=“UTF-8”?>
bpm-platform xmlns=“http://www.camunda.org/schema/1.0/BpmPlatform” xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance”
xsi:schemaLocation="http://www.camunda.org/schema/1.0/BpmPlatform http://www.camunda.org/schema/1.0/BpmPlatform ">
Please Help. we are struck with this issue.


<process-engine name="default">
    <job-acquisition>default</job-acquisition>
    <properties>
                 <property name="jdbcBatchProcessing">false</property>
    </properties>
</process-engine>
18

Hi Ingo

I still get the same error after placing the bpm-platform. Xml under META-INF folder.

Please help.

Regards

Ram

Sent from Yahoo Mail on Android

19

Hi Ram,
Kindly paste the contents of your bpm-platform.xml and server.xml .

20

Sorry for the late. I am able to resolve this issue by setting the parameter using process api. Now I am not getting the error. Thank you so much for offering the help.

21

We are facing the same issue …
Oracle version - PL/SQL Release 11.2.0.4.0 - Production
Using camunda-bpm-spring-boot-starter-webapp-ee
Spring-Boot: (v2.1.1.RELEASE)
Camunda BPM: (v7.10.0-ee)
Camunda BPM Spring Boot Starter: (v3.2.0)

Where do we need to add this property
name=“jdbcBatchProcessing” as false property ??
From the above posts, it seems processes.xml under META-INF is not the correct place ?

Exact trace log

ENGINE-08043 Exception while performing ‘Deployment of Process Application TestCamundaspringbootSeedApplication’ => 'Deployment of process archive ‘application-process-list’: ENGINE-03005 Execution of ‘UPDATE PropertyEntity[next.dbid]’ failed. Entity was updated by another transaction concurrently

TIA

22

One solution is adding the property in the code - the sample is provided in the below link

23

Hi @ppbiz,

with Camunda 7.10 you can configure camunda.bpm.database.jdbc-batch-processing in your application.yaml (https://docs.camunda.org/manual/7.10/user-guide/spring-boot-integration/configuration/#camunda-engine-properties)

Cheers, Ingo

24

Thanks Ingo …

25

Hi,
I update the batch processing property in my service but this property not working in my service.
Can please help any reason. Same working in my local but I deployed my service in docker. In docker region this property not loading
parameter camunda.bpm.database.jdbc-batch-processing: false
Jdk 11 and Oracle 11g and camunda 7.10

26