The information below details common Gateway integration error messages including the cause and solutions. These errors are applicable to Solver Cloud customers only. Please reference this kb article for troubleshooting steps should your integration fail to complete.
This article is broken down into the following sections:
- How to Find the Error Logs
- Restarting the Gateway OnPrem Service
- Troubleshooting Gateway integrations
How to Find the Error Logs?
The Gateway application generates and stores error logs which provides detailed error messages for when the application fails. These log files can be found in the hidden ProgramData folder.
- First, navigate to the C:\ drive, or other hard drive where the Gateway is installed.
- Click on the View tab, check off the Hidden items to expose the hidden folder.
- Click into the now exposed ProgramData folder Solver Gateway On-Premise Logs
- You should see a list of log files.
Restarting the Gateway OnPrem Service
The Gateway service should be running at all time, if it is not running, your Gateway integration will fail.
- Go to the machine where the Gateway application is installed
- Navigate to the start menu, search for Services
- Look for an application similar to BI360 Gateway or Gateway OnPrem Service
- Right click on said service, select Restart
- Re-select the data connection within your integration, then save and publish the integration to save the settings.
Please ensure all recovery modes are set to Restart the Service after failures.
Troubleshooting Gateway integrations
Common Errors in Gateway Setup
Service 'GatewayOnPrem' (GatewayOnPrem.exe) failed to start
The attempted installation of Cloud's Gateway connector results in the following error and installation of Gateway does not complete:
Check to verify the port for Gateway is not blocked by a firewall or occupied by another application.
Login failed for user 'NT AUTHORITY\SYSTEM'
When the user attempts to set up a Data Source with windows authentication in the Gateway application, it returns a "400 - Bad Request, Login failed for user 'NT AUTHORITY\SYSTEM' " error. The user has verified the windows user being used in the connection has the required permissions, all information has been input correctly as well. However, the Gateway continues to return the login fail error and references a system user rather than the actual windows user.
The application is passing off the system user "NT AUTHORITY\SYSTEM" rather than the actual windows user typed in even though windows authentication is selected.
- Log into the computer as that windows user and setup the Gateway
- From the computer where Gateway is installed, change the service to run as the windows user instead of "Log on as Local System Account" in Properties
NOTE: Each time the credential expires for the windows user, the credential will need to be updated in Properties for the Gateway OnPrem service again.
Gateway AppData Folder Error During Install
The attempted installation of Cloud's Gateway connector immediately results in one of the following two errors (or both):
The Gateway software needs access to the AppData folder during install in order to install some ancillary files and most likely, the user installing does not have access to the AppData folder location/there is not enough space in this folder to install. Assure the user installing the Gateway has write privileges to the AppData folder C:\Users\<UserName>\AppData, as well as that there is enough memory in this location to install the ancillary files Gateway will be installing.
Gateway Unable to read CSV files in Data Connection
Verify if there is any duplicate column names or special characters in the file and ensure each column name is unique.
Gateway Integrations Timing Out
A user finds that the all of their previously working Gateway integrations are failing with either one of the below timeout errors.
"Timeour expired after 30 minutes"
"Gateway client has not sent over a single one of the remaining batches for more than 60 minutes"
This issue can be caused by various reasons:
- The Gateway OnPrem Service is unable to be reached due to the the service stopping (i.e. automatic updates on the server the Gateway application is installed on)
- Web service account is no longer valid (i.e. password expires)
- Lack of resources on the Gateway machine to handle the data load
If you are not sure which one of the above is the root cause, begin troubleshooting with #1, then move on to #2. You may also contact Solver Support to help determine if #3 is the problem.
For #1, this scenario applies if each integration keeps failing after the first "Timeout expired" message. It this case, follow the below instructions to restart the Gateway OnPrem Service:
- Go to the start menu, search for Services
- Look for an application similar to BI360 Gateway or Gateway Services
- Right click on the services, select Restart
- Log out of the Cloud tenant, close out of the browser, then re-login to the tenant
- Verify if you can see the data connection now
For #2, check out this KB article to verify the web service credential being used in the data connection in the Gateway application.
For #3, it is recommended that the Gateway to be installed on a dedicated machine to ensure it has sufficient resources to run integrations. In terms of system specs, we can only provide the minimum requirements, depending on the organization's usage, you may need to beef up the machine accordingly. Below is the minimum requirements that is required for the Gateway machine.
|Operating System (32 or 64bit)||
|RAM||8GB minimum (16GB recommended)|
|Processor (32 or 64bit)||Intel or AMD, 2 core minimum (64bit recommended)|
Task Details Stuck in Spinning
The user moved the Gateway app to a new server. When they tried to update the Source Table and Target Table in the integration Task Details, the two fields kept spinning and it eventually timed out.
The spinning wheel indicates the Cloud cannot establish a connection to the data source, in this case, the integration lost connection to the Gateway app.
Since the Gateway is moved to a new server, the data connection in the Gateway app will need to be updated to use the correct server and any fields that was changed. The data connection being used in the integration will need to be "refreshed" in Cloud as well.
- Go to http://localhost:8080 on the machine where the Gateway application is installed
- Login to Gateway, Solver does not keep track of clients' credentials, you will need to obtain this from the person who manages the integrations
- Click on the data connection that is being used for the failing integration
- Verify all the fields are correct, update any fields that needs to be updated. Then click Save.
- Search for "Services" in the start menu, search for "Gateway OnPrem", right click and restart the service.
- Navigate to Cloud, click on the failing integration, it should direct the user to the Task Details page
- Navigate to the "Gateway" tab, you should see a drop down list that allows user to choose the data connection, select the appropriate connection
- Navigate to the mapping page, click "Preview" on the source data to verify if the connection is re-established
- Save the changes. You may now re-run the integration.