Sage 100 Paie & RH


Message d'erreur indiquant "Nombre d'utilisateurs connecté trop important"

Si la réinitialisation de dossier / Application ne fonctionne pas, il convient d'executer une requete sur la base de données avec le Management studio

Verifiez le contenue de T_INSTANCES en affichant les 1000 première lignes. Si personnes n'est connecté, il ne devrait y avoir aucune ligne.

S'il y a malgré tout des lignes, c'est qu'il existe une ou plusieurs connexion fantôme.

La requete à executer est la suivante : DELETE FROM T_INSTANCES (sur la base de données concernée UNIQUEMENT)

Récupérer le matricule d'un salarié "Fantôme" pour le recréer

Identification du salarié concerné

Requête pour récupérer le code interne

Remplacer 'matricule du salarié' par le matricule réel :

SELECT SA_CompteurNumero
FROM T_SAL
WHERE MatriculeSalarie = 'matricule du salarié'

🔎 Noter le SA_CompteurNumero récupéré (code interne salarié).

Exemple :

Suppression complète des données liées au salarié

⚠️ ATTENTION

Requêtes de suppression

Remplacer 2403 par le code interne du salarié.

Delete From T_infoBanque Where NumSalarie in (2403)
Delete From T_InfosParMois Where NumSalarie in (2403)
Delete From T_CUMSAL Where NumSalarie in (2403)
Delete From T_Declaratif Where NumSalarie in (2403)
Delete From T_Langue_Salarie Where NumSalarie in (2403)
Delete From T_BNSSAL Where NumSalarie in (2403)
Delete From T_COTSAL Where NumSalarie in (2403)
Delete From T_FlagInterne Where NumSalarie in (2403)
Delete From T_ZonesLibres Where NumSalarie in (2403)
Delete From T_IRCA Where NumSalarie in (2403)
Delete From T_ENF Where NumSalarie in (2403)
Delete From T_PER Where NumSalarie in (2403)
Delete From T_MUL Where NumSalarie in (2403)
Delete From T_PrevoyanceSalarie Where NumSalarie in (2403)
Delete From T_HAFF Where NumSalarie in (2403)
Delete From T_HBNS Where NumSalarie in (2403)
Delete From T_HCOT Where NumSalarie in (2403)
Delete From T_HCUM Where NumSalarie in (2403)
Delete From T_CUM2SAL Where NumSalarie in (2403)
Delete From T_Duplicata Where NumSalarie in (2403)
Delete From T_BilCum Where NumSalarie in (2403)
Delete From T_BilSal Where NumSalarie in (2403)
Delete From T_PJ_SALARIE Where NumSalarie in (2403)
Delete From T_Compacquise Where NumSalarie in (2403)
Delete From T_Contact Where NumSalarie in (2403)
Delete From T_CumCompteurSal Where NumSalarie in (2403)
Delete From T_CumPartSal Where NumSalarie in (2403)
Delete From T_CumPlanAnalytiqueSal Where NumSalarie in (2403)
Delete From T_EntrEval Where NumSalarie in (2403)
Delete From T_EvtPos Where NumSalarie in (2403)
Delete From T_GHRCal_Pas Where NumSalarie in (2403)
Delete From T_GHRCal_Salarie Where NumSalarie in (2403)
Delete From T_Participant Where NumSalarie in (2403)
Delete From T_PJ_salarie Where NumSalarie in (2403)
Delete From T_Pret Where NumSalarie in (2403)
Delete From T_Reponse Where NumSalarie in (2403)
Delete From T_Saliv_A Where NumSalarie in (2403)
Delete From T_Saliv_B Where NumSalarie in (2403)
Delete From T_Saliv_D Where NumSalarie in (2403)
Delete From T_Saliv_E Where NumSalarie in (2403)
Delete From T_Saliv_F Where NumSalarie in (2403)
Delete From T_Souhait Where NumSalarie in (2403)
Delete From T_GHRSal Where NumSalarie in (2403)
Delete From T_ValeursGHRSal Where NumSalarie in (2403)
Delete From TWf_Compteurs Where NumSalarie in (2403)
Delete From TWf_Conge Where NumSalarie in (2403)

Delete From T_SAL Where SA_CompteurNumero in (2403)

Vérification finale

  1. Relancer l’application.

  2. Recréer le salarié si nécessaire.

  3. Relancer le traitement de la paie.

  4. Vérifier l’absence d’erreur.

Bonnes pratiques