Application Delivery Management
Application Modernization & Connectivity
CyberRes
IT Operations Management
Summary
SSC displays “Indexing Error - Contact Administrator”
Products
Fortify Software Security Center
Environment
SSC 21.2.2
Windows Sever 2016
MySQL Community 8.0.27
Collation: latin1_general_cs
Java 11
Tomcat 9
Situation
“Indexing Error - Contact Administrator” is displayed in SSC
From the ssc.log file, the following errors are seen:
-------------------------
2022-03-29 04:25:15,089 [WARN] org.hibernate.engine.jdbc.spi.SqlExceptionHelper - SQL Error: -1, SQLState: 08000
2022-03-29 04:25:15,089 [ERROR] org.hibernate.engine.jdbc.spi.SqlExceptionHelper - Server has closed the connection. \nPlease check net_read_timeout/net_write_timeout/wait_timeout server variables. If result set contain huge amount of data, Server expects client to read off the result set relatively fast. In this case, please consider increasing net_read_timeout session variable / processing your result set faster (check Streaming result sets documentation for more information)
2022-03-29 04:25:15,320 [ERROR] org.hibernate.search.engine.reporting.impl.LogFailureHandler - HSEARCH000058: Exception occurred org.hibernate.TransactionException: Unable to commit against JDBC Connection\nFailing operation:\nFetching identifiers of entities to index for entity 'Issue' during mass indexing\n
org.hibernate.TransactionException: Unable to commit against JDBC Connection
For cause and resolution read Full Support Article here.
Support Article Reference Number (URL Name)
KM000006282
__________________________________
Elizabeth Knappen
CyberRes Community Manager
If you find this post useful, give it a ‘Like’ or use ‘Verify Answer’