Report generation is failing with Database error: [MySQL][ODBC 5.1

Article Id: 103644

Status: Published

Updated On: 20-04-2020 10:11

Products:

CA Spectrum

Issue/Introduction:

After upgrade to 10.2.3 trying to run ad-hoc reports in CABI 4.1 the following error may occur:

Database error: [MySQL][ODBC 5.1 Driver][mysqld-5.5.57-enterprise-commercial-advanced]Unknown column 'm.model_name' in 'where clause'. (IES 10901)

Environment:

Spectrum 10.2.3 CABI 4.1

Resolution:

This issue has been addressed in the Spectrum Bi-Monthly pack 10.02.03.BMP_10.2.303

Workaround:

1. Go to the following file and open it in edit mode $SPECROOT/Install-Tools/rpmgr/sql/srmdbapi/ddl/create_security_functions.sql .

2. Now go to line # 74 and add the following one “, reporting.model m” in the file and save it.

3. Now re-start the SRM spectrum tomcat.