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