RPA version 11 Kapplets application not working with SQL server

Issue

I am trying to setup Kofax RPA version 11 on SQL server. The Management Console on Tomcat is working. But it cannot start the Kapplets service. 

The following error message is written to the log file:

org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: Line 1: FOR UPDATE clause allowed only for DECLARE CURSOR. [See nested exception: com.microsoft.sqlserver.jdbc.SQLServerException: Line 1: FOR UPDATE clause allowed only for DECLARE CURSOR.]

Solution

In case of SQL server, please add the SelectMethod=cursor parameter in your kapplets.xml

Example of kapplets.xml:

<Context useHttpOnly="true">
 <!-- Default set of monitored resources -->
 <WatchedResource>WEB-INF/web.xml</WatchedResource>
<Resource name="jdbc/kapow/kapplets" auth="Container" type="javax.sql.DataSource"
 maxActive="100" maxIdle="30" maxWait="-1" 
 testOnBorrow="true"
 username="<DB username>" 
 password="<DB password>"   
 driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
 validationQuery="SELECT 1" url="jdbc:sqlserver://<IP address>:1433;DatabaseName=KAPOW_KAPPLETS;SelectMethod=cursor"/> 
 <Environment name="spring.datasource.jndi-name" value="jdbc/kapow/kapplets" type="java.lang.String" override="false"/>
 <Environment name="spring.jpa.database-platform" value="org.hibernate.dialect.SQLServer2012Dialect" type="java.lang.String" override="false"/>
 <Environment name="kapplets.services.mc.connection.url" value="http://<IP address>:8080/ManagementConsole/" type="java.lang.String" override="false"/>
 <Environment name="kapplets.services.mc.connection.username" value="<MC username>" type="java.lang.String" override="false"/>
 <Environment name="kapplets.services.mc.connection.password" value="<MC password>" type="java.lang.String" override="false"/>
</Context>

Level of Complexity 

Easy

Applies to  

References

Add any references to other internal or external articles

​