================== SCRIPT DE RELANCE DE FLUX GNAU AVEC DES JOBS VIDES ==================
Ce script permet de résoudre les erreurs suivantes:
Cerfa non transmis par le GNAU
================== Nombre de flux restant à bloqués =====================
39
================== Etape 0 =====================
Vérifier un flux dans le dossier jobs que le dossier soit vide
================== Etape 1 =====================
Recuperer les requêtes de restauration des flux en erreurs GNAU et garder les de côté pour plus tard

update gna_transmission set tra_statut =2 , tra_statutcodeerreur =null ,tra_statutliberreur= null WHERE tra_numtransmission in('34057-1-03022022151715-363-INI_CREATION-03022022155318') and tra_statutcodeerreur = '8' and tra_statut =3;
update gna_transmission set tra_statut =2 , tra_statutcodeerreur =null ,tra_statutliberreur= null WHERE tra_numtransmission in('34057-20-14022022101446-856-INI_CREATION-14022022102623') and tra_statutcodeerreur = '8' and tra_statut =3;
update gna_transmission set tra_statut =2 , tra_statutcodeerreur =null ,tra_statutliberreur= null WHERE tra_numtransmission in('34057-20-14022022145411-874-INI_CREATION-14022022151225') and tra_statutcodeerreur = '8' and tra_statut =3;
update gna_transmission set tra_statut =2 , tra_statutcodeerreur =null ,tra_statutliberreur= null WHERE tra_numtransmission in('34057-20-15022022155806-932-INI_CREATION-15022022160016') and tra_statutcodeerreur = '8' and tra_statut =3;
update gna_transmission set tra_statut =2 , tra_statutcodeerreur =null ,tra_statutliberreur= null WHERE tra_numtransmission in('34057-20-15022022173738-942-INI_CREATION-15022022174343') and tra_statutcodeerreur = '8' and tra_statut =3;
update gna_transmission set tra_statut =2 , tra_statutcodeerreur =null ,tra_statutliberreur= null WHERE tra_numtransmission in('34022-11-21022022113256-1110-INI_CREATION-21022022121018') and tra_statutcodeerreur = '8' and tra_statut =3;
update gna_transmission set tra_statut =2 , tra_statutcodeerreur =null ,tra_statutliberreur= null WHERE tra_numtransmission in('34057-20-22022022090243-1138-INI_CREATION-22022022090506') and tra_statutcodeerreur = '8' and tra_statut =3;
update gna_transmission set tra_statut =2 , tra_statutcodeerreur =null ,tra_statutliberreur= null WHERE tra_numtransmission in('34057-5-24022022163417-1261-INI_CREATION-24022022175947') and tra_statutcodeerreur = '8' and tra_statut =3;
update gna_transmission set tra_statut =2 , tra_statutcodeerreur =null ,tra_statutliberreur= null WHERE tra_numtransmission in('34057-20-23022022144202-1215-INI_CREATION-23022022145124') and tra_statutcodeerreur = '8' and tra_statut =3;
update gna_transmission set tra_statut =2 , tra_statutcodeerreur =null ,tra_statutliberreur= null WHERE tra_numtransmission in('34022-5-10032022062733-1599-INI_CREATION-10032022063252') and tra_statutcodeerreur = '8' and tra_statut =3;
update gna_transmission set tra_statut =2 , tra_statutcodeerreur =null ,tra_statutliberreur= null WHERE tra_numtransmission in('34057-20-10032022113800-1602-INI_CREATION-10032022113958') and tra_statutcodeerreur = '8' and tra_statut =3;
update gna_transmission set tra_statut =2 , tra_statutcodeerreur =null ,tra_statutliberreur= null WHERE tra_numtransmission in('34057-20-30032022112208-2300-INI_CREATION-30032022113104') and tra_statutcodeerreur = '8' and tra_statut =3;
update gna_transmission set tra_statut =2 , tra_statutcodeerreur =null ,tra_statutliberreur= null WHERE tra_numtransmission in('34057-20-05042022112102-2423-INI_CREATION-05042022112546') and tra_statutcodeerreur = '8' and tra_statut =3;
update gna_transmission set tra_statut =2 , tra_statutcodeerreur =null ,tra_statutliberreur= null WHERE tra_numtransmission in('34057-5-31032022071110-2326-INI_CREATION-31032022071320') and tra_statutcodeerreur = '8' and tra_statut =3;
update gna_transmission set tra_statut =2 , tra_statutcodeerreur =null ,tra_statutliberreur= null WHERE tra_numtransmission in('34022-20-08042022155700-2546-INI_CREATION-08042022155935') and tra_statutcodeerreur = '8' and tra_statut =3;
update gna_transmission set tra_statut =2 , tra_statutcodeerreur =null ,tra_statutliberreur= null WHERE tra_numtransmission in('34057-20-12042022094253-2599-INI_CREATION-12042022094552') and tra_statutcodeerreur = '8' and tra_statut =3;
update gna_transmission set tra_statut =2 , tra_statutcodeerreur =null ,tra_statutliberreur= null WHERE tra_numtransmission in('34057-5-15042022072446-2728-INI_CREATION-15042022073854') and tra_statutcodeerreur = '8' and tra_statut =3;
update gna_transmission set tra_statut =2 , tra_statutcodeerreur =null ,tra_statutliberreur= null WHERE tra_numtransmission in('34057-5-14042022083911-2674-INI_CREATION-14042022084225') and tra_statutcodeerreur = '8' and tra_statut =3;
update gna_transmission set tra_statut =2 , tra_statutcodeerreur =null ,tra_statutliberreur= null WHERE tra_numtransmission in('34057-20-14042022145354-2705-INI_CREATION-14042022145759') and tra_statutcodeerreur = '8' and tra_statut =3;
update gna_transmission set tra_statut =2 , tra_statutcodeerreur =null ,tra_statutliberreur= null WHERE tra_numtransmission in('34057-20-15042022104155-2739-INI_CREATION-15042022104615') and tra_statutcodeerreur = '8' and tra_statut =3;
update gna_transmission set tra_statut =2 , tra_statutcodeerreur =null ,tra_statutliberreur= null WHERE tra_numtransmission in('34057-20-17042022153319-2785-INI_CREATION-17042022153645') and tra_statutcodeerreur = '8' and tra_statut =3;
update gna_transmission set tra_statut =2 , tra_statutcodeerreur =null ,tra_statutliberreur= null WHERE tra_numtransmission in('34057-5-19042022163037-2835-INI_CREATION-19042022163556') and tra_statutcodeerreur = '8' and tra_statut =3;
update gna_transmission set tra_statut =2 , tra_statutcodeerreur =null ,tra_statutliberreur= null WHERE tra_numtransmission in('34022-20-22042022092614-2945-INI_CREATION-22042022095313') and tra_statutcodeerreur = '8' and tra_statut =3;
update gna_transmission set tra_statut =2 , tra_statutcodeerreur =null ,tra_statutliberreur= null WHERE tra_numtransmission in('34022-20-22042022095355-2952-INI_CREATION-22042022095717') and tra_statutcodeerreur = '8' and tra_statut =3;
update gna_transmission set tra_statut =2 , tra_statutcodeerreur =null ,tra_statutliberreur= null WHERE tra_numtransmission in('34022-20-22042022095735-2953-INI_CREATION-22042022095914') and tra_statutcodeerreur = '8' and tra_statut =3;
update gna_transmission set tra_statut =2 , tra_statutcodeerreur =null ,tra_statutliberreur= null WHERE tra_numtransmission in('34022-20-22042022095921-2955-INI_CREATION-22042022100035') and tra_statutcodeerreur = '8' and tra_statut =3;
update gna_transmission set tra_statut =2 , tra_statutcodeerreur =null ,tra_statutliberreur= null WHERE tra_numtransmission in('34022-20-22042022133507-2971-INI_CREATION-22042022133801') and tra_statutcodeerreur = '8' and tra_statut =3;
update gna_transmission set tra_statut =2 , tra_statutcodeerreur =null ,tra_statutliberreur= null WHERE tra_numtransmission in('34057-20-25042022140057-3039-INI_CREATION-25042022140842') and tra_statutcodeerreur = '8' and tra_statut =3;
update gna_transmission set tra_statut =2 , tra_statutcodeerreur =null ,tra_statutliberreur= null WHERE tra_numtransmission in('34022-20-25042022165705-3048-INI_CREATION-25042022170055') and tra_statutcodeerreur = '8' and tra_statut =3;
update gna_transmission set tra_statut =2 , tra_statutcodeerreur =null ,tra_statutliberreur= null WHERE tra_numtransmission in('34057-20-26042022142609-3094-INI_CREATION-26042022143041') and tra_statutcodeerreur = '8' and tra_statut =3;
update gna_transmission set tra_statut =2 , tra_statutcodeerreur =null ,tra_statutliberreur= null WHERE tra_numtransmission in('34057-20-03052022101342-3279-INI_CREATION-03052022101946') and tra_statutcodeerreur = '8' and tra_statut =3;
update gna_transmission set tra_statut =2 , tra_statutcodeerreur =null ,tra_statutliberreur= null WHERE tra_numtransmission in('34057-5-04052022153759-3332-INI_CREATION-04052022162329') and tra_statutcodeerreur = '8' and tra_statut =3;
update gna_transmission set tra_statut =2 , tra_statutcodeerreur =null ,tra_statutliberreur= null WHERE tra_numtransmission in('34057-20-12052022150836-3634-INI_CREATION-12052022151102') and tra_statutcodeerreur = '8' and tra_statut =3;
update gna_transmission set tra_statut =2 , tra_statutcodeerreur =null ,tra_statutliberreur= null WHERE tra_numtransmission in('34022-5-11052022112111-3555-INI_CREATION-16052022212457') and tra_statutcodeerreur = '8' and tra_statut =3;
update gna_transmission set tra_statut =2 , tra_statutcodeerreur =null ,tra_statutliberreur= null WHERE tra_numtransmission in('34134-4-15062022145442-4718-INI_CREATION-15062022150522') and tra_statutcodeerreur = '8' and tra_statut =3;
update gna_transmission set tra_statut =2 , tra_statutcodeerreur =null ,tra_statutliberreur= null WHERE tra_numtransmission in('34058-4-08072022160156-5518-INI_CREATION-08072022161553') and tra_statutcodeerreur = '8' and tra_statut =3;
update gna_transmission set tra_statut =2 , tra_statutcodeerreur =null ,tra_statutliberreur= null WHERE tra_numtransmission in('34198-4-04082022144856-6425-INI_CREATION-04082022151440') and tra_statutcodeerreur = '8' and tra_statut =3;
update gna_transmission set tra_statut =2 , tra_statutcodeerreur =null ,tra_statutliberreur= null WHERE tra_numtransmission in('34134-20-26042023105726-10499-INI_CREATION-26042023110546') and tra_statutcodeerreur = '8' and tra_statut =3;
update gna_transmission set tra_statut =2 , tra_statutcodeerreur =null ,tra_statutliberreur= null WHERE tra_numtransmission in('34172-20-24052023153833-12098-INI_CREATION-24052023154702') and tra_statutcodeerreur = '8' and tra_statut =3;


================== Etape 2 =====================
Passer les scripts sql de relance de flux dans la base du GNAU et attendre que la tache fr.operis.cron.tasks.ReceptionGNAUBOTask soit passé

update gna_transmission set tra_datetransmission =null,tra_statut=0 WHERE tra_numtransmission ='34057-1-03022022151715-363-INI_CREATION-03022022155318';
update gna_transmission set tra_datetransmission =null,tra_statut=0 WHERE tra_numtransmission ='34057-20-14022022101446-856-INI_CREATION-14022022102623';
update gna_transmission set tra_datetransmission =null,tra_statut=0 WHERE tra_numtransmission ='34057-20-14022022145411-874-INI_CREATION-14022022151225';
update gna_transmission set tra_datetransmission =null,tra_statut=0 WHERE tra_numtransmission ='34057-20-15022022155806-932-INI_CREATION-15022022160016';
update gna_transmission set tra_datetransmission =null,tra_statut=0 WHERE tra_numtransmission ='34057-20-15022022173738-942-INI_CREATION-15022022174343';
update gna_transmission set tra_datetransmission =null,tra_statut=0 WHERE tra_numtransmission ='34022-11-21022022113256-1110-INI_CREATION-21022022121018';
update gna_transmission set tra_datetransmission =null,tra_statut=0 WHERE tra_numtransmission ='34057-20-22022022090243-1138-INI_CREATION-22022022090506';
update gna_transmission set tra_datetransmission =null,tra_statut=0 WHERE tra_numtransmission ='34057-5-24022022163417-1261-INI_CREATION-24022022175947';
update gna_transmission set tra_datetransmission =null,tra_statut=0 WHERE tra_numtransmission ='34057-20-23022022144202-1215-INI_CREATION-23022022145124';
update gna_transmission set tra_datetransmission =null,tra_statut=0 WHERE tra_numtransmission ='34022-5-10032022062733-1599-INI_CREATION-10032022063252';
update gna_transmission set tra_datetransmission =null,tra_statut=0 WHERE tra_numtransmission ='34057-20-10032022113800-1602-INI_CREATION-10032022113958';
update gna_transmission set tra_datetransmission =null,tra_statut=0 WHERE tra_numtransmission ='34057-20-30032022112208-2300-INI_CREATION-30032022113104';
update gna_transmission set tra_datetransmission =null,tra_statut=0 WHERE tra_numtransmission ='34057-20-05042022112102-2423-INI_CREATION-05042022112546';
update gna_transmission set tra_datetransmission =null,tra_statut=0 WHERE tra_numtransmission ='34057-5-31032022071110-2326-INI_CREATION-31032022071320';
update gna_transmission set tra_datetransmission =null,tra_statut=0 WHERE tra_numtransmission ='34022-20-08042022155700-2546-INI_CREATION-08042022155935';
update gna_transmission set tra_datetransmission =null,tra_statut=0 WHERE tra_numtransmission ='34057-20-12042022094253-2599-INI_CREATION-12042022094552';
update gna_transmission set tra_datetransmission =null,tra_statut=0 WHERE tra_numtransmission ='34057-5-15042022072446-2728-INI_CREATION-15042022073854';
update gna_transmission set tra_datetransmission =null,tra_statut=0 WHERE tra_numtransmission ='34057-5-14042022083911-2674-INI_CREATION-14042022084225';
update gna_transmission set tra_datetransmission =null,tra_statut=0 WHERE tra_numtransmission ='34057-20-14042022145354-2705-INI_CREATION-14042022145759';
update gna_transmission set tra_datetransmission =null,tra_statut=0 WHERE tra_numtransmission ='34057-20-15042022104155-2739-INI_CREATION-15042022104615';
update gna_transmission set tra_datetransmission =null,tra_statut=0 WHERE tra_numtransmission ='34057-20-17042022153319-2785-INI_CREATION-17042022153645';
update gna_transmission set tra_datetransmission =null,tra_statut=0 WHERE tra_numtransmission ='34057-5-19042022163037-2835-INI_CREATION-19042022163556';
update gna_transmission set tra_datetransmission =null,tra_statut=0 WHERE tra_numtransmission ='34022-20-22042022092614-2945-INI_CREATION-22042022095313';
update gna_transmission set tra_datetransmission =null,tra_statut=0 WHERE tra_numtransmission ='34022-20-22042022095355-2952-INI_CREATION-22042022095717';
update gna_transmission set tra_datetransmission =null,tra_statut=0 WHERE tra_numtransmission ='34022-20-22042022095735-2953-INI_CREATION-22042022095914';
update gna_transmission set tra_datetransmission =null,tra_statut=0 WHERE tra_numtransmission ='34022-20-22042022095921-2955-INI_CREATION-22042022100035';
update gna_transmission set tra_datetransmission =null,tra_statut=0 WHERE tra_numtransmission ='34022-20-22042022133507-2971-INI_CREATION-22042022133801';
update gna_transmission set tra_datetransmission =null,tra_statut=0 WHERE tra_numtransmission ='34057-20-25042022140057-3039-INI_CREATION-25042022140842';
update gna_transmission set tra_datetransmission =null,tra_statut=0 WHERE tra_numtransmission ='34022-20-25042022165705-3048-INI_CREATION-25042022170055';
update gna_transmission set tra_datetransmission =null,tra_statut=0 WHERE tra_numtransmission ='34057-20-26042022142609-3094-INI_CREATION-26042022143041';
update gna_transmission set tra_datetransmission =null,tra_statut=0 WHERE tra_numtransmission ='34057-20-03052022101342-3279-INI_CREATION-03052022101946';
update gna_transmission set tra_datetransmission =null,tra_statut=0 WHERE tra_numtransmission ='34057-5-04052022153759-3332-INI_CREATION-04052022162329';
update gna_transmission set tra_datetransmission =null,tra_statut=0 WHERE tra_numtransmission ='34057-20-12052022150836-3634-INI_CREATION-12052022151102';
update gna_transmission set tra_datetransmission =null,tra_statut=0 WHERE tra_numtransmission ='34022-5-11052022112111-3555-INI_CREATION-16052022212457';
update gna_transmission set tra_datetransmission =null,tra_statut=0 WHERE tra_numtransmission ='34134-4-15062022145442-4718-INI_CREATION-15062022150522';
update gna_transmission set tra_datetransmission =null,tra_statut=0 WHERE tra_numtransmission ='34058-4-08072022160156-5518-INI_CREATION-08072022161553';
update gna_transmission set tra_datetransmission =null,tra_statut=0 WHERE tra_numtransmission ='34198-4-04082022144856-6425-INI_CREATION-04082022151440';
update gna_transmission set tra_datetransmission =null,tra_statut=0 WHERE tra_numtransmission ='34134-20-26042023105726-10499-INI_CREATION-26042023110546';
update gna_transmission set tra_datetransmission =null,tra_statut=0 WHERE tra_numtransmission ='34172-20-24052023153833-12098-INI_CREATION-24052023154702';


================== Etape 3 =====================
Vérifier que l"un des flux en erreur à l"erreur côté gnau sur le champ tra_statutliberreur à 8 et que tra_statutliberreur contient dans le message ""DDCDOSSIER.GNA_REC_ENREGISTRE"", ligne 244 via la requête sql suivante


SELECT tra_statutcodeerreur ,tra_statutliberreur FROM gna_transmission WHERE tra_numtransmission ='';


================== Etape 4 =====================
Une fois tout les flux relancer côté GNAU les jobs devrais de-nouveau etres remplis, pour vérifier cela repasser le script script_relance_flux_gnau_jobs_vide.php et vérifier qu'il n'y ai plus aucune requête à l'etape 1 et 2
S'il reste des requêtes, c'est que des dossiers jobs sont encore vide voir les logs DDC et gnau sur le serveur