Access violation at address 1A7F37EF in module 'eware.dll'. Read of address 00000000

We have a customer who has a custom page (asp) on the Company tab showing Order Items filtered on the current company (a very simple list block).

This works fine when clicking on the tab after navigating from the Company Summary screen. But when then clicking on the standard list of people tab (Person tab under Company) then clicking back to this Order Items tab they receive the red banner with 'Access violation at address 1A7F37EF in module 'eware.dll'. Read of address 00000000'. We've run fiddler and other developer tools, but nothing points anything extra being attached to the url or session, so seems to be something in the Sage .dll

We tried in the latest version of SageCRM 2018 and the error still occurs.

We have asked Sage support, but they have stated as customisation they can't really help in this matter.

Has anybody else seen this or have a workaround?

Kind Regards M Tindall

  • 0

    Hi,

    Could you please post the entire stack trace of the Access Violation error from the ewaresystem log and the exact version of CRM you are testing on here?

    To see the full stack trace you may have to do an IIS reset first and then reproduce the issue. The full stack trace is normally only recorded once in the logs after the app pool is restarted.

    This might give us an indication as to what the problem could be.

  • 0

    Please find the stack trace from the ewaresystem log (current versions we've tested are CRM 2018 R2 and CRM 2017 R3). Both have the same error.

    Jun 28 2018 15:30:11.970 3908 4428 4 EndUserAction,User,Action,Time 1 520 2500
    Jun 28 2018 15:30:18.229 3908 4624 3 CoeWareBaseInit,QueryString SID=134541775955623&Key0=1&Key1=43&Key2=57&J=CompanyOrderLines.asp&T=Company
    Jun 28 2018 15:30:18.308 3908 4624 5 Fav: 5:43
    Jun 28 2018 15:30:18.542 3908 4624 3 CoeWareBase,Time 312
    Jun 28 2018 15:30:20.738 7120 6424 1 Metadata 17000
    Jun 28 2018 15:30:20.864 7120 6424 5 TMetadata.Create finished.
    Jun 28 2018 15:30:20.874 7120 6424 5 TUserSession.Create finished.
    Jun 28 2018 15:30:23.726 3908 7004 4 StartUserAction,User,Action 1 181
    Jun 28 2018 15:30:23.741 3908 7004 5 Fav: 5:43
    Jun 28 2018 15:30:24.165 3908 7004 5 get help button code: 181-1 Helpfile is help.htm Using help file Main Menu/Default_CSH.htm#User/AI_AddingNewPersonToExis.htmMain Menu/Default_CSH.htm#User/AI_AddingNewPersonToExis.htm
    Jun 28 2018 15:30:24.507 3908 7004 4 EndUserAction,User,Action,Time 1 181 781
    Jun 28 2018 15:30:25.288 7120 6424 3 CoeWareBase,Time 22000
    Jun 28 2018 15:30:28.197 3908 4624 3 CoeWareBaseInit,QueryString SID=134541775955623&Key0=1&Key1=43&Key2=57&J=CompanyOrderLines.asp&T=Company
    Jun 28 2018 15:30:28.228 3908 4624 5 Fav: 5:43
    Jun 28 2018 15:30:28.587 3908 4624 3 CoeWareBase,Time 390

  • 0

    Hi,

    The access violation stack trace will look something like this:

    Apr 5 2018 8:29:32.441 4600 2660 1 Creating stack-trace ID:3962102232. Error message is "Access violation at address 1A0059EC in module 'eware.dll'. Read of address 636F6426"
    Apr 5 2018 8:29:32.441 4600 2660 1

    ----------------------------------------------------------------------------------------------
    |Address |Module |Unit |Class |Procedure/Method |Line |
    ----------------------------------------------------------------------------------------------
    |1A859FAA|eware.dll |Translate.pas |TTranslationFamily |GetTranslation |526[2] |
    |1A859F78|eware.dll |Translate.pas |TTranslationFamily |GetTranslation |524[0] |
    |1A85A4D0|eware.dll |Translate.pas |TTranslationList |GetTranslation |653[5] |
    |1A85A47C|eware.dll |Translate.pas |TTranslationList |GetTranslation |648[0] |
    |1A83BBFC|eware.dll |WebObject.pas |TWebObject |GetTrans |3492[5] |

    The bit highlighted in yellow is the bit we're interested in. Also the exact version and service pack of CRM is important to know so that we can match the line number in the code against the line number in the logs.

    Thanks

  • 0

    Hi,

    I'm afraid thats all that was written to the ewaresystem log. No access violation reported in the logs. Only onscreen.

    Thanks

  • 0

    Ok, would you be able to post a simplified version of the ASP file here so that I could take a look and try to reproduce?

    You should be able to attach a file to a forum post by clicking on the Options tab above.

  • 0

    Hi,

    I've added a test asp page and some notes in a zip file

    Thanks

  • 0

    Thanks I'll take a look and get back to you.

  • 0

    Hi,

    This is a bug in the eWare.dll so you can re-raise this case to your local support team and point them to this thread if necessary. (btw you're just missing 1 step in your steps to repro which is to add some columns to the list).

    To workaround this bug on the example you sent in you can redifine your view by adding the pers_personid to the view:

    CREATE VIEW vCompanyOrderItems
    AS
    SELECT OrderItems.*, Orders.* , Opportunity.Oppo_PrimaryCompanyId, NewProduct.*, Person.pers_personid
    FROM OrderItems
    LEFT JOIN Orders ON OrIt_OrderQuoteId = Orde_OrderQuoteId
    LEFT JOIN Opportunity ON Orde_OpportunityId = Oppo_OpportunityId
    LEFT JOIN NewProduct ON OrIt_ProductID = Prod_ProductId
    LEFT JOIN Person ON Oppo_PrimaryPersonId = pers_personid
    WHERE OrIt_Deleted IS NULL

    And edit the list so that "Use all SQL columns in query" is set to Yes

    Then refresh metadata and try the list again.

    That should resolve the issue until it's fixed in the eWare.dll

    Let me know if you have any issues.

    Cheers,

    Kevin

  • 0

    Hi,

    This workaround solves the problem. Thanks for your time on this. We've asked the case to be re-opened with Sage support

    Regards