Open Forum

Expand all | Collapse all

Dynamics GP Crashes for One User when clicking on Purchasing Module

  • 1.  Dynamics GP Crashes for One User when clicking on Purchasing Module

    Posted 3 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 3 days ago
    Edited by Darin Vialpando 3 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 3 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 2 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 2 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 2 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 2 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


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