Camunda :: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction

[sukdeb...@in.pwc.com]

Hi,

We have use camunda-bpm-jboss-7.1.0-Final in our application with mysql DB. We have been working since last 4-5 months in this application but now we are getting SQLException: Lock wait timeout exceeded error continuously in server log.

Can you help us to resolve this issue?

Please find the logs attached below,



### Error updating database.  Cause: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
### The error may involve org.camunda.bpm.engine.impl.persistence.entity.HistoricTaskInstanceEntity.updateHistoricTaskInstanceEvent-Inline
### The error occurred while setting parameters
### SQL: update ACT_HI_TASKINST set       EXECUTION_ID_ = ?,       NAME_ = ?,       PARENT_TASK_ID_ = ?,       DESCRIPTION_ = ?,       OWNER_ = ?,       ASSIGNEE_ = ?,       DELETE_REASON_ = ?,       TASK_DEF_KEY_ = ?,       PRIORITY_ = ?,       DUE_DATE_ = ?,       FOLLOW_UP_DATE_ = ?                             where ID_ = ?
### Cause: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
        at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)
        at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:147)
        at org.camunda.bpm.engine.impl.db.DbSqlSession.flushUpdates(DbSqlSession.java:687) [camunda-engine-7.1.0-Final.jar:7.1.0-Final]
        at org.camunda.bpm.engine.impl.db.DbSqlSession.flush(DbSqlSession.java:488) [camunda-engine-7.1.0-Final.jar:7.1.0-Final]
        at org.camunda.bpm.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:196) [camunda-engine-7.1.0-Final.jar:7.1.0-Final]
        at org.camunda.bpm.engine.impl.interceptor.CommandContext.close(CommandContext.java:126) [camunda-engine-7.1.0-Final.jar:7.1.0-Final]
        at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:99) [camunda-engine-7.1.0-Final.jar:7.1.0-Final]
        at org.camunda.bpm.engine.impl.interceptor.JtaTransactionInterceptor.execute(JtaTransactionInterceptor.java:59) [camunda-engine-7.1.0-Final.jar:7.1.0-Final]
        at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:32) [camunda-engine-7.1.0-Final.jar:7.1.0-Final]
        at org.camunda.bpm.engine.impl.TaskServiceImpl.setAssignee(TaskServiceImpl.java:111) [camunda-engine-7.1.0-Final.jar:7.1.0-Final]
        at org.camunda.bpm.engine.rest.sub.task.impl.TaskResourceImpl.setAssignee(TaskResourceImpl.java:199) [classes:]
        at sun.reflect.GeneratedMethodAccessor562.invoke(Unknown Source) [:1.7.0_51]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) [rt.jar:1.7.0_51]
        at java.lang.reflect.Method.invoke(Unknown Source) [rt.jar:1.7.0_51]
        at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:167) [resteasy-jaxrs-2.3.5.Final.jar:]
        at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:257) [resteasy-jaxrs-2.3.5.Final.jar:]
        at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:222) [resteasy-jaxrs-2.3.5.Final.jar:]
        at org.jboss.resteasy.core.ResourceLocator.invokeOnTargetObject(ResourceLocator.java:159) [resteasy-jaxrs-2.3.5.Final.jar:]
        at org.jboss.resteasy.core.ResourceLocator.invoke(ResourceLocator.java:107) [resteasy-jaxrs-2.3.5.Final.jar:]
        at org.jboss.resteasy.core.ResourceLocator.invokeOnTargetObject(ResourceLocator.java:154) [resteasy-jaxrs-2.3.5.Final.jar:]
        at org.jboss.resteasy.core.ResourceLocator.invoke(ResourceLocator.java:92) [resteasy-jaxrs-2.3.5.Final.jar:]
        at org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:542) [resteasy-jaxrs-2.3.5.Final.jar:]
        at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:524) [resteasy-jaxrs-2.3.5.Final.jar:]
        at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:126) [resteasy-jaxrs-2.3.5.Final.jar:]
        at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208) [resteasy-jaxrs-2.3.5.Final.jar:]
        at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55) [resteasy-jaxrs-2.3.5.Final.jar:]
        at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50) [resteasy-jaxrs-2.3.5.Final.jar:]
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.2.Final.jar:1.0.2.Final]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:295) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
        at org.camunda.bpm.engine.rest.filter.CacheControlFilter.doFilter(CacheControlFilter.java:47) [classes:]
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
        at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169) [jboss-as-web-7.2.0.Final.jar:7.2.0.Final]
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:145) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:336) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:653) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:920) [jbossweb-7.2.0.Final.jar:7.2.0.Final]
        at java.lang.Thread.run(Unknown Source) [rt.jar:1.7.0_51]
Caused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1084)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4232)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4164)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2615)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2776)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2838)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2082)
        at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1307)
        at org.jboss.jca.adapters.jdbc.CachedPreparedStatement.execute(CachedPreparedStatement.java:297)
        at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:404)
        at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:41)
        at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:66)
        at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:45)
        at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:108)
        at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:75)
        at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:145)
        ... 42 more

15:08:08,118 WARNING [ExceptionHandler] (http-/0.0.0.0:8080-34) org.camunda.bpm.engine.ProcessEngineException: Process engine persistence exception
        at org.camunda.bpm.engine.impl.interceptor.CommandContext.close(CommandContext.java:170)
        at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:99)
        at org.camunda.bpm.engine.impl.interceptor.JtaTransactionInterceptor.execute(JtaTransactionInterceptor.java:59)
        at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:32)
        at org.camunda.bpm.engine.impl.TaskServiceImpl.setAssignee(TaskServiceImpl.java:111)
        at org.camunda.bpm.engine.rest.sub.task.impl.TaskResourceImpl.setAssignee(TaskResourceImpl.java:199)
        at sun.reflect.GeneratedMethodAccessor562.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:167)
        at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:257)
        at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:222)
        at org.jboss.resteasy.core.ResourceLocator.invokeOnTargetObject(ResourceLocator.java:159)
        at org.jboss.resteasy.core.ResourceLocator.invoke(ResourceLocator.java:107)
        at org.jboss.resteasy.core.ResourceLocator.invokeOnTargetObject(ResourceLocator.java:154)
        at org.jboss.resteasy.core.ResourceLocator.invoke(ResourceLocator.java:92)
        at org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:542)
        at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:524)
        at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:126)
        at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)
        at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55)
        at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:295)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)
        at org.camunda.bpm.engine.rest.filter.CacheControlFilter.doFilter(CacheControlFilter.java:47)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149)
        at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:145)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:336)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:653)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:920)
        at java.lang.Thread.run(Unknown Source)
Caused by: org.apache.ibatis.exceptions.PersistenceException:
### Error updating database.  Cause: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
### The error may involve org.camunda.bpm.engine.impl.persistence.entity.HistoricTaskInstanceEntity.updateHistoricTaskInstanceEvent-Inline
### The error occurred while setting parameters
### SQL: update ACT_HI_TASKINST set       EXECUTION_ID_ = ?,       NAME_ = ?,       PARENT_TASK_ID_ = ?,       DESCRIPTION_ = ?,       OWNER_ = ?,       ASSIGNEE_ = ?,       DELETE_REASON_ = ?,       TASK_DEF_KEY_ = ?,       PRIORITY_ = ?,       DUE_DATE_ = ?,       FOLLOW_UP_DATE_ = ?                             where ID_ = ?
### Cause: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
        at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)
        at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:147)
        at org.camunda.bpm.engine.impl.db.DbSqlSession.flushUpdates(DbSqlSession.java:687)
        at org.camunda.bpm.engine.impl.db.DbSqlSession.flush(DbSqlSession.java:488)
        at org.camunda.bpm.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:196)
        at org.camunda.bpm.engine.impl.interceptor.CommandContext.close(CommandContext.java:126)
        ... 38 more
Caused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1084)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4232)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4164)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2615)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2776)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2838)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2082)
        at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1307)
        at org.jboss.jca.adapters.jdbc.CachedPreparedStatement.execute(CachedPreparedStatement.java:297)
        at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:404)
        at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:41)
        at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:66)
        at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:45)
        at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:108)
        at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:75)
        at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:145)
        ... 42 more

Thanks,
Shukdeb Paul

PwC | Senior Consultant - Consulting
Direct: +91 (0) 33 4404 4102 | Mobile: +91 (0) 977534 1535
Email: sukdeb...@in.pwc.com
PricewaterhouseCoopers Private Limited
Plot 56&57, Block DN, Sector-V, Saltlake
Kolkata - 700 091  |  India

---

The information transmitted, including any attachments, is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited, and all liability arising therefrom is disclaimed. If you received this in error, please contact the sender and delete the material from any computer.

[webcyberrob]

Hi,

Just for info, I see the same exception in my development environment when I put the engine under load. Ive not yet attempted to resolve this.

regards

Rob

[Sebastian Menski]

Hi Shukdeb and Rob,

are you using MySQL with the InnoDB storage engine? And do you have many process instances running? Than it could help you to increase the innodb_lock_wait_timeout parameter of your database.

Cheers,

Sebastian

[webcyberrob]

Hi Sebastian,

Yes I was playing with a multi-instance parallel, subprocess which calls 500 instances of another process...I was just reading the MySQL docs, looks like the default is 50 seconds. Interestingly it seems to timeout on an insert into ACT_RU_VAR table...

regards

Rob

[sukdeb...@in.pwc.com]

made the lock time out to 120 sec , not helping .   Need urgent help


23:25:56,892 SEVERE [org.camunda.bpm.engine.impl.interceptor.CommandContext] (org.springframework.scheduling.quartz.Scheduler
FactoryBean#0_Worker-4) Error while closing command context: org.apache.ibatis.exceptions.PersistenceException:

### Error updating database.  Cause: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction

### The error may involve org.camunda.bpm.engine.impl.persistence.entity.HistoricTaskInstanceEntity.insertHistoricTaskInstanc

eEvent-Inline
### The error occurred while setting parameters

### SQL: insert into ACT_HI_TASKINST (         ID_,         PROC_DEF_ID_,         PROC_INST_ID_,         EXECUTION_ID_,
   ACT_INST_ID_,         NAME_,         PARENT_TASK_ID_,         DESCRIPTION_,         OWNER_,         ASSIGNEE_,         STA
RT_TIME_,         END_TIME_,         DURATION_,         DELETE_REASON_,         TASK_DEF_KEY_,         PRIORITY_,         DUE
_DATE_,         FOLLOW_UP_DATE_       ) values (         ?,         ?,         ?,         ?,         ?,         ?,         ?,
         ?,         ?,         ?,         ?,         ?,         ?,         ?,         ?,         ?,         ?,         ?
  )

### Cause: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
        at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)
        at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:147)

        at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:134)

Shukdeb Paul

PwC | Senior Consultant - Consulting
Direct: +91 (0) 33 4404 4102 | Mobile: +91 (0) 977534 1535
Email: sukdeb...@in.pwc.com
PricewaterhouseCoopers Private Limited
Plot 56&57, Block DN, Sector-V, Saltlake
Kolkata - 700 091  |  India

[webcyberrob]

Hi,

Check the history level of the engine. As I am in a development environment, it was set to FULL and this puts a lot of load on the DB. When I set it to ACTIVITY, all was well. Note to change the history level, I had to change the engine config file, and update a config table in the database. Have a look at the history section of the user guide for supporting detail.

regards

Rob 

[amaronba...@gmail.com]

Hi shukdeb,

You told that from 4-5 months you are using camunda jboss with mysqldb.I am trying to do the same but i am getting some missing dependencies if i use mysql in datasource/xa datasource. Could you please help me out to solve the same,

Thanks,
jhansi.

[sukdeb...@in.pwc.com]

Please share error logs and configuration file for datasource or xa-datasource.

Shukdeb Paul

PwC | Senior Consultant - Consulting
Direct: +91 (0) 33 4404 4102 | Mobile: +91 (0) 977534 1535
Email: sukdeb...@in.pwc.com
PricewaterhouseCoopers Private Limited
Plot 56&57, Block DN, Sector-V, Saltlake
Kolkata - 700 091  |  India

From:        "jha...@ngit.in" <amaronba...@gmail.com>
To:        camunda-...@googlegroups.com
Cc:        Shukdeb Paul/IN/M&C/PwC@AMERICAS-IN

[jhansi]

Hi,

I have downloaded and installed camunda-bpm-jboss-7.2.0-alpha1.tar. I am trying to connect mysql database .Below are the steps i have followed to do so.

1.  I have created folder com/mysql/jdbc/main under camunda-jboss home directory and has placed module.xml(content below mentioned) and mysql-connector-java-5.1.17-bin.jar file.

Module.xml

<?xml version="1.0" encoding="UTF-8"?>

<module xmlns="urn:jboss:module:1.4" name="com.mysql.jdbc">

  <resources>

     <resource-root path="mysql-connector-java-5.1.17-bin.jar"/>              

  </resources>

  <dependencies>

     <module name="javax.api"/>

  </dependencies>

</module>

2.Datasources and xa datasources mentioned in standalone.xml,domain.xml .I have attachedthe files above for your reference.

In my server log file i have noticed some missing dependencies.I have attached file above for your reference.

Please guide me on how to proceed further.

Thanks,

jhansi.

[Daniel Meyer]

See also: https://app.camunda.com/jira/browse/CAM-2567

We prepared a patch which can be applied to the 7.1.0.Final Database Schema:

This may be related to your Problem: https://github.com/camunda/camunda-bpm-platform/blob/master/distro/sql-script/upgrade/mysql_engine_7.1_patch001.sql

Daniel

[jhansi]

Hi Shukdeb,

I found my mistake and now i am able to connect to mysqld.Thanks for responding me. Actually i have confused placing module.xml,mysqlconnector.jar in the modules folder.I have placed this under camunda-jboss/modules folder instead place under camunda-jboss/server/camunda-jboss-final/modules.

But i need some help from you on how to integrate openldap through camunda. I have enabled the below code in standalone.xml. I have created the same user in ldap also.

 <plugin>

                        <class>org.camunda.bpm.identity.impl.ldap.plugin.LdapIdentityProviderPlugin</class>

                        <properties>

                

                          <property name="serverUrl">ldap://localhost:10389/</property>

                          <property name="acceptUntrustedCertificates">false</property>

                          <property name="managerDn">uid=jhansi,ou=ngit,o=camunda,c=org</property>

                          <property name="managerPassword">jhansi</property>

                

                          <property name="baseDn">o=camunda,c=org</property>

                

                          <property name="userSearchBase">ou=example</property>

                          <property name="userSearchFilter">(objectclass=person)</property>

                

                          <property name="userIdAttribute">uid</property>

                          <property name="userFirstnameAttribute">cn</property>

                          <property name="userLastnameAttribute">sn</property>

                          <property name="userEmailAttribute">mail</property>

                          <property name="userPasswordAttribute">userpassword</property>

                

                          <property name="groupSearchBase">ou=roles</property>

                          <property name="groupSearchFilter">(objectclass=groupOfNames)</property>

                          <property name="groupIdAttribute">cn</property>

                          <property name="groupNameAttribute">cn</property>

                

                          <property name="groupMemberAttribute">member</property>

                

                        </properties>

                      </plugin> 

                      

                

                      <!-- LDAP CONFIGURATION -->

                      <!-- The following plugin allows you to grant administrator authorizations to an existing LDAP user -->

                      

                      <plugin>

                        <class>org.camunda.bpm.engine.impl.plugin.AdministratorAuthorizationPlugin</class>

                        <properties>

                          <property name="administratorUserName">jhansi</property>

                        </properties>

                      </plugin>

              

Thanks,

jhansi.

On Saturday, August 16, 2014 11:25:24 AM UTC+5:30, sukdeb...@in.pwc.com wrote:

[jhansi]

Hi Shukdeb,

Thanks for your response.Now i am able to connect to mysql. But i got one more issue while integrating openldap through camunda. Please find the attached standalone.xml file where i have enabled ldap integration code.

when i am trying to login through camunda with login credentials username-jhansi and password - jhansi i am not able to login and the error message it is showing in the screen is  Login Failed: Wrong credentials or missing access rights to application.

In server logs it is showing error.I have attached server log file and ldap tree screen shots for your reference.Please help me out to solve the same.

Thanks,

jhansi.