topic Re: Runtime error while data retrieval in Application Development and Automation Discussions

Runtime error while data retrieval

Former Member — Wed, 14 Jan 2009 06:02:46 GMT

Hi all,

I want to fetch some data from a custom table, for which I have made an internal table taking all those fields which are needed in the correct order and , to avoid data type conflict I have made the non-character fields to character ones i.e.

for DATS(8) :- CHAR(10),

TIMS(6) :-CHAR(8),

QUAN(length-13, dec- 3) :- CHAR(17)

CURR( length-15, dec- 2) :- CHAR(18)

But still program gives Runtime Error.

Could anybody suggest a solution ?

How can we use developer trace ST11 for this ? Any procedure how to use ST11?

thanxxx

Re: Runtime error while data retrieval

Former Member — Wed, 14 Jan 2009 06:06:01 GMT

Hi,

Can u tell me what error u got?

Thanks,

Srilakshmi.

Re: Runtime error while data retrieval

Former Member — Wed, 14 Jan 2009 06:17:12 GMT

Error in ABAP application program.

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

"GET_DATA_CLOSED_ITEMS" "(FORM)"

The reason for the exception is:

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

target field.

Either 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.

But I hv already checked the fields of int table and those are fine .

Pls revert me...on the same.........

Re: Runtime error while data retrieval

faisalatsap — Wed, 14 Jan 2009 06:19:54 GMT

hi,Ubhaka

Past your code for better understanding about your problem,

Kind Regards,

Faisal

Re: Runtime error while data retrieval

Former Member — Wed, 14 Jan 2009 06:25:08 GMT

Hi,

I dont know why u r converting those fields to char type.

Try to do conversion after your select query.

Thanks,

Srilakshmi.

Re: Runtime error while data retrieval

Former Member — Wed, 14 Jan 2009 06:32:11 GMT

Hello Ubhaka,

This error occured due to the data type or the length of the data type is insuffeciant or it is not compatable.

IT will be hard to provide any soultion without having a look at your code....

Can you paste your code...so that we can check and suggest what can be done to fix it.

Regards,

Kittu

Re: Runtime error while data retrieval

SuhaSaha — Wed, 14 Jan 2009 06:44:29 GMT

Hello,


I want to fetch some data from a custom table, for which I have made an internal table taking all those fields which are needed in the correct order and , to avoid data type conflict I have made the non-character fields to character ones i.e.
for DATS(8) :- CHAR(10), 
TIMS(6) :-CHAR(8),
QUAN(length-13, dec- 3) :- CHAR(17)
CURR( length-15, dec- 2) :- CHAR(18)

This is where you have committed the mistake, friend !!!

During data selection you cannot assign DATS, TIMS, QUAN & CURR field to character fields as you have done. It will lead to runtime error.

Please change the declaration of your internal table, it will work.

BR,

Suhas

Re: Runtime error while data retrieval

faisalatsap — Wed, 14 Jan 2009 06:50:53 GMT

Hi,

In the following code where i am using char(10) for date is giving the error,

TABLES: pa0001.

TYPES: BEGIN OF t_pa0001,
  pernr like pa0001-pernr,
  begda(10),
  endda(10),
  END OF t_pa0001.

data: it_pa0001 type STANDARD TABLE OF t_pa0001 WITH HEADER LINE,
      wa_it_pa0001 TYPE t_pa0001.


SELECT pernr begda endda from pa0001
  into CORRESPONDING FIELDS OF TABLE it_pa0001
  WHERE endda = '99991231'.

but in the bellow code where i am using sy-datum or like pa0001-begda, pa0001-endda, it is working fine

TABLES: pa0001.

TYPES: BEGIN OF t_pa0001,
  pernr like pa0001-pernr,
  begda like sy-datum,
  endda like pa0001-endda,
  END OF t_pa0001.

data: it_pa0001 type STANDARD TABLE OF t_pa0001 WITH HEADER LINE,
      wa_it_pa0001 TYPE t_pa0001.


SELECT pernr begda endda from pa0001
  into CORRESPONDING FIELDS OF TABLE it_pa0001
  WHERE endda = '99991231'.

So, Please Change your code Accordingly,

Replay if any Issue,

Kind Regards,

Faisal

Edited by: Faisal Altaf on Jan 14, 2009 11:51 AM

Re: Runtime error while data retrieval

dev_parbutteea — Wed, 14 Jan 2009 07:46:30 GMT

Hi,

Just use the same data types as in your z-table and do your retrieval. Do the conversion within your program.

Regards,

Dev.