SBL-DAT-60236 Error Message When Using Siebel Data Quality Universal Connector With Special Characters

(Doc ID 1069287.1)

Last updated on AUGUST 15, 2016

Applies to:

Siebel Data Quality Connector - Version 8.0 SIA [20405] to 8.0.0.10 SIA [20436] [Release V8]
Siebel CRM - Version 8.0.0.2 SIA [20412] and later
Information in this document applies to any platform.

Symptoms

Using Siebel with a third party vendor (e.g. Trillium) using the Data Quality Universal Connector, when attempting to match records with fields that contain a special character in them, for example, the apostrophe, ', the following error occurs:

SBL-DAT-00354: The query could not be run because the criteria for field '' contained an invalid arithmetic expression. Please ensure that the search criteria is correctly formatted.

This error is often caused by a missing operator (e.g. = or <) or missing quotes. If you aren't sure what may have caused this please contact your systems administrator.

SBL-DAT-60236: Expression does not match any Siebel query language grammar rules.


By following these steps the issue can be reproduced:
1. Set up the Universal Connector for data quality matching and set client/object manager to use the appropriate type

2. Set the real-time data matching settings in Administration - Data Quality > Data Quality Settings:

3. Amend the Account Token Expression and Account Query Expression to allow you to capture a suitable number of characters from the address, for example:
Account Token Expression:
IfNull (Left ([Postal Code], 5), "_____") + IfNull (Left ([Name], 1),"_") + IfNull (Left ([Street Address], FindNoneOf ([Street Address], "1234567890"), 5), "_____")
Account Query Expression:
IfNull (Left ([Postal Code], 5), "?????") + IfNull (Left ([Name], 1),"?") + IfNull (Left ([Street Address], FindNoneOf ([Street Address], "1234567890"), 5), "?????")

4. Logout and in again for changes to take effect

5. Enter two accounts e.g. Test Account with site 1 and Test Account with site 2 without any address data

6. After the second account has been saved, the deduplication popup should show the first as a match

7. Check S_DQ_ORG_KEY table to make sure that Universal Connector is being used - there should be two records with KEY_VALUE = _____T_____

8. Now add an address to one of them and save it, e.g.
Street Address = A Place in the Sun
City = Redwood Shores
State = CA
Zip Code = 11111
Country = USA

9. Check the S_DQ_ORG_KEY table. The key should now be '11111TA PLA'

10. Now add an address with an apostrophe (') to the other account and save it, e.g.
Street Address = A'Place in the Sun
City = Redwood Shores
State = CA
Zip Code = 11111
Country = USA

11. Receive the following error message:

[1] Invalid search specification '[DQ System Id] = '1-AIZ3' AND [Parent Id] LIKE '1-CF1T' AND [Key Value] NOT LIKE '11111TA'PLA''.
Please continue or ask your systems administrator to check your application configuration if the problem persists.(SBL-DAT-00501)

[2] Expression does not match any Siebel query language grammar rules. Unexpected token 'PLA' found at or near location 90.(SBL-DAT-60236)


The expectation is that Siebel can handle special characters when performing data matching with third party products via the Universal Connector.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms