Winshuttle Support systems have migrated into Precisely systems. If you weren't automatically forwarded to the new system, please go to https://support.precisely.com to access Suppport.

Adaptive Query Throttling setting is getting enabled at query level for runner user, even though it is disabled while creating with developer user setting.
Query - Criteria = and IN not working on Sales Org
How to make a Query macro with a xml file
Query / IN Operator: The file for selecting values is empty
Error: "String or binary data would be truncated"
Can I use Query to extract data from a Structure?
Query Create From Recording is Grayed Out
Missing the DataColumn 'DomainName' in the DataTable 'Fields' for the SourceColumn 'DomainName'
When adding new fields to Query script, how can I change the order?
Exception of type 'System.OutOfMemoryException' was thrown

Error: Invalid Select Statement

Fabian

July 22, 2019 15:57
Updated

Description

When trying to schedule a query script to run on the server from the query client, the user gets the attached error in an email.

Job History in Central also shows as follows

Applies To

Query 10.X

Cause

'NOT IN' operator used in 'where' condition was causing this issue.

Solution

Modify the query condition using the 'IN' operator.

Comments

0 comments

Please sign in to leave a comment.

# Notification banner writer

Articles in this section

Description

Applies To

Cause

Solution

Related articles