"Error - could not execute query" shows instead of the role name when listing roles in RSA Identity Governance & Lifecycle
Originally Published: 2018-09-17
Article Number
Applies To
RSA Version/Condition: 7.0.2 and 7.1.0
Issue
The following error is logged in the aveksaServer.log:
03/13/2017 12:30:37.446 ERROR (default task-153) [com.aveksa.gui.components.table.core.TableView]
org.hibernate.exception.GenericJDBCException: could not execute query
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
......................................................................
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLException: Invalid character encountered in
at oracle.sql.CharacterSet.failUTFConversion(CharacterSet.java:2865)
at oracle.sql.CharacterSetAL32UTF8.toString(CharacterSetAL32UTF8.java:186)
at oracle.xdb.XMLType.processString(XMLType.java:3090)
at oracle.xdb.XMLType.processThin(XMLType.java:3211)
at oracle.xdb.XMLType.<init>(XMLType.java:1413)
at oracle.xdb.XMLType.createXML(XMLType.java:846)
at oracle.xdb.XMLType.createXML(XMLType.java:823)
at com.aveksa.server.db.StringToXMLTypeMapper.nullSafeGet(StringToXMLTypeMapper.java:98)Cause
Resolution
