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)
Spectrum 10.2.3 CABI 4.1
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.
or apply Spectrum Bi-Monthly pack 10.02.03.BMP_10.2.301 that includes a new create_security_functions.sql file with the above modification.
Spectrum_10.02.03.BMP_10.2.301 can be downloaded from: