topic Re: Insert ITAB INDEX SY-TABIX Problem in Application Development and Automation Discussions

Insert ITAB INDEX SY-TABIX Problem

Former Member — Tue, 30 Mar 2010 14:40:11 GMT

Hi Experts,

I have a problem in my report.

Please look into the code.

loop at li_basez980.

read table i_z980 with key spmon = l_spmon

matnr = li_basez980-matnr

kunnr = li_basez980-kunnr

werks = li_basez980-werks

vkorg = li_basez980-vkorg binary search.

if sy-subrc ne 0.

i_z980-spmon = l_spmon.

i_z980-matnr = li_basez980-matnr.

i_z980-kunnr = li_basez980-kunnr.

i_z980-werks = li_basez980-werks.

i_z980-vkorg = li_basez980-vkorg.

i_z980-basme = li_basez980-basme. " 8/6/07

i_z980-waers = c_waers.

i_z980-cpudt = v_datum.

i_z980-cputm = v_uzeit.

i_z980-znetsalekg = 0.

i_z980-znetsalevl = 0.

insert i_z980 index sy-tabix.

clear i_z980.

endif.

endloop.

When run my report in Foreground it runs fine. But when i run the same report in Background job gets cancelled when the index reaches to 228984 once 230070 once and 230104 once at insert statement i.e " insert i_z980 index sy-tabix." . I found this by debugging the Job.

Please help me if you know the solution.

Regards,

Ravikumar P

Edited by: Ravikumar P on Mar 30, 2010 4:40 PM

Re: Insert ITAB INDEX SY-TABIX Problem

Former Member — Tue, 30 Mar 2010 14:41:45 GMT

What does the job log say?

Re: Insert ITAB INDEX SY-TABIX Problem

Former Member — Tue, 30 Mar 2010 14:43:07 GMT

Job log is

Date Time Msg.ID Message

03/30/2010 10:02:49 00516 Job started

03/30/2010 10:04:13 00554 Job also cancelled due to process termination. See the system log

Re: Insert ITAB INDEX SY-TABIX Problem

Former Member — Tue, 30 Mar 2010 14:50:43 GMT


> See the system log

So, what does the system log say??

Rob

Re: Insert ITAB INDEX SY-TABIX Problem

Former Member — Tue, 30 Mar 2010 15:20:38 GMT

System log:

10:06:06 D2 088 PAKALRA SM37 R0L S Program set manually to debug mode by user BACKJOB

10:09:27 B4 088 BACKJOB Q0E K Signal 4 received by operating system

10:09:27 B4 088 BACKJOB R68 W Perform rollback

10:09:27 B4 088 BACKJOB AB2 X > Program ZSDUZ980, Include ZSDUZ980, line 1171

10:09:27 B4 088 BACKJOB AB0 T Run-time error getwa_abswa

10:09:27 B4 088 BACKJOB Q02 S Stop Workproc 4, PID 23796

10:09:47 B4 Q01 S Start Workproc 4, 12 times since system startup. PID 23800

10:09:47 B4 088 BACKJOB F6F W TemSe object JOBLGX10055001X43418 was closed remotely

10:09:47 B4 088 BACKJOB R47 K Delete session 001 after error 023

Re: Insert ITAB INDEX SY-TABIX Problem

former_member302911 — Tue, 30 Mar 2010 15:25:21 GMT

HI,

Sorry for mistake, i haven't seen internal table.

Angelo.

Re: Insert ITAB INDEX SY-TABIX Problem

Clemenss — Tue, 30 Mar 2010 16:10:57 GMT

Hi Ravi,

in ST22 you will probably see a short dump that tells you that no more memory space could be allocated.

This happens if you hold too many data in internal tables or it is a programming error like appending to internal table within loop.

- avoid SELECT *

- process packages

Regards,

Clemens

Re: Insert ITAB INDEX SY-TABIX Problem

Subhankar — Tue, 30 Mar 2010 19:28:13 GMT

Hi,

This is happening because after read you inserting the records when sy-surbc <> 0. At that time did you check the sy-tabix value. This value is comming correctly. You directly append the same.

loop at li_basez980.

read table i_z980 with key spmon = l_spmon

matnr = li_basez980-matnr

kunnr = li_basez980-kunnr

werks = li_basez980-werks

vkorg = li_basez980-vkorg binary search.

if sy-subrc ne 0.

i_z980-spmon = l_spmon.

i_z980-matnr = li_basez980-matnr.

i_z980-kunnr = li_basez980-kunnr.

i_z980-werks = li_basez980-werks.

i_z980-vkorg = li_basez980-vkorg.

i_z980-basme = li_basez980-basme. " 8/6/07

i_z980-waers = c_waers.

i_z980-cpudt = v_datum.

i_z980-cputm = v_uzeit.

i_z980-znetsalekg = 0.

i_z980-znetsalevl = 0.

insert i_z980 index sy-tabix.

clear i_z980.

endif.

endloop.

Re: Insert ITAB INDEX SY-TABIX Problem

Former Member — Wed, 31 Mar 2010 04:54:30 GMT

Assuming "i_z980" is the internal table, use "Append i_z980" instead of "Insert i_z980 index sy-tabix".

Regards

Vinod

Re: Insert ITAB INDEX SY-TABIX Problem

Former Member — Wed, 31 Mar 2010 06:11:02 GMT

But the same program when run in foreground is running fine with no memory overflows.