About DUMP: DBIF_RSQL_SQL_ERROR

[Former Member]

Hii Expert ,

I am facing  below issue while trying to export client.   SQL Error Dump : DBIF_RSQL_SQL_ERROR

Exception              CX_SY_OPEN_SQL_DB

Short text

    SQL error in the database when accessing a table.

What can you do?

    Note which actions and input led to the error.

    For further help in handling the problem, contact your SAP administrator

    .

    You can use the ABAP dump analysis transaction ST22 to view and manage

    termination messages, in particular for long term reference.

How to correct the error

    Database error text........: "[601] Could not continue scan with NOLOCK due to

     data movement."

    Internal call code.........: "[RSQL/COUN/AFFH ]"

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

    If the error occures in a non-modified SAP program, you may be able to

    find an interim solution in an SAP Note.

    If you have access to SAP Notes, carry out a search with the following

    keywords:

    "DBIF_RSQL_SQL_ERROR" "CX_SY_OPEN_SQL_DB"

    "RSSPACECHECK" or "RSSPACECHECK"

    "GET_TABLE_SIZE"

If you cannot solve the problem yourself and want to send an error

notification to SAP, include the following information:

1. The description of the current problem (short dump)

   To save the description, choose "System->List->Save->Local File

(Unconverted)".

2. Corresponding system log

   Display the system log by calling transaction SM21.

   Restrict the time interval to 10 minutes before and five minutes

after the short dump. Then choose "System->List->Save->Local File

(Unconverted)".

3. If the problem occurs in a problem of your own or a modified SAP

program: The source code of the program

   In the editor, choose "Utilities->More

Utilities->Upload/Download->Download".

4. Details about the conditions under which the error occurred or which

actions and input led to the error.

The exception must either be prevented, caught within proedure

"GET_TABLE_SIZE" "(FORM)", or its possible occurrence must be declared in the

RAISING clause of the procedure.

To prevent the exception, note the following:

Regards

Dhananjay patil

[Sriram2009]

Hi Patil

Could you the full dump detail as text format either attachment or paste.

BR

[Former Member]

Hii SS

Runtime Errors DBIF_RSQL_SQL_ERROR

Exception CX_SY_OPEN_SQL_DB

Date and Time 24.12.2014 17:55:18

Short text

     SQL error in the database when accessing a table.

What can you do?

     Note which actions and input led to the error.

     For further help in handling the problem, contact your SAP administrator

     You can use the ABAP dump analysis transaction ST22 to view and manage

     termination messages, in particular for long term reference.

How to correct the error

    Database error text........: "[601] Could not continue scan with NOLOCK due to

     data movement."

    Internal call code.........: "[RSQL/COUN/AFFH ]"

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

If the error occures in a non-modified SAP program, you may be able to

    find an interim solution in an SAP Note.

    If you have access to SAP Notes, carry out a search with the following

    keywords:

    "DBIF_RSQL_SQL_ERROR" "CX_SY_OPEN_SQL_DB"

"RSSPACECHECK" or "RSSPACECHECK"

"GET_TABLE_SIZE"

    If you cannot solve the problem yourself and want to send an error

    notification to SAP, include the following information:

  1. The description of the current problem (short dump)

     To save the description, choose "System->List->Save->Local File

  (Unconverted)".

  2. Corresponding system log

  Display the system log by calling transaction SM21.

     Restrict the time interval to 10 minutes before and five minutes

  after the short dump. Then choose "System->List->Save->Local File

  (Unconverted)".

  3. If the problem occurs in a problem of your own or a modified SAP

  program: The source code of the program

     In the editor, choose "Utilities->More

Utilities->Upload/Download->Download".

  4. Details about the conditions under which the error occurred or which

  actions and input led to the error.

  The exception must either be prevented, caught within proedure

"GET_TABLE_SIZE" "(FORM)", or its possible occurrence must be declared in the

  RAISING clause of the procedure.

  To prevent the exception, note the following:

System environment

    SAP-Release 700

    Application server... "NBS007"

Operating system..... "Windows NT

Release.............. "5.2"

Hardware type........ "2x AMD64 L

Character length.... 16 Bits

Pointer length....... 64 Bits

Work process number.. 0

Shortdump setting.... "full"

Database server... "NBS007"

Database type..... "MSSQL"

Database name..... "NTP"

Database user ID.. "ntp"

Terminal................. " "

   Char.set.... "C"

   SAP kernel....... 700

   created (date)... "Jan 24 2008 01:15:15"

   create on........ "NT 5.2 3790 Service Pack 1 x86 MS VC++ 14.00"

   Database version. "SQL_Server_8.00 "

   Patch level. 144

   Patch text.. " "

Database............. "MSSQL 7.00.699 or higher, MSSQL 8.00.194"

   SAP database version. 700

   Operating system..... "Windows NT 5.0, Windows NT 5.1, Windows NT 5.2, Windows

    NT 6.0"

Memory consumption

Roll.... 16192

EM...... 41898400

Heap.... 0

Page.... 65536

MM Used. 25724256

MM Free. 3600656

User and Transaction

Client.............. 500

    User................ "KISHOR"

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

Transaction......... "SE38 "

    Transactions ID..... "BC648BE44AA8F1B89D5D902B34C3E68E"

Program............. "RSSPACECHECK"

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

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

Information on where terminated

    Termination occurred in the ABAP program "RSSPACECHECK" - in "GET_TABLE_SIZE".

    The main program was "RSSPACECHECK ".

    In the source code you have the termination point in line 184

    of the (Include) program "RSSPACECHECK".

    The termination is caused because exception "CX_SY_OPEN_SQL_DB" occurred in

    procedure "GET_TABLE_SIZE" "(FORM)", but it was neither handled locally nor

     declared

    in the RAISING clause of its signature.

    The procedure is in program "RSSPACECHECK "; its source code begins in line

    128 of the (Include program "RSSPACECHECK ".

Source Code Extract

Line  SourceCde

  154     EXCEPTIONS

  155       DDIC_ERROR       = 1

  156       OTHERS           = 2

  157             .

  158   NT_SUBRC = SY-SUBRC.

  159   IF X030L-TABFORM CO 'CP'.

  160     CALL FUNCTION 'DB_EXISTS_TABLE'

  161       EXPORTING

  162         TABNAME = X030L-REFNAME

  163       IMPORTING

  164         SUBRC = SUBRC.

  165   ELSE.

  166     CALL FUNCTION 'DB_EXISTS_TABLE'

  167       EXPORTING

  168         TABNAME = LTABLE

  169       IMPORTING

  170         SUBRC = SUBRC.

  171   ENDIF.

  172

  173   IF SUBRC = 0 AND NT_SUBRC = 0.

  174     CLEAR RCOD.

  175     IF CLIENT = '%'.

176       SELECT COUNT(*) INTO P_SIZETAB-NBRINS

177 FROM (P_SIZETAB-TABNAME).

178     ELSE.

179       LOOP AT T000_TAB.

180         READ TABLE DFIES INDEX 1.

181         CTAB = '& = ''&'' '.

182         REPLACE '&' WITH DFIES-FIELDNAME INTO CTAB.

183         REPLACE '&' WITH T000_TAB INTO CTAB.

>>> SELECT COUNT(*) INTO NBRINS FROM (P_SIZETAB-TABNAME)

185                                      CLIENT SPECIFIED WHERE (CTAB).

186 P_SIZETAB-NBRINS = P_SIZETAB-NBRINS + NBRINS.

187       ENDLOOP.

188     ENDIF.

189   ELSE.

190     RCOD = 8.

191   ENDIF.

192 ENDFORM.                    "GET_TABLE_SIZE

Contents of system fields

Name     Val.

SY-SUBRC 0

SY-INDEX 0

SY-TABIX 1

SY-DBCNT 0

SY-FDPOS 0

SY-LSIND 0

SY-PAGNO 0

SY-LINNO 1

SY-COLNO 1

SY-PFKEY

SY-UCOMM

SY-TITLE Determine Memory Requirement in Database Areas

SY-MSGTY I

SY-MSGID SF

SY-MSGNO 616

SY-MSGV1 RSSPACECHECK

SY-MSGV2 RE

SY-MSGV3 EN

SY-MSGV4

SY-MODNO 0

SY-DATUM 20141224

SY-UZEIT 175511

SY-XPROG SAPCNVE

SY-XFORM CONVERSION_EXIT

Active Calls/Events

1. Ty.          Program                             Include                             Line

      Name

    2 FORM         RSSPACECHECK                        RSSPACECHECK                          184

      GET_TABLE_SIZE

    1 EVENT        RSSPACECHECK                        RSSPACECHECK                           67

START-OF-SELECTION

Chosen variables

Name

    Val.

1. 2 Ty.          FORM

Name  GET_TABLE_SIZE

P_SIZETAB-NBRINS

    ########

    00000000

    0000000C

T000_TAB[]

    Table IT_22[1x6]

\PROGRAM=RSSPACECHECK\DATA=T000_TAB[]

    Table reference: 18

    TABH+  0(20) = B0775372FE070000000000000000000000000000

    TABH+ 20(20) = 1200000016000000010000000600000098000000

    TABH+ 40(16) = 04000000F005000010000000C1248001

    store        = 0xB0775372FE070000

    ext1         = 0x0000000000000000

    shmId        = 0 (0x00000000)

    id           = 18    (0x12000000)

    label        = 22 (0x16000000)

    fill         = 1 (0x01000000)

    leng         = 6 (0x06000000)

    loop         = 152 (0x98000000)

   xtyp         = TYPE#000017

   occu         = 16 (0x10000000)

   access       = 1 (ItAccessStandard)

   idxKind      = 0 (ItIndexNone)

   uniKind      = 2 (ItUniqueNon)

   keyKind      = 1 (default)

   cmpMode      = 2 (cmpSingleMcmpR)

   occu0        = 1

   groupCntl    = 0

   rfc          = 0

   unShareable  = 0

   mightBeShared = 0

   sharedWithShmTab = 0

   isShmLockId  = 0

   gcKind       = 0

   isUsed       = 1

   isCtfyAble   = 1

>>>>> Shareable Table Header Data <<<<<

   tabi         = 0xB0CD5C72FE070000

   pgHook       = 0x0000000000000000

   idxPtr       = 0x0000000000000000

   shmTabhSet   = 0x0000000000000000

    id           = 18    (0x12000000)

    refCount     = 0 (0x00000000)

    tstRefCount  = 0 (0x00000000)

    lineAdmin    = 16 (0x10000000)

    lineAlloc    = 16 (0x10000000)

    shmVersId    = 0 (0x00000000)

    shmRefCount  = 1 (0x01000000)

>>>>> 1st level extension part <<<<<

    regHook      = Not allocated

    collHook     = Not allocated

    ext2         = Not allocated

>>>>> 2nd level extension part <<<<<

    tabhBack     = Not allocated

    delta_head   = Not allocated

    pb_func      = Not allocated

    pb_handle    = Not allocated

T000_TAB[]

    Table IT_22[1x6]

T000_TAB

    500

    333

    500

    000

    000

TABLE

TABLE

    %

222222222222222222222222222222

500000000000000000000000000000

000000000000000000000000000000

000000000000000000000000000000

DFIES[]

    Table IT_11552[70x1342]

\PROGRAM=RSSPACECHECK\FORM=GET_TABLE_SIZE\DATA=DFIES[]

    Table reference: 30

    TABH+  0(20) = F0175472FE070000A0975572FE07000000000000

    TABH+ 20(20) = 1E000000202D0000460000003E050000FFFFFFFF

    TABH+ 40(16) = 04000000400A000008000000C1048001

    store        = 0xF0175472FE070000

    ext1         = 0xA0975572FE070000

    shmId        = 0 (0x00000000)

    id           = 30    (0x1E000000)

    label        = 11552 (0x202D0000)

    fill         = 70 (0x46000000)

    leng         = 1342 (0x3E050000)

    loop         = -1 (0xFFFFFFFF)

    xtyp         = TYPE#000040

    occu         = 8 (0x08000000)

    access       = 1 (ItAccessStandard)

    idxKind      = 0 (ItIndexNone)

    uniKind      = 2 (ItUniqueNon)

    keyKind      = 1 (default)

    cmpMode      = 2 (cmpSingleMcmpR)

    occu0        = 0

    groupCntl    = 0

    rfc          = 0

    unShareable  = 0

    mightBeShared = 0

    sharedWithShmTab = 0

    isShmLockId  = 0

    gcKind       = 0

    isUsed       = 1

    isCtfyAble   = 1

>>>>> Shareable Table Header Data <<<<<

    tabi         = 0xC0900A74FE070000

    pgHook       = 0x50185472FE070000

    idxPtr       = 0x0000000000000000

    shmTabhSet   = 0x0000000000000000

    id           = 19230 (0x1E4B0000)

    refCount     = 0 (0x00000000)

    tstRefCount  = 0 (0x00000000)

    lineAdmin    = 128 (0x80000000)

    lineAlloc    = 72 (0x48000000)

    shmVersId    = 0 (0x00000000)

    shmRefCount  = 1 (0x01000000)

>>>>> 1st level extension part <<<<<

    regHook      = 0x0000000000000000

    collHook     = 0x0000000000000000

    ext2         = 0x80238273FE070000

>>>>> 2nd level extension part <<<<<

    tabhBack     = 0x40B17673FE070000

    delta_head   = 0000000000000000000000000000000000000000000000000000000000000000000000000000000

    pb_func      = 0x0000000000000000

    pb_handle    = 0x0000000000000000

DFIES

    AFFH                          MANDT                          0001000000

4444222222222222222222222222224444522222222222222222222222222333333333322222222222222222222222

166800000000000000000000000000D1E4400000000000000000000000000000100000000000000000000000000000

0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

CTAB

    MANDT                          = '500'

44445222222222222222222222222223223332

D1E4400000000000000000000000000D075007

00000000000000000000000000000000000000

00000000000000000000000000000000000000

DFIES-FIELDNAME

    MANDT

444452222222222222222222222222

    D1E440000000000000000000000000

000000000000000000000000000000

000000000000000000000000000000

SY-ULINE

----------------------------------------------------------------------------------------------

2222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222

DDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDD

0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

    0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

P_SIZETAB-TABNAME

    AFFH

444422222222222222222222222222

166800000000000000000000000000

000000000000000000000000000000

000000000000000000000000000000

%_DUMMY$$

    2222

    0000

    0000

    0000

SY-XFORM

    CONVERSION_EXIT

444545544454545222222222222222

3FE65239FEF5894000000000000000

000000000000000000000000000000

000000000000000000000000000000

NBRINS

    0

    0000

    0000

SYST-REPID

    RSSPACECHECK

5555444444442222222222222222222222222222

23301353853B0000000000000000000000000000

0000000000000000000000000000000000000000

0000000000000000000000000000000000000000

%_TABLE_%_APP_%-TEXT

    Table Name

    566662466622222222222222222222

412C50E1D500000000000000000000

000000000000000000000000000000

000000000000000000000000000000

SPACE

    2

    0

    0

    0

1. 1 Ty.          EVENT

Name START-OF-SELECTION

VRS_TAB

00000000

22222222222222222222222222222222222222222222333333332222

00000000000000000000000000000000000000000000000000000000

00000000000000000000000000000000000000000000000000000000

    00000000000000000000000000000000000000000000000000000000

VRS_TAB[]

    Table IT_23[0x112]

\PROGRAM=RSSPACECHECK\DATA=VRS_TAB[]

    Table reference: 19

    TABH+  0(20) = 0000000000000000000000000000000000000000

    TABH+ 20(20) = 13000000170000000000000070000000FFFFFFFF

    TABH+ 40(16) = 040000002006000010000000C1248001

    store        = 0x0000000000000000

    ext1         = 0x0000000000000000

    shmId        = 0 (0x00000000)

    id           = 19    (0x13000000)

    label        = 23 (0x17000000)

    fill         = 0 (0x00000000)

    leng         = 112 (0x70000000)

    loop         = -1 (0xFFFFFFFF)

    xtyp         = TYPE#000018

    occu         = 16 (0x10000000)

    access       = 1 (ItAccessStandard)

    idxKind      = 0 (ItIndexNone)

    uniKind      = 2 (ItUniqueNon)

    keyKind      = 1 (default)

    cmpMode      = 2 (cmpSingleMcmpR)

    occu0        = 1

   groupCntl    = 0

   rfc          = 0

   unShareable  = 0

   mightBeShared = 0

   sharedWithShmTab = 0

   isShmLockId = 0

   gcKind       = 0

   isUsed       = 1

   isCtfyAble   = 1

>>>>> Shareable Table Header Data <<<<<

   tabi         = Not allocated

   pghook       = Not allocated

   idxPtr       = Not allocated

   shmTabhSet   = Not allocated

   id           = Not allocated

   refCount     = Not allocated

   tstRefCount  = Not allocated

   lineAdmin    = Not allocated

   lineAlloc    = Not allocated

   shmVersId    = Not allocated

   shmRefCount  = Not allocated

   shmIsReadOnly = Not allocated

   >>>>> 1st level extension part <<<<<

   regHook      = Not allocated

    collHook     = Not allocated

    ext2         = Not allocated

>>>>> 2nd level extension part <<<<<

    tabhBack     = Not allocated

    delta_head   = Not allocated

    pb_func      = Not allocated

    pb_handle    = Not allocated

%_PRINT

        000 0###

2222333222222222222222222222222222222222222222222222222222222222222222222222222222222222223000

0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

SY

######F###############################Ծ###############################################䵘# C##>

0000004000000000000000000000000000000030000000000000000000000000000000000000108000000050240000

    00001060000000000000000010001000000000E000000000200000000000000000000000000090C000100080030300

0000000000000000000000000000000000000000000000000000000000000000000000000000000000000040000000

00000000000000000000000000000000000000500000000000000000000000000000000000000000000000D000000C

DD02L_TAB-TABNAME

    AFFH

444422222222222222222222222222

166800000000000000000000000000

000000000000000000000000000000

000000000000000000000000000000

SY-SUBRC

    0

    0000

    0000

%_SSCR

    NOCLASSA䉃#P ##CCHAR

4444455440520044445222222222222222222222222222222222222222222222222222222222222222222222222222

EF3C13313F001033812000000000000000000000000000000000000000000000000000000000000000000000000000

0000000040000000000000000000000000000000000000000000000000000000000000000000000000000000000000

0000000020000000000000000000000000000000000000000000000000000000000000000000000000000000000000

SIZETAB

    AFFH                             #####͐##########

4444222222222222222222222222222220000050000000000222222222222222222222222222222222222222

166800000000000000000000000000000000000000000000C000000000000000000000000000000000000000

0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

000000000000000000000000000000000000C030000000000000000000000000000000000000000000000000

SYST

######F###############################Ծ###############################################䵘# C##>

0000004000000000000000000000000000000030000000000000000000000000000000000000108000000050240000

00001060000000000000000010001000000000E000000000200000000000000000000000000090C000100080030300

0000000000000000000000000000000000000000000000000000000000000000000000000000000000000040000000

00000000000000000000000000000000000000500000000000000000000000000000000000000000000000D000000C

%_SPACE

    2

    0

    0

    0

T000_TAB

    500

    333

    500

    000

    000

RCOD

    0

    0000

    0000

Internal notes

    The termination was triggered in function "HandleRsqlErrors"

    of the SAP kernel, in line 786 of the module

"//bas/700_REL/src/krn/runt/absapsql.c#9".

    The internal operation just processed is "SQLS".

    Internal mode was started at 20141224173231.

    Internal call code.........: "[RSQL/COUN/AFFH ]"

Active Calls in SAP Kernel

Lines of C Stack in Kernel (Structure Differs on Each Platform)

SAP (R) - R/3(TM) Callstack, Version 1.0

Copyright (C) SAP AG. All rights reserved.

Callstack without Exception:

App       : disp+work.EXE (pid=1288)

When      : 12/24/2014 17:55:17.984

Threads   : 2

Computer Name       : NBS007

User Name           : SAPServiceNTP

Number of Processors: 2

Processor Type: EM64T Family 6 Model 42 Stepping 7

Windows Version     : 5.2 Current Build: 3790

State Dump for Thread Id 54c

FramePtr ReturnAd         Param#1          Function Name

0000000007d8b780 0000000078d7041f 0000000000303fd0 ntdll!NtWaitForSingleObject

0000000007d8b820 000000000172a631 00000000000004e8 kernel32!WaitForSingleObjectEx

0000000007d8ba70 00000000006134a5 0000000000000001 disp+work!NTDebugProcess [ntstcdbg.c (501)]

0000000007d8baa0 0000000000afeb9c 0000000000000001 disp+work!CTrcStack [dptstack.c (182)]

0000000007d8baf0 0000000000b03dc0 0000000000000001 disp+work!rabax_CStackSave [abrabax.c (7091)]

0000000007d8c4d0 0000000000a1850c 0000000001ca86e0 disp+work!ab_rabax [abrabax.c (1231)]

0000000007d8c570 00000000009eb122 000000000000007d disp+work!ab_rsqlerr [abdberr.c (787)]

0000000007d8c760 00000000009fc4a3 000000000000003b disp+work!SqlsExecuteCall [absapsql.c (7353)]

0000000007d8c810 0000000000833eb2 0000000000000000 disp+work!ab_jsqls [absapsql.c (1414)]

0000000007d8c990 0000000000a15887 0000000000000000 disp+work!ab_extri [abextri.c (554)]

0000000007d8c9e0 0000000000a16224 0000000000000000 disp+work!ab_xevent [abrunt1.c (281)]

0000000007d8ca80 0000000000b7f16c 0000000000000000 disp+work!ab_trigg [abrunt1.c (68)]

0000000007d8cb20 0000000000671c8d 000007fe725c0f1c disp+work!ab_run [absubmit.c (408)]

0000000007d8cca0 00000000006762fa 000007fe725c0f1c disp+work!dynpmcal [dymainstp.c (2284)]

0000000007d8cd40 000000000067587a 0000000000000000 disp+work!dynppai0 [dymainstp.c (1004)]

0000000007d8cdf0 00000000006341d5 0000000000000000 disp+work!dynprctl [dymainstp.c (360)]

0000000007d8fc30 00000000004d868d 000000000000000c disp+work!dynpen00 [dymain.c (1629)]

0000000007d8feb0 000000000042d706 0000000007e1ab50 disp+work!TskhLoop [thxxhead.c (4525)]

0000000007d8fee0 000000000040108d ffffffff00000003 disp+work!DpMain [dpxxdisp.c (1122)]

0000000007d8ff10 00000000019d3301 0000000000000000 disp+work!nlsui_main [thxxanf.c (84)]

0000000007d8ff70 0000000078d5965c 0000000000000000 disp+work!wmainCRTStartup [crtexe.c (498)]

0000000007d8ffa0 0000000000000000 00000000019d3190 kernel32!BaseProcessStart

State Dump for Thread Id 818

FramePtr ReturnAd         Param#1          Function Name

000000000cd5fe40 0000000078d5f611 0000000007dda1a0 ntdll!NtFsControlFile

000000000cd5feb0 00000000018b954f 0000000000000000 kernel32!ConnectNamedPipe

000000000cd5ff40 000007ff7fc411c4 0000000000000000 disp+work!SigIMsgFunc [signt.c (679)]

000000000cd5ff70 0000000078d6b66a 0000000078d6b630 msvcrt!endthreadex

000000000cd5ffa0 0000000000000000 0000000000000000 kernel32!BaseThreadStart

[Sriram2009]

Hi Patil

Thanks for you info,

You kernel release are very low, you have to upgrade the kernel either kernel 700- release 353 or 720 kernel. and then try the export

BR

SS

[Former Member]

Hi Patil,

Probably customizin data of the client has been changed during the export and it caused the error. "Nolock" word made me think this way.

Did you lock all users and suspended all jobs before you began with exporting cleint?

Regards,

Serhat