Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

GP 2010: 'sa' account hung up, 'ASI_SOP_HDR_MSTR_Explorer' unknown error (39)

(0) ShareShare
ReportReport
Posted on by 25

Hi,

Since about a week ago (or more, I don't access 'sa' account all that frequently) whenever I try to log-in to my 'sa' account on GP 2010 it freezes up for about 30 minutes. It enters the company, it loads the Microsoft Dynamics GP menu, it loads the Navigation Pane, and it loads the Home Page before freezing up.

In 30 minutes I get the following error:

"Unhandled database exception: A save operation on table 'ASI_SOP_HDR_MSTR_Explorer' has caused an unknown error (39).

EXCEPTION_CLASS_DB

DB_ERR_UNKNOWN"

GP2010saError.png

This error only occurs on the 'sa' account as far as I can tell, and it occurs on different work stations. All other users seem to log-in without a problem.

Anyone know what may be causing this and how to fix it?

Thanks!

*This post is locked for comments

  • CelticsDresden Profile Picture
    CelticsDresden 25 on at
    RE: GP 2010: 'sa' account hung up, 'ASI_SOP_HDR_MSTR_Explorer' unknown error (39)

    Richard and Leslie,

    Thanks for all the help, it was greatly appreciated. What saved the day was really laziness. Since the Dynamics database is so small, I was too lazy to delete months of daily backups, so once I found a back-up that worked, the process became a bit simpler.

    I've never worked with SQL and my knowledge of Dynamics itself is very limited, so this was a good learning experience in all.

    But once again, thanks for all the help and taking your time to advice me to try and fix the issue.

    Thanks!

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,788 Moderator on at
    RE: GP 2010: 'sa' account hung up, 'ASI_SOP_HDR_MSTR_Explorer' unknown error (39)

    I am sure that buried in the code someplace is a case statement or if statement that looks to see if the user is 'sa' and then the roles assigned. Then what it must do is break out into some search that was essentially an endless loop. These can be the hardest to find as you just discovered. Good work in tracking it down. This one was surely was a mystery.

  • Verified answer
    CelticsDresden Profile Picture
    CelticsDresden 25 on at
    RE: GP 2010: 'sa' account hung up, 'ASI_SOP_HDR_MSTR_Explorer' unknown error (39)

    Hi,

    The report still exists, but I fixed the problem.

    All I had to do was go into "Microsoft Dynamics GP" ->"User Preferences" -> "Reminders".

    In there there's a table with "Custom Reminders" and I deleted the one that corresponded to the Smart List Report that was causing the problem. And all is working now.

    When one creates a Smart List Report and adds it to Favorites, it gives you an option to add the Report to Favorites as well to add a Reminder for it. Not sure why creating this reminder caused the problem.

    In any case, this is what I think was happening:

    The Reminder was causing to execute the Smart List Report query (or searching the database to meet some conditions) upon 'sa' logging-in. The report existed and was working, but it was doing a 4,000,000+ searches. Which was the main problem, this kept going on until the error of 'ASI_SOP_HDR_MSTR_Explorer' showed up.

    If the 'ASI_SOP_HDR_MSTR_Explorer' table is a memory table as you guys have mentioned, then maybe those 4,000,000 or so lines kept going until it couldn't hold anything more in memory, so the error showed up, stopped the report from running and let me continue using Dynamics as normal for the reminder of the session. Just a theory.

    Now why only when 'sa' was in Power User? I noticed that if I don't select Power User, there's a menu item under "Microsoft Dynamics GP" called "Reminders" that doesn't show up, but it does show up if I'm a Power User (note: this is not the same window under 'User Preferences').

    By simply clicking that menu item, it seems to reproduce the problem mentioned above. So I think there's a link to that.

    In any case, that was the problem. The reminder was causing a search to meet certain condition, and that search of the database reproduced 4,000,000+ of database queries or so in a span of 27 minutes or so until it couldn't handle it anymore while hanging up program in the process.

    Does any of this make sense to you?

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,788 Moderator on at
    RE: GP 2010: 'sa' account hung up, 'ASI_SOP_HDR_MSTR_Explorer' unknown error (39)

    Perhaps a SmartList favourite got setup for 'sa' but then somehow that report got deleted so when you log in as 'sa' it is looking for a report that no longer exists.

  • CelticsDresden Profile Picture
    CelticsDresden 25 on at
    RE: GP 2010: 'sa' account hung up, 'ASI_SOP_HDR_MSTR_Explorer' unknown error (39)

    Found another table that when restored, it gave me access to DYNAMICS without delay:

    SY01500

    This table only has 1 row.

    The difference between my non-functioning database and my backup was found in column "NOTEINDX".

    Also this single row table has 'sa' under LSTUSRED column.

     

    EDIT:

    Seems like I may have spoken too soon. Maybe it's SY01404.

    In any case, I'll keep doing more testing in the meantime to keep narrowing down.

    EDIT 2:

    Confirmed, cleaning up SY01404 also corrects the problem.

    Still doing further testing, but here's what I've found with SY01404.

    It contains information found in ASIEXP81:

    Report_Option_Name: DELETED TRX

    USERNAME: sa

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,788 Moderator on at
    RE: GP 2010: 'sa' account hung up, 'ASI_SOP_HDR_MSTR_Explorer' unknown error (39)

    Here is what in the ASIEXP81 table. This is plain Jane installation so this is what would be in that table by default.

    *                                                                                

    1099 Vendors*                                                                    

    28001                                                                            

    28002                                                                            

    28003                                                                            

    28004                                                                            

    28005                                                                            

    28006                                                                            

    28007                                                                            

    28008                                                                            

    28009                                                                            

    28010                                                                            

    28011                                                                            

    28012                                                                            

    28013                                                                            

    28014                                                                            

    28015                                                                            

    28016                                                                            

    28017                                                                            

    28018                                                                            

    28019                                                                            

    28020                                                                            

    28021                                                                            

    28022                                                                            

    28023                                                                            

    28024                                                                            

    28027                                                                            

    28028                                                                            

    28029                                                                            

    28030                                                                            

    28031                                                                            

    28032                                                                            

    28036                                                                            

    Applicant                                                                        

    Applicant Education                                                              

    Average Days to Pay*                                                            

    Back Ordered Items*                                                              

    Back Ordered Line Items*                                                        

    Cash Receipts Entered Today*                                                    

    Cash Requirements*                                                              

    Check Information; Current Year*                                                

    Contract Lines                                                                  

    Contracts                                                                        

    Contracts Expiring this Month*                                                  

    Current Financials Journal*                                                      

    Current Inventory Journal*                                                      

    Current Payroll Journal*                                                        

    Current Purchasing Journal*                                                      

    Current Sales Journal*                                                          

    Customer Balance*                                                                

    Customer Contact List*                                                          

    Customer Returns*                                                                

    Customers on Hold*                                                              

    Customers Over Credit Limit*                                                    

    Discounts Expiring this Week*                                                    

    Discounts Lost YTD*                                                              

    Drop-Ship Line Items*                                                            

    Employee Benefit                                                                

    Employee Education                                                              

    Employee List*                                                                  

    Employees Due for Pay Change*                                                    

    Equipment                                                                        

    Field Service Calls                                                              

    Fixed Assets                                                                    

    Fixed Assets Books                                                              

    Fixed Assets Purchase                                                            

    Fulfillment Orders to Pack*                                                      

    Fulfillment Orders to Pick*                                                      

    Fulfillment Orders to Ship*                                                      

    High Priority Documents Due this Week*                                          

    History Contract Lines                                                          

    History Contracts                                                                

    History Field Service Calls                                                      

    History Financials Journal*                                                      

    History Inventory Journal*                                                      

    History Payroll Journal*                                                        

    History Purchasing Journal*                                                      

    History RMA Lines                                                                

    History RMAs                                                                    

    History RTV Lines                                                                

    History RTVs                                                                    

    History Sales Journal*                                                          

    Inactive Customers*                                                              

    Inactive Vendors*                                                                

    Invoices by Vendor*                                                              

    Items Below Order Point Quantity*                                                

    Items by Site*                                                                  

    Items Due to be Counted*                                                        

    Items Overdue for Stock Count*                                                  

    Items Overdue to Ship*                                                          

    Items Past Requested Ship Date*                                                  

    Items Past Required Date*                                                        

    Items Shipped Today*                                                            

    Items to Put Away*                                                              

    Items to Ship Today*                                                            

    Negative Quantity Items*                                                        

    NSF Customers*                                                                  

    Open Invoices*                                                                  

    Open Orders for Customers on Hold*                                              

    Open Orders*                                                                    

    Open Purchase Orders by Vendor*                                                  

    Open Purchase Orders*                                                            

    Open RMAs*                                                                      

    Open Service Calls*                                                              

    Open Work Orders*                                                                

    Overdue Receipts*                                                                

    Overstocked Items*                                                              

    Past Due Customer Transactions*                                                  

    Past Due Customers*                                                              

    Past Due Payables*                                                              

    Past Due RTVs*                                                                  

    Payables Documents on Hold*                                                      

    Payables Due Today*                                                              

    PO Line Items Promised This Week*                                                

    Post-Dated Pay Rates                                                            

    Posted Invoices*                                                                

    Purchase Orders On Hold*                                                        

    Purchase Req Line Items                                                          

    Purchase Requisitions                                                            

    Quotes Expiring this Week*                                                      

    Receivables Due Today*                                                          

    RMA Lines                                                                        

    RMAs                                                                            

    RTV Lines                                                                        

    RTVs                                                                            

    Ship Complete Orders*                                                            

    Shipments Received but not Invoiced*                                            

    Shipping Performance*                                                            

    This Month's Late Vendor Shipments*                                              

    This Month's Sales*                                                              

    This Week's Back Orders*                                                        

    This Week's Invoices*                                                            

    This Week's Orders*                                                              

    This Week's Purchase Orders*                                                    

    This Week's Quotes*                                                              

    This Week's Returns*                                                            

    Today's Expected Receipts*                                                      

    Today's Payments*                                                                

    Today's Purchases*                                                              

    Today's Sales*                                                                  

    Transaction Information*                                                        

    Transactions by Customer*                                                        

    Transactions by Vendor*                                                          

    Unapplied Documents*                                                            

    Vacation/Sick Time Available*                                                    

    Vendor Balance*                                                                  

    Vendor Contact List*                                                            

    Vendors on Hold*                                                                

    Work Orders                                                                      

    Workflow Shipments Due Today*                                                    

  • CelticsDresden Profile Picture
    CelticsDresden 25 on at
    RE: GP 2010: 'sa' account hung up, 'ASI_SOP_HDR_MSTR_Explorer' unknown error (39)

    Mine has 273 rows, while my working database has 272.

    I did truncate table and then inserted the data from my backup database, and I managed to log-in to Dynamics GP2010 without delay.

    I'm doing this process with all the other tables that have differences in data just to make sure that's the problem, but I'm 90% sure that the culprit is in that table. I know the row causing the problem as well, as also the ASI_FAVORITE_NAME: "DELETED TRX". Do you have that one in your table or is it a personal one we created?

    So what I'm going to do is the following:

    1. Keep testing the other tables with differences (deleting data and inserting from working backup) so that I can discard them.

    2. If ASIEXP81 is indeed the culprit, I'll try to load Smart List and find "DELETED TRX" and remove it from Smart List.

    3. If that doesn't work, then I'll just delete in SQL all the data from that table and insert data from my working back-up to ASIEXP81 table.

    If you have other suggestions, let me know.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,788 Moderator on at
    RE: GP 2010: 'sa' account hung up, 'ASI_SOP_HDR_MSTR_Explorer' unknown error (39)

    The ASIEXP81 is the SmartLists Favourites Master table. That may make sense if 'sa' has a certain Smartlist as a favourite then only 'sa' would see this issue.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,788 Moderator on at
    RE: GP 2010: 'sa' account hung up, 'ASI_SOP_HDR_MSTR_Explorer' unknown error (39)

    My version of ASIEXP81 has 206 records in it with the following Prod ID's

    0

    309

    414

    949

  • CelticsDresden Profile Picture
    CelticsDresden 25 on at
    RE: GP 2010: 'sa' account hung up, 'ASI_SOP_HDR_MSTR_Explorer' unknown error (39)

    Ran a compare for the two databases, and Red Gate tells me they're identical, so it seems that it might be problem with data entered.

    I'm doing more testing, but I think I found the culprit. A row in table ASIEXP81 in the DYNAMICS database.

    Seems like a table that is related to the Smart List as well. Not sure what it's contained in that table, seems like it has definitions of smart list queries or something.

    Still troubleshooting other tables just in case, but this seems to be the culprit for now.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans