Official Support Articles

[Gerald_U]

A Qlik Replicate task fails with error:

00002482: 2022-12-01T21:05:43 [SOURCE_UNLOAD ]E: An error occurred unloading dataset: .Proposed_Product__c
[InvalidQueryLocatorFault [ApiFault exceptionCode='INVALID_QUERY_LOCATOR'
exceptionMessage='invalid query locator'
extendedErrorDetails='{[0]}'

Resolution

Query locators represent a server-side cursor for a query. Typically a query locator is returned when not all the records requested in a query fit into the returned data set. This way a queryMore() can be issued with the provided query locator to get additional rows.

For example, consider a query API call where the batch size is set to 2,000 and the organization has 2000+ accounts. In this scenario, SELECT id FROM account will return 2,000 records and a query locator to retrieve the remaining records.

To resolve this, review "INVALID_QUERY_LOCATOR" error when querying Salesforce through TIBCO Cloud Integration - Connect.

You may want to consult with a Salesforce support if the proposed solution does not work.

Environment

Qlik Replicate