Can't read with OPEN DATASET

[danilo_henriques]

Hey guys

I'm reading some files(TXT) from server with this command:

CALL 'SYSTEM' ID 'COMMAND' FIELD lv_command

ID 'TAB' FIELD lt_result-sys.

At this point i have my lt_result table filled with archives names.

They all have full permission: - rwxrwxrwx. Then i use the OPEN DATASET command to get data from each archive.

OPEN DATASET p_file FOR INPUT IN TEXT MODE.

I can perfectly read some of them but i keep getting sy-subrc = 8(The file could not be opened) at others...

Does anyone know how to solve this?

Best regards!

[Former Member]

check any open datasets prior to that. and also how you defined p_file..?

[danilo_henriques]

Vijay,

p_file LIKE rlgrap-filename.

I checked and there is no prior open dataset...

[danilo_henriques]

Vijay,

And also i'm doing this

READ DATASET p_file INTO ttp_arq11 LENGTH leng.

.....

CLOSE DATASET p_file.

TYPES: BEGIN OF i_arq,

line(999),

END OF i_arq.

DATA: leng(3) TYPE n VALUE 999.

[Former Member]

what are those files which you can't open/read using the open dataset.

are they normal text files or any thing else.

[danilo_henriques]

Normal text files: name_of_file.txt

[Former Member]

i thought they are not normal ones. may be they are associated with some code page etc.

[danilo_henriques]

Vijay,

What do you mean by code page?

[former_member156446]

HI SY-SUBRC 8..

then it should be some thing to do with the p_file make sure you are using the same case.. the path p_file is case sensitive.... check in tr. AL11 how are the paths defined.. and get the p_file exactly the same.

[danilo_henriques]

Jay,

I think the path is correct otherwise i wouldnt be able to read other files...I get sy-subrc = 8 only with a couple of files...

[Former Member]

Try opening the file using tcode cg3y .If you able we can then need to trouble shoot . if not then might be an authorization issue or file might be error. pls let us know the out come.

[danilo_henriques]

Karthik,

Do you know any other transaction to do this?

Because cg3y only accepts fields with max 60 lenght and my path has 70 lenght ( with file name included ).

[Former Member]

Hi,

Try to do some exception handling while opening the dataset and reading the dataset.

something like this :

  DATA : lex_file_open TYPE REF TO cx_sy_file_open,
         lex_file_access TYPE REF TO cx_sy_file_access_error,
         lex_file_io TYPE REF TO cx_sy_file_io,
         lex_root type ref to cx_root.

* Try to open the data set and catch the appropriate exception
  TRY.

      OPEN DATASET l_fsap FOR OUTPUT IN BINARY MODE.

    CATCH cx_sy_file_open INTO lex_file_open.
      MESSAGE lex_file_open->errortext TYPE 'I'.
    CATCH cx_sy_file_access_error INTO lex_file_access.
      MESSAGE lex_file_access->filename TYPE 'I'.
    catch CX_ROOT into lex_root...                        " any Other exceptions


  ENDTRY.

Similarly, for read dataset also handle the exceptions. You might get the exact root cause why the files are not being read.

regards,

Advait

[danilo_henriques]

Thanks for your help guys.

Jay,

The prolem was the file's extension:

file_name.txt is different from file_name.TXT

As you said, it's case sensitive. I just changed my code to search for both cases.

Thanks a lot.

Best regards.

Edited by: Danilo Henriques on Nov 3, 2008 8:47 PM