topic Re: Problem downloading from the application server in Application Development and Automation Discussions

Problem downloading from the application server

Former Member — Mon, 03 Mar 2008 15:39:59 GMT

Hey Folks,

I am using datasets to write a file onto the application server. but when i tried to download it on the dsktop its giving me a dump saying the file cannot handle more than 75mb of data. What wuld be the solution for this problem.

Regards

Rock.

Re: Problem downloading from the application server

Former Member — Mon, 03 Mar 2008 15:49:22 GMT

75 mb???

Is a binary file?

Show your code, you're probably using an infinite loop right now

Re: Problem downloading from the application server

Former Member — Mon, 03 Mar 2008 15:55:57 GMT

Hey ramiro,

class cl_abap_char_utilities definition load.

constants:

tab type c value cl_abap_char_utilities=>HORIZONTAL_TAB.

DATA : v_file TYPE rlgrap-filename VALUE 'D:\usr\sap\TST\DVEBMGS01\data\salesly.txt',

gs_data type string.

OPEN DATASET v_file FOR OUTPUT IN TEXT MODE ENCODING DEFAULT.

IF sy-subrc = 0.

LOOP AT gt_salesitm INTO gs_salesitm.

concatenate gs_salesitm-vkorg gs_salesitm-mtpos_mara gs_salesitm-region gs_salesitm-office gs_salesitm-text

gs_salesitm-hkunnr gs_salesitm-kunnr gs_salesitm-kunnr1 gs_salesitm-ernam gs_salesitm-kunnr2

gs_salesitm-text1 gs_salesitm-text2 gs_salesitm-matnr gs_salesitm-buy gs_salesitm-week

gs_salesitm-case gs_salesitm-doll gs_salesitm-pound into gs_data separated by tab.

TRANSFER gs_data TO v_file.

ENDLOOP.

WRITE : /'data written successfully'.

ENDIF.

CLOSE DATASET v_file.

Regards

Rock

Re: Problem downloading from the application server

Former Member — Mon, 03 Mar 2008 16:46:52 GMT

hi ,

use this it will exactly run,

report ztestprogramfordownload.

tables:zupload.

data:it_pa0002(200).

types: begin of ty_pa0002 ,

pernr like pa0002-pernr,

begda like pa0002-begda,

endda like pa0002-endda,

vorna like pa0002-vorna,

nachn like pa0002-nachn,

end of ty_pa0002.

data:begin of it_error occurs 0 ,

pernr like pa0000-pernr,

end of it_error .

data:it_final type standard table of ty_pa0002 with header line.

data:it_temp type standard table of ty_pa0002 with header line.

parameters:p_file like rlgrap-filename default 'F:\usr\sap\EC6\DVEBMGS00\work\entiraledu1'.

start-of-selection.

open dataset p_file for input in text mode encoding default.

do.

read dataset p_file into it_pa0002.

if sy-subrc = 0.

it_final-pernr = it_pa0002+0(8).

it_final-begda = it_pa0002+18(8).

it_final-endda = it_pa0002+36(8).

it_final-vorna = it_pa0002+54(40).

it_final-nachn = it_pa0002+104(40).

append it_final.

clear it_final.

else.

exit.

endif.

enddo.

if not it_final[] is initial.

sort it_final by pernr begda descending.

delete adjacent duplicates from it_final comparing pernr .

select pernr

begda

endda

vorna

nachn

from pa0002

into table it_temp

for all entries in it_final

where pernr = it_final-pernr.

endif.

loop at it_temp.

zupload-pernr = it_temp-pernr.

zupload-begda = it_temp-begda.

zupload-endda = it_temp-endda.

zupload-vorna = it_temp-vorna.

zupload-nachn = it_temp-nachn.

insert zupload.

clear it_temp.

clear zupload.

endloop.

close dataset p_file.

reward points if useful,

venkat.

Re: Problem downloading from the application server

Former Member — Mon, 03 Mar 2008 16:50:44 GMT

Hi Rock,

This code is to upload data to application server and should be wroking fine.

The issue generally comes when you try to download this file to presentation layer...

The reason fro getting this error is that huge amount of data is being downloaded into the same file in presentation server. Try downloading contents into multiple files.... It should work..

Split your internal table into itab1, itab2 and itab3 and download these into separate files and then manually combine these on the presentation server.

Hope this solves your problem

Cheers!!

Lokesh

Edited by: Lokesh Aggarwal on Mar 3, 2008 4:51 PM