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

[Former Member]

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

[hymavathi_oruganti]

try using primary keys

MBLNR etc

[Former Member]

Hi,

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

Thanks

Mohan

[hymavathi_oruganti]

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

[Former Member]

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.

[Former Member]

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).