5 Replies Latest reply: Oct 1, 2015 5:08 AM by Mark Kite RSS

    Unexpected exception occurred on Ajax Pivot Table

    Jarno Loubser

      We have a pivot table with the following dimensions and expressions:

      • Aircraft Type (dimension  - Vertical)
      • Aircraft MSN (dimension  - Vertical)
      • Contract No (dimension  - Vertical)
      • Appraisal Year (dimension  - Horizontal)
      • Avg Appraised Forecast Value (expression)
      • Avg Appraised Value (expression)


      We get the error above when scrolling right to year 2020 (first year being 2003) and right-clicking somewhere in the grid. The error does not occur when right clicking prior to scrolling to the right. The amount of right scroll to produce the error is also not consistent, but the error never occurs without at least some right scrolling.

        • Re: Unexpected exception occurred on Ajax Pivot Table
          Mark Kite

          I've had the same thing - also noticing that the cells affected don't apply filtering when clicked in the web-view, either when running the document with the Personal Edition or from the server.


          As with you I've three vertical dimensions and one horizontal dimension.


          What I've noticed is that the position of the first failure is always the 37th data (non-dimension) column in the pivot.  If you try yours, with two data columns per Appraisal Year, I expect you'll find that the message doesn't appear for Forecast for 2021 but does for the Appraised Value.  Can you confirm this please?


          I've knocked up a QV document to test this and it's consistent - two, three, four, five data columns tested and in each case the error first appears on the 37th column.


          I have a slight suspicion that this might be a bug.  However, perhaps there's some hidden configurable thing somewhere, "Don't add functionality past column 36 of pivot tables"?