topic Re: Short Dump while INSERTING to a DB Z table in Application Development and Automation Discussions

Short Dump while INSERTING to a DB Z table

Former Member — Mon, 05 Jan 2009 17:48:01 GMT

There is one report that we are running in production. Earlier it was taking about 2hrs to run and now it's taking about 14-15 hours to run after we applied the Support Pack. I must agree that the report is not well written by the previous developers and I have been asked to rewrite it but in the meanwhile, they want to continue running the old one.

This report deletes all the existing records first and then updates a Z table. Last week when they tried to run the report as batch job it got cancelled after running 22000 secounds and my basis team told me that logs are getting saturated and we need to use Truncate Statement instead of DELETE from table statement and that is what I did but again when they tried running the report in production it got cancelled again and this time after 55000 secs and this time it's getting cancelled in the last step when we are inserting the records back to the table from the internal table.

So can you please tell me how can I take care of this.

My Findings:

1. Report updates a Z table for 700K records which is really not a very big size.

2. Z table size category is customized for upto 48K to 93K . Does this matter when I try to update 700K records at a time.

3. There is no foreign key relations in the Z table

4. I feel that, it could be a basis problem like, memory related. Any light on this?

5. The program currently uses INSERT statement.Can I try for a success using MODIFY statement. All validations are handled before inserting to remove the duplicates.So I dont see any issues using INSERT statement

6. Can we use a commit statement after INSERT or MODIFY?

7. From SAP help, I see that there is a limitation on the number of records can be inserted or modified. Any idea on the number?

Thanks & Best Regards,

Kiran Babu Dasari

Re: Short Dump while INSERTING to a DB Z table

Former Member — Mon, 05 Jan 2009 18:00:07 GMT

Hi Kiran,

Can you post the dump given by SAP?

Regards,

Gilberto Li

Re: Short Dump while INSERTING to a DB Z table

former_member156446 — Mon, 05 Jan 2009 18:18:56 GMT

Today morning even Rajeev had a similar problem

Re: Short Dump while INSERTING to a DB Z table

Former Member — Mon, 05 Jan 2009 18:56:47 GMT

Dump:

Runtime Errors DBIF_RSQL_SQL_ERROR

Exception CX_SY_OPEN_SQL_DB

Date and Time 01/01/2009 10:17:22

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........: "SQL0964C The transaction log for the database is

full. SQLSTATE=57011 row=1"

Internal call code.........: "[RSQL/INSR/ZTMM_PU_FOR_BW ]"

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"

"ZPMM_BWLOAD_R_V2" or "ZPMM_BWLOAD_INC02"

"FILL_ZTMM_PU_FOR_BW"

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

"FILL_ZTMM_PU_FOR_BW" "(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... "ucerp13"

Network address...... "192.168.254.23"

Operating system..... "AIX"

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

Hardware type........ "00C4B5BE4C00"

Character length.... 16 Bits

Pointer length....... 64 Bits

Work process number.. 34

Shortdump setting.... "full"

Database server... "ucerp10"

Database type..... "DB6"

Database name..... "RP1"

Database user ID.. "SAPRP1"

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

Char.set.... "C"

SAP kernel....... 700

created (date)... "Oct 26 2008 20:51:39"

create on........ "AIX 2 5 005DD9CD4C00"

Database version. "DB6_81 "

Patch level. 183

Patch text.. " "

Database............. "DB6 08.02., DB6 09."

SAP database version. 700

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

Memory consumption

Roll.... 16192

EM...... 234631488

Heap.... 0

Page.... 24576

MM Used. 28706288

MM Free. 197532304

User and Transaction

Client.............. 400

User................ "BATCHUC"

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

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

Transactions ID..... "49597E9619C40076E1008000C0A8FE17"

Program............. "ZPMM_BWLOAD_R_V2"

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

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

Information on where terminated

Termination occurred in the ABAP program "ZPMM_BWLOAD_R_V2" - in

"FILL_ZTMM_PU_FOR_BW".

The main program was "ZPMM_BWLOAD_R_V2 ".

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

of the (Include) program "ZPMM_BWLOAD_INC02".

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

Job Name....... "ZPMM_BWLOAD_R_V2"

Job Initiator.. "BATCHSCHED"

Job Number..... 10261500

The termination is caused because exception "CX_SY_OPEN_SQL_DB" occurred in

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

nor declared

in the RAISING clause of its signature.

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

2751 of the (Include program "ZPMM_BWLOAD_INC02 ".

Source Code Extract

Line

SourceCde

2856	itab_result-rec_no = recnum.
2857	ENDIF.
2858
2859	11/30/05 - Change it back after sorting
2860	IF linetype = 'AAA'.
2861	itab_result-linetype = 'INI'.
2862	ENDIF.
2863	itab_result-extractdate = e_sdate.
2864	itab_result-mandant = sy-mandt.
2865	MODIFY itab_result INDEX indx.
2866
2867	SELECT SINGLE
2868	rec_no
2869	ponumber
2870	FROM ztmm_pu_for_bw
2871	INTO CORRESPONDING FIELDS OF itab_duprec
2872	WHERE rec_no = recnum
2873	AND ponumber = pono
2874	AND linetype = linetype
2875	AND line_no = lineno
2876	AND changenr = chgno
2877	AND chgind_h = indh
2878	AND chgind_p = indp
2879	AND tblname = tbl
2880	AND fldname = fld.
2881	IF sy-subrc <> 0.
2882	MOVE-CORRESPONDING itab_result TO itab_result_bw.
2883	APPEND itab_result_bw.
2884	nrecs_results = nrecs_results + 1.
2885
>>>>>	INSERT ztmm_pu_for_bw FROM TABLE itab_result_bw.
2887	INSERT zztmm_pu_for_bw FROM TABLE itab_result_bw.
2888
2889	CLEAR itab_result_bw.
2890	REFRESH itab_result_bw.
2891	ENDIF.
2892	ENDLOOP.
2893	*change to array insert for performance
2894	INSERT ZZTMM_PU_FOR_BW FROM TABLE itab_result_bw.
2895
2896	ENDFORM. " fill_ztmm_pu_for_bw

Contents of system fields

Name

Val.

SY-SUBRC	4
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	Load Purchasing Info. for BW Reporting
SY-MSGTY	E
SY-MSGID	TD
SY-MSGNO	600
SY-MSGV1	T710-08L04
SY-MSGV2	K01
SY-MSGV3	EN
SY-MSGV4
SY-MODNO	0
SY-DATUM	20081231
SY-UZEIT	190013
SY-XPROG	SAPCNVE
SY-XFORM	CONVERSION_EXIT

Active Calls/Events

No. Ty. Program Include Line

Name

2 FORM ZPMM_BWLOAD_R_V2 ZPMM_BWLOAD_INC02 2886

FILL_ZTMM_PU_FOR_BW

1 EVENT ZPMM_BWLOAD_R_V2 ZPMM_BWLOAD_R_V2 192

START-OF-SELECTION

Chosen variables

Name

Val.

No. 2 Ty. FORM

Name FILL_ZTMM_PU_FOR_BW

#######ৡ###################A###P#################ż#############################T#######린 u#̀##

00000000000000000000000000000000000000010000000000000000000000000000000000000000000000FB000000

000000090000000000000000000000000000000A0000000001000000000000000000000000000000000000F9000300

0000000E0000000000000000000400050000000B0000000007000000000000000000000000000105000000FB270000

0000010100000000000000000101010000000000000000040C000000000000000000000000000604000000F005000C

ITAB_RESULT_BW-WAERS

USD

00000

55422

53400

ITAB_RESULT-WAERS

USD

00000

55422

53400

ITAB_RESULT_BW+5358(10)

#U#C# #

0205040202

0005030000

ITAB_RESULT+4160(10)

#U#C# #

0205040202

0005030000

AMTCRCHGPOSREGUA2

00000000000

0000000000C

ITAB_RESULT_BW+5378(572)

#S#h#i#p#p#i#n#g# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #

0205060607070606060202020202020202020202020202020202020202020202020202020202020202020202020202

000308090000090E070000000000000000000000000000000000000000000000000000000000000000000000000000

ITAB_RESULT+4170(572)

#S#h#i#p#p#i#n#g# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #

0205060607070606060202020202020202020202020202020202020202020202020202020202020202020202020202

000308090000090E070000000000000000000000000000000000000000000000000000000000000000000000000000

C_INITIAL

@0E@

000000

434422

005000

ITAB_RESULT_BW-ORT01

Cincinnati

00000000000000000000000000000000000

46666666762222222222222222222222222

39E39EE1490000000000000000000000000

ITAB_RESULT-ORT01

Cincinnati

00000000000000000000000000000000000

46666666762222222222222222222222222

39E39EE1490000000000000000000000000

ITAB_RESULT_BW-PSTLZ

45206

0000000000

3333322222

4520600000

ITAB_RESULT-PSTLZ

45206

0000000000

3333322222

4520600000

ITAB_RESULT_BW-REGIO

000

442

F80

ITAB_RESULT-REGIO

000

442

F80

ITAB_RESULT_BW-STRAS

2709 Woodburn Ave.

00000000000000000000000000000000000

33332566667762476222222222222222222

270907FF4252E0165E00000000000000000

ITAB_RESULT-STRAS

2709 Woodburn Ave.

00000000000000000000000000000000000

33332566667762476222222222222222222

270907FF4252E0165E00000000000000000

%_SPACE

ITAB_RESULT_BW+6154(4)

0202

0000

ITAB_RESULT+4908(4)

0202

0000

LW_LINES

164

000A

0004

ITAB_RESULT_BW-TELF1

961-1122

0000000000000000

3332333322222222

961D112200000000

ITAB_RESULT-TELF1

961-1122

0000000000000000

3332333322222222

961D112200000000

ITAB_RESULT_BW-LAND1

000

552

530

ITAB_RESULT-LAND1

000

552

530

COUNTROCHGNEGCONOVER1K2

0000

ITAB_RESULT_BW+6158(337)

#0#3#6#0#-#0#0# # # # # # # # # # # # # #M#R#O# #&# #C#o#n#s#t#r#u#c#t#i#o#n#A#t#h#l#e#t#i#c

0203030303020303020202020202020202020202020405040202020406060707070706070606060407060606070606

00000306000D0000000000000000000000000000000D020F000600030F0E030402050304090F0E0104080C05040903

ITAB_RESULT+4950(337)

#0#3#6#0#-#0#0# # # # # # # # # # # # # #M#R#O# #&# #C#o#n#s#t#r#u#c#t#i#o#n#A#t#h#l#e#t#i#c

0203030303020303020202020202020202020202020405040202020406060707070706070606060407060606070606

00000306000D0000000000000000000000000000000D020F000600030F0E030402050304090F0E0104080C05040903

ITAB_CHGLOG[]

Table IT_33[587x1576]

\PROGRAM=ZPMM_BWLOAD_R_V2\DATA=ITAB_CHGLOG[]

Table reference: 25

TABH+ 0(20) = 070000009070DB38000000000000000000000000

TABH+ 20(20) = 00000019000000210000024B00000628FFFFFFFF

TABH+ 40(16) = 040000000000149000082C9401800000

store = 0x070000009070DB38

ext1 = 0x0000000000000000

shmId = 0 (0x00000000)

id = 25 (0x00000019)

label = 33 (0x00000021)

fill = 587 (0x0000024B)

leng = 1576 (0x00000628)

loop = -1 (0xFFFFFFFF)

xtyp = TYPE#000095

occu = 8 (0x00000008)

access = 1 (ItAccessStandard)

idxKind = 1 (ItIndexLinear)

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 = 0x07000000A0E13E70

pgHook = 0x07000000B2EBC728

idxPtr = 0x07000000906BA5E0

shmTabhSet = 0x0000000000000000

id = 32 (0x00000020)

refCount = 0 (0x00000000)

tstRefCount = 0 (0x00000000)

lineAdmin = 1024 (0x00000400)

lineAlloc = 592 (0x00000250)

shmVersId = 0 (0x00000000)

shmRefCount = 469 (0x000001D5)

>>>>> 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

ITAB_RESULT_BW+3592(1026)

# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #

0202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202

0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

ITAB_RESULT+5798(1026)

# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #

0202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202

0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

ITAB_RESULT_BW-MANDANT

400

000

333

400

ITAB_RESULT-MANDANT

400

000

333

400

AMTTCCHGPOSREGST2

00000000000

0000000000C

ITAB_RESULT_BW[]

Table IT_132[1x6760]

\PROGRAM=ZPMM_BWLOAD_R_V2\DATA=ITAB_RESULT_BW[]

Table reference: 51

TABH+ 0(20) = 07000000A9A1FEA8000000000000000000000000

TABH+ 20(20) = 00000033000000840000000100001A68FFFFFFFF

TABH+ 40(16) = 0400000000003140000224C401800000

store = 0x07000000A9A1FEA8

ext1 = 0x0000000000000000

shmId = 0 (0x00000000)

id = 51 (0x00000033)

label = 132 (0x00000084)

fill = 1 (0x00000001)

leng = 6760 (0x00001A68)

loop = -1 (0xFFFFFFFF)

xtyp = TYPE#000248

occu = 2 (0x00000002)

access = 1 (ItAccessStandard)

idxKind = 0 (ItIndexNone)

uniKind = 2 (ItUniqueNon)

keyKind = 1 (default)

cmpMode = 8 (cmpManyEq)

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 = 0x07000000A283E980

pgHook = 0x0000000000000000

idxPtr = 0x0000000000000000

shmTabhSet = 0x0000000000000000

id = 141 (0x0000008D)

refCount = 0 (0x00000000)

tstRefCount = 0 (0x00000000)

lineAdmin = 2 (0x00000002)

lineAlloc = 2 (0x00000002)

shmVersId = 0 (0x00000000)

shmRefCount = 1 (0x00000001)

>>>>> 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

ITAB_RESULT_BW

400##͒4500034945

0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

0000030000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

3330053333333333222222222222222222222222222222222222222222222222222222222222222222222222222222

4000024500034945000000000000000000000000000000000000000000000000000000000000000000000000000000

%_DUMMY$$

0000

2222

0000

COUNTTCCHGNEGCONST3

0000

<%_TABLE_ZTMM_PU_FOR_BW>

???

??????

AMTTOTAL3

00000000000

0000000000C

No. 1 Ty. EVENT

Name START-OF-SELECTION

T023T

000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222
000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
T024

0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
2222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
T161
00000 00000
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
2222222223333322222222222222222222222222222222222333332222222222222222222222222222222222222222
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
TWLAD

000000000000000000000000
000000000000000000000000
222222222222222222222222
000000000000000000000000
ZTMM_BOA
0000000000000000
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
2222222222222223333333333333333222222222222222222222222222222222222222222222222222222222222222
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
ZTMM_PU_FOR_BW

0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
2220002222222222222222222222222222222222222222222222222222222222222222222222222222222222222222
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
ZTPU_DOCTYPE

0000000000000000000000000000000000
0000000000000000000000000000000000
2222222222222222222222222222222222
0000000000000000000000000000000000
USR02
####0000000000000000 # 000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
2222222222222220000333333333333333322222222222220222222222222222222222222333333333333333333333
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
SSCRFIELDS

0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
2222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
C_BLUESQUAREX
@3X@
000000
000000
435422
038000

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#11".

The internal operation just processed is "SQLS".

Internal mode was started at 20081231190002.

Internal call code.........: "[RSQL/INSR/ZTMM_PU_FOR_BW ]"

Active Calls in SAP Kernel

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

=> 64 bit R/3 Kernel

=> 64 bit AIX Kernel

=> Heap limit = unlimited

=> Stack limit = 4294967296

=> Core limit = 1073741312

=> File size limit = unlimited

=> Heap address = 0x0x11c0f5d60

=> Stack address = 0xfffffffffff8040

=> Stack low = 0xfffffffffff8040

=> Stack high = 0xffffffffffff800

=> Stack Trace:

AixStack() at 0x1000c945c

CTrcStack2() at 0x1000c9554

rabax_CStackSave__Fv() at 0x1000b3ee0

ab_rabax() at 0x1000b0628

ab_rsqlerr__FPCUsiT1P11RS_HEADER94T1Pv() at 0x10058c010

HandleRsqlErrors__F9RsqlError9CloseMode() at 0x1017f1e94

SqlsExecuteCall__FUcP11DynCallInfo() at 0x1017efc68

ab_jsqls__Fv() at 0x1017ea82c

ab_extri__Fv() at 0x100419ca0

ab_xevent__FPCUs() at 0x10094e47c

ab_trigg__Fv() at 0x10094e168

ab_run() at 0x1011aabb8

N_ab_run() at 0x100f6edc0

dynpmcal() at 0x100f6d9c4

dynppai0() at 0x100f6b2c8

dynprctl() at 0x100f7375c

dynpen00() at 0x100f6761c

Thdynpen00() at 0x1000e3c6c

TskhLoop() at 0x1000e5b64

ThStart() at 0x1001000c0

DpMain() at 0x101301d34

nlsui_main() at 0x101abea68

List of ABAP programs affected

Index

Typ

Program

Group

Date

Time

Size

Lang.

0	Prg	ZPMM_BWLOAD_R_V2	0	12/31/2008	10:10:08	409600	E
1	Prg	SAPMSSY0	1	05/30/2008	12:59:05	92160	E
2	Prg	SAPMSSYD	1	08/16/2006	12:06:37	21504	E
3	Prg	SAPFSYSCALLS	1	09/09/2004	14:18:32	7168	E
4	Prg	RSDBRUNT	0	12/13/2008	02:15:03	254976	E
5	Prg	SAPLSPRI	5	12/13/2008	02:14:06	342016	E
6	Typ	PRI_PARAMS	0	11/02/1998	09:46:12	5120
7	Typ	ARC_PARAMS	0	08/28/1997	08:36:28	6144
8	Typ	PRI_LAYOUT	0	11/06/2003	20:30:04	2048
9	Typ	PRIPAR_EXT	0	05/18/2004	14:07:03	3072
10	Typ	PRIPAR_EX2	0	11/09/2000	14:10:39	2048
11	Typ	PRIPAR_EX3	0	05/18/2004	14:07:03	5120
12	Typ	TPRI_DEF	0	11/09/2000	14:24:28	5120
13	Typ	USR01	0	05/30/2008	19:06:47	4096
14	Typ	TSP1D	0	11/15/2000	17:58:02	5120
15	Prg	SAPLSPOO	15	12/13/2008	02:14:06	160768	E
16	Prg	SAPLRSPOLSTDRV	16	12/13/2008	02:13:54	58368	E
17	Typ	TSPOPTIONS	0	01/29/1997	19:13:56	2048
18	Typ	TSP03	0	11/02/1998	09:57:05	5120
19	Typ	TSP0A	0	11/15/2000	17:58:02	6144
20	Typ	TSP03C	0	11/21/2003	11:41:10	7168
21	Typ	TSP03T	0	03/23/1998	18:21:38	6144
22	Typ	TSP06A	0	11/15/2000	17:58:02	7168
23	Prg	SAPCNVE	23	09/09/2004	14:36:10	8192	E
24	Prg	SAPLSPOC	24	12/13/2008	02:15:07	137216	E
25	Typ	TSP03L	0	07/10/1997	00:46:18	2048
26	Typ	RSPOCHECK	0	08/13/1997	12:53:10	4096
27	Typ	TSP03A	0	07/10/1997	00:46:15	3072
28	Prg	SAPLSPOR	28	12/13/2008	02:15:07	39936	E
29	Prg	SAPLSPOB	29	05/30/2008	09:36:14	67584	E
30	Prg	SAPLSDEX	30	09/09/2004	14:20:42	22528	E
31	Typ	DD07T	0	05/30/2008	00:38:18	3072
32	Typ	DEVPAR	0	12/04/2000	12:46:11	3072
33	Typ	RSPOATTR	0	11/10/1999	17:44:19	2048
34	Typ	RSSCR	0	03/30/2005	10:21:45	5120
35	Prg	RSDBSPBL	0	03/30/2005	10:21:58	72704	E
36	Prg	SAPDB__S	0	03/30/2005	10:22:01	19456	E
37	Typ	VARID	0	05/12/1997	16:51:30	4096
38	Typ	SSCRFIELDS	0	05/13/1997	12:54:26	5120
39	Prg	%_CSYDB0	0	03/30/2005	10:21:45	35840	E
40	Prg	RSDBSPVA	0	12/13/2008	02:15:03	133120	E
41	Typ	RSVAMEMKEY	0	05/07/1997	13:07:49	5120
42	Prg	RSDBSPMC	0	08/16/2006	11:55:58	79872	E
43	Typ	DDSHDESCR	0	09/03/1997	03:05:16	4096
44	Typ	SPPARAMS	0	05/07/1997	13:10:38	2048
45	Prg	SAPLICON	45	05/30/2008	13:22:44	27648	E
46	Prg	%_CICON	45	05/30/2008	13:22:44	107520	E
47	Typ	ICONT	0	08/16/2006	11:55:57	2048
48	Prg	SAPLSABE	48	09/09/2004	14:18:36	12288	E
49	Prg	SAPLSECU	49	05/30/2008	11:07:13	87040	E
50	Typ	RSSUBINFO	0	10/14/1999	22:01:03	2048
51	Typ	RSEXFCODE	0	08/13/1997	12:52:57	2048
52	Prg	SAPLDSYA	52	05/30/2008	12:53:05	45056	E
53	Prg	SAPFSDS1	52	03/30/2005	10:22:01	52224	E
54	Typ	TDCLD	0	11/02/1998	09:51:35	6144
55	Prg	SAPLSDOD	55	01/25/2006	10:59:45	45056	E
56	Typ	DOKIL	0	05/12/1997	16:46:17	3072
57	Prg	SAPLLANG	57	09/09/2004	14:18:35	10240	E
58	Typ	T002	0	05/30/2008	00:53:58	2048
59	Prg	SAPFSPOR	0	05/30/2008	07:29:40	14336	E
60	Prg	SAPLSTUP	60	01/05/2006	12:20:05	74752	E
61	Prg	SAPLCNDP	61	12/13/2008	02:10:20	195584	E
62	Prg	SAPLSCNT	62	02/18/2005	14:16:06	30720	E
63	Prg	SAPSHDTV	62	01/05/2005	16:26:16	33792	E
64	Prg	SAPFGUICNTL	1	02/18/2005	14:15:08	24576	E
65	Prg	SAPLOLEA	65	05/30/2008	08:51:36	96256	E
66	Prg	SAPLSGUI	66	05/30/2008	12:59:05	84992	E
67	Prg	SAPLSTTM	67	07/05/2005	13:10:18	69632	E
68	Prg	SAPLSBDC	68	07/05/2005	13:10:18	44032	E
69	Prg	SAPLSFES	69	12/13/2008	02:09:04	261120	E
70	Prg	SAPLTHFB	70	12/13/2008	02:12:46	394240	E
71	Typ	WPINFO	0	02/26/1999	14:49:01	6144
72	Prg	SAPLURFC	72	05/30/2008	12:53:54	22528	E
73	Prg	SAPLSPLUGIN	73	09/09/2004	14:18:36	8192	E
74	Typ	SWCBCONT	0	11/15/2000	17:55:11	3072
75	Typ	OLE_VERBS	0	04/04/1995	16:02:20	2048
76	Typ	OLE_PA	0	04/04/1995	16:02:19	2048
77	Typ	SSCRTEXTS	0	09/03/1997	03:12:33	6144
78	Prg	SAPLSPIAGENTCW	78	05/30/2008	09:53:48	13312	E
79	Prg	SAPLSPILS	79	05/30/2008	12:59:05	64512	E
80	Prg	CL_OS_TRANSACTION_END_NOTIFIERCP	80	07/05/2005	13:05:25	9216	E
81	Prg	CL_SYSTEM_TRANSACTION_STATE===CP	81	05/30/2008	12:59:05	106496	E
82	Typ	EKKO	0	05/31/2008	00:00:14	21504
83	Typ	EKPO	0	05/31/2008	00:00:14	44032
84	Typ	ZTMM_DOCTYPES	0	05/30/2008	00:36:18	2048
85	Typ	CDHDR	0	06/06/2001	13:09:30	4096
86	Typ	CDPOS	0	12/14/1998	23:09:47	5120
87	Typ	TLINE	0	03/08/1992	00:19:59	2048
88	Prg	SAPLSTXD	88	12/13/2008	02:14:09	401408	E
89	Typ	TTXOB	0	08/27/1999	17:40:40	3072
90	Typ	TTXID	0	08/27/1999	17:40:33	3072
91	Typ	TCATALOG	0	05/25/1998	12:19:20	3072
92	Typ	STXH	0	11/06/2003	20:31:32	7168
93	Prg	CL_ABAP_CHAR_UTILITIES========CP	93	07/05/2005	13:10:15	13312	E
94	Typ	STXL	0	02/14/1998	10:13:53	11264
95	Typ	EKBE	0	12/12/2008	21:06:15	13312
96	Typ	T023T	0	02/14/1998	10:32:22	2048
97	Typ	LFA1	0	05/31/2008	00:05:46	22528
98	Typ	LFB1	0	05/31/2008	00:05:46	14336
99	Typ	OILT001L	0	02/24/2005	13:46:42	2048
100	Typ	T001L	0	05/31/2008	00:07:13	5120
101	Typ	T024	0	01/25/2006	10:56:28	3072
102	Typ	TWLAD	0	08/13/1997	14:04:45	2048
103	Typ	ADRC	0	11/06/2003	20:25:51	17408
104	Typ	EBAN	0	05/31/2008	00:00:03	26624
105	Prg	SAPLCTCE	105	09/09/2004	14:18:34	9216	E
106	Typ	CABN	0	09/18/2001	10:02:26	12288
107	Typ	AUSP	0	09/18/2001	10:02:23	9216
108	Typ	CAWN	0	09/18/2001	10:02:29	6144
109	Typ	CAWNT	0	09/18/2001	10:02:29	3072
110	Typ	ZTMM_BOA	0	05/30/2008	00:57:45	3072
111	Typ	ZTMM_PU_FOR_BW	0	05/30/2008	00:36:18	24576
112	Prg	SAPLSTXU	112	08/16/2006	12:06:32	129024	E
113	Typ	ITCRS	0	08/20/1998	10:54:36	3072
114	Prg	CX_SY_OPEN_SQL_DB=============CP	114	07/05/2005	13:10:16	12288	E
115	Typ	SCX_SRCPOS	0	05/18/2004	14:07:11	2048
116	Prg	CX_SY_OPEN_SQL_ERROR==========CP	116	07/05/2005	13:10:16	12288	E
117	Prg	CX_SY_SQL_ERROR===============CP	117	07/05/2005	13:10:16	10240	E
118	Prg	CX_DYNAMIC_CHECK==============CP	118	07/05/2005	13:10:16	10240	E
119	Prg	CX_ROOT=======================CP	119	05/30/2008	09:29:40	11264	E
120	Prg	CX_NO_CHECK===================CP	120	07/05/2005	13:10:16	10240	E
121	Prg	CX_SY_NO_HANDLER==============CP	121	07/05/2005	13:10:16	10240	E
122	Typ	T161	0	05/31/2008	00:07:15	8192
123	Typ	ZTPU_DOCTYPE	0	08/19/2005	14:15:29	2048
124	Typ	USR02	0	05/30/2008	18:52:30	8192

Directory of Application Tables

Name Date Time Lngth

Val.

Program ZPMM_BWLOAD_R_V2

SYST 09/09/2004 14:18:12 00004612
\0\0\0\0\0ŵ\0ৡ\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\x0001\0A
T023T / / : : 00000186

T024 / / : : 00000704

T161 / / : : 00000276
00000 00000
TWLAD / / : : 00000048

ZTMM_BOA / / : : 00000194
0000000000000000
ZTMM_PU_FOR_BW / / : : 00006760
\0\0\0
ZTPU_DOCTYPE / / : : 00000068

USR02 / / : : 00000432
\0\0\0\00000000000000000 \0
SSCRFIELDS 09/09/2004 14:18:02 00001708

SSCRTEXTS / / : : 00000742

Program RSDBRUNT

VARID / / : : 00000252

Program SAPLSPRI

TSP03 / / : : 00000460

UF00 HPLJ5SI E\0\0

USR01 / / : : 00000222

400BATCHUC UF00 GD2X

PRI_PARAMS / / : : 00000380

UF00001ZPMM_BWLOAD_

ARC_PARAMS / / : : 00000660

TPRI_DEF / / : : 00002932

400GV21 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0

TSP1D / / : : 00000320

0000000000

Program SAPLSPOO

TSP03 / / : : 00000460

UF00 HPLJ5SI E\0\0

TSP03C / / : : 00000352

UF00 \0 \0\0\0\0 \0\0ucerp13_RP1_00 VPSX UHALL_3R

TSP1D / / : : 00000320

X_65_80 ANY PL0008000065SAP 1998040711

Program SAPLRSPOLSTDRV

TSP0A / / : : 00000388

HPLJ5SI XHPL200835HP Laserjet 5 Si 1116111611

TSP03 / / : : 00000460

UF00 HPLJ5SI E\0\0

TSP03C / / : : 00000352

UF00 \0 \0\0\0\0 \0\0ucerp13_RP1_00 VPSX UHALL_3R

TSP03T / / : : 00000422

UF00

TSPOPTIONS / / : : 00000432

Program SAPLSPOC

TSP03L / / : : 00000068
UHall, 3rd floor HP5si UF00

Program SAPLSPOR

TSP03 / / : : 00000460
UF00 HPLJ5SI E\0\0
TSP03L / / : : 00000068
UHall, 3rd floor HP5si UF00

Program SAPLSDEX

DD07T / / : : 00000260

RSPOARCHTY EA00010000Print

Program SAPLICON

ICONT / / : : 00000130

Program SAPFSDS1

TDCLD / / : : 00000098
RE DOKU 8R XX XXLIMUDOKUX ḀXR3TRPROGX

Program SAPLSDOD

DOKIL / / : : 00000152

Program SAPLLANG

T002 / / : : 00000010
ES1EN

Program SAPLSTXD

T002 / / : : 00000010
ES1EN
TTXOB / / : : 00000112
EKKO VTA072
TTXID / / : : 00000116
EKKO K01 X
STXH / / : : 00000746
400EKKO T593-09S09
STXL / / : : 00008086
400TXEKKO T593-09S09

Program SAPLSTXU

ITCRS / / : : 00000476

\0\x0004 600T710-08L04

ABAP Control Blocks (CONT)

Index

Name

PAR0

PAR1

PAR2

PAR3

PAR4

PAR5

PAR6

Source Code

Line

16635	move	FF	0020	0692	0693					ZPMM_BWLOAD_INC02	2882
16637	move	FF	0006	0694	0695					ZPMM_BWLOAD_INC02	2882
16639	move	FF	0151	0696	0697					ZPMM_BWLOAD_INC02	2882
16641	move	FF	0402	0698	0699					ZPMM_BWLOAD_INC02	2882
16643	move	FF	0006	069A	0661					ZPMM_BWLOAD_INC02	2882
16645	MVCO	01	0000							ZPMM_BWLOAD_INC02	2882
16646	TAPP	00	0243	046D	046E					ZPMM_BWLOAD_INC02	2883
16648	ccqi	4B	0000	0000	1A98	0001	0000	0000	1A98	ZPMM_BWLOAD_INC02	2884
16652	SQLS	0B	0000							ZPMM_BWLOAD_INC02	2886
16653	SQLS	06	01A7							ZPMM_BWLOAD_INC02	2886
16654	PAR1	00	0662							ZPMM_BWLOAD_INC02	2886
16655	SQLS	39	0367							ZPMM_BWLOAD_INC02	2886
>>>>>	SQLS	0F	046D							ZPMM_BWLOAD_INC02	2886
16657	CLEA	00	046E							ZPMM_BWLOAD_INC02	2889
16658	REFR	00	0000	046D	0000					ZPMM_BWLOAD_INC02	2890
16660	BRAX	01	FF44							ZPMM_BWLOAD_INC02	2892
16661	ENDF	00	0000							ZPMM_BWLOAD_INC02	2896
16662		00	0000							ZPMM_BWLOAD_INC02	2896
16663	comp	00	0242	069B	004D					ZPMM_BWLOAD_R_V2	102
16665	BRAF	02	00AE							ZPMM_BWLOAD_R_V2	102

Re: Short Dump while INSERTING to a DB Z table

Former Member — Mon, 05 Jan 2009 19:00:52 GMT

Runtime Errors DBIF_RSQL_SQL_ERROR

Exception CX_SY_OPEN_SQL_DB

Date and Time 01/01/2009 10:17:22

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........: "SQL0964C The transaction log for the database is

full. SQLSTATE=57011 row=1"

Internal call code.........: "[RSQL/INSR/ZTMM_PU_FOR_BW ]"

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"

"ZPMM_BWLOAD_R_V2" or "ZPMM_BWLOAD_INC02"

"FILL_ZTMM_PU_FOR_BW"

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

"FILL_ZTMM_PU_FOR_BW" "(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... "ucerp13"

Network address...... "192.168.254.23"

Operating system..... "AIX"

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

Hardware type........ "00C4B5BE4C00"

Character length.... 16 Bits

Pointer length....... 64 Bits

Work process number.. 34

Shortdump setting.... "full"

Database server... "ucerp10"

Database type..... "DB6"

Database name..... "RP1"

Database user ID.. "SAPRP1"

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

Char.set.... "C"

SAP kernel....... 700

created (date)... "Oct 26 2008 20:51:39"

create on........ "AIX 2 5 005DD9CD4C00"

Database version. "DB6_81 "

Patch level. 183

Patch text.. " "

Database............. "DB6 08.02., DB6 09."

SAP database version. 700

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

Memory consumption

Roll.... 16192

EM...... 234631488

Heap.... 0

Page.... 24576

MM Used. 28706288

MM Free. 197532304

User and Transaction

Client.............. 400

User................ "BATCHUC"

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

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

Transactions ID..... "49597E9619C40076E1008000C0A8FE17"

Program............. "ZPMM_BWLOAD_R_V2"

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

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

Information on where terminated

Termination occurred in the ABAP program "ZPMM_BWLOAD_R_V2" - in

"FILL_ZTMM_PU_FOR_BW".

The main program was "ZPMM_BWLOAD_R_V2 ".

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

of the (Include) program "ZPMM_BWLOAD_INC02".

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

Job Name....... "ZPMM_BWLOAD_R_V2"

Job Initiator.. "BATCHSCHED"

Job Number..... 10261500

The termination is caused because exception "CX_SY_OPEN_SQL_DB" occurred in

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

nor declared

in the RAISING clause of its signature.

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

2751 of the (Include program "ZPMM_BWLOAD_INC02 ".

Source Code Extract

Line

SourceCde

2856	itab_result-rec_no = recnum.
2857	ENDIF.
2858
2859	11/30/05 - Change it back after sorting
2860	IF linetype = 'AAA'.
2861	itab_result-linetype = 'INI'.
2862	ENDIF.
2863	itab_result-extractdate = e_sdate.
2864	itab_result-mandant = sy-mandt.
2865	MODIFY itab_result INDEX indx.
2866
2867	SELECT SINGLE
2868	rec_no
2869	ponumber
2870	FROM ztmm_pu_for_bw
2871	INTO CORRESPONDING FIELDS OF itab_duprec
2872	WHERE rec_no = recnum
2873	AND ponumber = pono
2874	AND linetype = linetype
2875	AND line_no = lineno
2876	AND changenr = chgno
2877	AND chgind_h = indh
2878	AND chgind_p = indp
2879	AND tblname = tbl
2880	AND fldname = fld.
2881	IF sy-subrc <> 0.
2882	MOVE-CORRESPONDING itab_result TO itab_result_bw.
2883	APPEND itab_result_bw.
2884	nrecs_results = nrecs_results + 1.
2885
>>>>>	INSERT ztmm_pu_for_bw FROM TABLE itab_result_bw.
2887	INSERT zztmm_pu_for_bw FROM TABLE itab_result_bw.
2888
2889	CLEAR itab_result_bw.
2890	REFRESH itab_result_bw.
2891	ENDIF.
2892	ENDLOOP.
2893	*change to array insert for performance
2894	INSERT ZZTMM_PU_FOR_BW FROM TABLE itab_result_bw.
2895
2896	ENDFORM. " fill_ztmm_pu_for_bw

Re: Short Dump while INSERTING to a DB Z table

Former Member — Mon, 05 Jan 2009 19:02:23 GMT

Short text

SQL error in the database when accessing a table.

How to correct the error

Database error text........: "SQL0964C The transaction log for the database is

full. SQLSTATE=57011 row=1"

Internal call code.........: "[RSQL/INSR/ZTMM_PU_FOR_BW ]"

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"

"ZPMM_BWLOAD_R_V2" or "ZPMM_BWLOAD_INC02"

"FILL_ZTMM_PU_FOR_BW"

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

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

the

RAISING clause of the procedure.

To prevent the exception, note the following:

Information on where terminated

Termination occurred in the ABAP program "ZPMM_BWLOAD_R_V2" - in

"FILL_ZTMM_PU_FOR_BW".

The main program was "ZPMM_BWLOAD_R_V2 ".

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

of the (Include) program "ZPMM_BWLOAD_INC02".

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

Job Name....... "ZPMM_BWLOAD_R_V2"

Job Initiator.. "BATCHSCHED"

Job Number..... 10261500

The termination is caused because exception "CX_SY_OPEN_SQL_DB" occurred in

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

nor declared

in the RAISING clause of its signature.

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

2751 of the (Include program "ZPMM_BWLOAD_INC02 ".

Source Code Extract

Line

SourceCde

2856	itab_result-rec_no = recnum.
2857	ENDIF.
2858
2859	11/30/05 - Change it back after sorting
2860	IF linetype = 'AAA'.
2861	itab_result-linetype = 'INI'.
2862	ENDIF.
2863	itab_result-extractdate = e_sdate.
2864	itab_result-mandant = sy-mandt.
2865	MODIFY itab_result INDEX indx.
2866
2867	SELECT SINGLE
2868	rec_no
2869	ponumber
2870	FROM ztmm_pu_for_bw
2871	INTO CORRESPONDING FIELDS OF itab_duprec
2872	WHERE rec_no = recnum
2873	AND ponumber = pono
2874	AND linetype = linetype
2875	AND line_no = lineno
2876	AND changenr = chgno
2877	AND chgind_h = indh
2878	AND chgind_p = indp
2879	AND tblname = tbl
2880	AND fldname = fld.
2881	IF sy-subrc <> 0.
2882	MOVE-CORRESPONDING itab_result TO itab_result_bw.
2883	APPEND itab_result_bw.
2884	nrecs_results = nrecs_results + 1.
2885
>>>>>	INSERT ztmm_pu_for_bw FROM TABLE itab_result_bw.
2887	INSERT zztmm_pu_for_bw FROM TABLE itab_result_bw.
2888
2889	CLEAR itab_result_bw.
2890	REFRESH itab_result_bw.
2891	ENDIF.
2892	ENDLOOP.
2893	*change to array insert for performance
2894	INSERT ZZTMM_PU_FOR_BW FROM TABLE itab_result_bw.
2895
2896	ENDFORM. " fill_ztmm_pu_for_bw

Re: Short Dump while INSERTING to a DB Z table

Former Member — Mon, 05 Jan 2009 19:03:37 GMT

It doesnt allow me to copy my dump from a text pad.

But the short text says: SQL error in accessing database when accessing a table.

Thanks

Kiran

Re: Short Dump while INSERTING to a DB Z table

former_member191735 — Mon, 05 Jan 2009 20:37:57 GMT

1. Report updates a Z table for 700K records which is really not a very big size.

You are right.

2. Z table size category is customized for upto 48K to 93K . Does this matter when I try to update 700K records at a time.

This does not matter

3. There is no foreign key relations in the Z table

This is not an issue

4. I feel that, it could be a basis problem like, memory related. Any light on this?

If the short dump refers to some SQL then this might be the memory related

Good idea. Use Modify statement instead of Insert

6. Can we use a commit statement after INSERT or MODIFY?

Yes you can use commit statement after insert and also modify

7. From SAP help, I see that there is a limitation on the number of records can be inserted or modified. Any idea on the number?

I dont think there is a limit in no.of. records.

We do update more than 700K records and this runs perfectly.

First of you need to check the select statements, especially, if there are any for all entries statement. if there are any for all statements, make sure you have the data in reffering internal table. This will be a big issue (we had couple of these).

Last, i dont think, there will be any change in Z programs with support packs. I would suggest you to go through the program in debug and see which statement is taking time

After reading your dump.... this is a memory issue. Ask your basis to allocate more table space but before that make sure if there are any tables deleted or modified after support pack applied which were used in the program.

Edited by: abap technical on Jan 5, 2009 1:38 PM

Check out OSS note 873596 and also make sure the DB table and Internal table is similar

Reason and Prerequisites

If too many single values are assigned during a selection request, a dump occurs since the Where condition that is generated is too large. Implement the following correction instructions to catch this dump, and the system will issue a corresponding error message.

Edited by: abap technical on Jan 5, 2009 1:43 PM

Re: Short Dump while INSERTING to a DB Z table

Former Member — Tue, 06 Jan 2009 05:59:27 GMT

please check either ur itab & ztable are of same structure or not?if not insert will result in dump,also if duplicates records are inserting it will dump,u shd use WITH DUPLICATE KEY in INSTERT,ulse use update command.

Also in delete,if u can paste ur dump,we can elobrate it.