topic Re: 'Message_Type_Unknown' error while uploading in Application Development and Automation Discussions

'Message_Type_Unknown' error while uploading

Former Member — Mon, 08 Dec 2008 09:43:50 GMT

Hi,

Getting 'Message_Type_Unknown' error when using 'ALSM_EXCEL_TO_INTERNAL_TABLE' function module for data upload thro' excel sheet.

Why I get this error & what need to be done to rectify it?

Re: 'Message_Type_Unknown' error while uploading

Former Member — Mon, 08 Dec 2008 10:15:24 GMT

can you try this

TYPE-POOLS: truxs .

DATA: it_raw TYPE truxs_t_text_data.

PARAMETER: pfile LIKE rlgrap-filename MODIF ID sc1." OBLIGATORY.

CALL FUNCTION 'F4_FILENAME'

EXPORTING

program_name = syst-cprog

dynpro_number = syst-dynnr

field_name = ' '

IMPORTING

file_name = pfile.

CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'

EXPORTING

I_FIELD_SEPERATOR =

i_line_header = 'X'

i_tab_raw_data = it_raw

i_filename = pfile

TABLES

i_tab_converted_data = lt_excel[].

EXCEPTIONS
CONVERSION_FAILED = 1
OTHERS = 2

IF sy-subrc = 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

Re: 'Message_Type_Unknown' error while uploading

Former Member — Mon, 08 Dec 2008 10:25:20 GMT

Hi Kavitha,

When you are getting this message. Have you passed the parameters like this:

CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'

EXPORTING

FILENAME = P_FILE "name of file

I_BEGIN_COL = 1 "Starting column

I_BEGIN_ROW = 2 "Starting row

I_END_COL = 17 "Ending coloumn

I_END_ROW = 3000 "Ending row

TABLES

INTERN = itab "Internal table

EXCEPTIONS
INCONSISTENT_PARAMETERS = 1
UPLOAD_OLE = 2
OTHERS = 3 .

Can you paste the code where you are getting the error. You can check the error details in ST22. might be you are assiging the wrong data type.

Sachin

Re: 'Message_Type_Unknown' error while uploading

Former Member — Mon, 22 Dec 2008 07:11:19 GMT

Problem solved

Re: 'Message_Type_Unknown' error while uploading

Former Member — Tue, 03 Mar 2009 17:17:36 GMT

Hi Kavitha,

Can you please let me know how did you resolved this issue.

i am also getting the same kind of error. Working fine for some Excel files and for some excel files it is giving the same erroe 'MESSAGE UNKNOWN"

Thanks in advance.

Regards,

Lakshma.