production dump issue

[Former Member]

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

[Former Member]

hi,

error id is SAPSQL_WHERE_ILLEGAL_VALUE

[matt]

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

[Former Member]

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

[Former Member]

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

[former_member609120]

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