String size Issue into Dynamic Input

Hello,

I successfully ran a workflow in a previous version but now that I'm using 11.7, I'm getting an exception error when the string is over 2200 records.

Basically, the summary tool is pulling 2233 records, concatenating with commas and replacing a string in the SQL. Is there another way to do this?

Mark

Input

Dynamic Processing

Accepted answers

flipperdm

Exactly! Thanks.

All comments

CharlieS

I suggest splitting this into multiple records and taking advantage of the built in batch/union of the Dynamic Input tool. I've built the attached solution to show how a couple extra tools can be used to break down your list of clause arguments into subsets of any desired size. Inputting 10 records of 30 rather than 1 record of 300 should output the same from the Dynamic Input tool as it will union the results together.

Check out the attached workflow and let me know if you have any questions.

20180831-BatchQueryInputs.yxmd

flipperdm

Exactly! Thanks.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703