Skip to main content

SQL Integration and Dataset Statuses

Updated

You may occasionally encounter different SQL statuses on the Integrations page when troubleshooting dataset, synchronization, or widget issues in setups with an SQL integration. Understanding each of these statuses is vital for successful troubleshooting. 

This article lists each SQL status to aid in the investigation and resolution of SQL-related issues. 

SQL Agent Status

The SQL Agent Status is the message displayed beside the SQL Agent entry on the Integrations page. A Success message indicates that the SQL Agent client is properly installed and the network connection is working. 

SQL-agent-success.png

A red status signals a problem with the SQL agent's connection with MSPbots and may suggest recommended actions. The example below shows a data synchronization issue with the SQL agent. 

SQL-warning-data-sync-stopped.png

For more information on SQL agent connection error messages, see SQL Agent Integration States in the MSPbots App. 

You may encounter synchronization issues even when the SQL Agent connection is successful. When this happens, check the database and dataset statuses for errors you might be experiencing. Read on for more information. 

Database Status 

The Database Status is the overall state of the connectors you have set up with the SQL Agent integration. A Connect Success status indicates that the current database is accessible and available. 

SQL-server-connect-success.jpg

On the other hand, a red status indicates that at least one of the connected databases has an error.  The image below is an example of a Database Status indicating an error.   

SQL-server-error.png

The status provides the details of the error and may offer a recommended action.  

Dataset Status  

The Dataset Status displays the outcome of the last sync attempt. A Failed status shows the error details and will continue to appear until the next sync becomes successful. You can check the error details for guidance on resolving the issue. 

SQL-dataset-error.png

 

The SQL Agent may show a Success integration status even when the data sync fails. The Failed message will disappear on the next successful sync. 

Below are some examples of dataset errors that users may encounter. 

{"status":43,"info":"EXECUTE PUSH ERROR:One or more errors occurred. (Error while copying content to a stream.)","threshold":"threshold","currently":null}{"status":43,"info":"EXECUTE PUSH ERROR:One or more errors occurred. (An error occurred while sending the request.)","threshold":"threshold","currently":null}{"status":43,"info":"EXECUTE PUSH ERROR:One or more errors occurred. (A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. (agent-collect.mspbots.ai:443))","threshold":"threshold","currently":null}

For help with troubleshooting, please submit a Technical Support request. 

Related information: