Open Forum

Expand all | Collapse all

Dynamics GP Crashes for One User when clicking on Purchasing Module

Jump to Best Answer
  • 1.  Dynamics GP Crashes for One User when clicking on Purchasing Module

    Posted 8 days ago
    Hello everyone,

    I have encountered a very peculiar issue on one of my clients.  The user logs on to GP on any company, can access every single module and window, but when she clicks to access the Purchasing Module, GP freezes for a couple of minutes and then crashes. It is just this specific user, and it happens on every single workstation we have tried it on, so its not an issue of add-ons or a corrupt file in the GP installation for her workstation. I have accessed every single Purchasing window through the top panel (Transactions <> Inquiries <> Cards <> Reports), and they all open without problem when accessed this way.

    I have tried everything from checking the user's security, adding her to POWERUSER role, checking system tables in SQL to look for any weird records related to her user, inactivating and reactivating the user account, removing access to companies and readding them, etc. I have checked everywhere online for an user with this issue and have found nothing!

    The error I get is the following:

    Problem signature:

      Problem Event Name:                        APPCRASH

      Application Name:                             Dynamics.exe

      Application Version:                           16.0.33.0

      Application Timestamp:                     583359b7

      Fault Module Name:                          KERNELBASE.dll

      Fault Module Version:                       6.3.9600.19425

      Fault Module Timestamp:                 5d26ae6e

      Exception Code:                                  e0434352

      Exception Offset:                                00034e28

      OS Version:                                          6.3.9600.2.0.0.272.7

      Locale ID:                                             1033

      Additional Information 1:                 65e8

      Additional Information 2:                 65e82aceb67c346a379013c9fdb1c48b

      Additional Information 3:                 cac2

      Additional Information 4:                 cac274a10b93b41dcc730229607b1250

    Any help I can get is greatly appreciated.

    ------------------------------
    Ricardo Carrillo
    RSM
    San Juan, PR
    ------------------------------
    Conference-GPUG_200x200


  • 2.  RE: Dynamics GP Crashes for One User when clicking on Purchasing Module

    TOP CONTRIBUTOR
    Posted 8 days ago
    Edited by Darin Vialpando 8 days ago
    Ricardo,

    I suggest creating a DEXSQL log  

    go into GP Data folder  select the Dex.ini  file and open in notepad. Then change the SQL Stmnt log files  from FALSE to TRUE and save

    SQLLogSQLStmt=FALSE
    SQLLogODBCMessages=FALSE
    SQLLogAllODBCMessages=FALSE

    Launch GP - At the point the crash occurs view the end of the DEX SQL - It should show what was happening right before the error - Caution the DEX SQL log can get big - quickly so after your done be sure to go back in and set the SQL stmts back to False

    This should at least get you going on what error is occurring  in GP  that could be causing the app crash.




    ------------------------------
    Darin Vialpando
    Enterprise Applications Administrator
    RK Mechanical, Inc.
    Denver CO
    ------------------------------

    Conference-GPUG_200x200


  • 3.  RE: Dynamics GP Crashes for One User when clicking on Purchasing Module

    GPUG ALL STAR
    Posted 8 days ago
    @Ricardo Carrillo

    A DexSQL log will only give you what is happening at the SQL level. If turned on at the Dex.ini level it will also include all users in that workstation/server. It also logs from the start of your session.

    How about installing GP Power Tools and using the free 30 day trial period. Then you can capture 5 different logs of just when the problem occurs for the one instance of the application.

    If the system crashes, it won't be able to write all the logs but it will write the Dexterity script log giving us the actual script it crashed in. Combined with the Dex SQL log we could probably get very close to the line causing the error.

    Then we could also use Dynamic Trigger Logging (a GP Power Tools feature) to get even closer to the line causing the crash.

    Regards

    David


    ------------------------------
    David Musgrave MVP, GPUG All-Star

    Managing Director
    Winthrop Development Consultants

    Perth, Western Australia

    http://www.winthropdc.com
    ------------------------------

    Conference-GPUG_200x200


  • 4.  RE: Dynamics GP Crashes for One User when clicking on Purchasing Module

    Posted 7 days ago
    @David Musgrave ​​ @Darin Vialpando

    Thank you very much for your replies.  As you both mentioned, I enabled the SQLLogs on Dex.ini and installed GP Power Tools and ran the log.  I'm not too technical, but I only got information on the DEXSQL (based on Dex.ini) and the Script log (from GPPT).

    I ran through both logs and did not see anything that caught my eye.  Like I mentioned, I'm not a very technical person. Perhaps I can send them via e-mail so you can get a quick look at them?

    Thanks once again.

    ------------------------------
    Ricardo Carrillo
    RSM
    San Juan
    ------------------------------

    Conference-GPUG_200x200


  • 5.  RE: Dynamics GP Crashes for One User when clicking on Purchasing Module

    GPUG ALL STAR
    Posted 7 days ago

    @Ricardo Carrillo

    If the system crashed again as you mentioned, then the last line in the script log is the code that was being run.

    If using GP Power Tools, please don't enable the SQL Logs in the Dex.ini. Use the Dex.ini Settings window in GP Power Tools to turn these settings off again or manually edit the Dex.ini.

    Using only GP Power Tools (so we have more control), capture the logs again.

    Can you post the last 10 lines or so of both logs​, so we can review them.

    Regards

    David



    ------------------------------
    David Musgrave MVP, GPUG All-Star

    Managing Director
    Winthrop Development Consultants

    Perth, Western Australia

    http://www.winthropdc.com
    ------------------------------

    Conference-GPUG_200x200


  • 6.  RE: Dynamics GP Crashes for One User when clicking on Purchasing Module

    Posted 7 days ago
    @David Musgrave ​ I disabled the SQL Logs in the Dex.ini and enabled manual logging on GPPT.

    Even though I have SQL Logs disabled Dex.ini, the DEXSQL file being created is not appearing on the GPPT Logs folder, and it is created in the GP data folder as DEXSQL.log, not in the GPPT format DEXSQL_<Date>_<Time>.log. Not sure if this is correct, I even closed GP and reopened to make sure the change was made.

    DEXSQL:
    /* Date: 02/14/2020 Time: 10:42:59
    stmt(176205000):*/
    { CALL ##zDP_1035640S_1 ( 550, 892, 0 ) }

    /* Date: 02/14/2020 Time: 10:42:59
    stmt(176205000):*/
    { CALL ##zDP_1035640S_1 ( 550, 891, 0 ) }

    /* Date: 02/14/2020 Time: 10:42:59
    stmt(176205000):*/
    { CALL ##zDP_1035640S_1 ( 550, 892, 0 ) }

    /* Date: 02/14/2020 Time: 10:42:59
    stmt(176205000):*/
    { CALL ##zDP_1035640S_1 ( 550, 888, 0 ) }

    /* Date: 02/14/2020 Time: 10:42:59
    stmt(176205000):*/
    { CALL ##zDP_1035640S_1 ( 550, 892, 0 ) }

    /* Date: 02/14/2020 Time: 10:42:59
    stmt(176205000):*/
    { CALL ##zDP_1035640S_1 ( 550, 889, 0 ) }

    /* Date: 02/14/2020 Time: 10:42:59
    stmt(176205000):*/
    { CALL ##zDP_1035640S_1 ( 550, 887, 0 ) }

    /* Date: 02/14/2020 Time: 10:42:59
    stmt(176205000):*/
    { CALL ##zDP_1035640S_1 ( 550, 893, 0 ) }

    /* Date: 02/14/2020 Time: 10:42:59
    stmt(176205000):*/
    { CALL ##zDP_1035640S_1 ( 550, 893, 0 ) }

    /* Date: 02/14/2020 Time: 10:42:59
    stmt(176205000):*/
    { CALL ##zDP_1035640S_1 ( 550, 893, 0 ) }

    /* Date: 02/14/2020 Time: 10:42:59
    stmt(176205000):*/
    { CALL ##zDP_1035640S_1 ( 550, 893, 0 ) }

    Dexterity Script Log:
    10:42:59 'ContentPageCache_GetProperty() of form Command_NavBar', "", 3680, 2
    10:42:59 'ContentPageCache_GetProperty() of form Command_NavBar', "", 3681, 2
    10:42:59 'ContentPageCache_GetProperty() of form Command_NavBar', "", 3682, 2
    10:42:59 'ContentPageCache_GetProperty() of form Command_NavBar', "", 3683, 2
    10:42:59 'ContentPageCache_GetProperty() of form Command_NavBar', "", 3684, 2
    10:42:59 'ContentPageCache_GetProperty() of form Command_NavBar', "", 3685, 2
    10:42:59 'ContentPageCache_GetProperty() of form Command_NavBar', "", 3686, 2
    10:42:59 'ContentPageCache_GetProperty() of form Command_NavBar', "", 3687, 2
    10:42:59 'ContentPageCache_GetProperty() of form Command_NavBar', "", 3688, 2
    10:42:59 'ContentPageCache_GetProperty() of form Command_NavBar', "", 3689, 2
    10:42:59 'ContentPageCache_GetProperty() of form Command_NavBar', "", 3690, 2
    10:42:59 'ContentPageCache_GetProperty() of form Command_NavBar', "", 3691, 2
    10:42:59 'ContentPageCache_GetProperty() of form Command_NavBar', "", 3692, 2

    ------------------------------
    Ricardo Carrillo
    RSM
    San Juan
    ------------------------------

    Conference-GPUG_200x200


  • 7.  RE: Dynamics GP Crashes for One User when clicking on Purchasing Module

    GPUG ALL STAR
    Posted 7 days ago
    @Ricardo Carrillo

    If GP crashes, it means the post logging code fails to run. This code will rename and move the DEXSQL log. Sadly the name is hardcoded and cannot be defined from code, so it can only be moved after the fact.

    Looking at the logs sadly provides nothing useful. It was just drawing the navigation pane.

    How many lines can you see that look like this and what are the lines above where the repetition starts in the script log.

    It looks like it has gone into a loop, or there is something wrong with the data for this user.

    Exactly what are they clicking on to make this happen? Can they get to the Purchasing Area Page?

    Regards

    David

    ------------------------------
    David Musgrave MVP, GPUG All-Star

    Managing Director
    Winthrop Development Consultants

    Perth, Western Australia

    http://www.winthropdc.com
    ------------------------------

    Conference-GPUG_200x200


  • 8.  RE: Dynamics GP Crashes for One User when clicking on Purchasing Module

    Posted 4 days ago
    Hi @David Musgrave ,

    This happens when they click the "Purchasing" module button. It just freezes and does not load up anything and after a couple of minutes, GP crashes.  I think there is some sort of issue with the navigation pane for this user on the Purchasing module as all other modules work perfectly.  Also all Purchasing functionality (transactions / inquiries / reports / cards) work when you access them directly through the top toolbar.

    That type of line appears thousands of times, but before that this is the type of lines that appear:
    10:42:08 'CreateAreaPageSection_Routines of form Command_Purchasing', 1-
    10:42:08 'AddContentArea of form syAreaPageXML', 1-, "Routines", "Images/Routines.png", 0, 1
    10:42:08 'AddItems of form syAreaPageXML', 1-, OK Button
    10:42:08 'AddListToElement of form syAreaPageXML', 1-, 890, object: 'MSXML2.IXMLDOMElement', 0
    10:42:08 'AddLink of form syAreaPageXML', 1-, 921, object: 'MSXML2.IXMLDOMElement'
    10:42:08 'AddLink of form syAreaPageXML', 1-, 898, object: 'MSXML2.IXMLDOMElement'
    10:42:08 'AddLink of form syAreaPageXML', 1-, 940, object: 'MSXML2.IXMLDOMElement'
    10:42:08 'AddLink of form syAreaPageXML', 1-, 954, object: 'MSXML2.IXMLDOMElement'
    10:42:08 'AddLink of form syAreaPageXML', 1-, 951, object: 'MSXML2.IXMLDOMElement'
    10:42:08 'AddSectionXML() of form syAreaPageObj', 0, 550, 890, 1-
    10:42:08 'ContentPageCache_AddSectionXML() of form Command_NavBar', 0, 550, 890, 0, "<section title="Routines" image="Images/Routines.png" expanded="false" column="1"><item title="Post Scheduled Payments" link="http://dexterity/product=0/script=ExecuteAreaPageLink/args=0,1566,35"/><item title="Print 1099" link="http://dexte"...
    10:42:08 'SectionWillDisplay() of form syAreaPageObj', 0, 550, 889, 14, "Reports", 3
    10:42:08 'ContentPageCache_GetContentPageTag() of form Command_NavBar', 0
    10:42:08 'ContentPageCache_FindSectionByTag() of form Command_NavBar', 0, 889
    10:42:08 'ContentPageCache_GetProperty() of form Command_NavBar', "", 6, 2
    10:42:08 'ContentPageCache_SetProperty() of form Command_NavBar', 0, 6, 0, "Reports"
    10:42:08 'ContentPageCache_GetProperty() of form Command_NavBar', "", 6, 0
    10:42:08 'ContentPageCache_GetProperty() of form Command_NavBar', "", 6, 0
    10:42:08 'ContentPageCache_SetProperty() of form Command_NavBar', 0, 6, 8, "14"
    10:42:08 'ContentPageCache_GetProperty() of form Command_NavBar', "", 6, 8
    10:42:08 'ContentPageCache_GetProperty() of form Command_NavBar', "", 6, 8
    10:42:08 'ContentPageCache_GetProperty() of form Command_NavBar', "", 6, 4
    10:42:08 'CreateAreaPageSection_Reports of form Command_Purchasing', 1-
    10:42:08 'AddContentArea of form syAreaPageXML', 1-, "Reports", "Images/Report.png", 0, 1
    10:42:08 'AddItems of form syAreaPageXML', 1-, Registered
    10:42:08 'AddListToElement of form syAreaPageXML', 1-, 889, object: 'MSXML2.IXMLDOMElement', 0
    10:42:08 'AddLink of form syAreaPageXML', 1-, 899, object: 'MSXML2.IXMLDOMElement'
    10:42:08 'AddLink of form syAreaPageXML', 1-, 904, object: 'MSXML2.IXMLDOMElement'
    10:42:08 'AddLink of form syAreaPageXML', 1-, 928, object: 'MSXML2.IXMLDOMElement'
    10:42:08 'AddLink of form syAreaPageXML', 1-, 929, object: 'MSXML2.IXMLDOMElement'
    10:42:08 'AddLink of form syAreaPageXML', 1-, 918, object: 'MSXML2.IXMLDOMElement'
    10:42:08 'AddLink of form syAreaPageXML', 1-, 932, object: 'MSXML2.IXMLDOMElement'
    10:42:08 'AddLink of form syAreaPageXML', 1-, 916, object: 'MSXML2.IXMLDOMElement'
    10:42:08 'AddSectionXML() of form syAreaPageObj', 0, 550, 889, 1-
    10:42:08 'ContentPageCache_AddSectionXML() of form Command_NavBar', 0, 550, 889, 0, "<section title="Reports" image="Images/Report.png" expanded="false" column="1"><item title="Trial Balance" link="http://dexterity/product=0/script=ExecuteAreaPageLink/args=0,1566,13"/><item title="History" link="http://dexterity/product=0/s"...
    10:42:08 'SectionWillDisplay() of form syAreaPageObj', 0, 550, 893, 16, "Utilities", 3
    10:42:08 'ContentPageCache_GetContentPageTag() of form Command_NavBar', 0
    10:42:08 'ContentPageCache_FindSectionByTag() of form Command_NavBar', 0, 893
    10:42:08 'ContentPageCache_GetProperty() of form Command_NavBar', "", 1602, 2
    10:42:08 'ContentPageCache_SetProperty() of form Command_NavBar', 0, 1602, 0, "Utilities"
    10:42:08 'ContentPageCache_GetProperty() of form Command_NavBar', "", 1602, 0
    10:42:08 'ContentPageCache_GetProperty() of form Command_NavBar', "", 1602, 0
    10:42:08 'ContentPageCache_SetProperty() of form Command_NavBar', 0, 1602, 8, "16"
    10:42:08 'ContentPageCache_GetProperty() of form Command_NavBar', "", 1602, 8
    10:42:08 'ContentPageCache_GetProperty() of form Command_NavBar', "", 1602, 8
    10:42:08 'ContentPageCache_GetProperty() of form Command_NavBar', "", 1602, 4
    10:42:08 'Display of form syAreaPageXML', 1-
    10:42:08 'DisplayContentPage of form Command_NavBar', 550
    10:42:08 'ContentPage_RemoveSection() of form syContentPageObj', 0, 550, -1
    10:42:08 'ContentPageCommand_GetType() of form syContentPageObj', 0, 550
    10:42:08 'ApplyContentPageSettings of form Command_NavBar', 550
    10:42:08 'ContentPageCache_GetProperty() of form Command_NavBar', "", 0, 91
    10:42:08 'ContentPageCache_GetProperty() of form Command_NavBar', "", 0, 93
    10:42:08 'ContentPageCache_GetProperty() of form Command_NavBar', "", 0, 92
    10:42:08 'ContentPageCache_GetProperty() of form Command_NavBar', "", 0, 90
    10:42:08 'ContentPageCache_GetProperty() of form Command_NavBar', "", 0, 95
    10:42:08 'ContentPageCache_GetProperty() of form Command_NavBar', "", 0, 94
    10:42:08 'ContentPage_ApplyPageSettings() of form syContentPageObj', 0, 550, 3, 2, 0, "Purchasing", "Customize this page...", "http://dexterity/product=0/script=OpenCustomizeWindow/form=Command_NavBar"
    10:42:08 'ContentPageCache_GetProperty() of form Command_NavBar', "", 1, 2
    10:42:08 'ContentPageCache_GetProperty() of form Command_NavBar', "", 1, 1
    10:42:08 'ContentPageCache_GetProperty() of form Command_NavBar', "", 1, 4
    10:42:08 'ContentPageCache_GetProperty() of form Command_NavBar', "", 1, 5
    10:42:08 'ContentPageCache_GetProperty() of form Command_NavBar', "", 1, 3
    10:42:08 'ContentPageCache_GetProperty() of form Command_NavBar', "", 1, 7
    10:42:08 'ContentPageCache_GetProperty() of form Command_NavBar', "", 1, 0
    10:42:08 'ContentPageCache_GetProperty() of form Command_NavBar', "", 1, 8
    10:42:08 'ContentPageCache_GetSectionXML() of form Command_NavBar', "", 550, 887, 0

    The only thing that occurs to me is that the Navigation Pane data is corrupted for this user.  I looked in a couple of tables but did not see anything that was different from other users...

    ------------------------------
    Ricardo Carrillo
    RSM
    San Juan
    ------------------------------

    Conference-GPUG_200x200


  • 9.  RE: Dynamics GP Crashes for One User when clicking on Purchasing Module
    Best Answer

    GPUG ALL STAR
    Posted 4 days ago

    Hi Ricardo

    The navigation pane Area Page is built off the data in the syMenuMstr (SY07110) table in the system (DYNAMCIS) database.

    How many records are in this table?

    Are they all with blank User ID, or do you have specific records for a user ID (in particular the User ID of the problem user).

    If you do, delete the records for the User ID, if needed they will be recreated.

    Regards

    David



    ------------------------------
    David Musgrave MVP, GPUG All-Star

    Managing Director
    Winthrop Development Consultants

    Perth, Western Australia

    http://www.winthropdc.com
    ------------------------------

    Conference-GPUG_200x200


  • 10.  RE: Dynamics GP Crashes for One User when clicking on Purchasing Module

    Posted 4 days ago
    @David Musgrave

    That particular table had all records with USERID blank.  However, I started checking other tables after that one and managed to find a few that had that particular problem user in the USERID. ​​I deleted all records related to the user in these tables and the problem was fixed!!!

    In case someone meets with this issue in the future, the tables were SY0721, SY07125, SY07130, SY07140.

    Thank you for your help!!

    ------------------------------
    Ricardo Carrillo
    RSM
    San Juan
    ------------------------------

    Conference-GPUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role