AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Acumatica Generic I...
An unhandled except...
 
Notifications
Clear all

Questions An unhandled exception has occurred in the function 'MoveNext'. Please see the trace log for more details.

 
Acumatica Generic Inquiries & Pivot Tables
Last Post by jfbrut 4 years ago
5 Posts
4 Users
2 Reactions
3,271 Views
RSS
tclaw
Posts: 7
 tclaw
Topic starter
January 15, 2022 3:36 am
(@tclaw)
Active Member
Joined: 6 years ago

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


4 Replies
Tim Rodman
Posts: 3193
 Tim Rodman
Admin
January 15, 2022 8:20 pm
(@timrodman)
Famed Member
Joined: 10 years ago

This isn't your error message so it might not be helpful, but maybe it's related:

https://www.augforums.com/forums/acumatica-generic-inquiries/error-or-blank-screen-when-creating-a-pivot-table-on-a-generic-inquiry


Reply
tclaw
Posts: 7
 tclaw
Topic starter
January 16, 2022 8:58 pm
(@tclaw)
Active Member
Joined: 6 years ago

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.


Reply
Wyatt.ERP
Posts: 128
 Wyatt.ERP
January 17, 2022 2:16 pm
(@wyatt-erp)
Estimable Member
Joined: 6 years ago

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. 


Reply
Tim Rodman reacted
jfbrut
Posts: 3
 jfbrut
May 9, 2022 10:15 am
(@jfbrut)
Active Member
Joined: 5 years ago

hello tclaw

I have the same problem in 21R2, have you found a solution?


Reply
Tim Rodman reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,526 Topics
  • 10.9 K Posts
  • 34 Online
  • 2,412 Members
Our newest member: thollings
Latest Post: Attribute Input Mask
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

 No online members at the moment

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2025 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×