topic Re: Error handling with OPEN DATASET in Application Development and Automation Discussions

Error handling with OPEN DATASET

Former Member — Tue, 23 Jun 2009 19:48:28 GMT

Hi,

I have a question about the usage of error handling in OPEN DATASET

I can user MESSAGE msg option with OPEN DATASET

I can use TRY .... CATCH .. ENDTRY. statement.

1. Can I use both these ? or If I use one option, Is it true that I should not use the other option?

2. What is the difference between these two options?

Please let me know. Your help is appreciated.

Thank you,

Surya

Re: Error handling with OPEN DATASET

Former Member — Tue, 23 Jun 2009 20:07:04 GMT

hey..

check this..

OPEN DATASET dset FOR access IN mode MESSAGE msg .

If an error occurs when a fileis opened, the corresponding operating system message is assigned to the data object msg. A character-type variable can be entered for msg.

Regards,

Re: Error handling with OPEN DATASET

martinborda — Tue, 23 Jun 2009 21:17:51 GMT

Hi Surya,

I always use this code to handle errors in OPEN DATASET, both those that gets a SY-SUBRC NE 0 and those which could generate a dump (TRY...CATCH...ENDTRY):


CONSTANTS: c_error TYPE sy-msgty VALUE 'E'.

PARAMETERS: p_path TYPE admi_path.

START-OF-SELECTION.
 
...
 
  DATA: l_message   TYPE string,
        o_exception TYPE REF TO cx_root.

  TRY.

      OPEN DATASET p_path
           FOR OUTPUT
           IN TEXT MODE ENCODING DEFAULT
           MESSAGE l_message.

*     Error
      IF sy-subrc IS NOT INITIAL.

        MESSAGE l_message
           TYPE c_error.

      ENDIF.

*   Error
    CATCH cx_root
      INTO o_exception.

*     Gets error message
      CALL METHOD o_exception->if_message~get_text
        RECEIVING
          result = l_message.

      MESSAGE l_message
         TYPE c_error.

  ENDTRY.
 
...
 
  CLOSE DATASET p_path.

Re: Error handling with OPEN DATASET

martinborda — Tue, 23 Jun 2009 21:25:16 GMT

Regarding the difference between SY-SUBRC errors and EXCEPTIONS errors in OPEN DATASET, they are just two different ways of getting (different) possible errors, so you must take both into account.

This is from OPEN DATASET SAP help:

Return Value

sy-subrc Description 
0 File was opened. 
8 Operating system could not open file. 
 

Exceptions 
Catchable Exceptions 

CX_SY_FILE_OPEN 

Cause: File is already open (only in Unicode programs) 
Runtime Error: DATASET_REOPEN 

CX_SY_CODEPAGE_CONVERTER_INIT 

Cause: The desired conversion is not supported. (Due to specification of invalid code page or of language not supported in the conversion, with SET LOCALE LANGUAGE.) 
Runtime Error: CONVT_CODEPAGE_INIT (catchable) 

CX_SY_CONVERSION_CODEPAGE 

Cause: Internal error in the conversion. 
Runtime Error: CONVT_CODEPAGE (catchable) 

CX_SY_FILE_AUTHORITY 

Cause: No authorization for access to file 
Runtime Error: OPEN_DATASET_NO_AUTHORITY (catchable) 

Cause: Authorization for access to this file is missing in OPEN DATASET with addition FILTER. 
Runtime Error: OPEN_PIPE_NO_AUTHORITY (catchable) 

CX_SY_PIPES_NOT_SUPPORTED 

CX_SY_TOO_MANY_FILES 

Cause: Maximum number of open files exceeded. 
Runtime Error: DATASET_TOO_MANY_FILES (catchable) 


Non-Catchable Exceptions 

Cause: You tried to open a pipe that is already open. 
Runtime Error: DATASET_PIPE_POSITION

Re: Error handling with OPEN DATASET

Former Member — Tue, 23 Jun 2009 22:04:14 GMT

Hi Martin,

Thaks for your quick reply. This helps me.

I have a final question. What will be the value of SY-SUBRC in case of an exception?

Thank you,

Surya.

Re: Error handling with OPEN DATASET

former_member156446 — Wed, 24 Jun 2009 03:16:30 GMT

Re: Error handling with OPEN DATASET

Former Member — Wed, 24 Jun 2009 03:22:11 GMT

Why not use sy-subrc?

if sy-subrc is ne 0

" then you have a problem

You can use more specific number if you wish... I use and it tends to work well

Re: Error handling with OPEN DATASET

martinborda — Wed, 24 Jun 2009 14:21:20 GMT

Keith,

As you said, some errors will just generate a SY-SUBRC NE 0, but not trigger any exception.

These errors are easily "catchable" with:


  DATA: l_message   TYPE string.

      OPEN DATASET p_path
           FOR OUTPUT
           IN TEXT MODE ENCODING DEFAULT
           MESSAGE l_message.
 
*     Error
      IF sy-subrc IS NOT INITIAL.
 
        MESSAGE l_message
           TYPE c_error.
 
      ENDIF.

But another errors will trigger an exception, and if you don't catch them, they will show a nice dump in your program.

You catch them with:


  DATA: l_message   TYPE string,
        o_exception TYPE REF TO cx_root.

  TRY.
 
      OPEN DATASET p_path
           FOR OUTPUT
           IN TEXT MODE ENCODING DEFAULT.
 
...
 
*   Error
    CATCH cx_root
      INTO o_exception.
 
*     Gets error message
      CALL METHOD o_exception->if_message~get_text
        RECEIVING
          result = l_message.
 
      MESSAGE l_message
         TYPE c_error.
 
  ENDTRY.

That's why in the code I posted, you catch both types of errors that OPEN DATASET can generate.

Re: Error handling with OPEN DATASET

Former Member — Wed, 24 Jun 2009 20:42:16 GMT

Hi Martin,

Is it Ok to use like the following in Get error message?

Error

CATCH cx_root

INTO o_exception.

Gets error message

l_message = o_exception->get_text( ).

MESSAGE l_message

TYPE c_error.

Thank you,

Surya

Re: Error handling with OPEN DATASET

former_member156446 — Wed, 24 Jun 2009 21:06:53 GMT

DATA:
  gr_err TYPE REF TO cx_root,
  gs_msg TYPE string.
*
TRY.
  OPEN DATASET xxx FOR INPUT IN TEXT MODE ENCODING DEFAULT.
    CATCH cx_root INTO gr_err.
      gs_msg = gr_err->get_text( ).
ENDTRY.
*
IF  gs_msg IS NOT INITIAL.
    WRITE: /001 gs_msg.
ENDIF.

From the link I posted before.

Re: Error handling with OPEN DATASET

martinborda — Thu, 25 Jun 2009 13:40:23 GMT

Yes, it's the same, I just copied and pasted the method name from SE24.

Don't forget to take SY-SUBRC errors into account too.

Re: Error handling with OPEN DATASET

Former Member — Thu, 25 Jun 2009 16:01:34 GMT

Thank you!