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: | D27840 | |
| Published: | 24 May 2022 | |
| Updated: | 13 June 2022 |
Defect Id
DEF346756
Originally Reported Against
SBM 11.7.1
Also Affects
SBM 11.7.1
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
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 SBM 11.7.1 Hotfix 7 for a fix.
