Skip to Content
0
Former Member
Jan 08, 2008 at 07:02 PM

DBIF_REPO_SQL_ERROR short dumps while activating data in ODS

761 Views

Hi All,

We are using BW3.5 with Oracle 9.2 on AIX 5.3 box, from the past few days we are getting DBIF_REPO_SQL_ERROR short dumps frequently while activating data in ODS.

Runtime Error DBIF_REPO_SQL_ERROR

Date and Time 08.01.2008 13:01:08

1. A printout of the problem description (short dump)

To obtain this, select in the current display "System->List->

Save->Local File (unconverted)".

2. A suitable printout of the system log

To obtain this, call the system log through transaction SM21.

Limit the time interval to 10 minutes before and 5 minutes

after the short dump. In the display, then select the function

"System->List->Save->Local File (unconverted)".

3. If the programs are your own programs or modified SAP programs,

supply the source code.

To do this, select the Editor function "Further Utilities->

Upload/Download->Download".

4. Details regarding the conditions under which the error occurred

or which actions and input led to the error.

Internal call code.........: "[REPO/*/43/LOAD/CX_SY_OPEN_SQL_DB=============CP

]"

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_REPO_SQL_ERROR" C

"SAPLRSSM_PROCESS" or "LRSSM_PROCESSF04"

"CHECK_IF_ANALYZE_IS_NESSESSARY"

System environment

SAP Release.............. "640"

Application server....... "psapdb"

Network address.......... "158.58.65.11"

Operating system......... "AIX"

Release.................. "5.3"

Hardware type............ "00CD615C4C00"

Character length......... 16 Bits

Pointer length........... 64 Bits

Work process number...... 22

Short dump setting....... "full"

Database server.......... "psapdb"

Database type............ "ORACLE"

Database name............ "BWP"

Database owner........... "SAPBWP"

Character set............ "C"

SAP kernel............... "640"

Created on............... "Oct 29 2006 20:49:57"

Created in............... "AIX 1 5 00538A4A4C00"

Database version......... "OCI_920 "

Patch level.............. "155"

Patch text............... " "

Supported environment....

Database................. "ORACLE 9.2.0.., ORACLE 10.1.0.., ORACLE

10.2.0.."

SAP database version..... "640"

Operating system......... "AIX 1 5, AIX 2 5, AIX 3 5"

Memory usage.............

Roll..................... 16192

EM....................... 16759424

Heap..................... 0

Page..................... 24576

MM Used.................. 6604384

MM Free.................. 1772536

SAP Release.............. "640"

User and Transaction

Client.............. 200

User................ "R3REMOTE"

Language key........ "E"

Transaction......... " "

Program............. "SAPLRSSM_PROCESS"

Screen.............. "SAPMSSY0 1000"

Screen line......... 6

Information on where terminated

The termination occurred in the ABAP program "SAPLRSSM_PROCESS" in

"CHECK_IF_ANALYZE_IS_NESSESSARY".

The main program was "RSPROCESS ".

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

program "LRSSM_PROCESSF04"

of the source code of program "LRSSM_PROCESSF04" (when calling the editor

11430).

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

Job name........ "BI_PROCESS_ODSACTIVAT"

Job initiator... "RPRIYANKA"

Job number...... 02010102

************************************************************************

Also we have a failed job here. Here is the job log.

Job log overview for job: BI_PROCESS_ODSACTIVAT / 02010102

Date Time Message text

08.01.2008 13:01:00 Job started

08.01.2008 13:01:00 Step 001 started (program RSPROCESS, variant &0000000000188, user ID R3REMOTE)

08.01.2008 13:01:02 Activation is running: Data target HBCS_O25, from 1,758 to 1,767

08.01.2008 13:01:02 Data to be activated successfully checked against archiving objects

08.01.2008 13:01:02 SQL: 01/08/2008 13:01:02 R3REMOTE

08.01.2008 13:01:02 ANALYZE TABLE "/BIC/AHBCS_O2540" DELETE

08.01.2008 13:01:02 STATISTICS

08.01.2008 13:01:02 SQL-END: 01/08/2008 13:01:02 00:00:00

08.01.2008 13:01:02 SQL: 01/08/2008 13:01:02 R3REMOTE

08.01.2008 13:01:02 BEGIN DBMS_STATS.GATHER_TABLE_STATS ( OWNNAME =>

08.01.2008 13:01:02 'SAPBWP', TABNAME => '"/BIC/AHBCS_O2540"',

08.01.2008 13:01:02 ESTIMATE_PERCENT => 1 , METHOD_OPT => 'FOR ALL

08.01.2008 13:01:02 INDEXED COLUMNS SIZE 75', DEGREE => 1 ,

08.01.2008 13:01:02 GRANULARITY => 'ALL', CASCADE => TRUE ); END;

08.01.2008 13:01:05 SQL-END: 01/08/2008 13:01:05 00:00:03

08.01.2008 13:01:05 SQL-ERROR: 603 ORA-00603: ORACLE server session terminated by fat al error

08.01.2008 13:01:05 System error: RSDU_ANALYZE_TABLE_ORA/ ORACLE

08.01.2008 13:01:08 ABAP/4 processor: DBIF_REPO_SQL_ERROR

08.01.2008 13:01:08 Job cancelled

*************************************************************************

Listener is working fine, Checked the RFC connections, Tried restarting the system, tried adding space to the TEMP tablespace as well as PSAPBWP, but they didn't work.

Please help.