topic Re: Select gives timedout error in Application Development and Automation Discussions

Select gives timedout error

former_member382337 — Fri, 19 Oct 2007 17:08:57 GMT

Hi,

I had a select statement like this:

select * from ausp where attin = '123'. Since this table(ausp) has got some 1500+ entries for a particular attin, this select gave timed out error.

Instead of using select I modified my query as:

OPEN CURSOR g_cursor FOR

SELECT * FROM ausp where attin = '123'.

FETCH NEXT CURSOR g_cursor

APPENDING CORRESPONDING FIELDS OF TABLE lt_participants.

IF SY-SUBRC <> 0.

CLOSE CURSOR g_cursor.

ENDIF.

Even after using cursor, the query gives timedout error.

There are few more key entries in the table, but I dont have those values when i do the select, so I have to select with just one where condition. Is there is any other way I can select the values from this table without giving timedout error.

Thanks for your help.

Regards, Sathish R

Re: Select gives timedout error

Former Member — Fri, 19 Oct 2007 17:12:17 GMT

Change you select WHERE Condition. It says ATTIN but the field name is ATINN. That is causing the problem.

Re: Select gives timedout error

Former Member — Fri, 19 Oct 2007 17:24:22 GMT

Because you haven't included KLART in the WHERE.

Rob

Re: Select gives timedout error

former_member382337 — Mon, 22 Oct 2007 04:54:26 GMT

Hi Ashis,

It was a typo. I am using the right field name in my select condition. I am not getting short dump, I am getting timed out error.

Regards, Sathish R

Re: Select gives timedout error

Former Member — Mon, 22 Oct 2007 04:57:09 GMT

Instead of SELECT *, can you just populate required fields? Also can you add some more conditions in WHERE clause like for which Class you want to fetch the characteristics values?

Re: Select gives timedout error

kiran_k8 — Mon, 22 Oct 2007 05:04:16 GMT

Sathish,

See to that you use only primary key or index fields in the where clause of the select query so that it enhances the performance and thus avoids time out errors.

K.Kiran.

Re: Select gives timedout error

Former Member — Tue, 23 Oct 2007 15:26:19 GMT

Before the Select statement use the conversion exit for the field ATINN.

Call Fm ---> CONVERSION_EXIT_ATINN_INPUT

with input -

> '123'

feed the result of this into your Select statement like this

SELECT * FROM AUSP where ATINN = output_of_conversion_exit.

The reason it is timing out is because the field ATINN has a non-standard conversions.

Let me know if that worked.

PS - also use SE16 to see if you are able to get a result for the same Select statement.