topic Re: Error Analysis in Application Development and Automation Discussions

Error Analysis

Former Member — Mon, 04 Feb 2008 11:28:02 GMT

Hi Techis

Wiil anybody pls tell how to solve following error as my report is giving dump]

Error analysis

An exception occurred that is explained in detail below.

The exception, which is assigned to class 'CX_SY_OPEN_SQL_DB', was not caught

and

therefore caused a runtime error.

The reason for the exception is:

In a SELECT access, the read file could not be placed in the target

field provided.

Either the conversion is not supported for the type of the target field,

the target field is too small to include the value, or the data does not

have the format required for the target field.

AND my select statement is

SELECT BUKRS BLDAT GSBER DMBTR BUDAT GJAHR SGTXT SAKNR FROM BSID INTO TABLE IT_FINAL

where BUKRS IN S_BUKRS.

AND MY INTERNAL TABLE IS

DATA : BEGIN OF IT_FINAL OCCURS 0,

NAME LIKE KNA1-NAME1, " Customer Name

KTOKD LIKE KNA1-KTOKD, "Account group

SORTL LIKE KNA1-SORTL, " Search Term

BUKRS LIKE BSID-BUKRS, "Comany Code

KUNNR LIKE BSID-KUNNR, "Customer Number

BLDAT LIKE BSID-BLDAT, " Doc.date

GSBER LIKE BSID-GSBER, " Business Area

DMBTR LIKE BSID-BUDAT, "Document Date

BUDAT LIKE BSID-BUDAT, "Document Date

GJAHR LIKE BSID-GJAHR, "Fiscal Year

SGTXT LIKE BSID-SGTXT, " Line-item text.

SAKNR LIKE BSID-SAKNR, "g/l Account

SHKZG LIKE BSID-SHKZG, " Debit/Credit ind.

PRCTR LIKE BSID-PRCTR, " Profit Center

THIRTY LIKE BSID-DMBTR, " 00-30 days.

SIXTY LIKE BSID-DMBTR, " 31-60 days.

NINETY LIKE BSID-DMBTR, " 61-90 days.

ONETWENTY LIKE BSID-DMBTR, " 91-120 days.

ONEFIFTY LIKE BSID-DMBTR, " 121-150 days.

ONEEIGHTY LIKE BSID-DMBTR, " 151-180 days.

THREESIXTY LIKE BSID-DMBTR, " 180-360 days.

AMT LIKE BSID-DMBTR, " 180-360 days.

END OF IT_FINAL.

REwars will be awarde for ans

Regards

Re: Error Analysis

Former Member — Mon, 04 Feb 2008 11:30:18 GMT

Hello,

Modify ur select like this.


SELECT BUKRS BLDAT GSBER DMBTR BUDAT GJAHR SGTXT SAKNR FROM BSID INTO 
Corresponding fields of " Check here
TABLE IT_FINAL
where BUKRS IN S_BUKRS.

Cheers,

Vasanth

Re: Error Analysis

Former Member — Mon, 04 Feb 2008 11:30:30 GMT

hi,

the structure of the table IT_FINAL and the order and number of fields in the select statemnt is different.

chaneg the definition of the table it_FINAL with the same number and order of the fields as in select statement and exceute.

Reward Appropriate points.

regards,

Mansi.

Re: Error Analysis

Former Member — Mon, 04 Feb 2008 11:30:43 GMT

Hi,

If you are using into table in the select statement the order of the fields in the internal table defination and the fields in the select statement should be in the same order. (THis is to increase the performance also).

Use corresponding fields of itab instead of into table itab.

This will solve your problem.

Thanks,

Sriram Ponna.

Re: Error Analysis

former_member188829 — Mon, 04 Feb 2008 11:32:40 GMT

Hi,

Use your select statement like this...

SELECT BUKRS BLDAT GSBER DMBTR BUDAT GJAHR SGTXT SAKNR FROM BSID INTO CORRESPONDING FIELDS OF TABLE IT_FINAL

where BUKRS IN S_BUKRS.

Re: Error Analysis

former_member386202 — Mon, 04 Feb 2008 11:51:02 GMT

Hi,

Its a BASIS problem, BASIS people has to increase the roll area memory. Tell them to increase the memory.

Regards,

Prashant

Re: Error Analysis

Former Member — Mon, 04 Feb 2008 16:00:08 GMT

You are SELECTing a very large amount of data. Do you really need to do this? If so, you can use the PACKAGE SIZE option of the SELECT statement.

Rob