By using this website, you agree to our Terms of Use (click here)
while i am creating a pivot table or edit a pivot table, when i try to drag a data field to Rows, Columns, Filters or Values, i get this error message:
*An unhandled exception has occurred in the function 'MoveNext'. Please see the trace log for more details.*
hi Tim, thank you for the feedback.
we are having the similar role configuration; the administrator for pivot table screen sm208020 is delete right.
actually we are facing this error after upgraded from 2019R2 to 2021R2.
after this version upgrade, in the pivot table screen once we drag any field OR in the pivot table that created with save as pivot from the generic inquiry will generate this error message.
hopefully can get assistant from this forum.
thank you.
If you use Tools -> Trace, sometimes you can get lucky and get more info regarding this error.
If I had to guess, there's an issue somewhere in the configuration of your GI due to the schema change of UserID from a GUID type to Int type, which happened in version 2020R2. You would see something about an error with type conversion in the trace logs. You will need to review your columns, conditions, relations, parameters (if they are using one of those column schemas), etc. looking for anywhere UserID, OwnerID, or @me is used and correct it. Once that is OK, review your filters for the same if the error persists. If you have any customizations, you might want to have those reviewed as well.
It could even be something in the pivot table's configuration.
hello tclaw
I have the same problem in 21R2, have you found a solution?
