Error "Illegal character in query" When Filtering on Shell Attribute

(Doc ID 2063848.1)

Last updated on AUGUST 01, 2017

Applies to:

Primavera Gateway - Version and later
Information in this document applies to any platform.


When attempting to Import Activity data from Unifier to P6 the following error occurs.

There is an issue with the ERP Provider. Please verify the configuration details. The error is below: Illegal character in query at index n

The issue can be reproduced at will with the following steps:

  1. Create a Synchronization.
    • Set Parameters: Criteria: Project: Shell Attribute = Status = Active
  2. Run the Synchronization


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