Special Characters in SPM Test URL result in 'Unknown Exception' error

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

The following error is seen in the OneClick log after running an SPM test to a URL;

Oct 18, 2016 08:15:34.409 (SRM/SRMSPMTestExporter/bucketReader) (SPM_Events) - (ERROR) - Unknown exception encountered while processing name events: processing halted for all servers

Further details show that the issue is caused by a special character (the between 1stname.d'2ndname);

Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT test_id FROM spmtest WHERE model_key=71352 AND source_address='xxx.xxx.xxx.xxx' AND dest_address = 'https://api.test.com/simple-entity.json/user/user?condition[mail]=1stname.d'2ndname@mycompany.com

 

Environment:
Spectrum 10.1.xSpectrum 10.0.xSpectrum 9.4.x
Cause:

The cause is the special character (the between 1stname.d'2ndname) not being valid in the MySQL query so it needs to be dereferenced before use.

Resolution:

A Program Temporary Fix (Spectrum_10.01.02.PTF_10.1.211) patch has been created to fix this. 

If this problem affects you then please contact CA Support to obtain this patch.

Additional Information:

Spectrum_10.01.02.PTF_10.1.211 is available for Spectrum 10.1.2. For earlier versions experiencing this problem, please contact CA Support.