Skip to main content

ChapterSage Connection

Chapter 13 — When something gets stuck

Each blockage has its message, and each message says what to do. Here are the ones you may meet, step by step, with their remedy.

In this chapter

  • The agent and the server
  • The extraction
  • The sync
  • The mappings and payroll
  1. Read the message
  2. Find the step
  3. Apply the remedy
  4. Run again
Book contents

The agent

What you seeWhat to do
The agent's card is OfflineThe computer is off, the agent window closed, or the internet down at the client's. Start agent-setup.exe again on that computer.
Agent window on « Arrêté » (stopped), with under Activité « Jeton refusé (401). Vérifiez le jeton de l'agent. » (token refused)The token is mistyped, or the agent was revoked: the agent stopped by itself. Paste the token again, then click Démarrer. Token lost: revoke the agent and create another one (chapter 2).
Agent window: « IntegraSys injoignable — nouvelle tentative… » (IntegraSys unreachable, retrying)No internet on this computer, or a firewall blocks outgoing traffic to IntegraSys. The agent retries by itself; check the connection.
Agent window: « Échec de l'activation du démarrage automatique : … » (auto-start failed)Start agent-setup.exe with Run as administrator, click Arrêter, tick auto-start again, then Démarrer (chapter 2).
« The agent is not available for download yet. Contact the IntegraSys team. »The program is not published yet: write to the team.

The server and the databases

What you seeWhat to do
« The local agent did not answer within 90 seconds. Check in « Local agents » that it is Online, then try again. »The agent is no longer picking up requests. Check its card and its window, then click again.
Test connection and Show databases greyed outThe server linked to an agent is not saved yet: click Save, then open it again.
« Data source name not found and no default driver specified »The form's ODBC driver is missing on the agent's computer: install ODBC Driver 18 for SQL Server, or type the name of the driver installed there.
A login or password refusalCheck the User, the Password and this account's rights on the database. With Windows, the account the agent runs under is the one that needs access.
The Client list of the Extraction screen is emptyNo database is assigned to a client: see chapter 4.

The extraction

What you seeWhat to do
The extraction stays PendingThe agent is not Online: see above.
The extraction goes back from Running to Pending, then starts againThe agent gives no more news on the way: restart it on the client's computer (chapter 6).
« Interrompu : l'agent n'a pas terminé le travail (plusieurs tentatives). » (interrupted: the agent did not finish the job)The agent dropped the extraction three times before it had started. Look at the Activité area of its window, then run the extraction again.
Under a data set: « Reason: … »A table or column does not exist under that name, or the SQL account has no right to read it. Correct the card in Mappings (chapter 5), then run again.
« Aucun jeu de données n'a pu être extrait. » (no data set could be extracted)No data set came through: most often, unexpected table names. Check Mappings.
« Check: entries missing »The read was cut short: run the extraction again (chapter 7).
« The results could not be sent: the agent goes through the website address… »In the agent window: Arrêter, replace the address with the one the message gives, Démarrer, then run again. Better: update the agent.
« The results exceed what the server accepts in a single upload… », or, in the window of an agent 1.10.2, « Envoi des résultats refusé par le serveur : … »Update the agent (1.11 or later), or run again with fewer fiscal years at a time.

The sync

What you seeWhat to do
« Le client n'a pas de dossier comptable (tenue comptable). » (no accounting file)Open the client's accounting file, then run again.
« Cette base n'est reliée à aucun client. » (database linked to no client)Assign the database to its client under Client databases, then click Sync to Accounting again.
« L'extraction doit être terminée avec succès. » (the extraction must have succeeded)Wait for the extraction to end, or run it again if it failed.
Orange box « Syncing requires an extraction that includes "Accounting entries". » instead of the buttonTick Écritures comptables and run the extraction again.
In Progress, « Données de synchronisation trop volumineuses (…) : relancez l'extraction sur un seul exercice à la fois. » (sync data too large)An old agent sent too much: update it, or extract one year at a time.
« Données de synchronisation… » sentences followed by « Toutes les écritures n'ont pas été extraites : relancez l'extraction. »The extraction has holes: run it again (chapter 7).
« Aucun exercice 2023 dans ce dossier — créez-le d'abord. »Click Create fiscal year 2023 (chapter 8).
« Exercice 2023 clôturé, veuillez le réouvrir. »Reopen the fiscal year in the accounting, then run again.
« Sync stopped: … »The takeover stopped on the error quoted. What was already written stays written; fix the cause if it is on your side, then click again: nothing is duplicated.
« The takeover report could not be downloaded. »Try again a little later; if it happens again, write to the team.

The mappings and payroll

What you seeWhat to do
« No database uses this software: first declare the client’s Sage Paie database (External connection › Databases). »Assign the Sage Paie database with the source software Sage Paie (SQL Server) (chapter 4).
« L'IA n'a pas pu proposer la correspondance (crédits IA épuisés)… » (the AI could not propose the mapping)A name-based proposal was made instead: check it, or top up the firm's AI credits.
« This extraction carries no importable payroll data… »Tick at least one of the six data sets taken over, with an agent 1.12 or later, and run again.
« No HR file in the firm: first open the client’s HR file. »Open the client's HR file (book « HR & Payroll »).

If nothing helps

Write to the IntegraSys team from Complaints, in the Tools menu. Give the client, the database, the time of the extraction and the exact message: a screenshot of the Progress card saves time.