topic Re: help in dump in Application Development and Automation Discussions

help in dump

Former Member — Wed, 14 May 2008 08:59:24 GMT

hi,

i do this select and when i have in range table (pro_tab) lot of recoreds

above 1000 i have dump .

how can i avoid that?

SELECT dimybproject COUNT(*) AS cnt

FROM /bic/0czempl

INTO CORRESPONDING FIELDS OF TABLE it_em

WHERE dim0calmonth GE res_per

AND dim0calmonth LE st_date

AND dimybproject IN pro_tab

GROUP BY dimybproject.

Regards

Re: help in dump

Sm1tje — Wed, 14 May 2008 09:06:03 GMT

the only way to avoid this is to limit the number of entries in your select options.

Re: help in dump

Former Member — Wed, 14 May 2008 09:06:24 GMT

ranges or select options cannot have a lot of records in low ..

pro_tab-low ..

U can have them in a range ..

say from 1 to 100000 ... but cannot have values only in low..

If possible give the values in a range ..

Re: help in dump

Former Member — Wed, 14 May 2008 09:13:47 GMT

Hi,

avoid LE, GE

handel them after selection, no of records u r saying is not too much it should work with it, try to find out other cause of the dump .

Regards

Bikas

Re: help in dump

Former Member — Wed, 14 May 2008 09:22:56 GMT

hi,

Add Package size in your select statement.

so your select query will fatch the data into packages.

Re: help in dump

Former Member — Wed, 14 May 2008 09:26:15 GMT

Hello,

You need to change ur select statment like this.


loop at pro_tab.
SELECT dimybproject COUNT(*) AS cnt
FROM /bic/0czempl
INTO CORRESPONDING FIELDS OF TABLE APPENDIND it_em " CHECK HERE
WHERE dim0calmonth GE res_per
AND dim0calmonth LE st_date
AND dimybproject EQ pro_tab-low " Check here
GROUP BY dimybproject.
endloop.

Re: help in dump

Former Member — Wed, 14 May 2008 09:43:58 GMT

Thanks Vasanth ,

how i write this commend right?

INTO CORRESPONDING FIELDS OF TABLE APPENDIND

Regards

Re: help in dump

Former Member — Wed, 14 May 2008 09:50:20 GMT

Hello,

Sorry, Change the syntax like this.


loop at pro_tab.
SELECT dimybproject COUNT(*) AS cnt
FROM /bic/0czempl
INTO CORRESPONDING FIELDS OF  APPENDING TABLE it_em " CHECK HERE
WHERE dim0calmonth GE res_per
AND dim0calmonth LE st_date
AND dimybproject EQ pro_tab-low " Check here
GROUP BY dimybproject.
endloop.

Cheers,

Vasanth

Re: help in dump

Former Member — Wed, 14 May 2008 09:58:06 GMT

Hi,

Thanks it work but the problem that it don't to count

for employee .

the table have 2 field cnt is emplyee

project cnt

e0011 2

e0022 5

what i miss?

Regards

Re: help in dump

Former Member — Wed, 14 May 2008 10:07:15 GMT

Hi,

Its better to debug the code. Put a breakpoint at the select statement and check.

See if u can give any other conditions for the selection criteria.

According to my knowledge there wont be dumps for jus 1000 records. when we had this kind of situation the records were crossing 750000 or so entries. There were some select queries where in the condition had not been mentioned accordingly..so corrected those mistakes n it was all fine.

Hope this small piece of info helped u....

Regards,

Ramya