Regarding Dump Analysis

[Former Member]

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.

[Former Member]

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

[Former Member]

because of huge data

[Former Member]

hi,

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

Thanks

Seema

[umashankar_sahu]

Hello Dear,

Please Check below link

[]

[Former Member]

Hi Madhav,

Optimize your code.

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

Howard.

[Former Member]

Madhav,

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

Thanks

Bala Duvvuri