topic Re: Can't read with OPEN DATASET in Application Development and Automation Discussions

Can't read with OPEN DATASET

danilo_henriques — Mon, 03 Nov 2008 13:21:13 GMT

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!

Re: Can't read with OPEN DATASET

Former Member — Mon, 03 Nov 2008 13:23:43 GMT

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

Re: Can't read with OPEN DATASET

danilo_henriques — Mon, 03 Nov 2008 13:27:56 GMT

Vijay,

p_file LIKE rlgrap-filename.

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

Re: Can't read with OPEN DATASET

danilo_henriques — Mon, 03 Nov 2008 13:31:33 GMT

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.

Re: Can't read with OPEN DATASET

Former Member — Mon, 03 Nov 2008 13:34:03 GMT

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

are they normal text files or any thing else.

Re: Can't read with OPEN DATASET

danilo_henriques — Mon, 03 Nov 2008 13:37:30 GMT

Normal text files: name_of_file.txt

Re: Can't read with OPEN DATASET

Former Member — Mon, 03 Nov 2008 13:53:27 GMT

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

Re: Can't read with OPEN DATASET

former_member156446 — Mon, 03 Nov 2008 13:54:07 GMT

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.

Re: Can't read with OPEN DATASET

danilo_henriques — Mon, 03 Nov 2008 13:58:04 GMT

Vijay,

What do you mean by code page?

Re: Can't read with OPEN DATASET

danilo_henriques — Mon, 03 Nov 2008 14:00:34 GMT

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...

Re: Can't read with OPEN DATASET

Former Member — Mon, 03 Nov 2008 14:05:00 GMT

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.

Re: Can't read with OPEN DATASET

danilo_henriques — Mon, 03 Nov 2008 14:16:41 GMT

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 ).

Re: Can't read with OPEN DATASET

Former Member — Mon, 03 Nov 2008 14:17:44 GMT

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

Re: Can't read with OPEN DATASET

danilo_henriques — Mon, 03 Nov 2008 19:44:00 GMT

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