Sage 100

 View Only
  • 1.  Spawn Tasks

    Posted 03-04-2024 14:51

    I have recently been doing several Standard to Advanced conversions, as well as regular Advanced upgrades to v2023. It seems like without fail, with every upgrade, I need to go and check the Spawn Tasks for all users. Otherwise, they all get the "Connection failure to host: [TCP]server:port number:NODELAY;STREAM" error. I have increased the HEAP size, but that does not help. Sage100 is running as a Service, and I would like to keep it this way. Is there a trick to fixing this so checking the Spawn tasks is not required? Most of these upgrades are to new servers with plenty of RAM and Speed with all the bells and whistles. I always thought this was a slow server or slow connection issue, but these servers are new, and the network connections are not problematic.



    ------------------------------
    Kenny Daniel
    TechnoClarity, Inc.
    ------------------------------


  • 2.  RE: Spawn Tasks

    Posted 03-04-2024 17:23

    It's in our upgrade checklist, for conversions from Standard to one of the C/S versions, to always check this box for all users (to prevent errors on day 1). 

    I know of no alternative.



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



  • 3.  RE: Spawn Tasks

    Posted 03-04-2024 20:21

    My question:

    Why do some sites require spawn tasks to be checked - or users receive the "Connection Failure".

    Other sites do not require spawn tasks to be checked - and do not generate a "Connection Failure."

    I know the fix/workaround; however, most IT people press on this issue by asking why this option (spawn tasks) is or isn't required.

    I'm unsure that Sage knows why spawn tasks may (or may not) be required.



    ------------------------------
    Wayne Schulz
    wayne@s-consult.com
    Schulz Consulting
    (860) 516-8990
    Moodus, CT
    ------------------------------



  • 4.  RE: Spawn Tasks

    Posted 03-05-2024 13:57

    Here are some key notes I took while on a call with Sage support a month or two ago regarding another issue.  

    • KeepAlives should be unchecked.  Sage 100 doesn't benefit from this ProvideX feature.
    • Re-Connect should be set to None. 
    • Spawn tasks from application server under User Maintenance should only be checked for problem users, not all users.  See this KB, Spawn Tasks Information (sage.com).  If this is unchecked, the pvxwin32.exe process should be added as a firewall exception because it will use dynamic ports.
    • If using the C/S ODBC driver, the pvxiosvr.exe process should be added as a firewall exception because it will use dynamic ports beyond the configured port (default is 20222).


    ------------------------------
    David Speck II
    Blytheco LLC
    ------------------------------



  • 5.  RE: Spawn Tasks

    Posted 03-05-2024 14:23

    Spawn tasks from application server under User Maintenance should only be checked for problem users, not all users.

    I seem to run into all-or-nothing situations. Within User Maintenance - I need to either (a) check "spawn tasks" for all users or (b) I don't need it for anyone. I'm not sure why.



    ------------------------------
    Wayne Schulz
    wayne@s-consult.com
    Schulz Consulting
    (860) 516-8990
    Moodus, CT
    ------------------------------



  • 6.  RE: Spawn Tasks

    Posted 03-05-2024 16:07

    Thanks @David Speck II. That is great information and concise!  I thought that at one time I was told that you could not "mix" the Spawn Tasks from Server setting and all users had to be set the same. I'm glad that is not the case as it will make it easier going forward. Maybe it is the firewall issue that we keep running into and setting that exception could prove helpful. 



    ------------------------------
    David Overholt
    DWD Technology Group
    ------------------------------



  • 7.  RE: Spawn Tasks

    Posted 03-06-2024 07:54

    I have the same experience as Wayne, either check-all or check-none (no middle ground), but I'm excited to try the pvxwin32.exe firewall exception, which is new to me.



    ------------------------------
    Steve Iwanowski, NextStep Technology Advisors, aka DSD Lancaster PA ¯\_(ツ)_/¯
    ------------------------------



  • 8.  RE: Spawn Tasks

    Posted 03-05-2024 19:18

    Thanks for the information David!  That is very interesting.  I could have sworn I had issues with the error for processes directly on the Sage server (where presumably the firewall "should" not be involved)... but the connection is to a port, and the firewall might not sense that the connection attempt is from the same machine.

    Sage seriously needs to document these things in the KB.  Sharing critical nuggets of information in support calls is insufficient.

    Also, I'd never seen this KB article before... nice to know what the checkbox actually does.



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