User receives an error against Salesforce table that does not support PKChunking: FOC45425

Diagnostics

Product: Reporting Server

Release: 8205

Primary OS: Windows

Solution Date: 2019-01-11

Symptom

(FOC45425) Entity 'abc' is not supported to use PKChunking

Problem

User receives the error message above with a TABLE request or flow against a Salesforce table that does not support PKChunking.

Solution

Assuming PKChunking is turned on for the adapter, set the following in the focexec or in a stored procedure that runs before a data flow:

ENGINE SFDC SET PKCHUNKING OFF
ENGINE SFDC SET PKCHUNKSIZE 0

Information is published on an "as is" basis without a warranty of any kind. Information Builders, Inc. ("IBI") hereby represents that such information has not been subject to any formal testing or review by IBI. IBI assumes no responsibility for usage of such information, including the implementation of solutions associated therewith. The customer assumes responsibility for the results obtained from such information. IBI is not responsible for and shall not be held liable for the results obtained, including but not limited to any errors, delays or omissions. IBI disclaims any liability for the completeness or accuracy of such information.