D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

D365FO production slowness due to LedgerActivityEntity

  • 1.  D365FO production slowness due to LedgerActivityEntity

    GOLD CONTRIBUTOR
    Posted 12 days ago
    On a live customer production environment, we see recurring slowness and at times system freezing and have been suggested on LedgerActivityEntity as potential root cause.
    We don't use this entity in any data management import or export and wondering if anyone has experienced similar slowness / suggestions.

    ------------------------------
    Regards
    Rahul Mohta
    Advisor - D365FO
    Real Dynamics
    ------------------------------


  • 2.  RE: D365FO production slowness due to LedgerActivityEntity

    Posted 11 days ago
    We also experienced issues with slow performance.  Most of that was corrected by updating to v 10 pl 28.  There could be several reasons why you are seeing this.  We finally narrowed it down to how some of the queries were pulling data.  Have you had anyone do a trace on the transactions that they are performing when they experience this slow down?  is this a issue across all of D365 or only for some users performing a specific task?​

    ------------------------------
    Erik Fischer
    ERP Program Manager
    HBD Industries
    Dublin OH
    ------------------------------



  • 3.  RE: D365FO production slowness due to LedgerActivityEntity

    Posted 10 days ago
    All...

    We as well are experiencing extreme slowness on Management Reporter utility specifically tied to the "General Ledger to fact" integration step of Management Reporter; most notably since upgrading to 10.0.4.  The Management Reporter utility was running upwards of 3+ days without a successful refresh of the "General Ledger to fact" integration step.  A review of LCS 'long running queries' isolated a specific query that spawned upwards of six (6) concurrent SPIDs causing a deadlock affecting on-line performance especially with the MPOS (Point of Sales)....  We immediately killed the SPIDs and the performance snapped back to acceptable, however a SEV-A last weekend resulted in a rebuild of the Management Reporter Data Mart...  Upon the rebuild we were able to achieve a successful refresh of the Data Mart, however, yet again a secondary error occurred whereby the Trial Balance for MTD reconciled, however YTD balances were off significantly.  Thje resolution to this error was a back-end 'hot-fix' to apply a KB this is available in 10.0.5.

    LCS: KB 4506583: Transactions posted to a period with more than 32 days will not be available in Financial reporting reports

    https://fix.lcs.dynamics.com/Issue/Details?kb=4506583&bugId=322699&dbType=3&qc=0a6c01d161fa2602e042b68bc652d712c81dea6ddd061a8d190289aaba7c2cf7

    This issue is resolved in the v10.0.5.

    ------------------------------
    Joe MacPherson
    Coldwater Creek
    Hingham MA
    ------------------------------



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