Kapplet LDAP Login UI Spinning After Entering Credentials

Question / Problem: 

This symptom occurs when a user attempts to log into Kapplets using LDAP authentication

Answer / Solution: 

This is caused by an incorrect configuration for Kapplets - most likely the database configuration isn't for the correct database type. Check the Environment element within the kapplets.xml:

 

<Environment name="spring.jpa.database-platform" value="org.hibernate.dialect.MySQL8Dialect" type="java.lang.String" override="false"/>

 

And verify the application.properties file is also correctly configured.

For more details, review the General Settings section in RPA v11.x Installation Guide under Install Kapplets.

Some errors you may see in kapplet.log:

rsLanguageConfigurationServiceImpl : Was not able to resolve users language preference

org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet
    at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:280) ~[spring-orm-5.1.10.RELEASE.jar:5.1.10.RELEASE]
    at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:254) ~[spring-orm-5.1.10.RELEASE.jar:5.1.10.RELEASE]
    at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.t

 

Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
    at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:103) ~[hibernate-core-5.4.8.Final.jar:5.4.8.Final]
    at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42) ~[hibernate-core-5.4.8.Final.jar:5.4.8.Final]

Applies to:  

Product	Version
RPA	11.x