Short dump issue

[Former Member]

check sy-subrc = 0.

Gave a short dump.

Any idea why?

[Former Member]

Hi,

Show your complete related code .

Regards

vijay

[Former Member]

Short dumps are created when there is an error in the program, overflow of mathematical computations, the memory required to run the report is too big for the server, etc. You can also check your error even though it gave you a short dump. Just press debugging when the dump screen appears.

[Former Member]

My short dump screen shows the dump line on this code

"Check sy-subrc = 0"

Is there any problem in describing this sentence?

Before this statement i am running a select statement.

[Former Member]

Runtime Error DBIF_RSQL_SQL_ERROR

Exception CX_SY_OPEN_SQL_DB

Occurred on 22.08.2006 at 14:43:12

-

-

---

An SQL error occurred when accessing a table.

-

-

---

What happened?

-

-

---

-

-

---

What can you do?

-

-

---

Make a note of the actions and input which caused the error.

To resolve the problem, contact your SAP system administrator.

You can use transaction ST22 (ABAP Dump Analysis) to view and administer

termination messages, especially those beyond their normal deletion

date.

-

-

---

Error analysis

-

-

---

An exception occurred. This exception will be dealt with in more detail

below. The exception, assigned to the class 'CX_SY_OPEN_SQL_DB', was not

caught, which

led to a runtime error. The reason for this exception is:

-

-

---

How to correct the error

-

-

---

Database error text........: "ORA-01555: snapshot too old: rollback segment

number 39 with name "PRS_BIG18" too small"

Internal call code.........: "[RSQL/FTCH/MSEG ]"

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_RSQL_SQL_ERROR" CX_SY_OPEN_SQL_DBC

"ZSMR0016_ALL " or "ZSMR0016_ALL "

"START-OF-SELECTION"

-

-

---

If you cannot solve the problem yourself, please send the

following documents to SAP:

1. A hard copy print describing the problem.

To obtain this, select the "Print" function on the current screen.

-

-

---

2. A suitable hardcopy prinout of the system log.

To obtain this, call the system log with Transaction SM21

and select the "Print" function to print out the relevant

part.

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

supply the source code.

To do this, you can either use the "PRINT" command in the editor or

print the programs using the report RSINCL00.

4. Details regarding the conditions under which the error occurred

or which actions and input led to the error.

-

-

---

System environment

-

-

---

SAP Release.............. "620"

Application server....... "vms1prd3"

Network address.......... "192.168.11.74"

Operating system......... "HP-UX"

Release.................. "B.11.00"

Hardware type............ "9000/800"

Character length......... 8 Bits

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

Work process number...... 11

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

Database server.......... "vms1prd2"

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

Database name............ "PRD"

Database owner........... "SAPR3"

Character set............ "en_US.iso88591"

SAP kernel............... "620"

Created on............... "Jun 26 2005 21:21:08"

Created in............... "HP-UX B.11.00 U 9000/800"

Database version......... "OCI_817_64 "

Patch level.............. "1945"

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

Supported environment....

Database................. "ORACLE 8.1.7.., ORACLE 9.2.0.."

SAP database version..... "620"

Operating system......... "HP-UX B.11"

-

-

---

User, transaction...

-

-

---

Client.............. 800

User................ "DHOR"

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

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

Program............. "ZSMR0016_ALL "

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

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

-

-

---

Information on where terminated

-

-

---

The termination occurred in the ABAP program "ZSMR0016_ALL " in

"START-OF-SELECTION".

The main program was "ZSMR0016_ALL ".

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

program "ZSMR0016_ALL "

of the source code of program "ZSMR0016_ALL " (when calling the editor 900).

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

-

-

---

Source code extract

-

-

---

000600 DATA:

000610 unitp TYPE unitcost, " Unit Price

000620 netamt LIKE mseg-dmbtr.

000630

000640 *----

---

Selection Screen----

---

000650 SELECTION-SCREEN BEGIN OF BLOCK frame1 WITH FRAME.

000660 PARAMETERS: werks1 LIKE mseg-werks OBLIGATORY MEMORY ID wrk.

000670

000680 SELECT-OPTIONS:

000690 budat1 FOR mkpf-budat OBLIGATORY DEFAULT sy-datum,

000700 mblnr1 FOR mkpf-mblnr,

000710 matnr1 FOR mseg-matnr,

000720 slbwart FOR mseg-bwart,

000730 sllgort FOR mseg-lgort.

000740 SELECTION-SCREEN END OF BLOCK frame1.

000750

000760 START-OF-SELECTION.

000770 * Fetch Material Document Data

000780 SELECT mkpf_{budat mseg}mblnr mseg_{zeile mseg}bwart mseg~matnr

000790 mseg_{werks mseg}lgort mseg_{dmbtr mseg}bwtar mseg~menge

000800 mseg~lifnr INTO TABLE itab

000810 FROM mseg JOIN mkpf ON ( mkpf_{mblnr = mseg}mblnr )

000820 WHERE mseg~mblnr IN mblnr1

000830 AND mkpf~budat IN budat1

000840 AND mseg~werks = werks1

000850 AND mseg~matnr IN matnr1

000860 AND mseg~bwart IN slbwart

000870 AND mseg~xauto = space

000880 AND mseg~lgort IN sllgort.

000890

-

-

---

CHECK sy-subrc = 0.

000910

000920 SET PF-STATUS 'TOOL'.

000930

000940 PERFORM make_report.

000950

000960 PERFORM write_report.

000970

000980

000990 *----

---

001000 * FORM make_report *

001010 *----

---

001020 * ........ *

001030 *----

---

001040 FORM make_report.

001050 DATA: BEGIN OF imara OCCURS 0,

001060 matnr LIKE mara-matnr,

001070 matkl LIKE mara-matkl, "Material Group

001080 END OF imara.

001090

-

-

---

Contents of system fields

-

-

---

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

-

-

---

-

-

---

-

-

---

-

-

---

SY-SUBRC 0 SY-INDEX 0

SY-TABIX 1 SY-DBCNT 1

SY-FDPOS 0 SY-LSIND 0

SY-PAGNO 0 SY-LINNO 1

SY-COLNO 1 SY-PFKEY

SY-UCOMM

SY-TITLE Value Of Material documents (Standard Price)

SY-MSGTY I SY-MSGID SF

SY-MSGNO 616 SY-MSGV1 ZSMR0016_ALL

SY-MSGV2 RE SY-MSGV3 EN

SY-MSGV4

-

-

---

Active calls / events

-

-

---

No.... Type........ Name..........................

Program

Include Line

Class

-

-

---

1 EVENT START-OF-SELECTION

ZSMR0016_ALL

ZSMR0016_ALL 90

-

-

---

Chosen variables

-

-

---

-

-

---

1 EVENT START-OF-SELECTION

ZSMR0016_ALL

ZSMR0016_ALL 90

-

-

---

%_DUMMY$$

2222

0000

MBLNR1[] Table IT_37[0x23]

000000000000000000010002000000010000FFFF

0000000000000000000D0005000000070000FFFF

... + 40

0000000600290000

400000A00A400000

BUDAT1[] Table IT_12[1x19]

800002910000000000000000000000010000FFFF

00012D0800000000000A000C000100030000FFFF

... + 40

0000000B00290000

400000980A404000

SY ########################################

0000000000000000000000000000000000000000

0000000000010000000000000000000000000000

... + 40 ###############A#######ÿ###############ÿ

00000000000000040000000F000000000000000F

00010000000100010001000F000000000000000F

... + 80 ########################################

0000000000000000000000000000000000000000

0000000000000000000400000000000000000000

... + 120 #######################################T

0000000000000000000000000000000000010005

0000000000000000000000000000000000060004

... + 160 ##############p# C############# E0X X1

0000000000000078240000000000000222435253

0000000400000000030020000C0000C000508081

... + 200 000 N ####__S 800

3332222222420000555222222222222222223332

0000000000E00000FF3000000000000000008000

... + 240 80 X

222223325222222

000008008000000

WERKS1 1400

3333

1400

SYST ########################################

0000000000000000000000000000000000000000

0000000000010000000000000000000000000000

... + 40 ###############A#######ÿ###############ÿ

00000000000000040000000F000000000000000F

00010000000100010001000F000000000000000F

... + 80 ########################################

0000000000000000000000000000000000000000

0000000000000000000400000000000000000000

... + 120 #######################################T

0000000000000000000000000000000000010005

0000000000000000000000000000000000060004

... + 160 ##############p# C############# E0X X1

0000000000000078240000000000000222435253

0000000400000000030020000C0000C000508081

... + 200 000 N ####__S 800

3332222222420000555222222222222222223332

0000000000E00000FF3000000000000000008000

... + 240 80 X

222223325222222

000008008000000

VARI 800VAZSMR0016_ALL

3335455453333544422222222222222222222222

80061A3D20016F1CC00000000000000000000000

... + 40 &0000000000569 ####00000000000000

2222223333333333333200003333333333333322

0000060000000000569000000000000000000000

... + 80 #ó########1100####[########>#-##Q#^s

22220F0000008033330000500011901302005157

0000030611220011000000B2002FD24E6D8210E3

... + 120 ©,è##¯Þ#N»VÞ×##¬L#ÿcP¿ ó¯åÛ·FÄ#æ0#ò#o´g¬

A2E90AD84B5DD99A40F65B2FAEDB4C8E32F96B6A

9C807FE4EB6E720CCDF30F03F5B764B6032CF47C

... + 160 Ó#lÄ##Y¶;#Õ#Ï®ú##1Àà&îxòdXg=à!MÎu.#ß©im}

D16C095B31D0CAF983CE2E7F6563E24C728DA667

34C48596B55DFEAD51006E82487D01DE5E5F99DD

... + 200 á#ý`ŵêY#ŲM Ë##Ôi#Ó±ÂH~##°!#tPÕ±###(ÐÜ#

E8F6CBE50CB42C01D69DBC4790B2275DB9002DD0

10D055A9E52D0B164963128E02013405108A80C4

... + 240 ###A###é&WÉÂÿ§~

8004900E25CCFA7

2201B6596792F7E

MATNR1[] Table IT_36[1x39]

800003CF0000000000010002000000020000FFFF

0001233000000000000C0004000100070000FFFF

... + 40

0000000000290000

400000B801400000

%_SSCR %B%_F000##BGK #### FRAME1

2425433300444222000022222454443222222222

525F60000F27B000000000000621D51000000000

... + 40

2222222222222222222222222222222222222222

0000000000000000000000000000000000000000

... + 80

2222222222222222222222222222222222222222

0000000000000000000000000000000000000000

... + 120

2222222222222222222222222222222222222222

0000000000000000000000000000000000000000

... + 160 E ########

2222222222222222222222222222422200000000

0000000000000000000000000000500000000000

... + 200

2222222222222222222222222222222222222222

0000000000000000000000000000000000000000

... + 240

222222222222222

000000000000000

SLBWART[] Table IT_35[1x9]

800003BF0000000000010002000000000000FFFF

000123E800000000000B0003000100090000FFFF

... + 40

0000000700290000

400000B801400000

SPACE

2

0

MAKT

2222222222222222222222222222222222222222

0000000000000000000000000000000000000000

... + 40

2222222222222222222222222222222222222222

0000000000000000000000000000000000000000

... + 80

2222222222222222222222

0000000000000000000000

RSJOBINFO 00000000

2222222222222222222222222222222233333333

0000000000000000000000000000000000000000

... + 40 000000

3333332222222222222222222222222222222222

0000000000000000000000000000000000000000

... + 80 ####

0000

0000

SLLGORT[] Table IT_34[1x11]

800003B00000000000010002000000000000FFFF

000123A800000000000800020001000B0000FFFF

... + 40

0000000E00290000

400000B801400000

MBLNR1-LOW

2222222222

0000000000

ITAB[] Table IT_56[53474x85]

8000037E000000000001000300DE00050000FFFF

00012AC00000000000030008000200050000FFFF

... + 40

0000000C012B0000

40000058004C0000

SY-SUBRC 0

0000

0000

-

-

---

Application Calls

-

-

---

No dump information available

-

-

---

Application Information

-

-

---

No dump information available

-

-

---

Internal notes

-

-

---

The termination occurred in the function "HandleRsqlErrors" of the SAP

Basis System, specifically in line 738 of the module

"//bas/620/src/krn/runt/absapsql.c#41".

The internal operation just processed is "cmpr".

The internal session was started at 20060822100150.

Internal call code.........: "[RSQL/FTCH/MSEG ]"

-

-

---

Active calls in SAP kernel

-

-

---

( 0) 0x4000000000bec4fc CTrcStack2 + 0x2bc

( 1) 0x4000000000bec230 CTrcStack + 0x18

( 2) 0x4000000001929860 rabax_CStackSave__Fv + 0xf0

( 3) 0x4000000001934304 ab_rabax + 0x7fc

( 4) 0x40000000017ff608 ab_rsqlerr__FPCciT1P11RS_HEADER94T1Pv >

> + 0x220

( 5) 0x400000000181b240 HandleRsqlErrors__F9RsqlError9CloseMode >

> + 0x2c0

( 6) 0x4000000001475698 SqlsExecuteCall__FUcP11DynCallInfo + 0xc98

( 7) 0x4000000001471080 ab_jsqls__Fv + 0x98

( 😎 0x4000000001490c44 ab_extri__Fv + 0x1cc

( 9) 0x40000000015dacf0 ab_xevent__FPCc + 0x1a0

(10) 0x40000000016b27c4 ab_trigg__Fv + 0x174

(11) 0x40000000016b2454 ab_run + 0xd4

(12) 0x40000000010e1424 N_ab_run + 0x14

(13) 0x40000000010dbc7c dynpmcal + 0x18c

(14) 0x40000000010d9828 dynppai0 + 0x898

(15) 0x40000000010d7b70 dynprctl + 0x428

(16) 0x40000000010d3094 dynpen00 + 0x1ec4

(17) 0x4000000000f6b9f8 Thdynpen00 + 0x670

(18) 0x4000000000f69b78 TskhLoop + 0x2f60

(19) 0x4000000000f612b8 tskhstart + 0x180

(20) 0x400000000158d088 DpMain + 0x4a8

(21) 0x4000000001763f1c main + 0x14

(22) 0xc00000000002bbc0 $START$ + 0xa0

-

-

---

List of ABAP programs affected

-

-

---

Type Program Gen. Date Time Load Size

Prg ZSMR0016_ALL 13.09.2003 22:43:41 41984

Prg SAPMSSY0 08.01.2006 11:31:12 62464

Prg SAPMSSYD 05.06.2002 17:09:33 16384

Prg SAPFSYSCALLS 14.02.2002 14:22:47 6144

Prg RSDBRUNT 07.08.2005 20:01:04 220160

Prg SAPLSPRI 08.01.2006 13:13:59 268288

Typ PRI_PARAMS 02.11.1998 09:46:12 4096

Typ ARC_PARAMS 28.08.1997 08:36:28 4096

Typ PRIPAR_EXT 09.11.2000 14:10:39 3072

Typ PRIPAR_EX2 09.11.2000 14:10:39 2048

Typ PRIPAR_EX3 30.08.2001 17:57:21 2048

Typ PRI_LAYOUT 30.08.2001 17:57:21 3072

Typ USR01 14.02.1998 15:22:01 3072

Prg SAPLSPOO 08.01.2006 12:48:31 120832

Typ TSP1D 15.11.2000 17:58:02 5120

Prg SAPLRSPOLSTDRV 08.01.2006 12:48:30 48128

Typ TSPOPTIONS 29.01.1997 19:13:56 2048

Typ TSP03 02.11.1998 09:57:05 4096

Typ TSP0A 15.11.2000 17:58:02 5120

Typ TSP03C 13.05.2004 12:07:39 6144

Typ TSP03T 23.03.1998 18:21:38 5120

Typ TSP06A 15.11.2000 17:58:02 5120

Prg SAPCNVE 14.02.2002 14:22:47 6144

Prg SAPLSPOC 08.01.2006 13:13:03 124928

Typ TSP03L 10.07.1997 00:46:18 1024

Typ TSP03A 10.07.1997 00:46:15 2048

Prg SAPLSPOR 08.01.2006 13:13:59 31744

Prg SAPLSDEX 08.01.2006 11:48:59 19456

Typ DD07T 12.05.1997 16:45:51 2048

Typ DEVPAR 04.12.2000 12:46:11 3072

Typ RSSCR . . : m:15 4096

Prg RSDBSPBL 07.01.2003 18:47:02 58368

Prg SAPDB__S 14.02.2002 14:22:47 16384

Typ VARID 12.05.1997 16:51:30 4096

Prg %_CSYDB0 14.02.2002 14:22:46 28672

Prg RSDBSPVA 08.01.2006 12:49:07 108544

Prg RSDBSPDD 08.01.2006 13:11:36 30720

Typ RSCONVERT 09.11.2000 14:11:21 3072

Prg CONTEXT_X_FREE_SEL_DD_INFO 08.01.2006 13:11:34 54272

Typ TCONT 29.07.1998 19:46:10 2048

Typ RSCONVERT 09.11.2000 14:11:21 3072

Prg SAPLSSELSERVICE 07.01.2003 18:31:25 20480

Prg CL_ABAP_CHAR_UTILITIES========CP 08.01.2006 09:57:54 11264

Typ TUVID 10.07.1997 00:46:43 1024

Typ DD01L 13.05.2004 12:01:05 4096

Prg SAPLSVAR 08.01.2006 13:14:04 608256

Typ VARIS 12.05.1997 15:27:21 2048

Typ RSVAMEMKEY 07.05.1997 13:07:49 2048

Prg RSDBSPMC 05.06.2002 17:09:26 66560

Typ DDSHDESCR 03.09.1997 03:05:16 3072

Typ SPPARAMS 07.05.1997 13:10:38 1024

Prg SAPLICON 13.05.2004 16:05:03 23552

Prg %_CICON 14.02.2002 14:22:46 57344

Prg SAPLSABE 14.02.2002 14:22:47 11264

Prg SAPLSECU 08.01.2006 12:26:48 63488

Prg RSDBSPVD 08.01.2006 09:59:31 73728

Typ RSDSFIELDS 20.08.1998 10:57:22 2048

Prg %_CRSDS 14.02.2002 14:22:46 8192

Typ RSDSEXPR 20.08.1998 10:57:18 2048

Prg SAPLSSEL 08.01.2006 13:11:43 955392

Typ RSCONVERT 09.11.2000 14:11:21 3072

Prg RSDBSPDS 05.06.2002 17:09:26 46080

Prg SAPLDSYA 14.02.2002 14:22:47 38912

Prg SAPFSDS1 07.01.2003 18:32:17 46080

Typ TDCLD 02.11.1998 09:51:35 4096

Prg SAPLSDOD 08.01.2006 11:35:20 38912

Typ DOKIL 12.05.1997 16:46:17 2048

Prg SAPLLANG 14.02.2002 14:22:47 8192

Typ T002 14.02.1998 10:24:58 2048

Typ RSEXFCODE 13.08.1997 12:52:57 1024

Prg RSDYNSS0 08.01.2006 13:04:32 44032

Typ ICONT 14.02.1998 07:48:14 2048

Typ RSPARINT 10.04.1995 09:58:38 1024

Typ RSSELINT 04.04.1995 16:12:37 2048

Prg SAPLOMCV 08.01.2006 09:45:20 16384

Prg CL_EXITHANDLER================CP 08.01.2006 13:12:29 25600

Prg SAPLSEXV 08.01.2006 13:11:43 105472

Prg CL_BADI_FLT_DATA_TRANS_AND_DB=CP 08.01.2006 13:12:29 32768

Typ SXS_ATTR 20.08.2001 12:23:27 3072

Typ V_EXT_ACT 09.11.2000 14:27:05 2048

Typ SXC_EXIT 09.11.2000 14:23:43 2048

Prg CL_EX_BADI_MATN1==============CP 08.01.2006 09:45:06 22528

Typ TMCNV 24.02.1999 03:33:25 3072

Prg SAPLSTUP 08.01.2006 13:12:33 62464

Prg SAPLCNDP 08.01.2006 13:12:27 156672

Prg SAPFGUICNTL 09.01.2003 17:18:52 20480

Prg SAPLOLEA 08.01.2006 12:26:40 77824

Prg SAPLSGUI 09.01.2003 17:15:12 30720

Prg SAPLSTTM 08.01.2006 11:49:44 73728

Prg SAPLSBDC 08.01.2006 12:40:31 37888

Prg SAPLSFES 08.01.2006 13:13:55 181248

Prg SAPLURFC 08.01.2006 11:50:24 17408

Prg SAPLSPLUGIN 14.02.2002 14:22:48 6144

Prg SAPLSCNT 14.02.2002 14:22:47 22528

Prg SAPSHDTV 13.05.2004 15:25:19 27648

Typ SSCRTEXTS 03.09.1997 03:12:33 2048

Typ SSCRFIELDS 13.05.1997 12:54:26 3072

Typ MSEG 14.05.2004 17:26:45 26624

Typ MKPF 14.05.2004 17:28:06 5120

Prg CX_SY_OPEN_SQL_DB=============CP 14.02.2002 14:22:47 9216

Typ SCX_SRCPOS 09.11.2000 14:12:15 1024

Prg CX_SY_OPEN_SQL_ERROR==========CP 14.02.2002 14:22:47 8192

Prg CX_SY_SQL_ERROR===============CP 14.02.2002 14:22:47 8192

Prg CX_DYNAMIC_CHECK==============CP 14.02.2002 14:22:47 8192

Prg CX_ROOT=======================CP 14.02.2002 14:22:47 9216

Prg CX_NO_CHECK===================CP 14.02.2002 14:22:47 8192

Typ SYST 04.12.2000 14:54:51 24576

-

-

---

List of internal tables

-

-

---

PROGRAM=ZSMR0016_ALLDATA=MBLNR1[]

TABH+ 0(20) = 000000000000000000000000000000000000001D

TABH+ 20(20) = 00000025000000000000001700000000FFFFFFFF

TABH+ 40(16) = 0400000000000A60000A249000000000

store = 0x0000000000000000

ext1 = 0x0000000000000000

id = 29 (0x0000001D)

label = 37 (0x00000025)

fill = 0 (0x00000000)

leng = 23 (0x00000017)

lopc = 0 (0x00000000)

loop = -1 (0xFFFFFFFF)

xtyp = TYPE#000038

occu = 10 (0x0000000A)

access = 1 (ItAccessStandard)

idxKind = 0 (ItIndexNone)

uniKind = 2 (ItUniqueNon)

keyKind = 1 (default)

cmpMode = 2 (cmpSingleMcmpR)

occu0 = 0

collHash = 0

lock = 0

shrd = 0

visited = 0

unShareable = 0

wasShared = 0

iterIsValid = 0

isShareable = 0

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

tabi = Not allocated

pghook = Not allocated

idxPtr = Not allocated

refCount = Not allocated

tstRefCount = Not allocated

lineAdmin = Not allocated

lineAlloc = Not allocated

store_id = Not allocated

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

regHook = Not allocated

hsdir = Not allocated

ext2 = Not allocated

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

tabhBack = Not allocated

delta_head = Not allocated

PROGRAM=ZSMR0016_ALLDATA=BUDAT1[]

TABH+ 0(20) = 80000001022D901800000000000000000000000A

TABH+ 20(20) = 0000000C000000010000001300000000FFFFFFFF

TABH+ 40(16) = 04000000000009B8000A249004000000

store = 0x80000001022D9018

ext1 = 0x0000000000000000

id = 10 (0x0000000A)

label = 12 (0x0000000C)

fill = 1 (0x00000001)

leng = 19 (0x00000013)

lopc = 0 (0x00000000)

loop = -1 (0xFFFFFFFF)

xtyp = TYPE#000035

occu = 10 (0x0000000A)

access = 1 (ItAccessStandard)

idxKind = 0 (ItIndexNone)

uniKind = 2 (ItUniqueNon)

keyKind = 1 (default)

cmpMode = 2 (cmpSingleMcmpR)

occu0 = 0

collHash = 0

lock = 0

shrd = 0

visited = 0

unShareable = 0

wasShared = 0

iterIsValid = 0

isShareable = 1

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

tabi = 0x80000001022D8F40

pghook = 0x0000000000000000

idxPtr = 0x0000000000000000

refCount = 0 (0x00000000)

tstRefCount = 0 (0x00000000)

lineAdmin = 10 (0x0000000A)

lineAlloc = 10 (0x0000000A)

store_id = 10 (0x0000000A)

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

regHook = Not allocated

hsdir = Not allocated

ext2 = Not allocated

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

tabhBack = Not allocated

delta_head = Not allocated

PROGRAM=ZSMR0016_ALLDATA=MATNR1[]

TABH+ 0(20) = 800000010233C3F000000000000000000000001C

TABH+ 20(20) = 00000024000000010000002700000000FFFFFFFF

TABH+ 40(16) = 0400000000000B080001249000000000

store = 0x800000010233C3F0

ext1 = 0x0000000000000000

id = 28 (0x0000001C)

label = 36 (0x00000024)

fill = 1 (0x00000001)

leng = 39 (0x00000027)

lopc = 0 (0x00000000)

loop = -1 (0xFFFFFFFF)

xtyp = TYPE#000041

occu = 1 (0x00000001)

access = 1 (ItAccessStandard)

idxKind = 0 (ItIndexNone)

uniKind = 2 (ItUniqueNon)

keyKind = 1 (default)

cmpMode = 2 (cmpSingleMcmpR)

occu0 = 0

collHash = 0

lock = 0

shrd = 0

visited = 0

unShareable = 0

wasShared = 0

iterIsValid = 0

isShareable = 0

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

tabi = 0x800000010233C3B0

pghook = 0x0000000000000000

idxPtr = 0x0000000000000000

refCount = 0 (0x00000000)

tstRefCount = 0 (0x00000000)

lineAdmin = 1 (0x00000001)

lineAlloc = 1 (0x00000001)

store_id = 28 (0x0000001C)

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

regHook = Not allocated

hsdir = Not allocated

ext2 = Not allocated

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

tabhBack = Not allocated

delta_head = Not allocated

PROGRAM=ZSMR0016_ALLDATA=SLBWART[]

TABH+ 0(20) = 800000010233BEF800000000000000000000001B

TABH+ 20(20) = 00000023000000010000000900000000FFFFFFFF

TABH+ 40(16) = 0400000000000B780001249000000000

store = 0x800000010233BEF8

ext1 = 0x0000000000000000

id = 27 (0x0000001B)

label = 35 (0x00000023)

fill = 1 (0x00000001)

leng = 9 (0x00000009)

lopc = 0 (0x00000000)

loop = -1 (0xFFFFFFFF)

xtyp = TYPE#000043

occu = 1 (0x00000001)

access = 1 (ItAccessStandard)

idxKind = 0 (ItIndexNone)

uniKind = 2 (ItUniqueNon)

keyKind = 1 (default)

cmpMode = 2 (cmpSingleMcmpR)

occu0 = 0

collHash = 0

lock = 0

shrd = 0

visited = 0

unShareable = 0

wasShared = 0

iterIsValid = 0

isShareable = 0

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

tabi = 0x800000010233BEC0

pghook = 0x0000000000000000

idxPtr = 0x0000000000000000

refCount = 0 (0x00000000)

tstRefCount = 0 (0x00000000)

lineAdmin = 1 (0x00000001)

lineAlloc = 1 (0x00000001)

store_id = 27 (0x0000001B)

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

regHook = Not allocated

hsdir = Not allocated

ext2 = Not allocated

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

tabhBack = Not allocated

delta_head = Not allocated

PROGRAM=ZSMR0016_ALLDATA=SLLGORT[]

TABH+ 0(20) = 800000010233BA08000000000000000000000018

TABH+ 20(20) = 00000022000000010000000B00000000FFFFFFFF

TABH+ 40(16) = 0400000000000BE80001249000000000

store = 0x800000010233BA08

ext1 = 0x0000000000000000

id = 24 (0x00000018)

label = 34 (0x00000022)

fill = 1 (0x00000001)

leng = 11 (0x0000000B)

lopc = 0 (0x00000000)

loop = -1 (0xFFFFFFFF)

xtyp = TYPE#000045

occu = 1 (0x00000001)

access = 1 (ItAccessStandard)

idxKind = 0 (ItIndexNone)

uniKind = 2 (ItUniqueNon)

keyKind = 1 (default)

cmpMode = 2 (cmpSingleMcmpR)

occu0 = 0

collHash = 0

lock = 0

shrd = 0

visited = 0

unShareable = 0

wasShared = 0

iterIsValid = 0

isShareable = 0

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

tabi = 0x800000010230A918

pghook = 0x0000000000000000

idxPtr = 0x0000000000000000

refCount = 0 (0x00000000)

tstRefCount = 0 (0x00000000)

lineAdmin = 1 (0x00000001)

lineAlloc = 1 (0x00000001)

store_id = 26 (0x0000001A)

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

regHook = Not allocated

hsdir = Not allocated

ext2 = Not allocated

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

tabhBack = Not allocated

delta_head = Not allocated

PROGRAM=ZSMR0016_ALLDATA=ITAB[]

TABH+ 0(20) = 80000001023A7CE0000000000000000000000013

TABH+ 20(20) = 000000380000D0E20000005500000000FFFFFFFF

TABH+ 40(16) = 04000000000005C8001024BC00000000

store = 0x80000001023A7CE0

ext1 = 0x0000000000000000

id = 19 (0x00000013)

label = 56 (0x00000038)

fill = 53474 (0x0000D0E2)

leng = 85 (0x00000055)

lopc = 0 (0x00000000)

loop = -1 (0xFFFFFFFF)

xtyp = TYPE#000017

occu = 16 (0x00000010)

access = 1 (ItAccessStandard)

idxKind = 0 (ItIndexNone)

uniKind = 2 (ItUniqueNon)

keyKind = 1 (default)

cmpMode = 7 (cmpManyEq)

occu0 = 1

collHash = 0

lock = 0

shrd = 0

visited = 0

unShareable = 0

wasShared = 0

iterIsValid = 0

isShareable = 0

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

tabi = 0x80000001022B9210

pghook = 0x800000010228F0C8

idxPtr = 0x0000000000000000

refCount = 0 (0x00000000)

tstRefCount = 0 (0x00000000)

lineAdmin = 69552 (0x00010FB0)

lineAlloc = 53552 (0x0000D130)

store_id = 39 (0x00000027)

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

regHook = Not allocated

hsdir = Not allocated

ext2 = Not allocated

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

tabhBack = Not allocated

delta_head = Not allocated

-

-

---

Directory of Application Tables

-

-

---

Program

Name................ Contents....1........2........3........4........5....+....

-

-

---

ZSMR0016_ALL

SYST |00000000000x010000000000000000

RSJOBINFO | 00000000000000

VARI |800VAZSMR0016_ALL &000000000056

MAKT |

SSCRFIELDS |

SSCRTEXTS |

RSDBRUNT

TUVID |800WRK |

RSVUVINT | |

VARID | ZSMR0016_ALL

SAPLSPRI

TSP03 |JB01 ZPOST2 U 00

USR01 |800DHOR LOCL GD1X

PRI_PARAMS |JB01001DHOR_SAP_RPT

ARC_PARAMS |

TPRI_DEF |800GV20 0000000x06x01x01x02x02x80

TSP1D | 0000000000

SAPLSPOO

TSP03 |JB01 ZPOST2 U 00

TSP03C |JB01 0 000000 0000Production Spool NPI

TSP1D |Z_65_1023 ANY .L0102300065JCHEW 2004060316

SAPLRSPOLSTDRV

TSP0A |ZPOST2 XPOST00192PS lv.2 ISO Latin1 R4.5A+ONLY!1117111711

TSP03 |JB01 ZPOST2 U 00

TSP03C |JB01 0 000000 0000Production Spool NPI

TSP03T |JB01

TSPOPTIONS |

SAPLSPOC

TSP03L |JB-LJ5000-1 JB01|

SAPLSPOR

TSP03 |JB01 ZPOST2 U 00

TSP03L |JB-LJ5000-1 JB01|

SAPLSDEX

DD07T |RSPOARCHTY EA00010000Print

CONTEXT_X_FREE_SEL_DD_INFO

CONTEXTB |800IBFREE_SEL_DD_INFO 000005000120060822100000 000

TCONT |FREE_SEL_DD_INFO 00000000000000|

SAPLSSELSERVICE

DFIES |MSEG BWART

SAPLSVAR

VARIS |800ZSMR0016_ALL 1000ACAEAGAQ RS

SAPLICON

ICONT |E@28@Select: Include pattern

SAPFSDS1

TDCLD |RE DOKU 8R XX XXLIMUDOKUX x1E0XR3TRPROGX |

SAPLSDOD

DOKIL |

SAPLLANG

T002 |ES1EN|

SAPLOMCV

TMCNV |800MATCONV 0x120000000x12

-

-

---

Directory of Application Tables (Administrative Information)

-

-

---

Program

Name.......................... Time.......... Length...

-

-

---

SAPLOMCV

SYST 20060108123823 00002404

RSJOBINFO 00000084

VARI 00002972

MAKT 00000102

SSCRFIELDS 20000323224119 00000854

SSCRTEXTS 00000371

RSDBRUNT

TUVID 00000023

RSVUVINT 00000047

VARID 00000132

SAPLSPRI

TSP03 00000240

USR01 00000110

PRI_PARAMS 00000196

ARC_PARAMS 00000332

TPRI_DEF 00002912

TSP1D 00000168

SAPLSPOO

TSP03 00000240

TSP03C 00000192

TSP1D 00000168

SAPLRSPOLSTDRV

TSP0A 00000194

TSP03 00000240

TSP03C 00000192

TSP03T 00000211

TSPOPTIONS 00000216

SAPLSPOC

TSP03L 00000034

SAPLSPOR

TSP03 00000240

TSP03L 00000034

SAPLSDEX

DD07T 00000130

CONTEXT_X_FREE_SEL_DD_INFO

CONTEXTB 00002944

TCONT 00000034

SAPLSSELSERVICE

DFIES 20010223091005 00000669

SAPLSVAR

VARIS 00000061

SAPLICON

ICONT 00000065

SAPFSDS1

TDCLD 00000050

SAPLSDOD

DOKIL 00000076

SAPLLANG

T002 00000005

SAPLOMCV

TMCNV 00000062

-

-

---

ABAP control blocks CONT

-

-

---

Include Line source code

Index Name F1 Co Par01 Par2. Par3. Par4. Tabl

-

-

---

-

-

---

-- -- -

-

---

-

-

---

-

-

---

-

-

---

-

-

---

-

-

---

ZSMR0016_ALL 78 SELECT mkpf_{budat mseg}mblnr m

174 WHER 13 9 28

176 PAR1 84 56

177 WHER 13 7 27

179 PAR1 84 61

180 WHER 20 8 35

182 PAR1 80 73

183 WHER 13 11 30

185 PAR1 84 66

186 SQLS 39

187 SQLS 39 55

188 SQLS 3B

189 SQLS 0C 38

ZSMR0016_ALL 90 CHECK sy-subrc = 0.

>>>>> cmpr 00 02 74

192 REJE 1D

ZSMR0016_ALL 92 SET PF-STATUS 'TOOL'.

193 SCUA 01 75

ZSMR0016_ALL 94 PERFORM make_report.

194 perf 00 10

195 PERP 80

ZSMR0016_ALL 96 PERFORM write_report.

196 perf 00 11

197 PERP 80

198 -

-

---

-

-

---

End of runtime analysis

-

-

---

[Former Member]

check..

if it is not work plz paste ur internal table too..

SELECT mkpf_{budat mseg}mblnr mseg_{zeile mseg}bwart mseg~matnr

mseg_{werks mseg}lgort mseg_{dmbtr mseg}bwtar mseg~menge

mseg~lifnr INTO <b>corresponding fields of</b> TABLE itab

[Former Member]

Hi,

it is not because of sy-subrc check , it is because of SQL(select problem). the select is taking too much time.

Regards

vijay

[Former Member]

Hey,

You have used "INTO TABLE" keyword in the select statement. Does the field sequence in the select statement match the field sequence in the internal table definition. If not use "INTO CORRESPONDING FIELDS OF TABLE" in the select statement OR match the field sequence of the select statement to the internal table definition.

-Kiran

*Please reward useful answers

[Former Member]

Hi,

U can just replace the check statemnt, and use If statment instant of check.

[Former Member]

will that really make a difference?

can u explain how?

[Former Member]

I think Vijay is correct. When I've seen this error:

Database error text........: "ORA-01555: snapshot too old: rollback segment 
number 39 with name "PRS_BIG18" too small" 

It's because the statement has taken too long to execute. Users are updating the tables you are selecting from and the rollbacke segment is out of date. You can get around this by running the program when users are off the system (ie - overnight).

Rob

[Former Member]

not check ,

1.try like this

if sy-subrc eq 0.

else.

message.

endif.

2. if r_mblnr1[] is not initial.

select data.

endif.

Regards

Prabhu

[Former Member]

hi S Kantheri,

just a suggestion :

can you check whether "itab" has the same structure with the same order / sequence as in SQL statement ?

1. mkpf~budat

2. mseg~mblnr

3. mseg~zeile

4. mseg~bwart

5. mseg~matnr

6. mseg~werks

7. mseg~lgort

8. mseg~dmbtr

9. mseg~bwtar

10. mseg~menge

11. mseg~lifnr

thanks.

[Former Member]

internal table str is

DATA: BEGIN OF itab OCCURS 0,

budat LIKE mkpf-budat,

mblnr LIKE mseg-mblnr,

zeile LIKE mseg-zeile,

bwart LIKE mseg-bwart,

matnr LIKE mseg-matnr,

werks LIKE mseg-werks,

lgort LIKE mseg-lgort,

dmbtr LIKE mseg-dmbtr,

bwtar LIKE mseg-bwtar,

menge LIKE mseg-menge,

END OF itab.

[Former Member]

DATA: BEGIN OF itab OCCURS 0,

budat LIKE mkpf-budat,

mblnr LIKE mseg-mblnr,

zeile LIKE mseg-zeile,

bwart LIKE mseg-bwart,

matnr LIKE mseg-matnr,

werks LIKE mseg-werks,

lgort LIKE mseg-lgort,

dmbtr LIKE mseg-dmbtr,

bwtar LIKE mseg-bwtar,

menge LIKE mseg-menge,

<b>lfnr type lifnr,</b>--->missing

END OF itab.

[Former Member]

sorry, i gave wrong internal table structure...

it does have the missing field..

DATA: BEGIN OF itab OCCURS 0,

budat LIKE mkpf-budat,

mblnr LIKE mseg-mblnr,

zeile LIKE mseg-zeile,

bwart LIKE mseg-bwart,

matnr LIKE mseg-matnr,

werks LIKE mseg-werks,

lgort LIKE mseg-lgort,

dmbtr LIKE mseg-dmbtr,

bwtar LIKE mseg-bwtar,

menge LIKE mseg-menge,

lifnr LIKE mseg-lifnr,

END OF itab.

[Former Member]

Here is what the dump said and my answers are right below them.

Possible errors:

o The maximum size of an SQL statement has been exceeded.

This may not be the reason in your case. This usually happens when you use the option FOR ALL ENTRIES

o The statement contains too many input variables.

Most likely this is your issue. <b>I think your lifnr is filled with all the vendors in your system and filled as single values. In that case you may be exceeding a limit set on the system. Instead of trying to remove this setting, what I would suggest is to do the following.</b>

Define a select-option for LIFNR on your selection screen. This way users can have the flexibility of specifying certain vendors. If they don't enter anything, it is still ok. Don't fill it with single values.

Use this select-option in your select statement. After the select statement, do a delete from itab where the vendors are not in your r_lifnr as below.

DELETE t_bsak_tmp WHERE NOT lifnr IN r_lifnr.

.

o The space needed for the input data exceeds the available memory.

If the above changes are made and the problem is still there, then this is the next thing to look at.

[Former Member]

Thanks Kishan

I will try this and see.

[Former Member]

Kishan i did not understand the following para of urs

"Use this select-option in your select statement. After the select statement, do a delete from itab where the vendors are not in your r_lifnr as below.

DELETE t_bsak_tmp WHERE NOT lifnr IN r_lifnr.

"

I assume u meant itab instead of t_bsak_tmp.

but where do i get r_lifnr when the user doesnot select by vendor?

[Former Member]

for ex. u enter 3 vendor in selection option for fetch data.

it may possible it retrive all the vendor. so just delete entries for table which are not in vendor select option.

if u don't select on the basis of vendor(empty select-option) than it there is no need for that.

so may be it give u error because u select data from mseg and it contain lot of lot of data....

for this perpose to ristrict some value u can use one select-option for vendor also...

[Former Member]

Hi Kishan,

some more clarification on your solutions.

What do you mean by too many input variables?

What made u say that lifnr is filled with all the vendors in the sys and filled as single values, i did not understand this.

What do u mean by limit set, y would not u suggest changing this setting?

how is that a select option would help here even when the user doesnot enter anything.

Why are you stressing on lifnr field, there are other fields too.

Sorry to ask you so many questions, but i am literally confused now and it is causing a major issue in our system.

I told abt this to basis , he has tried increasing the memory limit. But i guess this is not the problem as u mentioned in the first point.

[Former Member]

Hello S Kantheri,

Can I ask you couple of questions ??

How many records are you fetching with your selection parameters and secondly does the dump occur immediately or after a while ?

I feel it is more to do with performance !!

--Since you are interested in only one field of MPKF why dont you have the select without the join basically only on MSEG and later in the loop do a select single to fetch the bldat field from MPKF. It would be much more efficient

Regards

Anurag

Message was edited by: Anurag Bankley

[Former Member]

Hi,

This is because of not declaring the ITAB as you are r fetching the records from Table using Joins

The solution for this is

1. Declare the ITAB as you r fetching the records using JOINs

2. "into corresponding fields"

Hope this will help you.

Thanks

Shiva

[Former Member]

Hi Rob, The user had run this program over night itself.

Do u think ""into corresponding fileds" would help?

What else needs to be done?

[Former Member]

Nope, but I think if the user reduces the amount of data selected, that would help. Try selecting only half of the data and run it twice - once for each half.

It's a performance issue. Another way to help would be to make sure the select-option for mblnr has some values (equal or between).

Rob

Message was edited by: Rob Burbank

[Former Member]

Hi,

I have seen this type of dump coming many times if you run pgm in debug mode while testing. Are u running pgm in debug mode when that select statement is getting excuted.

Also chk if replacing INTO TABLE by INTO CORRESPONDING FIELDS OF TABLE will help.

The issue is definately due to incorrect retrival of data during the select statement and cursor fetch is not able to get data correctly from table.

Cheers,

Vikram

Pls reward for helpful replies!!