OraFAQ Forum: Forms » Form hangs when scroll bar reaches the last record in detail block

Home » Developer & Programmer » Forms » Form hangs when scroll bar reaches the last record in detail block (Forms 6.0.8.28.0, used for Oracle EBS 11i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Form hangs when scroll bar reaches the last record in detail block [message #470172]

Mon, 09 August 2010 04:22

abhikv
Messages: 4
Registered: February 2006
Location: Dubai

Junior Member

Hi,

I'm having a multi-record detail block in my form and after querying the form, when I scroll through the scroll bar, it is hanging (freezing) just before reaching the last record.

I have noticed that it never hangs if I use arrow keys to scroll between the records. It only hangs when I use scroll bar or page down key.

Regardless of the number of records fetched, it only hangs when I click the scroll bar (or press page down key) to fetch the last record.

It happens to all my custom forms and I'm developing this for Oracle EBS Apps 11.5.10.2. Oracle JInitiator Version is 1.3.1.21 and my form builder is Forms 6.0.8.28.0.

I'm attaching the form for your reference.

Thanks,
Abhi

Attachment: XXPIDQF.fmb
(Size: 676.00KB, Downloaded 1061 times)

Report message to a moderator

Re: Form hangs when scroll bar reaches the last record in detail block [message #470173 is a reply to message #470172]

Mon, 09 August 2010 04:28

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

Best guess - page down is causing it to query the next set of records and this is taking a long time.
Try setting the "query all records" block property to Yes and see what happens.

Report message to a moderator

Re: Form hangs when scroll bar reaches the last record in detail block [message #470209 is a reply to message #470173]

Mon, 09 August 2010 05:52

abhikv
Messages: 4
Registered: February 2006
Location: Dubai

Junior Member

Thanks,

I tried all possible combination with Query Array Size, Number of Records Buffered, Number of Records Displayed and Query All Records. Still the issue persists.

If 100 records queried in this block and Number of Records Displayed is 10 then, the form will hang only on the 10th click on scroll bar or 10th press on "Page Down" key.

If 15 records queried then, the form will hang on the first click itself on scroll bar.

Regards,
Abhi

Report message to a moderator

Re: Form hangs when scroll bar reaches the last record in detail block [message #470213 is a reply to message #470209]

Mon, 09 August 2010 05:59

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

Did you try setting query all records to Yes?

Report message to a moderator

Re: Form hangs when scroll bar reaches the last record in detail block [message #470214 is a reply to message #470213]

Mon, 09 August 2010 06:00

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

Ok so have done that.
I would expect it to hang when populating the first set of records if that's set to Yes.
Did it?

Report message to a moderator

Re: Form hangs when scroll bar reaches the last record in detail block [message #470218 is a reply to message #470209]

Mon, 09 August 2010 06:08

abhikv
Messages: 4
Registered: February 2006
Location: Dubai

Junior Member

If I set Query All Records = 'Yes' then the form hangs at the time of "Execute_Query" itself.

Report message to a moderator

Re: Form hangs when scroll bar reaches the last record in detail block [message #470226 is a reply to message #470218]

Mon, 09 August 2010 06:19

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

So it's querying all the records that's taking a long time.

You need to do the following:

Use trace your form session in the database.
Get the exact query forms is issuing.
Get the explain plan for that query.
Post the query and the explain plan here.

If you don't know how to do any of the above let us know.

Report message to a moderator

Re: Form hangs when scroll bar reaches the last record in detail block [message #470231 is a reply to message #470226]

Mon, 09 August 2010 06:29

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

Just remembered there's a way of getting the query without tracing the session. Do the following:

Change all the settings so that it'll do the first query without hanging.

Add a text item to one of the blocks. Make it visible on screen. Set it's max length to 4000. Set it's database item property to No.
Create a button, stick it on the canvas. Add the following WHEN-BUTTON-PRESSED trigger.

<new text item you just created> := get_block_property('<name of block with the problem>', last_query);

Run the form.
Execute the query.
Press the button.
Copy the text that appears in the new item.

Report message to a moderator

Re: Form hangs when scroll bar reaches the last record in detail block [message #470236 is a reply to message #470231]

Mon, 09 August 2010 06:40

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Just a hint.
You can get the last query, from Help -> Diagnostics.
Block -> SYSTEM
Field -> LAST_QUERY

By
Vamsi

Report message to a moderator

Re: Form hangs when scroll bar reaches the last record in detail block [message #470255 is a reply to message #470236]

Mon, 09 August 2010 07:42

abhikv
Messages: 4
Registered: February 2006
Location: Dubai

Junior Member

Thanks to all,

When i tried with Query All Records = 'Yes' alone it was hanging. Now I gave Query Array Size = 1000, Number of Records Buffered = 1000 and Query All Records = 'Yes'. This combination fixed the issue.

Thanks a lot for the support,
Abhi

Report message to a moderator

Previous Topic:	Show the message in form pesonalization
Next Topic:	FMX to FMB ?!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 17:23:43 CDT 2024