Trouble Tickets are not created for url_reponse alarms

Document ID : KB000115438
Last Modified Date : 20/09/2018
Show Technical Document Details
Issue:
The CA Service Desk Manager is not creating the ticket for url_response alarm only. Tickets are being created for others types of alarms.

This is the error message in the Tomcat's log file (catalina.out):
Sep 19, 2018 11:22:49.548 (http-bio-8080-exec-399) (SDIntegration) - Creating ticket: problemType='SPECTRUM_HIGH', endUserId='' asset='nr:B0D5DFF9ECEF404E8DCB6EC3A5020C93', alarmId='5ba257dd-19de-1025-0361-0080100d0670' 
Sep 19, 2018 11:22:49.577 - Error occurred while attempting to create a ticket in Service Desk. Error fetching: AHD03053:Bad where clause: Parse error at : "( (((name='xxxxxx05') AND delete_flag='0')) ) AND ( tenant IS NULL OR tenant.[tenant_id]groups.tenant_group IN U'EA593F354AFAC04FBCB67F7AF7C0BB4A' )" (Bad where clause) 
Sep 19, 2018 11:22:49.577 (http-bio-8080-exec-399) (SDIntegration) - SDServlet - create ticket failed

This is the error message in the stdlog.2 file (from SDM):
09/19 11:22:49.72 SERVER spelsrvr:primary: 4720 ERROR api.spl 8117 Error querying the database for duplicates syntax error, unexpected NAME, expecting OR or AND or ';' or ')' at N'XXXXXXXXXXX - URL response for ' http 
09/19 11:22:49.72 SERVER spelsrvr:primary: 4720 ERROR api.spl 8118 SQL Statement was: str1_rsrved='sapolicy:400001' AND str2_rsrved='saprobtyp:400002' AND ob_type='cr' AND lstr1_rsrved='XXXXXXXXXXX - URL response for 'http://SDM_server:8080/CAisd/pdmweb.exe' failed. 7 Couldn't connect to server_2441564' AND lstr2_rsrved='I' 
Environment:
CA Spectrum 10.2.3, CA UIM 8.51 SP1 and CA SDM 14.1
Cause:
The tested URL is in between ' characters.

User-added image
 
Resolution:
Change the configuration on CA UIM side, in message definition and removed the ' characters.

From:
User-added image

To:
User-added image