DBIF_RSQL_SQL_ERROR - CX_SY_OPEN_SQL_DB

Former Member — Thu, 26 Jul 2007 10:02:58 GMT

All,

When trying to run a program for the IS-U system I get the following error:

The termination occurred in the ABAP program "ZISU_DWNL_AFWIJKEND_VERBRUIK" in

" ".

The main program was " ".

The termination occurred in line 0 of the source code of the (Include)

program " "

of the source code of program " " (when calling the editor 00).

The program "ZISU_DWNL_AFWIJKEND_VERBRUIK" was started as a background job.

Processing was terminated because the exception "CX_SY_OPEN_SQL_DB" occurred in

the

procedure "SELECT_DATA" "(FORM)" but was not handled locally, not declared in

the

RAISING clause of the procedure.

The procedure is in the program "ZISU_DWNL_AFWIJKEND_VERBRUIK ". Its source

code starts in line " "

of the (Include) program " ".

An exception occurred. This exception is dealt with in more detail below

. The exception, which is assigned to the class 'CX_SY_OPEN_SQL_DB', was

neither

caught nor passed along using a RAISING clause, in the procedure "SELECT_DA

"(FORM)"

Since the caller of the procedure could not have expected this exception

to occur, the running program was terminated.

The reason for the exception is:

Tips voor foutoplossing

The exception must either be prevented, caught within the procedure

"SELECT_DATA"

"(FORM)", or declared in the procedure's RAISING clause.

To prevent the exception, note the following:

Database error text........: "ORA-01114: IO error writing block to file %s

(block # %s)"

Internal call code.........: "[RSQL/FTCH/ZVIEW_EABLG ]"

Please check the entries in the system log (Transaction SM21).

You may able to find an interim solution to the problem

in the SAP note system. If you have access to the note system yourself,

use the following search criteria:

"DBIF_RSQL_SQL_ERROR" CX_SY_OPEN_SQL_DBC

"ZISU_DWNL_AFWIJKEND_VERBRUIK" or " "

" "

Looking in SM21 and on SAPnet for notes did not give me the right solution.

Hopefully someone of you can.

Ps: This error we are also getting on other jobs (large jobs)

Re: DBIF_RSQL_SQL_ERROR - CX_SY_OPEN_SQL_DB

Former Member — Mon, 30 Jul 2007 20:51:05 GMT

The disk may have been off-line or more probably ran out of space or the table out of tablespace.

Rob

Re: DBIF_RSQL_SQL_ERROR - CX_SY_OPEN_SQL_DB

Former Member — Mon, 30 Jul 2007 21:21:20 GMT

Take the ORA-01114 error code to your DBA and let them take a look, as Rob told you, it is to do with filled up table space, probably ZVIEW_EABLG.

topic Re: DBIF_RSQL_SQL_ERROR - CX_SY_OPEN_SQL_DB in Application Development and Automation Discussions

DBIF_RSQL_SQL_ERROR - CX_SY_OPEN_SQL_DB

Re: DBIF_RSQL_SQL_ERROR - CX_SY_OPEN_SQL_DB

Re: DBIF_RSQL_SQL_ERROR - CX_SY_OPEN_SQL_DB