How to deploy Camunda Project in debug mode from eclipse to camunda-bpm-tomcat

Getting the following error while deploying :

INFO: ENGINE-08024 Found processes.xml file at file:/D:/camunda-bpm-tomcat-7.5.0/server/apache-tomcat-8.0.24/webapps/camunda-example-multi-tenancy-tenant-identifier-shared/WEB-INF/classes/META-INF/processes.xml
Sep 28, 2016 12:57:54 PM org.camunda.commons.logging.BaseLogger logInfo
INFO: ENGINE-08023 Deployment summary for process archive ‘tenant2-archive’:

    tenant2_process.bpmn

Sep 28, 2016 12:57:54 PM org.camunda.commons.logging.BaseLogger logError
SEVERE: ENGINE-16004 Exception while closing command context:

Error querying database. Cause: org.h2.jdbc.JdbcSQLException: Column “D.SOURCE_” not found; SQL statement:

CREATE FORCE VIEW PUBLIC.0 AS
SELECT
B.NAME
,
MAX(D.DEPLOY_TIME_) AS DEPLOY_TIME_
FROM PUBLIC.ACT_GE_BYTEARRAY B
INNER JOIN PUBLIC.ACT_RE_DEPLOYMENT D
ON 1=1
WHERE (((D.NAME_ = ?1)
AND ((D.SOURCE_ IS NULL)
OR (D.SOURCE_ = ?2)))
AND (B.NAME_ IN(?3)))
AND (B.DEPLOYMENT_ID_ = D.ID_)
GROUP BY B.NAME_ [42122-168]

The error may exist in org/camunda/bpm/engine/impl/mapping/entity/Resource.xml

The error may involve org.camunda.bpm.engine.impl.persistence.entity.ResourceEntity.selectLatestResourcesByDeploymentName

The error occurred while executing a query

SQL: select B.* from ACT_GE_BYTEARRAY B inner join (select B.NAME_, MAX(D.DEPLOY_TIME_) DEPLOY_TIME_ from ACT_GE_BYTEARRAY B inner join ACT_RE_DEPLOYMENT D on B.DEPLOYMENT_ID_ = D.ID_ where D.NAME_ = ? and (D.SOURCE_ is null or D.SOURCE_ = ? ) and B.NAME_ in ( ? ) group by B.NAME_) LAST_RESOURCE on B.NAME_ = LAST_RESOURCE.NAME_ inner join ACT_RE_DEPLOYMENT D on B.DEPLOYMENT_ID_ = D.ID_ and D.DEPLOY_TIME_ = LAST_RESOURCE.DEPLOY_TIME_ and D.NAME_ = ? and (D.SOURCE_ is null or D.SOURCE_ = ? ) and D.TENANT_ID_ = ?

Cause: org.h2.jdbc.JdbcSQLException: Column “D.SOURCE_” not found; SQL statement:

CREATE FORCE VIEW PUBLIC.0 AS
SELECT
B.NAME
,
MAX(D.DEPLOY_TIME_) AS DEPLOY_TIME_
FROM PUBLIC.ACT_GE_BYTEARRAY B
INNER JOIN PUBLIC.ACT_RE_DEPLOYMENT D
ON 1=1
WHERE (((D.NAME_ = ?1)
AND ((D.SOURCE_ IS NULL)
OR (D.SOURCE_ = ?2)))
AND (B.NAME_ IN(?3)))
AND (B.DEPLOYMENT_ID_ = D.ID_)
GROUP BY B.NAME_ [42122-168]
org.apache.ibatis.exceptions.PersistenceException:

Error querying database. Cause: org.h2.jdbc.JdbcSQLException: Column “D.SOURCE_” not found; SQL statement:

CREATE FORCE VIEW PUBLIC.0 AS
SELECT
B.NAME
,
MAX(D.DEPLOY_TIME_) AS DEPLOY_TIME_
FROM PUBLIC.ACT_GE_BYTEARRAY B
INNER JOIN PUBLIC.ACT_RE_DEPLOYMENT D
ON 1=1
WHERE (((D.NAME_ = ?1)
AND ((D.SOURCE_ IS NULL)
OR (D.SOURCE_ = ?2)))
AND (B.NAME_ IN(?3)))
AND (B.DEPLOYMENT_ID_ = D.ID_)
GROUP BY B.NAME_ [42122-168]

The error may exist in org/camunda/bpm/engine/impl/mapping/entity/Resource.xml

The error may involve org.camunda.bpm.engine.impl.persistence.entity.ResourceEntity.selectLatestResourcesByDeploymentName

The error occurred while executing a query

SQL: select B.* from ACT_GE_BYTEARRAY B inner join (select B.NAME_, MAX(D.DEPLOY_TIME_) DEPLOY_TIME_ from ACT_GE_BYTEARRAY B inner join ACT_RE_DEPLOYMENT D on B.DEPLOYMENT_ID_ = D.ID_ where D.NAME_ = ? and (D.SOURCE_ is null or D.SOURCE_ = ? ) and B.NAME_ in ( ? ) group by B.NAME_) LAST_RESOURCE on B.NAME_ = LAST_RESOURCE.NAME_ inner join ACT_RE_DEPLOYMENT D on B.DEPLOYMENT_ID_ = D.ID_ and D.DEPLOY_TIME_ = LAST_RESOURCE.DEPLOY_TIME_ and D.NAME_ = ? and (D.SOURCE_ is null or D.SOURCE_ = ? ) and D.TENANT_ID_ = ?

Cause: org.h2.jdbc.JdbcSQLException: Column “D.SOURCE_” not found; SQL statement:

1 Like

Hi @Karandeep_Singh,

could you attach tenant2_process.bpmn and tell us a bit more details about your environment please? is that a multi-tenant setup?

Cheers,
Askar

HI Askar,

Yes, I am deploying multi-tenant setup to camunda-bpm-tomcat-7.5.0. I am deploying the webapp from eclipse in debug mode which caused this fatal error. In other case, if deploy directly to webapps folder of the server(apache-tomcat-8.0.24), it is working fine.
Requirement: need to debug the project from eclipse using breakpoints.

tenant2_process.bpmn (3.8 KB)

Hi @Karandeep_Singh,

would it be an option for you to use remote debugging?

Cheers,
Askar

Hi Askar,

I have tried it and another options, but with no effect at all. Actually, Camunda deployment couldn’t able to read h2.jdbc queries and result in the following exception.

If, I deploy the same deployment directly to webapps, everything is working fine.

Fyi, eclipse server get published in debugging mode, but having no data record of users if accessed from web url.

HI Askar,

Can you provide any alternate solution for the same problem.
Any input provided will be helpful.

Hi @Karandeep_Singh,

I did not understand if you tried remote debugging. You have to start tomcat separately with additional jvm parameters (not from eclipse). And then configure in eclipse a remote debug session.

Cheers,
Askar.

Thanks Askar, it works. Sorry for the delay revert.

1 Like