Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Designer Error SecString size limit reached

Fescobar
8 - Asteroid

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.

  Screenshot 2024-05-17 at 2.40.43 PM.png

 

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

Screenshot 2024-05-17 at 2.42.50 PM.png

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

 

Cheers,

 

Fausto

1 REPLY 1
cpet13
11 - Bolide

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.

Labels
Top Solution Authors