IBM Support

Escaping backslash doesn't work in IBM security Guardium when used in query condition

Troubleshooting


Problem

Per v10 help book : https://www.ibm.com/support/knowledgecenter/en/SSMPHH_10.0.0/com.ibm.gu… To correctly escape a backslash character for use in a query condition, use four backslash characters. For example, to specify domain\user you would enter domain\\\\user. But when you try to use backslashes as per documented you face below error : "Invalid query - Invalid query. Input fields can not have special characters such as single quote , backslash , if it is an integer or SUM field can not have double quote or semicolon either"

Symptom

You will see below error when you try to add DB user names in query condition.

Environment

v10.1.3

Resolving The Problem

This issue is going to be fixed in 10.1.5 and tentative date of it's release is Q2 2018

[{"Product":{"code":"SSMPHH","label":"IBM Security Guardium"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Guardium Appliances","Platform":[{"code":"PF016","label":"Linux"}],"Version":"10.1.3","Edition":"All Editions","Line of Business":{"code":"LOB24","label":"Security Software"}}]

Document Information

Modified date:
16 June 2018

UID

swg22011387