1 Reply Latest reply: Jan 28, 2013 8:48 PM by scott.wesley RSS

    Reset Pagination

    user13653962
      every now and then i got the message to run a drill down report why?
      Invalid set of rows requested, the source data of the report has been modified.
      Reset Pagination 
        • 1. Re: Reset Pagination
          scott.wesley
          The example is generally if you've "paginated" (eg: clicked 'next 50 rows') onto 2nd page.
          Then you link to the same page later on without clearing pagination and have smaller number of rows in report - it attempts to render 2nd page of results when you might only have one page.

          Documentation here doesn't have much detail regarding Reset Pagination, but it's a checkbox option on many links
          http://docs.oracle.com/cd/E37097_01/doc/doc.42/e35125/bldapp_rpt_att.htm#BCEDFBGH

          It is also one of the clearcache options in your parameter list (RP) app:page:session:request:debug:clearcache:items

          You'll probably get more info about it here, and the "Clearing session state" link
          http://docs.oracle.com/cd/E37097_01/doc/doc.42/e35125/concept_url.htm#BCEDJBEH

          Scott