topic Re: Query regarding short dump in Application Development and Automation Discussions

Query regarding short dump

Former Member — Wed, 20 Dec 2006 04:01:12 GMT

The runtime error is DBIF_RSQL_INVALID_RSQL and the exception is CX_SY_OPEN_SQL_DB.can anyone explain me these errors.

At this select query it going to short dump.Could anyone help me.Its urgent.

Select a_{aufnr a}gstrp a_{gsuzp b}iedd b~iedz into table i_uncount

from afko as a inner join afru as b on a_{aufnr = b}aufnr

for all entries in i_ordscp

where a_{aufnr = i_ordscp-aufnr and b}grund = 'ONS'

and b~stzhl = '0000000'.

Error Analysis:

The data read during a SELECT access could not be inserted into the target field.

Either the conversion is not supported for the target field's type or the target field is too short to accept the value or the data are not in a form that the target field can accept.

The target field is all correct.I've checked it.

Could anyone please help me.Its really urgent.U'll definitely be given points.

Thanks

chandrika.

Re: Query regarding short dump

Former Member — Wed, 20 Dec 2006 04:03:48 GMT

Select a~aufnr a~gstrp a~gsuzp b~iedd b~iedz 
<b>into corresponding fields of table i_uncount</b>from afko as a inner join afru as b on a~aufnr = b~aufnr 
for all entries in i_ordscp
where a~aufnr = i_ordscp-aufnr and b~grund = 'ONS'
and b~stzhl = '0000000'

try this.Then u will come to know where is the problem

Regards

Prabhu

Re: Query regarding short dump

Former Member — Wed, 20 Dec 2006 04:04:02 GMT

Either the table i_uncount doesn't have the fields a_{aufnr a}gstrp a_{gsuzp b}iedd b~iedz or its not in the same order

Regards,

Ravi

Re: Query regarding short dump

Former Member — Wed, 20 Dec 2006 04:27:43 GMT

This is the structure of t_uncont.

TYPES:BEGIN OF t_uncont,

aufnr like afko-aufnr,

gstrp like afko-gstrp,

gsuzp like afko-gsuzp,

aufpl like afko-aufpl,

iedd like afru-iedd,

iedz like afru-iedz,

END OF t_uncont.

DATA:i_uncont type standard table of t_uncont.

Re: Query regarding short dump

Former Member — Wed, 20 Dec 2006 04:38:48 GMT

Hi Sarath ,

Please look at the internal table decleration and the sequence of fields in select statement .

What is happening is that the select is tying to place the value of iedd into aufpl as a result of which this incompatibilty occurs.

So you can either user into corresponding-fields or modify the sequence of your internal table.

I would sugges the second option , as first can effect the performance.

So just declare the it as

TYPES:BEGIN OF t_uncont,

aufnr like afko-aufnr,

gstrp like afko-gstrp,

gsuzp like afko-gsuzp,

iedd like afru-iedd,

iedz like afru-iedz,

aufpl like afko-aufpl,

END OF t_uncont.

Regards

Arun