Sage 100

 View Only
Expand all | Collapse all

Reports Slow in One Company

  • 1.  Reports Slow in One Company

    Posted 03-07-2019 10:16
    I have a client on 2018 PU 2 (5.40.2.0) Advanced who is experiencing slowness running reports out of one of their 7 companies. The other companies run fine.

    They are using the CS ODBC. I’ve switched it off and on to see if there was a difference. There wasn’t.

    I turned off DEP and rebooted. No change.

    Any ideas?

    ---------------------------------
    Robert Wood
    DDF Consulting Group, Inc.
    Ocala FL
    352-615-5898
    ---------------------------------


  • 2.  RE: Reports Slow in One Company

    Posted 03-07-2019 10:28
    Edited by Rhonda McNamara 03-07-2019 10:29
    Spawn Tasks? I'm sure you ruled out AV and Anti-Malware as the first thing. Right.  One company, not one user.

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



  • 3.  RE: Reports Slow in One Company

    Posted 03-07-2019 10:38
    Do you know if it is in one module in particular or all modules ?

    You may want to copy this company to a new company, and then rebuild Key files and Sort files in the copy and see if the copy runs it faster...

    Jeff

    ------------------------------
    Jeff Fiddelman
    Exeplex, LLC
    ------------------------------



  • 4.  RE: Reports Slow in One Company

    Posted 03-07-2019 10:58
    So far, I've tested AP & SO. I'm copying the company now and also going to test other modules.

    ------------------------------
    Robert Wood
    DDF Consulting Group, Inc.
    Ocala FL
    352-615-5898
    ------------------------------



  • 5.  RE: Reports Slow in One Company

    Posted 03-07-2019 11:34
    Runs the same in the copied company. Rebuilt copied company and no improvement.

    ------------------------------
    Robert Wood
    DDF Consulting Group, Inc.
    Ocala FL
    352-615-5898
    ------------------------------



  • 6.  RE: Reports Slow in One Company

    Posted 03-07-2019 11:36
    Running from the Sage server (not a terminal server)?

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



  • 7.  RE: Reports Slow in One Company

    Posted 03-07-2019 11:46
    Edited by Robert Wood 03-07-2019 11:51
    Running from the Sage server, it took about 15 seconds.

    From the terminal servers, it runs in about 13 minutes.

    From workstations further away on the network, it takes an hour+.

    From another company that has more data, the same report takes about 15 seconds on the terminal server.

    ------------------------------
    Robert Wood
    DDF Consulting Group, Inc.
    Ocala FL
    352-615-5898
    ------------------------------



  • 8.  RE: Reports Slow in One Company

    Posted 03-07-2019 12:02
    CS ODBC should be a resolution - ...

    Jeff

    ------------------------------
    Jeff Fiddelman
    Exeplex, LLC
    ------------------------------



  • 9.  RE: Reports Slow in One Company

    Posted 03-07-2019 12:21
    They are running CS ODBC. The same users from the same workstations are running the reports.

    I've tested it both on and off. It was actually running faster for me on the terminal server with the CS ODBC turned off.

    This just started Tuesday.
    --

    Robert C. Wood  Consultant

    DDF Consulting Group, Inc.

    direct: 352.615.5898 | help desk: 888.289.2075

    RobertW@ddfcgi.com |  www.ddfcgi.com


    Eric Hoffer: "In times of change learners inherit the earth; while the learned find themselves beautifully equipped to deal with a world that no longer exists."




    ------Original Message------

    CS ODBC should be a resolution - ...

    Jeff

    ------------------------------
    Jeff Fiddelman
    Exeplex, LLC
    ------------------------------


  • 10.  RE: Reports Slow in One Company

    Posted 03-07-2019 12:10
    Using the same printer objects (local to TS vs. redirected)?
    Are you running the Sage service using a domain account?
    Force the Read Only flag off for the entire MAS90 folder?

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



  • 11.  RE: Reports Slow in One Company

    Posted 03-07-2019 12:39
    If you compare setup between companies in Company Maintenance, is there anything unusual about the slow company?  Maybe the data location in the preferences tab.  Any custom mods?

    ------------------------------
    Chris St. Amand
    Arizona Accounting & Information Systems
    ------------------------------



  • 12.  RE: Reports Slow in One Company

    Posted 03-07-2019 13:14
    Did someone accidentally create a ton of fiscal years this week?  That can slow things down.

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



  • 13.  RE: Reports Slow in One Company

    Posted 03-07-2019 17:17
    It ended up being corrupt data in both SO and AP in the one company.

    ---------------------------------
    Robert Wood
    DDF Consulting Group, Inc.
    Ocala FL
    352-615-5898
    ---------------------------------





  • 14.  RE: Reports Slow in One Company

    Posted 03-07-2019 17:23

    Thanks for letting us know Robert!  That helps us a lot!

     

    Sue Bennett | President

    P. 503 620 3484 | F. 503 620 2765

    12559 SW 69th Ave | Tigard, OR  97223

    Sue@benpor.com www.benpor.com

    Bennett/Porter Blog facebook twitter

     

     



    ------Original Message------

    It ended up being corrupt data in both SO and AP in the one company.

    ---------------------------------
    Robert Wood
    DDF Consulting Group, Inc.
    Ocala FL
    352-615-5898
    ---------------------------------