When using Service Desk select operators, it fails with the error bellow: Error fetching: AHD03053:Bad where clause: Parse error at : "XXX:XXXXX"

book

Article ID: 188251

calendar_today

Updated On:

Products

CA Service Management - Service Desk Manager CA Process Automation Base

Issue/Introduction

When using Service Desk select operators, it fails with the error bellow:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><soapenv:Body><soapenv:Fault><faultcode>soapenv:Client</faultcode><faultstring>Error fetching: AHD03053:Bad where clause: Parse error at : "xxx:xxxxx" (syntax error)</faultstring><faultactor/><detail><ErrorMessage>Error fetching: AHD03053:Bad where clause: Parse error at : "xxx:xxxxx" (syntax error)</ErrorMessage><ErrorCode>103</ErrorCode></detail></soapenv:Fault></soapenv:Body></soapenv:Envelope>

 

Cause

The issue was caused by not using double quotes in the where clause field

Environment

Release : 17.1 or higher  4.2 or higher

Component : CA SERVICE MANAGEMENT PROCESS AUTOMATION

Resolution

When using the where clause it is necessary to use double quotes from the start to the end and for the string values withi the where clause single quotes.

Attachments