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

Document ID : KB000103644
Last Modified Date : 28/06/2018
Show Technical Document Details
Issue:
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:
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.

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.
Additional Information:
Spectrum_10.02.03.BMP_10.2.301 can be downloaded from:
https://support.ca.com/us/product-content/recommended-reading/technical-document-index/ca-spectrum-r10-2-solutions-patches.html