Service Virtualization

Hello Team,

Running Enterprise Dashboard 10.0 under SUSE Linux Enterprise Server 12 SP2 / Docker / MySQL 5.7, I've got the following log when accessing Dashboard with web browser :

2017-07-04T10:47:08.259913+02:00 sl00sa docker LOG docker-virtual.artefact/dvtst/oi042-dashboard:0.0.34-18 sha256:23f24 qoi042_oi042-dashboard_m_1 591cd4b8d237[14262]: 2017-07-04 08:47:08,259Z (08:47) [qtp1474234791-24] WARN groovy.sql.Sql - Failed to execute: SELECT ca.*, c.host_name FROM COMPONENT c, COMP_ATTR ca WHERE c.comp_uuid = ca.comp_uuid AND ca.attr_key = 'VSE Performance' AND ( ( ca.end_tm IS NULL AND ca.start_tm < '2017-07-04 08:00:00.0' ) OR NOT ( ca.end_tm < '2017-07-03 08:00:00.0' OR ca.start_tm > '2017-07-04 08:00:00.0' ) ) ORDER BY ca.start_tm because: Table 'DRADIS.COMPONENT' doesn't exist

The first time, mysqld was missing parameters "--character-set-server=utf8 --collation-server=utf8_general_ci".

Now, the error is still here...

Table component exists in mysql schema.

Any idea ?

Regards,

Benoit

Please open a ticket with CA Support..  We can look at the issue in a webex.  

Thanks

Shiney

Ok, ticket opened : 00790040

Best regards,

Benoit

This was resolved in the support ticket 00790040 with the below resolution.

The tables were created with lowercase table name upon ED start up. But ED is looking for uppercase table names Table 'DRADIS.COMPONENT' doesn't exist while trying to retrieve the data which is why you are seeing this issue.

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.

The below resolution should help you with the issue.:
. Drop the tables for ED.
. Change MySQL database /etc/mysql/my.cnf file. Add the below line:
lower_case_table_names=1

. Run- sudo service mysql restart

There is a KB article is available at https://www.ca.com/us/services-support/ca-support/ca-support-online/knowledge-base-articles.TEC1838142.html.