ConnectALL Not Synching Some Changes from ServiceNow due to "Illegal character in query at index ###" error

Products

• ConnectAll SaaS
• ConnectALL
• ConnectAll On-Prem

Issue/Introduction

When a change is made in the source system, the change is not synchronized to the destination.

Logs may also show the following error:

Caused by: java.lang.IllegalArgumentException: java.lang.IllegalArgumentException: Illegal character in query at index ###:

Environment

Source System: ServiceNow

 

Cause

The illegal character error references a problem with a query being passed to the ServiceNow system.  This can be caused when an invalid Flow Filter is configured.

Resolution

Validate the Flow Filter query and ensure it works in ServiceNow prior to implenting in ConnectALL