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

book

Article ID: 103644

calendar_today

Updated On:

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.