SqlExceptionHelper - Table 'qd99emdb.COMPONENT' doesn't exist

Document ID : KB000047334
Last Modified Date : 14/02/2018
Show Technical Document Details


When I start Enterprise dashboard I am seeing the following errors in the ED logs and it fails to load data : 

2016-09-29 16:10:00,662Z (12:10) [http-nio-1506-exec-10] WARN org.hibernate.engine.jdbc.spi.SqlExceptionHelper - SQL Error: 1146, SQLState: 42S02 
2016-09-29 16:10:00,662Z (12:10) [http-nio-1506-exec-10] ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper - Table 'qd99emdb.COMPONENT' doesn't exist 
2016-09-29 16:10:00,663Z (12:10) [http-nio-1506-exec-10] ERROR com.ca.dradis.service.RegistryService - failed to get registries: 



MySQLv 5.6




Enterprise Dashboard is configured for MySQL on Linux Sever.  

 We noticed that the tables were created with lowercase table name upon ED start up.  But it is looking for uppercase  table names Table 'qd99emdb.COMPONENT'  while trying to retrieve the data. 

This is what we saw in the ED logs

org.hibernate.engine.jdbc.spi.SqlExceptionHelper - Table 'qd99emdb.COMPONENT' doesn't exist 

MySQL database is configured with case-sensitive table name by default. We need to setup MySQL database with case-insensitive identifiers to get it to work



Drop the tables for ED. 

Change MySQL database settings as below:

add the line



sudo service mysql restart


Recreate the Enterprise Dashboard Tables again . 

 You can now see the enterprise dashboard correctly, and no table issue in the log . This should work for Registry Tables too. 

Additional Information: