Skip to Content
0
Former Member
Apr 23, 2007 at 03:02 PM

DUMP in the MFBF transaction

140 Views

Hi Folks,

Users getting the frequent dumps in production systems. actaully we observed that dumps are coming when the users accessing the MFBF transaction manually when the batch job was running for backflush and NRIV (number ranges) table is getting locked.

The dump details is:

ABAP/4 runtime error DBIF_RSQL_SQL_ERROR

Occurred on 16.04.2007 at 15:57:10

-


>> Short dump has not been completely stored. It is too big.

-


SQL error 60 occurred when accessing table "NRIV ".

-


What happened?

-


The database system detected a deadlock and avoided it by rolling back

your transaction.

-


Information on where termination occurred

-


The termination occurred in the ABAP/4 program "SAPLSNR3" in

"READ_NRIV".

The main program was "SAPLBARM".

The termination occurred in line 231

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

The error occurred during batch input processing

-


Source code extract

-


002010 NRIV-TOYEAR = BNRIV-TOYEAR.

002020 G_FOUND = YES.

002030 WHEN 4.

002040 WHEN OTHERS.

002050 G_ERROR_IN_BUFFER = YES.

002060 ENDCASE.

002070 ENDIF.

002080

002090 IF BUFFER_ACTIVE = NO OR G_ERROR_IN_BUFFER = YES.

002100 * Die Pufferversion ist nicht aktiv oder es wurde bereits

002110 * ein Fehler im Puffer oder NrKreisServer festgestellt.

002120 * Gⁿltiges NrKreisIntervall mit Bis-GeschΣftsjahr aus der

002130 * DB ermitteln

002140 *

002150 SELECT * FROM NRIV WHERE OBJECT = P_OBJECT

002160 AND SUBOBJECT = P_SUBOBJECT

002170 AND NRRANGENR = P_NR_RANGE_NR

002180 AND TOYEAR >= P_TOYEAR

002190 ORDER BY PRIMARY KEY.

002200 G_FOUND = YES.

002210 EXIT.

002220 ENDSELECT.

002230 ENDIF.

002240

002250 IF G_FOUND = YES.

002260 * Intervall lesen, um zu sperren

002270 SELECT SINGLE FOR UPDATE * FROM NRIV WHERE

002280 OBJECT = NRIV-OBJECT

002290 AND SUBOBJECT = NRIV-SUBOBJECT

002300 AND NRRANGENR = NRIV-NRRANGENR

-


> AND TOYEAR = NRIV-TOYEAR.

002320 IF SY-SUBRC <> 0.

002330 MESSAGE E751 RAISING INTERVAL_NOT_FOUND WITH P_OBJECT

002340 P_NR_RANGE_NR.

002350 ENDIF.

002360 ELSE.

002370 MESSAGE E751 RAISING INTERVAL_NOT_FOUND WITH P_OBJECT

002380 P_NR_RANGE_NR.

002390 ENDIF.

002400 ENDIF.

002410

002420 IF NRIV-EXTERNIND <> SPACE.

002430 MESSAGE E752 RAISING NUMBER_RANGE_NOT_INTERN.

002440 ENDIF.

002450

002460 * L&#931;nge (maximale Anzahl Stellen) der Nummern berechnen

002470 G_NR_LENGTH = STRLEN( NRIV-FROMNUMBER ).

002480

002490 * Nummern in numerische Felder f&#8319;r sp&#931;tere Berechnungen &#8319;bernehmen

002500 ASSIGN NRIV-FROMNUMBER(G_NR_LENGTH) TO <G_F>.

-


Contents of system fields

-


SY field contents..................... SY field contents.....................

-


-


-


-


SY-SUBRC 0 SY-INDEX 1

SY-TABIX 1 SY-DBCNT 1

SY-FDPOS 32 SY-LSIND 0

SY-PAGNO 0 SY-LINNO 1

SY-COLNO 1

-


Chosen variables

-


Any help will get full points.

Regards

TAJUDDIN