topic Re: Maximum number of parameters that can be passed to a Stored Process? in Developers

Maximum number of parameters that can be passed to a Stored Process?

bheinsius — Fri, 14 Sep 2018 14:39:22 GMT

Hi,

I have a webapp that calls a SAS Stored Process with method=post and about 15000 name/value pairs.

Only the first 9998 name/value pairs come through to the SAS Stored Process.

Is there a limit?

Regards,

Bart

Re: Maximum number of parameters that can be passed to a Stored Process?

JuanS_OCS — Fri, 14 Sep 2018 15:26:21 GMT

Hello @bheinsius,

have you tried with different browsers/OS, to check if this statement changes?

I don't think there is a limit on STP input parameters (but perhaps someone else can feed us in better), I think the limitation is in the limitations by internet and its tools.

https://stackoverflow.com/questions/1051485/what-is-the-character-limit-on-url

http://documentation.sas.com/api/docsets/stpug/9.4/content/stpug.pdf?locale=en

http://support.sas.com/rnd/itech/doc9/dev_guide/stprocess/webinput.html

See Input Parameters on both docs.

Re: Maximum number of parameters that can be passed to a Stored Process?

AllanBowe — Wed, 19 Sep 2018 21:19:21 GMT

Not aware of a limit (other than the url limitation mentioned by Juan) but I can advise the possibility of performance issues with creating that many macro variables in a stored process.

If you are passing a lot of data to an STP by far the best method is to use file (eg CSV) upload. You can also save yourself a lot of time and effort by using the open source h54s adapter for this kind of task! The file upload feature is in the development branch, but will be merged soon.

Re: Maximum number of parameters that can be passed to a Stored Process?

bheinsius — Thu, 20 Sep 2018 13:57:25 GMT

SAS TS pointed me to the Tomat option maxPostSize at https://tomcat.apache.org/tomcat-5.5-doc/config/http.html for SASServer1, which has a default limit of 2MB.

That did not help but on the same page i read this:

maxParameterCount

The maximum number of parameters (GET plus POST) which will be automatically parsed by the container. A value of less than 0 means no limit. If not specified, a default of 10000 is used. Note that FailedRequestFilter filter can be used to reject requests that hit the limit.

Setting that to 1000000 fixed my problem.

The file to update is <sasconfigdir>/Levx/Web/WebAppServer/SASServer1_1/conf/server.xml.

In there add maxParameterCount="1000000" to the <Connector ... />