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.
Feedback