Prev
Next
Forums User Experience Lawson Add-Ins for Microsoft Office

Add-Ins Peformance Issues

 7 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages


Greg Moeller











Veteran Member



Posts: 1498




Veteran Member



5/23/2016 5:25 PM

    Hi!

    We're upgrading to Infor10 and switching platforms from Unix to Windows.

    We're struggling because an Addins that should take no longer than 10 minutes tops has been running now for nearly 45 and isn't even half done.

    Any settings that I could look at?

    TIA,

    -Greg



    John Henley














    Posts: 3353







    5/23/2016 7:01 PM
      Hi Greg,
      Did you install new version of the addins for v10?
      Also, look for log file, in C:\Users\\AppData\Roaming\Lawson Software\Office Add-ins
      Thanks for using the LawsonGuru.com forums!
      John


      Kat V











      Veteran Member



      Posts: 1020




      Veteran Member



      5/24/2016 5:10 PM
        What John said and a note about Office version - v9 works fine on my desktop with Office 10. Coworker had to upgrade to both v10 and Office 10 to get it to work. There are issues with users on older version of Windows.

        (I'm public healthcare - there are a lot of users on older versions.)


        Jeff Shumate











        Advanced Member



        Posts: 31




        Advanced Member



        5/24/2016 9:49 PM

          I've been advised by Infor (though I have not tried yet) that I should horizontally scale a WAS cluster with one WAS just for handling add-in traffic.  They made it sound like everybody on version 10 is doing it...



          John Henley














          Posts: 3353







          5/25/2016 12:05 PM
            um, no. that is a drastic measure that shouldn't be required.
            Thanks for using the LawsonGuru.com forums!
            John


            Jason Beard











            Veteran Member



            Posts: 124




            Veteran Member



            5/26/2016 1:16 AM
              Jeff -
              as John said, that is a drastic measure however I'm not sure I agree that it shouldn't be required. It depends on your use of add-ins and the rest of the system. I've had clients that absolutely pounded the system via add-ins. Best example is applying cash in AR via spreadsheet. 60K lines minimum and they would run them multiple times throughout the day. Portal would immediately slowdown as the rest of the users were going through the same path to perform their daily duties. Separating add-ins had the immediate benefit of reducing the impact on the rest of the user base and the added benefit of preventing a poorly written add-ins query from tying up too man web sphere threads when the user killed it and started again... over and over and over...
              Long answer to saying... that it is an option and has it's benefits but is not to be taken lightly and no not "everyone on v10 is doing it"
              Jason Beard
              617-548-5568
              jabeard3@gmail.com


              Greg Moeller











              Veteran Member



              Posts: 1498




              Veteran Member



              7/11/2016 5:39 PM
                We did install the new version to go along with our upgrade to Infor10.. We've also enabled the "Multi-thread" where it makes sense, but Add-Ins still run slower than they did in our Oracle days.
                We have found that running Fiddler along side of Add-Ins speeds the upload WAY up, but nobody has a local install of Add-Ins but us in IT.
                Everyone else accesses Add-Ins via Citrix.


                drewlewis15











                New Member



                Posts: 2




                New Member



                12/19/2017 8:56 PM
                  I know this is an older thread, but did Infor offer up a solution for the performance issue? We recently upgraded from v9 to v10 MOA, and have noticed significant performance issues... Uploads running twice as long. We have had a case logged with Infor for over a year now continually testing new versions of v10 MOA. Any insight/solution that anyone can offer would be greatly appreciated!