topic Re: Regarding Dump Analysis in Application Development and Automation Discussions

Regarding Dump Analysis

Former Member — Wed, 19 May 2010 04:16:56 GMT

My select statement is working very fine in Development client, when it is transported to Production client, it is showing dump error because of huge data. how to rectify this error.

Re: Regarding Dump Analysis

Former Member — Wed, 19 May 2010 04:19:31 GMT

Hi Madhav,

If the dump is a time out dump, then it's performance issues and one possible solution is to run the report in background and draw out the report (as long as output is not interactive).

If the dump is not a time out dump, then study the dump more closely, especially if the query is on a Z table because there might be some field/ data element not transported across to Q and hence causing the dump.

Hope this helps!

Cheers,

Aditya

Re: Regarding Dump Analysis

umashankar_sahu — Wed, 19 May 2010 04:23:24 GMT

Hello Dear,

Please Check below link

[]

Re: Regarding Dump Analysis

Former Member — Wed, 19 May 2010 05:02:11 GMT

because of huge data

Re: Regarding Dump Analysis

Former Member — Wed, 19 May 2010 05:06:29 GMT

hi,

Try to optimise your query. If you could paste the query here, we might suggest the reason.

Thanks

Seema

Re: Regarding Dump Analysis

Former Member — Wed, 19 May 2010 05:13:53 GMT

Hi Madhav,

Optimize your code.

Post the data fetching part of your code. Lets see if could find some workarounds..

Howard.

Re: Regarding Dump Analysis

Former Member — Wed, 19 May 2010 05:26:46 GMT

Madhav,

check the sql traces in st05 ,st01 and see which statement is taking more time

Thanks

Bala Duvvuri