topic Re: Problem in open data set in Application Development and Automation Discussions

Problem in open data set

Former Member — Tue, 23 Mar 2010 08:53:21 GMT

HI All ,

I have file which i can read from GUI_UPLOAD but we need to read it

on OPEN DATASET for that i use the following code but i get in mess

No such file or directory

What i miss here since when i try to open it from start->run it's work and

also in GUI_UPLAOD but not in open data set

OPEN DATASET lv_path_file FOR INPUT IGNORING CONVERSION ERRORS

IN TEXT MODE ENCODING DEFAULT MESSAGE mess .

Regards

Alex

Re: Problem in open data set

Former Member — Tue, 23 Mar 2010 09:02:01 GMT

Hello,

FOR INPUT is to read a already existing file in the application server. You will have to use FOR OUTPUT if you are creating the file


OPEN DATASET lv_path_file FOR OUTPUT IGNORING CONVERSION ERRORS
IN TEXT MODE ENCODING DEFAULT MESSAGE mess .

Vikranth

Re: Problem in open data set

Former Member — Tue, 23 Mar 2010 09:04:18 GMT

HI,

There is a basic difference between GUI upload and OPEN Dataset.

GUI uploads uploads file from presentation server into SAP. But Open dataset uploads from application server.

U seem to be trying to use open dataset for a file on ur desktop.

hope it helps,

Raj

Re: Problem in open data set

RaymondGiuseppi — Tue, 23 Mar 2010 09:07:09 GMT

- GUI_UPLOAD load a file from presentation server (PC, windows, eg: C:\)

- OPEN DATASET load a file from application server (see transactions AL11, FILE, platform dependant)

Where is your file stored ?

Regards,

Raymond

Re: Problem in open data set

Former Member — Tue, 23 Mar 2010 09:22:13 GMT

HI Vikranth ReddY ,

the file is already exist so any idea ?

Regards

Alex

Re: Problem in open data set

Former Member — Tue, 23 Mar 2010 09:24:54 GMT

HI Rajat ,

i drop it to server ,

when the file was on the desktop i use gui upload and it work fine .

Regards

Alex

Edited by: Alex Dean on Mar 23, 2010 10:25 AM

Re: Problem in open data set

Former Member — Tue, 23 Mar 2010 09:25:52 GMT

Hello Alex,

I thought you were trying to create a file after using GUI_UPLOAD.

If the file already exists, make sure you are passing the correct file path from AL11 also check if you are able to view the file through AL11. Also what is the value of SY_SUBRC after the open dataset?

Vikranth

Re: Problem in open data set

Former Member — Tue, 23 Mar 2010 09:38:28 GMT

HI Raymond ,

I Create file in transaction file and i use 'FILE_GET_NAME' FM

to read the file from the location but now the problem is that the read

dataset I getting subrc 4 and the file contain data so what can be the reason

in this case ?

OPEN DATASET lv_path_file FOR INPUT IGNORING CONVERSION ERRORS
  IN text  MODE ENCODING DEFAULT MESSAGE mess .

   DO.
      READ DATASET lv_path_file INTO ls_file.
      IF sy-subrc = 0.
        APPEND ls_file TO  lt_file .
      ELSE.
        EXIT.
      ENDIF.
    ENDDO.

Thanks

Alex

Re: Problem in open data set

Former Member — Tue, 23 Mar 2010 09:40:20 GMT

HI Vikranth ,

I Create file in transction FILE and i use 'FILE_GET_NAME' FM

to read the file from the location but now the problem is that the read

dataset i getting subrc 4 and the file contain data so what can be the reason

in this case ?

OPEN DATASET lv_path_file FOR INPUT IGNORING CONVERSION ERRORS
  IN text  MODE ENCODING DEFAULT MESSAGE mess .

   DO.
      READ DATASET lv_path_file INTO ls_file.
      IF sy-subrc = 0.
        APPEND ls_file TO  lt_file .
      ELSE.
        EXIT.
      ENDIF.
    ENDDO.

Thanks

Alex

Re: Problem in open data set

RaymondGiuseppi — Tue, 23 Mar 2010 09:41:47 GMT

Did you check authority (SU53 or SE16 on table SPTH) - Are you able to see the data from AL11, not only the file name in the list ?

SY-SUBRC = 4 is an EOF condition, check the linefeed default value in parameter abap/NTfmode (or add a [linefeed |http://help.sap.com/abapdocu_70/en/ABAPOPEN_DATASET_LINEFEED.htm]option to the OPEN DATASET)

Regards,

Raymond

Re: Problem in open data set

Former Member — Tue, 23 Mar 2010 11:01:30 GMT

Check whether the FM is returing logical file name or physical file name.

For OPEN DATASET, you need to specify the complete path.

Re: Problem in open data set

Former Member — Tue, 23 Mar 2010 12:13:36 GMT

Hi Alex,

What does the FM- FILE_GET_NAME return ?

Cross check before running the program using the file-name returned in earlier step by going to transaction AL11 (logical file paths for application server) and see if a file actually exists.

Plus the statement - OPEN DATASET <file> , needs not only the file directory path, but the complete file name,

i.e. say eg;- directory is TMP, in that a file by name "test.txt".

then ur filename value for OPEN DATASET should be "/tmp/test.txt".

Please try again this time.

Regards

Dedeepya C

Re: Problem in open data set

Former Member — Tue, 23 Mar 2010 16:25:53 GMT

HI Raymond

I am not see the file in AL11 ,

now i get sy-subrc = 0 after open data set but

the problem is that when i do read it's not opening (sy-subrc = 4 like below ) .any idea want could be the reason ?

READ DATASET lv_path_file INTO ls_file.
      IF sy-subrc = 0.

Regards

Alex

Re: Problem in open data set

Former Member — Tue, 23 Mar 2010 16:34:55 GMT

HI dedeepya ,

it return the file path ( the full file path)

Regards

Alex

Re: Problem in open data set

SuhaSaha — Tue, 23 Mar 2010 16:59:13 GMT


> I am not see the file in AL11 ,
> now  i get sy-subrc = 0 after open data set but 
> the problem is that when i do read it's not opening (sy-subrc = 4 like below )  .any idea want could be the reason ?
> 
>      READ DATASET lv_path_file INTO ls_file.
>       IF sy-subrc = 0.

If you cannot see the file in the app server directory how do you expect to READ it

Re: Problem in open data set

MariaJooRocha — Tue, 23 Mar 2010 17:19:03 GMT

Hi,

Did you check autohorizations? For server application SAP uses other than your username.

Best regards,

Maria João Rocha

Re: Problem in open data set

Former Member — Tue, 23 Mar 2010 17:52:49 GMT

HI Suhas ,

the file is in server and i create entry in TR . file

when I do open data set i get subrc = 0,

i guess if it dont find the file the i get subrc 8 .

bu the read is not work well do you have any idea ?

p.s.

do you say that if the file is not exist in AL11 i cant read it so i need to create entry there

and dont use TR.FILE

Regards

Alex

Re: Problem in open data set

Former Member — Tue, 23 Mar 2010 17:54:25 GMT

HI ,

I dont think that this relate to authorisation since it's not fail in open data set ,

i get subrc = 0 .

Regards

Alex

Re: Problem in open data set

SuhaSaha — Tue, 23 Mar 2010 18:20:52 GMT

What you are doing in FILE is basically creating logical filename & filepath. When you do so you donot create a physical file with its contents in the app server.

SY-SUBRC = 4 for READ DATASET implies that End Of File is reached & there are no contents in the file left to be read.

[http://help.sap.com/abapdocu_70/en/ABAPREAD_DATASET.htm|http://help.sap.com/abapdocu_70/en/ABAPREAD_DATASET.htm]

I think you have uploaded an empty file in the app server.

BR,

Suhas

PS: Try uploading the file to the app server using CG3Z trxn or CACS_FILE_COPY trxn & check if the READ DATASET stmt is failing.

Edited by: Suhas Saha on Mar 23, 2010 11:51 PM

Re: Problem in open data set

Former Member — Wed, 24 Mar 2010 04:01:10 GMT

How is your ls_file declared, try changing it into a variable of type string or use a field symbol and try.