topic Re: Modify Query Issue in Application Development and Automation Discussions

Modify Query Issue

koushikking — Tue, 19 Apr 2016 08:59:15 GMT

Hi Experts,

I have situation where i must use modify query inside loop( modify ztable from table itab ), in development server query is working fine but in quality when control moves modify query it is stops and no further execution is happening. Please anyone guide me on this issue.

Re: Modify Query Issue

Former Member — Tue, 19 Apr 2016 09:06:27 GMT

Hi,

Can you get the screenshot of what is happening in the debugger.

May be the table (Ztable) is not transported in the quality or the data is huge to be modifies in the loop.

Hope this helps.

Re: Modify Query Issue

koushikking — Tue, 19 Apr 2016 09:17:45 GMT

Hi,

The table is already there in quality, i have added some extra fields and then again transported.

Re: Modify Query Issue

Austin_D_Costa — Tue, 19 Apr 2016 09:22:54 GMT

Hello Koushik,

Even i have faced the same problem!!! But Didn't get he solution for that.

Have you checked with the table!!!

Re: Modify Query Issue

koushikking — Tue, 19 Apr 2016 09:31:20 GMT

Hi Austin,

I Checked and everything fine with the table.

Re: Modify Query Issue

Former Member — Tue, 19 Apr 2016 10:25:40 GMT

Check, if this thread can help.

ABAP program freezes on MODIFY dbtab from wa | SCN

Re: Modify Query Issue

pranay570708 — Tue, 19 Apr 2016 10:56:44 GMT

Check DB lock in DB01 tcode.

Re: Modify Query Issue

Former Member — Tue, 19 Apr 2016 10:57:03 GMT

Have you also checked, if the table really exists on the database.

Go to SE11 -> Open your table (display) -> Menu -> Utilities -> Database Object -> Database Utility

Re: Modify Query Issue

koushikking — Tue, 19 Apr 2016 14:35:55 GMT

Hi Armin,

Yeah, i did Checked and it exists.

Re: Modify Query Issue

Former Member — Tue, 19 Apr 2016 15:30:10 GMT

How many records are there in table LT_META_I?

Rob

Re: Modify Query Issue

koushikking — Mon, 02 May 2016 07:49:23 GMT

Hi All,

Sorry for the late reply,

i found the solution, it is stopping because the table has been locked.

Thanks all for your replys