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 |