topic Re: production dump issue in Application Development and Automation Discussions

production dump issue

Former Member — Wed, 20 May 2009 12:23:12 GMT

hi,

i got one issue in production dump.

in the dump (st22) ,below got like this

Error analysis

The current ABAP/4 program attempted to execute an ABAP/4 Open SQL

statement containing a WHERE condition of the form WHERE (itab) or

WHERE ... AND (itab). The part of the WHERE condition specified at

runtime in the internal table itab contains an invalid

value "NULL". Literals are allowed as values, but not variables.

name of program : SAPLSDTX

FM:RFC_READ_TABLE" ,in this FM, in the below select statement.

yarrow mark here marking

001490 IF NO_DATA EQ SPACE.

001500

001510 DATA: BEGIN OF WORK, BUFFER(30000), END OF WORK.

001520 FIELD-SYMBOLS <F>.

001530

001540 IF ROWCOUNT > 0.

001550 ROWCOUNT = ROWCOUNT + ROWSKIPS.

001560 ENDIF.

001570

> SELECT * FROM (QUERY_TABLE) INTO WORK WHERE (OPTIONS).

001590

001600 IF SY-DBCNT GT ROWSKIPS.

can anybody give the possible reason for dump in production.dump is coming repeately 45 times with in 3 hr.??

i am waiting for ur valuable answer??

thanks

subhasis

Re: production dump issue

Former Member — Wed, 20 May 2009 12:24:24 GMT

hi,

error id is SAPSQL_WHERE_ILLEGAL_VALUE

Re: production dump issue

matt — Wed, 20 May 2009 14:31:38 GMT

Have a look, in the dump, at the value of "OPTIONS". Whatever is constructing that is presumably getting it wrong.

But you'd need to provide considerably more detail for any specific help. What's the name of the program that's running?

If it's SAP standard, then search on OSS, and if necessary log a call.

matt

Re: production dump issue

Former Member — Wed, 20 May 2009 14:41:21 GMT

Hi,

if you pass null in where condition...

select single * from mara into it_mara where matnr = null.

below error throws by system..

Field "NULL" is unknown. It is neither in one of the specified tables

nor defined by a "DATA" statement. "DATA" statement.

so null is not recognized and predefined statement is sap..

try to pass SPACE in place of NULL it will works..

Regards,

Prabhudas

Re: production dump issue

Former Member — Thu, 21 May 2009 05:12:23 GMT

hi,

program name is SAPLSDTX

in this program, one include is there INCLUDE LSDTXU01. "RFC_READ_TABLE

insight this include above select statement is executing.

in where condition option is refering

TABLES

*" OPTIONS STRUCTURE RFC_DB_OPT

where RFC_DB_OPT is (RFC Table Read: Select Options / WHERE Clause)

IN THE RFC_DB_OPT STRUCTURE ONE FIELD TEXT IS THERE , IN DEBUGGING MODE

ALSO THE FIELD VALUE IS COMING BLANK.

and WA contains the values correctly.

so i think any buffering issue.??

kindly let me know

Re: production dump issue

former_member609120 — Thu, 21 May 2009 09:03:27 GMT

Hi,

The exception raised could be caused because A token cannot be interpreted as a literal or as a

valid variable name.

Thanks and regards,

Vanessa