Camunda 8 integrate with Oracle connector

Camunda 8 Topics
1

Hi Camunda Community,

I’m using Camunda 8.6.5 self-managed, i tried integrate with Oracle connector (Oracle Database Connector | Camunda Marketplace).

Step1: I created simple BPMN to insert into Oracle db.
image

Step2: Hosted the connector using this command “java -cp "connector-runtime-application-8.6.5-with-dependencies.jar;connector-oracle-0.1.0-SNAPSHOT-with-dependencies.jar” io.camunda.connector.runtime.app.ConnectorRuntimeApplication"

image
image1156×280 32.4 KB

Step3: When i run the process, i could see that the Oracle connecter received the job and process it. But there is, error
"2025-02-10T09:55:26.787+08:00 INFO 2072 — [pool-2-thread-1] i.c.c.r.c.outbound.ConnectorJobHandler : Received job: 2251799815036600 for tenant:
2025-02-10T09:55:26.838+08:00 ERROR 2072 — [pool-2-thread-1] i.c.c.r.c.outbound.ConnectorJobHandler : Exception while processing job: 2251799815036600 for tenant:

io.camunda.connector.api.error.ConnectorException: Exception: InvalidDefinitionExceptionwas raised

  •    at io.camunda.connector.runtime.core.outbound.JobHandlerContext.mapJson(JobHandlerContext.java:104)*

  •    at io.camunda.connector.runtime.core.outbound.JobHandlerContext.bindVariables(JobHandlerContext.java:63)*

  •    at com.infosys.camundaconnectors.db.oracle.OracleDBFunction.execute(OracleDBFunction.java:35)*

  •    at io.camunda.connector.runtime.core.outbound.ConnectorJobHandler.handle(ConnectorJobHandler.java:184)*

  •    at io.camunda.connector.runtime.outbound.jobhandling.SpringConnectorJobHandler.lambda$handle$0(SpringConnectorJobHandler.java:75)*

  •    at io.micrometer.core.instrument.AbstractTimer.record(AbstractTimer.java:250)*

  •    at io.camunda.zeebe.spring.client.actuator.MicrometerMetricsRecorder.executeWithTimer(MicrometerMetricsRecorder.java:50)*

  •    at io.camunda.connector.runtime.outbound.jobhandling.SpringConnectorJobHandler.handle(SpringConnectorJobHandler.java:66)*

  •    at io.camunda.zeebe.client.impl.worker.JobRunnableFactoryImpl.executeJob(JobRunnableFactoryImpl.java:45)*

  •    at io.camunda.zeebe.client.impl.worker.JobRunnableFactoryImpl.lambda$create$0(JobRunnableFactoryImpl.java:40)*

  •    at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:572)*

  •    at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317)*

  •    at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:304)*

  •    at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)*

  •    at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)*

  •    at java.base/java.lang.Thread.run(Thread.java:1575)*

2025-02-10T09:55:26.957+08:00 INFO 2072 — [pool-2-thread-1] i.c.c.r.c.outbound.ConnectorJobHandler : Received job: 2251799815036600 for tenant:
2025-02-10T09:55:26.968+08:00 ERROR 2072 — [pool-2-thread-1] i.c.c.r.c.outbound.ConnectorJobHandler : Exception while processing job: 2251799815036600 for tenant:

io.camunda.connector.api.error.ConnectorException: Exception: InvalidDefinitionExceptionwas raised

  •    at io.camunda.connector.runtime.core.outbound.JobHandlerContext.mapJson(JobHandlerContext.java:104)*

  •    at io.camunda.connector.runtime.core.outbound.JobHandlerContext.bindVariables(JobHandlerContext.java:63)*

  •    at com.infosys.camundaconnectors.db.oracle.OracleDBFunction.execute(OracleDBFunction.java:35)*

  •    at io.camunda.connector.runtime.core.outbound.ConnectorJobHandler.handle(ConnectorJobHandler.java:184)*

  •    at io.camunda.connector.runtime.outbound.jobhandling.SpringConnectorJobHandler.lambda$handle$0(SpringConnectorJobHandler.java:75)*

  •    at io.micrometer.core.instrument.AbstractTimer.record(AbstractTimer.java:250)*

  •    at io.camunda.zeebe.spring.client.actuator.MicrometerMetricsRecorder.executeWithTimer(MicrometerMetricsRecorder.java:50)*

  •    at io.camunda.connector.runtime.outbound.jobhandling.SpringConnectorJobHandler.handle(SpringConnectorJobHandler.java:66)*

  •    at io.camunda.zeebe.client.impl.worker.JobRunnableFactoryImpl.executeJob(JobRunnableFactoryImpl.java:45)*

  •    at io.camunda.zeebe.client.impl.worker.JobRunnableFactoryImpl.lambda$create$0(JobRunnableFactoryImpl.java:40)*

  •    at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:572)*

  •    at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317)*

  •    at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:304)*

  •    at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)*

  •    at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)*

  •    at java.base/java.lang.Thread.run(Thread.java:1575)*

2025-02-10T09:55:26.993+08:00 INFO 2072 — [pool-2-thread-1] i.c.c.r.c.outbound.ConnectorJobHandler : Received job: 2251799815036600 for tenant:
2025-02-10T09:55:26.997+08:00 ERROR 2072 — [pool-2-thread-1] i.c.c.r.c.outbound.ConnectorJobHandler : Exception while processing job: 2251799815036600 for tenant:

io.camunda.connector.api.error.ConnectorException: Exception: InvalidDefinitionExceptionwas raised

  •    at io.camunda.connector.runtime.core.outbound.JobHandlerContext.mapJson(JobHandlerContext.java:104)*

  •    at io.camunda.connector.runtime.core.outbound.JobHandlerContext.bindVariables(JobHandlerContext.java:63)*

  •    at com.infosys.camundaconnectors.db.oracle.OracleDBFunction.execute(OracleDBFunction.java:35)*

  •    at io.camunda.connector.runtime.core.outbound.ConnectorJobHandler.handle(ConnectorJobHandler.java:184)*

  •    at io.camunda.connector.runtime.outbound.jobhandling.SpringConnectorJobHandler.lambda$handle$0(SpringConnectorJobHandler.java:75)*

  •    at io.micrometer.core.instrument.AbstractTimer.record(AbstractTimer.java:250)*

  •    at io.camunda.zeebe.spring.client.actuator.MicrometerMetricsRecorder.executeWithTimer(MicrometerMetricsRecorder.java:50)*

  •    at io.camunda.connector.runtime.outbound.jobhandling.SpringConnectorJobHandler.handle(SpringConnectorJobHandler.java:66)*

  •    at io.camunda.zeebe.client.impl.worker.JobRunnableFactoryImpl.executeJob(JobRunnableFactoryImpl.java:45)*

  •    at io.camunda.zeebe.client.impl.worker.JobRunnableFactoryImpl.lambda$create$0(JobRunnableFactoryImpl.java:40)*

  •    at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:572)*

  •    at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317)*

  •    at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:304)*

  •    at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)*

  •    at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)*

  •    at java.base/java.lang.Thread.run(Thread.java:1575)*"

At Operate Page, it shows JSON Processing error:

image
image964×236 10.8 KB

Can someone help me on this?

Regards,
Amirul

2

Hi @nor_amirul,

it’s hard to tell without the BPMN file. Could you share it so that we can see the connector’s configuration? The error suggests that it’s misconfigured.

Thanks
Jonathan

3

Hi @jroques , attached here is the BPMN file

diagram_1.bpmn (13.4 KB)

4

Hi @nor_amirul
You are using a template to configure the “Insert Data” but the BPMN does not contain it so we can’t see it.
Maybe you can share the configuration with some screenshots?

5

Hi @Alex_Voloshyn , here’s the screenshoot

image
image1154×915 39.4 KB