Defects

After restarting Tomcat, Work Center gives error "Unable to load initial data for Work Center, please contact your Administrator" and does not load



ID:    D27841
Published:    24 May 2022
 

Defect Id

DEF346754

Originally Reported Against

SBM 11.7.1

Also Affects

SBM 11.7.1

Assigned To

SBM 12.1

Status

In Progress

Description

After Tomcat is restarted, the user can log into Work Center. However, work center does not load. Only the top header is displayed, and this message is given:
 Unable to load initial data for Work Center, please contact your Administrator 

The console.log gives the following error:
 ERROR [localhost-startStop-2] [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/commonsvc]:182] [::] -- Exception sending context initialized event to listener instance of class [org.springframework.web.context.ContextLoaderListener]
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute statement 
...
Caused by: org.hibernate.exception.SQLGrammarException: could not execute statement
...
Caused by: java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000 
...
 ERROR [localhost-startStop-2] [org.apache.catalina.core.StandardContext:180] [::] -- One or more listeners failed to start. Full details will be found in the appropriate container log file 

Resolution

Contact support for help with this error.

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