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
Issue:

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.

Environment:
Spectrum 10.1.2Windows 2008CABI BOXI 4.1 SP3
Cause:

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

Resolution:

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

Spectrum_10.01.02.PTF_10.1.220