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

ID:    D27840
Published:    24 May 2022
Updated:    13 June 2022

Defect Id


Originally Reported Against

SBM 11.7.1

Also Affects

SBM 11.7.1


 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  


Contact support for SBM 11.7.1 Hotfix 7 for a fix.

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