Designer Error SecString size limit reached

Question

I am running a query with 115k "product numbers" in order to minimize the size of the return.  I am getting the error below, I have executed queries where the return has been billions of rows and have never experienced this before.

I have the select tool and it does not see the fields in the query.

I have ZERO, ZILCH, NADA, of an idea of what it could be.  Any assistance will be immensely appreciated.

Cheers,

Fausto

cpet13 · Answer

Hi @Fescobar, based on the error message, it does not seem to have to do with the number of records you are returning, but that one of the records has a value that is not in the size limit range of 0 to 1000000. You probably need to go back to the data source and find the field(s) that are outside of that size limit.