I am working on a stored procedure that returns back a dataset containing a single column that stores a set of integers. When my process executes the stored procedure and processes the response, it acts as if only the top record of the set exists in the set even though the raw DBSET string shows 10 records.
Here is my Database profile that expects three things: the record set, and two output parameter values that provide metadata on the set.
Here is my Database operation. I have tried modifying the batch settings in the following ways:
* Set batch count to 1
* Set batch count to 1 and link the registration_id parameter
Here you can see the raw data being returned by the connector
And here you can see the logs picking up only a single document