topic Re: GUI_UPLOAD FM in Application Development and Automation Discussions

GUI_UPLOAD FM

Former Member — Mon, 13 Sep 2010 11:49:55 GMT

Hi,

Im trying to upload a Notepad file using FM GUI_UPLOAD.I have total 255 columns. Im getting the error as Access Denied(13 exception)The following is my code. please help me.

data p_apfile LIKE rlgrap-filename.

    DATA: lv_filepath TYPE string.     
    lv_filepath = p_apfile.

I_EXTRACT1 is an Internal table which has got 255 columns.

CALL FUNCTION 'GUI_UPLOAD'
      EXPORTING
        filename                      = lv_filepath
       filetype                      = 'ASC'
      TABLES
        data_tab                      = i_extract1
     EXCEPTIONS
       file_open_error               = 1
       file_read_error               = 2
       no_batch                      = 3
       gui_refuse_filetransfer       = 4
       invalid_type                  = 5
       no_authority                  = 6
       unknown_error                 = 7
       bad_data_format               = 8
       header_not_allowed            = 9
       separator_not_allowed         = 10
       header_too_long               = 11
       unknown_dp_error              = 12
       access_denied                 = 13
       dp_out_of_memory              = 14
       disk_full                     = 15
       dp_timeout                    = 16
       OTHERS                        = 17.

Regards,

Deepthi.

Edited by: Thomas Zloch on Sep 13, 2010 1:52 PM - code tags added

Re: GUI_UPLOAD FM

Former Member — Mon, 13 Sep 2010 11:51:00 GMT

Hi,

Make sure that file is not open already.

Regards,

Chen

Re: GUI_UPLOAD FM

Former Member — Mon, 13 Sep 2010 12:03:05 GMT

Hi,

The file is not opned.

I have also tried another way of uploading data as below but still it gives aceess_denied issue

DATA: lv_filepath TYPE string,

li_head TYPE xstring.

CLEAR: lv_filepath, li_head.

lv_filepath = p_apfile.

types : begin of t_data,

line TYPE string,

line(400),

end of t_data.

data: i_data type standard table of t_data.

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

filename = lv_filepath

filetype = 'ASC'

TABLES

data_tab = i_data "i_extract1[]

EXCEPTIONS

file_open_error = 1

file_read_error = 2

no_batch = 3

gui_refuse_filetransfer = 4

invalid_type = 5

no_authority = 6

unknown_error = 7

bad_data_format = 8

header_not_allowed = 9

separator_not_allowed = 10

header_too_long = 11

unknown_dp_error = 12

access_denied = 13

dp_out_of_memory = 14

disk_full = 15

dp_timeout = 16

OTHERS = 17.

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: GUI_UPLOAD FM

AlexanderOv — Mon, 13 Sep 2010 12:24:40 GMT

Maybe you don't have permissions for working with this file or file doesn't exist.

Re: GUI_UPLOAD FM

Former Member — Mon, 13 Sep 2010 12:37:07 GMT

hi ,

1. File is already open while you trying to upload.

2. Check the place where you would have saved the file .

3.Else try to upload a excel file and check fi you face the same issue.

Thanks!

Re: GUI_UPLOAD FM

Former Member — Mon, 13 Sep 2010 12:42:24 GMT

Hi Deepthi,

One tricky option would be, Try to copy the file and place it on your desktop and try to upload the data now..

If the file is not open you would be able to upload the file..

Regards

Satish Boguda

Re: GUI_UPLOAD FM

kesavadas_thekkillath — Mon, 13 Sep 2010 12:44:38 GMT

This exception gets triggered when some one else is trying to access the same file which is already in use.

Re: GUI_UPLOAD FM

Former Member — Mon, 13 Sep 2010 12:54:48 GMT

Hi Deepthi,

Kill/End all the tasks for "NOTEPAD" in the task manager and try again, also is this file local to your machine or a file on a file server?

Regards,

Chen

Re: GUI_UPLOAD FM

Former Member — Mon, 13 Sep 2010 12:55:05 GMT

Hi,

When i try to upload file through excel, there is no problem.

I have freshly copied the notepad file into my desktop and tried using gui_upload but still it is not working.

Thanks,

Deepthi.

Re: GUI_UPLOAD FM

Former Member — Mon, 13 Sep 2010 13:08:11 GMT

Check the file name getting populated to upload.

Debug the GUI_UPLOAD where it triggers the exception - check with message number.

If you can access the excel sheet from same place where you are trying to read the notepad then its fine.

Else You do not have the access to connect to the Presentation server from SAP.

Thanks!

Re: GUI_UPLOAD FM

Former Member — Mon, 13 Sep 2010 13:17:35 GMT

Hi Deeepthi,

Try in this way... From the same file remove some columns ( i would say use some 10 columns and try to upload the file )

Check are you getting the same error now or not..

Regards

Satish Boguda

Re: GUI_UPLOAD FM

Former Member — Mon, 13 Sep 2010 14:38:59 GMT

Hi,

I have removed the Heading rows and tried to upload data. now, it is working fine.

DATA: lv_filepath TYPE string,

li_head TYPE xstring.

CLEAR: lv_filepath, li_head.

lv_filepath = p_apfile.

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

filename = lv_filepath

filetype = 'ASC'

TABLES

data_tab = i_data

EXCEPTIONS

file_open_error = 1

file_read_error = 2

no_batch = 3

gui_refuse_filetransfer = 4

invalid_type = 5

no_authority = 6

unknown_error = 7

bad_data_format = 8

header_not_allowed = 9

separator_not_allowed = 10

header_too_long = 11

unknown_dp_error = 12

access_denied = 13

dp_out_of_memory = 14

disk_full = 15

dp_timeout = 16

OTHERS = 17.

IF sy-subrc <> 0.

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

ENDIF.

Split the File at Tab Delimited(#)

REFRESH: i_extract1[].

LOOP AT i_data INTO w_data.

SPLIT w_data-line AT cl_abap_char_utilities=>horizontal_tab INTO

w_extract1-lifnr w_extract1-dum2 w_extract1-dum3 w_extract1-dum4 w_extract1-dum5 w_extract1-dum6

w_extract1-dum7 w_extract1-dum8 w_extract1-dum9 w_extract1-dum10 w_extract1-dum11 w_extract1-dum12

w_extract1-dum13 w_extract1-dum14 w_extract1-dum15 w_extract1-dum16 w_extract1-dum17 w_extract1-dum18

w_extract1-dum19 w_extract1-duns w_extract1-dum21 w_extract1-dum22 w_extract1-dum23 w_extract1-dum24

w_extract1-dum25 w_extract1-dum26 w_extract1-dum27 w_extract1-dum28 w_extract1-dum29 w_extract1-dum30

w_extract1-dum31 w_extract1-dum32 w_extract1-dum33 w_extract1-dum34 w_extract1-dum35 w_extract1-dum36

w_extract1-dum37 w_extract1-dum38 w_extract1-dum39 w_extract1-dum40 w_extract1-dum41 w_extract1-dum42

w_extract1-dum43 w_extract1-min w_extract1-dum45 w_extract1-dum46 w_extract1-min1 w_extract1-dum48

w_extract1-dum49 w_extract1-dum50 w_extract1-dum51 w_extract1-dum52 w_extract1-dum53 w_extract1-dum54

w_extract1-dum55 w_extract1-dum56 w_extract1-dum57 w_extract1-dum58 w_extract1-dum59 w_extract1-dum60

w_extract1-dum61 w_extract1-dum62 w_extract1-dum63 w_extract1-dum64 w_extract1-dum65

w_extract1-dum66 w_extract1-dum67 w_extract1-dum68 w_extract1-dum69 w_extract1-dum70 w_extract1-dum71

w_extract1-dum72 w_extract1-dum73 w_extract1-dum74 w_extract1-dum75 w_extract1-dum76 w_extract1-dum77

w_extract1-dum78 w_extract1-dum79 w_extract1-dum80 w_extract1-dum81 w_extract1-dum82 w_extract1-dum83

w_extract1-dum84 w_extract1-dum85 w_extract1-dum86 w_extract1-dum87 w_extract1-dum88 w_extract1-dum89

w_extract1-womanind w_extract1-dum91 w_extract1-dum92 w_extract1-dum93 w_extract1-dum94 w_extract1-dum95

w_extract1-dum96 w_extract1-dum97 w_extract1-dum98 w_extract1-dum99 w_extract1-dum100 w_extract1-dum101

w_extract1-dum102 w_extract1-dum103 w_extract1-dum104 w_extract1-dum105 w_extract1-dum106 w_extract1-dum107

w_extract1-dum108 w_extract1-dum109 w_extract1-dum110 w_extract1-dum111 w_extract1-dum112 w_extract1-dum113

w_extract1-dum114 w_extract1-dum115 w_extract1-dum116 w_extract1-dum117 w_extract1-dum118 w_extract1-dum119

w_extract1-dum120 w_extract1-dum121 w_extract1-dum122 w_extract1-dum123 w_extract1-dum124 w_extract1-dum125

w_extract1-dum126 w_extract1-dum127 w_extract1-dum128 w_extract1-dum129 w_extract1-dum130 w_extract1-veteran

w_extract1-dum132 w_extract1-dum133 w_extract1-dum134 w_extract1-dum135 w_extract1-dum136 w_extract1-dum137

w_extract1-dum138 w_extract1-dum139 w_extract1-dum140 w_extract1-dum141 w_extract1-dum142 w_extract1-dum143

w_extract1-dum144 w_extract1-dum145 w_extract1-dum146 w_extract1-dum147 w_extract1-dum148 w_extract1-dum149

w_extract1-dum150 w_extract1-dum151 w_extract1-dum152 w_extract1-dum153 w_extract1-dum154 w_extract1-dum155

w_extract1-dbe w_extract1-dum157 w_extract1-dum158 w_extract1-dum159 w_extract1-dum160 w_extract1-dum161

w_extract1-dum162 w_extract1-dum163 w_extract1-dum164 w_extract1-dum165 w_extract1-dum166 w_extract1-dum167

w_extract1-dum168 w_extract1-dum169 w_extract1-dum170 w_extract1-sdb w_extract1-dum172 w_extract1-dum173

w_extract1-dum174 w_extract1-dum175 w_extract1-dum176 w_extract1-dum177 w_extract1-8a w_extract1-dum179

w_extract1-dum180 w_extract1-dum181 w_extract1-dum182 w_extract1-dum183 w_extract1-dum184 w_extract1-dum185

w_extract1-dad w_extract1-dum187 w_extract1-dum188 w_extract1-dum189 w_extract1-dum190 w_extract1-dum191

w_extract1-dum192 w_extract1-dum193 w_extract1-dum194 w_extract1-dum195 w_extract1-dum196 w_extract1-dum197

w_extract1-dum198 w_extract1-dum199 w_extract1-dum200 w_extract1-hubz w_extract1-lsa w_extract1-bmc

w_extract1-smlbus w_extract1-mbe w_extract1-wbe w_extract1-vvt w_extract1-sdv w_extract1-vbe

w_extract1-dve w_extract1-dvb w_extract1-sic1 w_extract1-sic2 w_extract1-sic3 w_extract1-dum215

w_extract1-dum216 w_extract1-dum217 w_extract1-dum218 w_extract1-dum219 w_extract1-dum220 w_extract1-dum221

w_extract1-dum222 w_extract1-dum223 w_extract1-naics1 w_extract1-naics2 w_extract1-naics3 w_extract1-dum227

w_extract1-dum228 w_extract1-dum229 w_extract1-dum230 w_extract1-dum231 w_extract1-dum232 w_extract1-dum234

w_extract1-dum235 w_extract1-dum236 w_extract1-dum237 w_extract1-dum238 w_extract1-dum239 w_extract1-dum240

w_extract1-dum241 w_extract1-dum242 w_extract1-dum243 w_extract1-dum244 w_extract1-dum245 w_extract1-dum246

w_extract1-dum247 w_extract1-dum248 w_extract1-dum249 w_extract1-dum250 w_extract1-dum251 w_extract1-dum252

w_extract1-dum253 w_extract1-dum254 w_extract1-dum255.

APPEND w_extract1 TO i_extract1.

CLEAR w_extract1.

ENDLOOP.

Thanks,

Deepthi.

Re: GUI_UPLOAD FM

Former Member — Mon, 13 Sep 2010 14:39:51 GMT

it is solved by removing the heading details from Notepad file.