program going to dump

[Former Member]

Hi friends,

the following program is going to dump when i am executing it Plz correct me

the details are

dump: An exception occurred. This exception is dealt with in more detail below

. The exception, which is assigned to the class 'CX_SY_CONVERSION_NO_NUMBER',

was neither

caught nor passed along using a RAISING clause, in the procedure "FILE_UPLOAD"

"(FORM)"

.

Since the caller of the procedure could not have expected this exception

to occur, the running program was terminated.

The reason for the exception is:

The program attempted to interpret the value "BBP_PDS_HE" as a number, but

since the value contravenes the rules for correct number formats,

this was not possible.

FORM FILE_UPLOAD .

DATA: p_infile type string.

p_infile = p_file.

CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'

EXPORTING

• I_FIELD_SEPERATOR =

• i_line_header = 'X'

i_tab_raw_data = it_raw " WORK TABLE

i_filename = p_FILE

TABLES

i_tab_converted_data = i_FINAL[] "ACTUAL DATA

EXCEPTIONS

conversion_failed = 1

OTHERS = 2.

IF SY-SUBRC = 0.

ENDIF.

LOOP AT I_FINAL INTO WA_FINAL.

WA_MATERIAL-MATNR = WA_FINAL-PROID.

WA_MATERIAL-LIFNR = WA_FINAL-VEND+0(6).

WA_MATERIAL-PRICE = WA_FINAL-PRICE.

APPEND WA_MATERIAL TO I_MATERIAL.

ENDLOOP.

LOOP AT I_MATERIAL INTO WA_MATERIAL.

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'

EXPORTING

INPUT = WA_MATERIAL-MATNR

IMPORTING

OUTPUT = WA_MATERIAL-MATNR.

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'

EXPORTING

INPUT = WA_MATERIAL-LIFNR

IMPORTING

OUTPUT = WA_MATERIAL-LIFNR.

IF SY-SUBRC = 0.

MODIFY I_MATERIAL FROM WA_MATERIAL TRANSPORTING MATNR LIFNR.

ENDIF.

plz let me know

Any help is highly appreciated

[JozsefSzikszai]

hi,

looks like, there are problems with conversion, for example you want to put text into a field, which is defined as number. Pls. compare your input table and your target table in the program!

ec

[Former Member]

Hi eric,

the structures are as follows what was the wrong plz correct me

TYPES: BEGIN OF T_FINAL,

BID(30) TYPE C,

ITEM(15) TYPE C,

DATA(30) TYPE C,

SPACE(10) TYPE C,

DOC(30) TYPE C,

INDEX(3) TYPE C,

LINE(1) TYPE C,

SPAC1(10) TYPE C,

chgkey(1) TYPE C,

GUID(30) TYPE C,

INDEX1(3) TYPE C,

SPAC4(10) TYPE C,

ITDESC(30) TYPE C,

PROTYP(1) TYPE C,

PRODESC(30) TYPE C,

SPACE7(10) TYPE C,

MATNR TYPE MARA-MATNR, "Material Number

MAKTX TYPE MAKT-MAKTX, "Material description

MATKL TYPE MARA-MATKL, "Material group

WGBEZ60 TYPE T023T-WGBEZ60, "Material grp Desc.

ddate(10) type C,

dtime(10) type C,

fdat(10) type C,

tdat(10) type C,

qty(3) type c,

MEINS TYPE MARA-MEINS, "Base Unit of Measure

punit(10) type c,

PRICE(10) TYPE C,

curry(3) type c,

NDAY(2) TYPE C,

DAYS(4) TYPE C,

SPACE5(10) TYPE C,

SPACE6(10) TYPE C,

proid type mara-matnr,

DATIM(25) TYPE C,

VEND(10) TYPE C,

DATIM1(25) TYPE C,

VEND1(10) TYPE C,

END OF T_FINAL,

BEGIN OF T_MATERIAL,

MATNR TYPE EINA-MATNR,

LIFNR TYPE EINA-LIFNR,

PRICE TYPE EIPA-PREIS,

END OF T_MATERIAL,

[Former Member]

Can you check........ what is this BBP_PDS_HE in your program?

R u passing any header or anything other than values?

If you are passing the header and you declared the field as the numerical then it will not convert the data.

Put a breakpoint and debug the code you can easily find the exact field where it is going to dump...

[JozsefSzikszai]

it looks OK (only character fields), but you have to check your input file as well. Also check the detailed dump in ST22, may be it tells in which field is the problem.

[Former Member]

Hi Raj,

using debugging try to find exactly where you got the dump.

or go to ST22 and try find more details about your error.

Thanks.

[Former Member]

Hi

Eric and Vijji,

I went to ST22 the details about the error is as follows

You may able to find an interim solution to the problem

in the SAP note system. If you have access to the note system yourself,

use the following search criteria:

-

---

"CONVT_NO_NUMBER" CX_SY_CONVERSION_NO_NUMBERC

"ZR_UPLOAD_PIRPRICE_FROM_SRM" or "ZR_UPLOAD_PIRPRICE_FROM_SRM"

"FILE_UPLOAD"

-

---

If you cannot solve the problem yourself and you wish to send

an error message to SAP, include the following documents:

1. A printout of the problem description (short dump)

To obtain this, select in the current display "System->List->

Save->Local File (unconverted)".

2. A suitable printout of the system log

To obtain this, call the system log through transaction SM21.

Limit the time interval to 10 minutes before and 5 minutes

after the short dump. In the display, then select the function

"System->List->Save->Local File (unconverted)".

3. If the programs are your own programs or modified SAP programs,

supply the source code.

To do this, select the Editor function "Further Utilities->

Upload/Download->Download".

4. Details regarding the conditions under which the error occurred

or which actions and input led to the error.

The exception must either be prevented, caught within the procedure

"FILE_UPLOAD"

"(FORM)", or declared in the procedure's RAISING clause.

To prevent the exception, note the following:

what was the cause plz let me know

[Former Member]

there's a BIG hint in your short dump.

The program attempted to interpret the value "BBP_PDS_HE" as a number, but
since the value contravenes the rules for correct number formats,
this was not possible.

You need to go and figure out what TYPE your function module is expecting and compare that to the TYPE of what you are actually passing it.

[Former Member]

Hi Eric,

Thanks for the reply the downloaded file cant be coverted because of some reson

checked in notes 582516

Then i i copied the line items from the original file to new excel file and then try to upload its working now

but i dont know whether they are going to consider this becoz they have to copy the downloaded file to another new xls file

Edited by: sukruthi raj on Mar 17, 2008 6:53 PM