Friday, July 24, 2009

Partial Page Rendering ChangeEventPolicy="ppr" bug. (Fixed in 11.1.2)

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

7 comments:

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

    See 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

    ReplyDelete
  2. Thanks Steve,
    I 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.

    ReplyDelete
  3. Some news for this issue? Is it a bug and will it fixed in PatchSet 1?

    kind regards

    ReplyDelete
  4. There are 2 bugs in metalink about it:
    Bug 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

    ReplyDelete
  5. Hi Milkbird,

    many thanks for fast answer. I hope they fix it in PatchSet 1.

    kind regards

    ReplyDelete
  6. Thanks for this!

    Incidentally, bug 7233400 now states fixed in 11.1.2.

    Cheers

    ReplyDelete
  7. Unfortunately from what i heared 11.1.2 will be out late this year

    ReplyDelete