Defects
Error during login: "ORA-01795: maximum number of expressions in a list is 1000"
| ID: | D27854 | |
| Published: | 02 August 2022 |
Defect Id
DEF346979
Originally Reported Against
SBM 11.8
Assigned To
SBM 12.1
Status
Submitted
Description
When a user tries to log into Work Center, they get an error:
could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet
An Administrator might get a similar error if they try to view the User Preferences>Side Menu Settings for this user in Application Administrator.
There will also be errors like these in the workCenter.log:
ERROR 29-07-2022 06:57:42 [UserDataController] -- could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet 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:261)
at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:261)
.
.
.
.
Caused by: java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
Resolution
A workaround would be to reduce the affected user's membership to 1000 groups or 1000 teams.
