# Pivot Issue with Toad Workbook 5.2.0.276 - Query Spins Indefinitely

**URL:** <https://forums.toadworld.com/t/pivot-issue-with-toad-workbook-5-2-0-276-query-spins-indefinitely/53081>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [June 22, 2021, 10:43pm UTC](https://forums.toadworld.com/t/pivot-issue-with-toad-workbook-5-2-0-276-query-spins-indefinitely/53081 "2021-06-22T22:43:31Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![la\_grey](https://avatars.discourse-cdn.com/v4/letter/l/d2c977/32.png) [@la\_grey](https://forums.toadworld.com/u/la_grey)\
**Post date:** [June 22, 2021, 10:43pm UTC](https://forums.toadworld.com/t/pivot-issue-with-toad-workbook-5-2-0-276-query-spins-indefinitely/53081/1 "2021-06-22T22:43:31Z")

</div>

A workbook contains 4 Pivots and is executed to only return 1000 rows. The query returns the data and the cleanse process completes successfully. However, only 2 of the 4 pivots complete successfully. The remaining 2 pivots continue to spin. The only difference I see with the 2 pivots that aren't completing is that they have additional filters on them. Is there a way to determine why the 2 pivots run indefinitely?

---

<div class="post-metadata">

**Author:** ![la\_grey](https://avatars.discourse-cdn.com/v4/letter/l/d2c977/32.png) [@la\_grey](https://forums.toadworld.com/u/la_grey)\
**Post date:** [June 25, 2021, 7:56pm UTC](https://forums.toadworld.com/t/pivot-issue-with-toad-workbook-5-2-0-276-query-spins-indefinitely/53081/2 "2021-06-25T19:56:02Z")

</div>

The data is being returned from the database. Is there a way to view the logic the pivots are generating in version 5.2.0.276? We are going to upgrade to version 5.4 to see if that resolves the issue.

---

<div class="post-metadata">

**Author:** ![Julie\_Hyman](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/julie_hyman/32/13709_2.png) [@Julie\_Hyman](https://forums.toadworld.com/u/Julie_Hyman)\
**Post date:** [July 1, 2021, 6:52pm UTC](https://forums.toadworld.com/t/pivot-issue-with-toad-workbook-5-2-0-276-query-spins-indefinitely/53081/3 "2021-07-01T18:52:31Z")

</div>

Hi la\_grey,

Very curious to know if this was resolved for you in Toad Data Point 5.4. We did some significant work with pivots in that Toad Data Point release. One thing to look at is how you are summarizing the data in the 2 pivots that won't complete - are use using **distinct count** or **list agg** summaries?

---

<div class="post-metadata">

**Author:** ![la\_grey](https://avatars.discourse-cdn.com/v4/letter/l/d2c977/32.png) [@la\_grey](https://forums.toadworld.com/u/la_grey)\
**Post date:** [July 1, 2021, 8:12pm UTC](https://forums.toadworld.com/t/pivot-issue-with-toad-workbook-5-2-0-276-query-spins-indefinitely/53081/4 "2021-07-01T20:12:35Z")

</div>

The upgrade seems to have helped. However, not all of our employees may be able to upgrade to 5.4. According to the SQL, the query is not using a distinct(count) or list agg. Is there another way to confirm how the data is being summarized? Are you aware of a way to view the logic/processing that's being generated behind the individual pivots, similar to how we can see the SQL that's generated?