If you are updating your JumpAgent GUI without prompting from Datavant Site Connect, please notify us by sending an email to support@healthjump.com. If we are aware of an update, we can check that there is still a clear connection and that all the queries run successfully, to avoid any unexpected issues. Thank you, The Datavant Site Connect Team.

Updating the JumpAgent GUI & Common Errors:

1. Locate the JumpAgent GUI (most likely on the desktop).
1. The default installation location is C:\Program Files (x86)\Datavant Site Connect. If you do not know the location of where it was installed, you can also search for JumpAgent in your desktops search bar.
2. Open the JumpAgent GUI.

1. Edit any outdated information in JumpAgent GUI and make sure the credentials are up-to-date.
2. Click “Test Connection”. A pop-up window should appear saying “Successfully Saved”. Click “Ok”.
3. After a few seconds, another pop-up window should appear saying “Connection successfully established”.
4. If “Connection Successfully established” has appeared then please just click Save and Restart in the lower-left corner of the agent to restart the service. If “Connection Failed” has appeared then please go to ‘Common Errors and How to Fix Them’.

Common Errors and How to Fix Them:

• Unhandled Windows Exception.

1. Open your file browser
2. Navigate to your C:\ Drive.
3. In Program Files (x86) you will find the Datavant Site Connect folder.
4. Once you have opened the JumpAgent folder inside the Datavant Site Connect folder you will find the JumpAgent GUI application.
5. Right-click on the JumpAgent GUI then 'Run as Administrator.

Note: If you've changed the default installation location and cannot locate the Datavant Site Connect folder, please contact HealthJump for assistance. 

• Connection Failed:

1. Go to C:/Program Files (x86)/Datavant Site Connect/JumpAgent and open the file ErrorLog.txt
2. Once ErrorLog.txt is opened you can scroll to the bottom for the most recent error messages. Most common errors below:
   
   1. “A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.” This most likely means that either the database IP address, the port number, or the name of the database was entered incorrectly in the JumpAgent GUI.
   2. “Login failed for user”. This means the database credentials were entered incorrectly in the JumpAgent GUI, or the credentials are correct but the user does not have proper access to the database. You can correct this issue by opening your database management tool and editing the properties of the user.
   3. Once you have resolved the configuration issues in the JumpAgent GUI you can click Test Connection and you should see the “Connection successfully established” pop-up.

• Restarting the JumpAgent service:

1. Go to services.msc → JumpAgent - Right Click, select Start or Restart
2. Retest connection.

• If using Windows Authentication instead of SQL credentials to access database:

1. Go to Services.msc → JumpAgent - Right click, select Properties.
2. Go to Log On
3. Fill in the Windows Authentication credentials you entered in the JumpAgent GUI.
4. Apply → Okay.
5. Retest connection.

If none of these solutions help:

Please contact your Datavant Site Connect representative or email us at support@healthjump.com. They can provide you with a link to schedule a call with us so we can further assist you.