Fetching more than 10MB payload from ATP Database
SummaryFetching more than 10MB payload from ATP Database
We are trying to pull a lot of data(probably more than 10mb) using a SQL statement from an ATP Database. But getting below error. Please let me know any work around for this.
Error Summary: ICS runtime execution error Error Reason: Size Overflow Exception.
The payload being built into an XML exceeded a maximum size.
The column LINE2 was of size 16 bytes. If it had been processed, that would have exceeded the payloadSizeThreshold of 10,000,000 bytes (10MB), making a total of 10,000,012 bytes.
Recommended actions :
1) Tune the SQL to return a smaller set by providing a more restrictive where clause