After upgrading to Spectrum r10.1.2, on the RTT CABI BOXI Reports parameter page, after select the ICMP Test type, the list of tests are not displayed.

Document ID : KB000005067
Last Modified Date : 14/02/2018
Show Technical Document Details

After upgrading to Spectrum r10.1.2, when running RTT reports in CABI BOXI (Public Folders->CA Reports->CA Spectrum->Response Time), on  the parameter page, and after select the Test Type, the Test ID combo box is not populated with the list of tests.

Spectrum 10.1.2Windows 2008CABI BOXI 4.1 SP3

The query executed on mysql Report Manager after select the Test Type always uses the spmtest.test_type = 7, no matter the Test Type selected.


SELECT DISTINCT (m.network_address),t.model_name,t.test_id FROM v_security_string_accessibility_by_landscape v, model m, spmtest t, spmbasictestresults r WHERE t.model_h= m.model_h AND t.test_id = r.test_id AND m.landscape_h = v.landscape_h AND m.security_string = v.security_string AND v.user_name = '79963730' and t.test_type=7 AND r.timestamp >= '2016-11-14 00:00:00.0' AND r.timestamp <= '2016-11-14 23:59:59.0' ORDER BY m.network_address


t.test_type=7 means DHCP tests, and not ICMP test


This issue has been addressed in the following patch. Please contact CA Spectrum support: