Case insensitive SQL when calling the Query method on the EAI Siebel Adapter with search spec. (Doc ID 535121.1)

Last updated on JULY 16, 2021

Applies to:

Symptoms

• have an integration object based upon the contact BC.
• use EAI Siebel Adapter to query the BC using this integration object to query the contact BC for a contact with a particular email address (using BC field Email Address).
• The workflow process property used as input argument is similar to the following:

SearchSpec, Literal, [Contact.HSBC Notes Email] = “USER1@<DOMAIN_NAME>”

• CaseInsensitive = TRUE in the .cfg file and DSCaseInsensitiveFlg = True for the named subsystem ServerDataSrc.

However, when the workflow was executed using the Simulator or the Workflow Process Manager the generated select statement was case sensitive and the contact was not returned. When the same query was executed in the UI the contact was found.

Cause