‎2007 Jul 16 12:43 PM
hi ,
i am facing a problem while uploading a file which is encoded as well as compressed to the application server.
it is going to dump.
error is ,
the capacity limit has been reached
pls urgent .
points are assured.
‎2007 Jul 16 12:46 PM
Hi Sumeet,
Try to Access file data into batches.
like make a batch of first 20000 records and
then 200001 to 40000 likewise,
Reward if useful!
‎2007 Jul 16 12:53 PM
hello prasad,
i do not have many records,
then also i m getting this dump
here is my code:
OPEN DATASET l_file_oa FOR OUTPUT
FILTER 'compress'
IN
LEGACY
TEXT MODE
ignoring conversion errors
CODE PAGE g_sap_code_page.
in this g_sap_code _page correspond to 'iso-8859-1'
thnx
‎2007 Jul 16 12:49 PM
Hi,
What you need to do is to go to the particular directory and the delete the files which are no longer needed to get more space.It is a space issue and probably the basis team can help you on this.
Thanks,
Sandeep.
‎2007 Jul 16 12:52 PM
If capacity limit has been reached then it means App Server is no more capable of storing more data..
First you have to delete existing files on the server...
If you know about the useless files then you can delete those yourself... but u r not supposed to do that.. contact ur BASIS person..
If it is urgent and u know the the names and path of useless files..
just create a simple report and
use DELETE DATASET "filename with full path"
It will work...
Regards
Prax
‎2007 Jul 16 12:55 PM
hi Prax,
It has nothin to do with the size of application server, as i have deleting all the file s existing in the Application server,
but i m still getting this dump
‎2007 Jul 16 12:56 PM
hi i had developed a program in which uploading data to application server
so ithink it will be helpul for you
REPORT ZSD_EXCEL_INT_APP.
parameter: file_nm type localfile.
types : begin of it_tab1,
f1(20),
f2(40),
f3(20),
end of it_tab1.
data : it_tab type table of ALSMEX_TABLINE with header line,
file type rlgrap-filename.
data : it_tab2 type it_tab1 occurs 1,
wa_tab2 type it_tab1,
w_message(100) TYPE c.
at selection-screen on value-request for file_nm.
CALL FUNCTION 'KD_GET_FILENAME_ON_F4'
EXPORTING
PROGRAM_NAME = SYST-REPID
DYNPRO_NUMBER = SYST-DYNNR
FIELD_NAME = ' '
STATIC = 'X'
MASK = ' '
CHANGING
file_name = file_nm
EXCEPTIONS
MASK_TOO_LONG = 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.
start-of-selection.
refresh it_tab2[].clear wa_tab2.
file = file_nm.
CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'
EXPORTING
filename = file
i_begin_col = '1'
i_begin_row = '1'
i_end_col = '10'
i_end_row = '35'
tables
intern = it_tab
EXCEPTIONS
INCONSISTENT_PARAMETERS = 1
UPLOAD_OLE = 2
OTHERS = 3
.
IF sy-subrc <> 0.
MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.
loop at it_tab.
case it_tab-col.
when '002'.
wa_tab2-f1 = it_tab-value.
when '004'.
wa_tab2-f2 = it_tab-value.
when '008'.
wa_tab2-f3 = it_tab-value.
endcase.
at end of row.
append wa_tab2 to it_tab2.
clear wa_tab2.
endat.
endloop.
data : p_file TYPE rlgrap-filename value 'TEST3.txt'.
OPEN DATASET p_file FOR OUTPUT IN TEXT MODE ENCODING DEFAULT.
*--- Display error messages if any.
IF sy-subrc NE 0.
MESSAGE e001(zsd_mes).
EXIT.
ELSE.
*---Data is downloaded to the application server file path
LOOP AT it_tab2 INTO wa_tab2.
TRANSFER wa_tab2 TO p_file.
ENDLOOP.
ENDIF.
*--Close the Application server file (Mandatory).
CLOSE DATASET p_file.
loop at it_tab2 into wa_tab2.
write : / wa_tab2-f1,wa_tab2-f2,wa_tab2-f3.
endloop.
REWARD IF USEFUL
REGARDS
NARESH
‎2007 Jul 16 1:08 PM
hi naresh,
the thing is i have to encode as well as compress my data in to a particular format,
to the code given by you does not solve my purpose
‎2007 Jul 16 1:01 PM
Hi Surmeet,
It may be do to buffer overflow. do one thing, use standard fm for upload(like gui_upload). they do not have buffer problem.
Regards,
Nikhil
‎2007 Jul 16 1:06 PM
hi dear,
i have to schedule my report, and i think we can not use GUI tool in this case.
can u help me to solve this buffering problem