topic Re: Dump in select querry in Application Development and Automation Discussions

Dump in select querry

Former Member — Mon, 30 Nov 2009 06:48:16 GMT

Can any one help me with this issue?

An exception occurred. This exception is dealt with in more detail below

. The exception, which is assigned to the class 'CX_SY_OPEN_SQL_DB', was

neither

caught nor passed along using a RAISING clause, in the procedure

"XTAB_SELECT_SALES" "(FORM)"

The reason for the exception is:

The SQL statement generated from the SAP Open SQL Statement violates a

restriction imposed by the database system used in R/3.

Possible errors:

o The maximum size of an SQL statement has been exceeded.

o The statement contains too many input variables.

o The space needed for the input data exceeds the available memory.

o ...

Prem

Re: Dump in select querry

Sm1tje — Mon, 30 Nov 2009 06:51:05 GMT

The explanation of the dump seems quite clear. So if anyone would be able to answer it, it would be you. Otherwise, be so kind as to provide some additional info like program name (custom or standard), the actual select statement and anything that in anyway would be helpful.

Re: Dump in select querry

Former Member — Mon, 30 Nov 2009 06:53:25 GMT

Hi Prem,

Could you please share the SQL statement and other details with it?

Regards,

Anand.

Re: Dump in select querry

Former Member — Mon, 30 Nov 2009 07:18:06 GMT

Hi Prem,

The error because the select query list of value and Internal Table is mismatch

Check it both both sould have smiliar structure and sequence

reagrds

Nilesh

Re: Dump in select querry

Former Member — Mon, 30 Nov 2009 08:28:21 GMT

Hi,

The error coming in your query is coming may be because of

number and sequence of fields in the select query and in the internal table

used does not match.Their number and sequence must be equal .

Hope it helps

Regards

Mansi

Re: Dump in select querry

p604431 — Mon, 30 Nov 2009 08:45:42 GMT

Hi,

Probably in this the input condition in your select stamtent (i.e) select-option fields or internal table whichever using in the where condition contains huge data to compare and fetch details in the select statement.

Re: Dump in select querry

Former Member — Mon, 30 Nov 2009 09:02:36 GMT

Hi,

Can you share your internal table structure and select statement here.

thanks.

Re: Dump in select querry

Former Member — Mon, 30 Nov 2009 09:07:53 GMT

Hi everyone the problem has been solved. Thank you all for your suggestions