While working on previews application I noticed something else.
Suddenly the result table in query page started to refresh every time I selected a row.
Also when I had scroll down in the results and selected a row the visible range whas returned back to the first page and I could not see the selected row.
I looked at the history of page and I didnt see anything strange, just I had added in a point a navigation button in the collection.
I checked the history in bindings and there I found the difference:
iterator Binds="EmployeesView1" RangeSize="25"
DataControl="AppModuleDataControl" id="EmployeesView1Iterator"
ChangeEventPolicy="ppr"
after removing ChangeEventPolicy="ppr" the table behaved correctly again.
I also notice in the detail log(-Djbo.debugoutput=console) the following:
[9421] !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
[9422] ! ERROR: Use of pinDataControl
[9423] ! is not supported. Pinning the !
[9424] ! DataControl will result in severe!
[9425] ! performance issues. !
[9426] !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
I don't know if it is related but it doesn't seems good.
So is this a bug?
We should not use ChangeEventPolicy="ppr" for iterators used in tables?
If not why it is set automatically when you drag and drop some iterator operations?
I reproduced the problem in a simple test case with just departments table
http://adfbugs.googlecode.com/files/TestPPR.zip
Metalink:
Bug No: 7233400 AUTOPPR: TABLE REREFRESHES UNNECESSARILY
Status: Scheduled for Future Release
Does not reproduce in Jdeveloper 11.1.2
Clicking in a row in a table shouldn't normally cause a refresh of the table. Please submit a simple testcase to worldwide support that they can triage to investigate what is specific about your case. I tried creating both a new read-only table and editable table, and out of the box just having ChangeEventPolicy=PPR didn't cause a table refresh on row select, so there must be something else about your testcase that we need to pinpoint.
ReplyDeleteSee comments in this thread about this unnecessarily alarming diagnostic message. There is nothing to worry about in actual fact.
http://forums.oracle.com/forums/thread.jspa?threadID=842205
Thanks Steve,
ReplyDeleteI reproduced the problem in a simple test case.
May be the problem is that i use panelCollection and partial trigers are automaticaly created.
Anyway i also created an SR for this.
We have hit to this problem many times in the application we create.
Some news for this issue? Is it a bug and will it fixed in PatchSet 1?
ReplyDeletekind regards
There are 2 bugs in metalink about it:
ReplyDeleteBug No: 7233400 AUTOPPR: TABLE REREFRESHES UNNECESSARILY
Status Scheduled for Future Release
Bug No: 8736426 AUTOPPR: ADF TABLE REFRESHES WHEN CHANGEEVENTPOLICY="PPR" IN PAGEDEF.XML Status Duplicate Bug. To Filer
So i guess its not fixed yet
Hi Milkbird,
ReplyDeletemany thanks for fast answer. I hope they fix it in PatchSet 1.
kind regards
Thanks for this!
ReplyDeleteIncidentally, bug 7233400 now states fixed in 11.1.2.
Cheers
Unfortunately from what i heared 11.1.2 will be out late this year
ReplyDelete