Skip to main content
Kofax

RPA version 11 Kapplets application not working with SQL server

Article # 3035388 - Page views: 7

Article # 3035388 - Page views: 7

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  

Product Version Build Environment Hardware
Kofax RPA 11      

References

Add any references to other internal or external articles

  • Was this article helpful?