Skip to Content
0
Former Member
Sep 26, 2005 at 10:24 PM

Need help regarding short dumps in BW

302 Views

hi all,

We have a problem in our production.Thousands of short dumps have been created in a day stating

"Runtime Errors DBIF_RSQL_SQL_ERROR

Exception CX_SY_OPEN_SQL_DB"

=====================

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 "INSERT_ODS"

"(FORM)"

.

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

to occur, the running program was terminated.

The exception must either be prevented, caught within the procedure

"INSERT_ODS"

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

To prevent the exception, note the following:

Database error text........: "ORA-14400: inserted partition key does not map to

any partition"

===================

The RSRV check shows "Inconsistency: High value for table /BIC/B0000xxx000: 0002 ; PARTNO value in RSTSODS: 010."

When a repair was run on this table the short dumps stopped.Is there any other steps that should be taken to avoid such dumps in future/is there something that we have missed to maintainin in BW.

Please explain in detail, it will be of great help.

Thanks