topic Re: Timit limit exceeded and run time exception while retrieving data from Data in Application Development and Automation Discussions

Timit limit exceeded and run time exception while retrieving data from Data

Former Member — Wed, 01 Mar 2006 05:06:45 GMT

Hi All,

We have a requirement to retrieve data from MSEG table using AUFNR (not primary key in MSEG).

When we are doing so, getting dump saying ‘Time limit exceeded’.

Using secondary index also, encountering the same problem.

If any one knows the optimal solution, kindly request you to let us know.

Thanks and Regards,

Katta Mohan Reddy

Re: Timit limit exceeded and run time exception while retrieving data from Data

hymavathi_oruganti — Wed, 01 Mar 2006 05:13:30 GMT

try using primary keys

MBLNR etc

Re: Timit limit exceeded and run time exception while retrieving data from Data

Former Member — Wed, 01 Mar 2006 05:21:16 GMT

Hi,

My requirement does not want to retrieve the data by using primiry of that table.

Thanks

Mohan

Re: Timit limit exceeded and run time exception while retrieving data from Data

hymavathi_oruganti — Wed, 01 Mar 2006 05:28:20 GMT

then build some more secondary indeces, so that the retrieval becomes more precise. that is the only solution.

Re: Timit limit exceeded and run time exception while retrieving data from Data

Former Member — Wed, 01 Mar 2006 05:46:26 GMT

Hello Katta,

As AUFNR is not primary key it is reading through each and every record in MSEG. Couple of things.

1. U can create an alternative index for AUFNR. However I am not sure if u are allowed to bcoz of Basis restirctions. Secondly creating an alternate index is also a burden on DB. But apart form this as u indicate that even using secondary index u are encountering the same problem, try using SQL trace and find out which index is DB using. It might be using a wrong index. If so force it to use ur index.

2. If u are just retriving records then u may think of splitting in batches and reading.

Re: Timit limit exceeded and run time exception while retrieving data from Data

Former Member — Wed, 01 Mar 2006 13:32:14 GMT

Dear Katta Mohan Reddy,

I think the dump ‘Time limit exceeded’is caused because you are processing the transaction online. There is a setting which permits online transactions to run for only a predetermined time. Have you tried running in the background? (using a variant).