Sage 100

 View Only
Expand all | Collapse all

Performance issues 2019.2 data entry

  • 1.  Performance issues 2019.2 data entry

    Posted 11-06-2019 13:57
    Has anyone had a client complain about performance issues in a data entry screen (SO Entry, Shipping, etc) ONLY on the first record?
    Have a client recently upgraded and there is significant delay after they select the first customer in SO Entry, or the first SO in Shipping Data Entry, etc.  Once they have gotten past that, subsequent orders/shipments show no lag time.

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Beth Bowers
    269-445-1625
    ------------------------------


  • 2.  RE: Performance issues 2019.2 data entry

    Posted 11-06-2019 22:06
    ADV or STD?  Any enhancements?

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------



  • 3.  RE: Performance issues 2019.2 data entry

    Posted 11-07-2019 07:57
    Advanced and they have some scripts, but I've watched the trace and it doesn't look like it's running any script at the time it's hanging.  They also have Avalara, but I don't think that would affect Shipping Data Entry.

    I've seen similar at another client, who is on Standard - theirs hangs in the Customer PO field if they turn on duplicate PO checking in the AR Invoice HIstory file.  Just seems like in this version something has changed in how large files are accessed/read.

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Beth Bowers
    269-445-1625
    ------------------------------



  • 4.  RE: Performance issues 2019.2 data entry

    Posted 11-07-2019 10:08
    Did you check DFDM for blank/corrupt records in the tables it hits? I imagine the first record creates an index/cache of sorts as well, so maybe it is just creating that?

    ------------------------------
    Michelle Forsey
    Eide Bailly, Inc.
    801-456-5470
    ------------------------------



  • 5.  RE: Performance issues 2019.2 data entry

    Posted 11-07-2019 10:21
    This is happening at 2 totally different installs for the same client (and a third client who is on Std, not Adv).  SO what I'm really just asking of everyone is whether you have any clients who also see this pattern in 2019 - this would be someone with some pretty large files.

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Beth Bowers
    269-445-1625
    ------------------------------



  • 6.  RE: Performance issues 2019.2 data entry

    Posted 11-07-2019 10:25
    Maybe their AV is scanning the files upon first access?

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 7.  RE: Performance issues 2019.2 data entry

    Posted 11-07-2019 10:57
    IT assures me they've turned off AV...

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Beth Bowers
    269-445-1625
    ------------------------------



  • 8.  RE: Performance issues 2019.2 data entry

    Posted 11-12-2019 13:56
    "IT assures me they've turned off AV..."


    ------------------------------
    ==================
    Rhonda McNamara
    Customer Success Manager
    Stewart Technologies, Inc.
    rsm@stewarttechnologies.com
    ------------------------------



  • 9.  RE: Performance issues 2019.2 data entry

    Posted 11-07-2019 10:11
    Spawn tasks from server enabled for the user?

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 10.  RE: Performance issues 2019.2 data entry

    Posted 11-07-2019 11:22
    Are they using mapped drives or only network shares?  The reason I ask is I've seen this on some systems, where the network share silently disconnects, so when you start to use the network share, it has to go through all of the security stuff as though you were not connected.  With mapped drives, the mapping keeps the security in memory and the reconnect is almost instantaneous.

    IT types hate mapped drives, because yes, it does reduce security.  The speed difference though, especially for STD but even ADV is significant.  Also, in 2016 R2 and above, Microsoft started enforcing the silent disconnect at 600 seconds by default.  That means after 5 minutes of inactivity, the server will drop the connection, and then have to connect again when activity continues.  This sometimes leads to corrupted records such as in sy_workstation or sy_console for instance.  So in either mapped or network shares, the IT department may want to crank up the timeout to about 5120 from 600, which will set the silent disconnect to about 1.4 hours.

    ------------------------------
    Bob Sosbee
    Senior Developer
    Accounting Systems, Inc. (ASI)
    Covina CA
    803-252-6154 x245
    ------------------------------



  • 11.  RE: Performance issues 2019.2 data entry

    Posted 11-07-2019 13:20
    IT says they don't have a clue where you mean.  Can you give me the specifics of what may need to be changed on the timeout issue?

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Beth Bowers
    269-445-1625
    ------------------------------



  • 12.  RE: Performance issues 2019.2 data entry

    Posted 11-07-2019 15:09
    Seriously?  They can start by researching "net config" and "network share timeout" and "UNC timeouts".  I'm surprised an MCSE wouldn't know this...

    ------------------------------
    Bob Sosbee
    Senior Developer
    Accounting Systems, Inc. (ASI)
    Covina CA
    803-252-6154 x245
    ------------------------------



  • 13.  RE: Performance issues 2019.2 data entry

    Posted 11-07-2019 13:21
    Edited by Alnoor Cassim 11-07-2019 13:21
    I've run into that before. It was exactly what @Michelle Forsey said. DFDM showed 1st record in SO_SalesOrderHeader had a blank key but there was data in the record. After determining it was safe to delete, did so, and then real 1st record loaded w/o delay.

    ------------------------------
    Alnoor Cassim

    Accounting Systems, Inc. (ASI)
    Email: alnoor@asifocus.com
    Orange County, CA
    ------------------------------



  • 14.  RE: Performance issues 2019.2 data entry

    Posted 11-07-2019 13:52
    I checked the obvious suspects - AR_Customer, SO_SalesOrderHeader, SO_InvoiceHeader - nothing

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Beth Bowers
    269-445-1625
    ------------------------------



  • 15.  RE: Performance issues 2019.2 data entry

    Posted 11-07-2019 18:44
    In that case, perhaps have your MD type do a pvx Trace at the point where you select the 1st Customer from S/O Entry (or the 1st order from Shipping Data Entry or from wherever it's happening). They can compare it to a Trace for the next order / customer that loads fast.

    I remember at Sage back in 4.early, this type of slowness occurred when selecting a Customer in S/O Entry that had a tax schedule / tax code with Tax on Tax box checked. It got fixed as far as I know. And I guess that's not in play since AVATAX is the tax schedule here.

    ------------------------------
    Alnoor Cassim

    Accounting Systems, Inc. (ASI)
    Email: alnoor@asifocus.com
    Orange County, CA
    ------------------------------