topic Re: run time error in Application Development and Automation Discussions

run time error

SG141 — Mon, 14 Jul 2008 14:10:39 GMT

My program is ending with run time error..... SAPSQL_STMNT_TOO_LARGE what does it mean.

Re: run time error

Former Member — Mon, 14 Jul 2008 14:13:24 GMT

Hi,

Just Check the SQL statement,I mean the SELECT Query you have written,

Runtime Error is occuring from that Section.

According to SAP it occurs duu to System is unable to handle the Number of Objects you have selected through the SELECT Query.Diviode the data into smaller chunks and Seclect accordingly.

The ABAP runtime environment does not support large WHERE conditions (> 64 KB).

Regards,

Sujit

Re: run time error

Former Member — Mon, 14 Jul 2008 14:14:04 GMT

Post your SELECT statement here

The WHERE clause could be too large or you have included lots of large ranges.

Re: run time error

Former Member — Mon, 14 Jul 2008 14:14:09 GMT

Hi Karthik,

Check SAP Note: 434625.

also see this thread:

http://www.sapfans.com/forums/viewtopic.php?p=118964&sid=40cc28887cb425484f244922868682b5

Regards,

ravi

Re: run time error

Former Member — Mon, 14 Jul 2008 14:15:30 GMT

Check the SELECT statement.

You might have moving the data into Workarea instead of table.

change SELECT

FROM

INTO TABLE

WHERE conditions.

Regards

Kannaiah

Re: run time error

Former Member — Mon, 14 Jul 2008 14:15:48 GMT

Hi kratik,

This has occured because the number objects selected by the selection screen are not handled by the system.

Regards

Sravanthi.

Re: run time error

Former Member — Mon, 14 Jul 2008 14:16:07 GMT

Hi Karthik,

Are you using select-options, if that is the case then 'IN' statement of your select query used has a limitation that if the no. of entries are large ( may be more than 3000 ) then you

will get a short dump .

With luck,

Pritam.

Re: run time error

SG141 — Mon, 14 Jul 2008 14:19:10 GMT

Here is my select query ...

SELECT LIPS~VBELN

LIPS~POSNR

LIKP~LFART

LIPS~WERKS

LIPS~MATNR

LIPS~CHARG

LIPS~LFIMG

LIPS~BWART

LIPS~VKGRP

LIPS~MATKL

LIKP~KUNNR

LIPS~VRKME

LIKP~KUNAG INTO TABLE GT_LIPS

FROM ( LIPS INNER JOIN LIKP

ON LIPS_{VBELN = LIKP}VBELN )

WHERE LIPS~VBELN IN R_VBELN AND

LIKP~LFART IN ('YLF','ZLSB','ZLSR') AND

LIPS~WERKS = P_PLANT AND

LIPS~SPART = '17' AND

LIPS~VTWEG = '9E' AND

LIPS~ERDAT GE GV_START AND

LIPS~ERDAT LE GV_END AND

LIPS~LFIMG > 0.

Re: run time error

Former Member — Mon, 14 Jul 2008 14:19:16 GMT

Karthik,

Just refer:

this is exactly same what you are facing.

Amit.

Re: run time error

Former Member — Mon, 14 Jul 2008 14:38:45 GMT

R_VBELN is probably filled in somewhere else in the program and has too many entries for the database to handle. You can correct this by using another JOIN or FOR ALL ENTRIES.

Rob