000011760 - java.sql.SQLException: ORA-01795 when trying to display Application Group

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000011760
Applies ToRSA Key Manager Server 2.0.x
RSA Key Manager Server 2.1.x
Oracle database
Issuejava.sql.SQLException: ORA-01795 when trying to display Application Group
com.rsa.kms.edge.java.sql.EdgeSqlException: java.sql.SQLException: ORA-01795: maximum number of expressions in a list is 1000
 at com.rsa.kms.edge.java.sql.DefaultEdgePreparedStatement.executeQuery(DashoA10*..:58)
 at com.rsa.kms.database.sql.SQLDataPaginator.getSize(DashoA10*..:84)
 at com.rsa.kms.database.sql.DefaultKeyClassFinder.getSize(DashoA10*..:186)
 at org.apache.jsp.admin.main_jsp._jspService(main_jsp.java:1730)
 at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
CauseRSA Key Manager (RKM) Server created an improper SQL statement when Oracle database is in use
ResolutionThis issue has been fixed in RSA key Manager Server 2.2.  Upgrade your RKM Server to 2.2.
NotesBZ 105890
Legacy Article IDa42078