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) 
.
.
.
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) 



Resolution

A workaround would be to reduce the affected user's membership to 1000 groups or 1000 teams.
 

Find Answers

Type a question or describe what you are looking for below

My Recent Searches

Welcome kb sso

Additional Assistance

  • Submit a Case Online
  • FAQs