Error Connection Failure to.

SUGGESTED

Hello,

I do have sage 100 advance 5.008.00, one of the user gets disconnect from the server that's what I assume because of the message.

host:[tcp]server1.companyname.local;49383;NODELAY;STREAM

 

 she needs to log off and then log in in order to get back in sage, I Did check the Spawn tasks from application server in the user Maintenance but it did happen again this morning (I did check that last Friday)

any advice

.Thank you

 

  • 0
    SUGGESTED
    That error can appear if a firewall (Windows Firewall, software such as Antivirus, or Router firewall) is blocking the temporary ports used by Sage 100.

    The Knowledgebase article below may be helpful (KB article id 19875).

    This, and all other knowledgebase articles are available on-line at our Sage Support portal https://support.na.sage.com

    You can Logon using your normal Customer or Partner credentials or register for the first time if you have not done so already.

    Error: "Connection failure to host: [TCP]<server>:<port number>:NODELAY;STREAM" occurs when accessing and processing through any task module in Sage 100

    Products: Sage 100

    Description
    Error: "Connection failure to host: [TCP] <server> : <port number> : NODELAY : STREAM" occurs when accessing and processing through any task module in Sage 100

    How to create program inbound rules for Firewall

    Disclaimer
    Network Warning
    This solution requires advanced knowledge of your network. Contact your system administrator for assistance. Modifying Windows security incorrectly can severely affect system operations. Sage is not responsible for operation issues caused by incorrectly modifying your Windows security. Always create a backup of your data before proceeding with advanced solutions.

    Cause
    - Firewall rules are not properly set for the Sage 100 program
    - The service may be corrupt or another application is using the same port number as Sage 100 ERP.
    - The root cause is often due to a problem with the network environment. The suggested resolutions are potential workarounds.

    Resolution
    To resolve these issues, perform the following:
    * If error occurs with all tasks and the port number in error is random port number from 49152 - 65535 then Program Process Inbound Rules needs to be created on the Windows 2008 or 2012 Server under Windows Firewall Advanced Security.

    Open Administrative Tools, Windows Firewall with Advanced Security console
    In the left pane of the console, select Inbound Rules
    Right-click select New Rule
    Select Program click Next
    Select "This program path:" and browse to <drive letter>\..\mas90\home\pvxwin32.exe (i.e. C:\Sage\MAS90\Home\pvxwin32.exe) on server
    Select Next until get to 'Specify the name and Description of this Rule" screen
    Enter name for Inbound Rule
    Select Finish

    ** If using C/S ODBC Driver in Sage 100 Advanced follow the steps below:
    In the left pane of the console, select Inbound Rules
    Right-click select New Rule
    Select Program click Next
    Select "This program path:" and browse to <drive letter>\..\mas90\Home\pvxiosvr.exe (i.e. C:\Sage\MAS90\Home\Pvxiosvr.exe) on server
    Select Next until get to 'Specify the name and Description of this Rule" screen
    Enter name for Inbound Rule
    Select Finish

    *** To remove corruption from the Sage 100 service, disable and reinstall the service. Then create new files:

    To uninstall the Sage 100 ERP service:

    From the Windows desktop on the Sage 100 server, click the Start button. On the Programs menu, point to Sage Software, and then click Uninstall Application Server Service.
    In the Service field, select the service, and then select the port of the service.
    Click the Remove button.
    Click Yes to confirm.

    To reinstall the Application Server Service:

    From the Windows desktop on the Sage 100 server, click the Start button. On the Programs menu, point to Sage Software, and then click Application Server Service Setup.
    Select the path to the Sage 100 folder
    Click OK to add the service.
    Note: The service is added based on the settings on the Server tab of Application Server Configuration.

    **** To refresh the Application Server Configuration files in case of corruption and make the connection more stable:

    Stop the Application Server and close the Application Server Configuration application.
    On the Sage 100 ERP server, rename the following files:
    ..\MAS90\MAS_System\SY_Console.m4t
    ..\MAS90\MAS_System\SY_Workstation.m4t
    ..\MAS90\Home\Lib\_Appserv\Locate.pvk
    ..\MAS90\Home\Lib\_Appserv\Sessions.pvk
    Restart the Application for Sage 100 ERP Advanced or Premium
    From the Windows Desktop at the Sage 100 ERP server, click Start
    On the Programs menu, point to the Sage Software or Sage program folder
    Select click Application Server Configuration
    Click the Server tab. Clear the KeepAlives check box
    Click the Clients tab. On the Re-Connect list, select None
    Note: New Locate.pvk and Sessions.pvk files are created when the Application is restarted. If Sage 100 ERP is normally run as a Service, start the Application first and follow the steps above, then make sure at least one user can log in. Then have that user log out and stop the Application, then Start the Service and allow users to log in.)

    If problem continues, consider changing the port number:
    At the Sage 100 ERP server, set the service to Manually Start.
    From the Windows Desktop on the Sage 100 server, click Start. On the Programs menu, point to Sage Software or Sage program folder, then click Application Server Configuration.
    Click the Server tab. In the Sockets field, change the socket number to any unused number between 9,000 and 10,000. (If using a firewall, make sure the port is not blocked.)
    Click the Start button
    If the service starts and runs as an application on the new port number, remove the previous service, and create a new one with the new port number.
    Remove the original service using Uninstall Application Server Service.
    Create a new service using Application Server Service Setup

    ***** If the message is occuring for Specific users:
    Have all users exit Sage 100.
    Log on to Sage 100 as Administrator.
    From Administrative Tools, select User Maintenance.
    Select the first user, and click the Preferences tab.
    Select the Spawn Tasks from Application Server check box, and click Accept.
    Proceed for remaining users.
    Click Done.

    ****** Run Sage 100 as an Application rather than as a Service:
    On the Sage 100 server from the Windows Taskbar, click Start, Program Files, Sage, Application Server Configuration.
    Click Start