topic Re: Infoset Query in Application Development and Automation Discussions

Infoset Query

jogeswararao_kavala — Sat, 14 Jul 2012 11:55:06 GMT

Dear Experts,

I am getting a dump when the number of values exceed 9999 in the multiple selection (EQUNR) in the selection screen

(of an infoset query using logical database.)

Pl. guide.

kind regards

Jogeswara Rao

Re: Infoset Query

Former Member — Mon, 16 Jul 2012 14:33:37 GMT

Hi Jogeswara Rao,

This is a common limitation. You are exceeding the maximum allowed query length. Let me explain with an example.

Suppose you have two entries on the selection screen s_equnr- eq 1 or eq 2. The open SQL select query gets converted native SQL query as - where EQUNR = 1 or equnr = 2. Now if you enter 9999 values the query length exceeds a set limit - say 20000 characters. It is fixed length for a system - May be BASIS can increase it - Not sure. This can happen for any field. Just that if you use a smaller field like vbeln (10 chars) you can may be enter a couple of thousand more. Hope that makes sense.

Regards,

Shravan

Re: Infoset Query

jogeswararao_kavala — Tue, 17 Jul 2012 02:22:47 GMT

Thank you for explaining.

Regards

Jogeswara Rao