info : ('206Z2','Dossiers médicaux agents expatriés Total Gabon',NULL,'20250201','20230525',,'Mer 23 Avr. 2025 09:02:41')
 info : ('207Z2','Dossiers médicaux agents expatriés Total Gabon',NULL,'20250202','20230526',,'Mer 23 Avr. 2025 09:02:41')
 info : ('208Z2','Dossiers médicaux agents expatriés Total Gabon',NULL,'20250203','20230527',,'Mer 23 Avr. 2025 09:02:41')
 info : ('209Z2','Dossiers médicaux agents expatriés Total Gabon',NULL,'20250204','20230528',,'Mer 23 Avr. 2025 09:02:41')
 info : ('210Z2','Dossiers médicaux agents expatriés Total Gabon',NULL,'20250205','20230529',,'Mer 23 Avr. 2025 09:02:41')
 info : ('211Z2','Dossiers médicaux agents expatriés Total Gabon',68,'20250206','20230530',,'Mer 23 Avr. 2025 09:02:41')
 info : ('206Z2','Dossiers médicaux agents expatriés Total Gabon',NULL,'20250201','20230525',2,'Mer 23 Avr. 2025 09:09:38')
 info : ('207Z2','Dossiers médicaux agents expatriés Total Gabon',NULL,'20250202','20230526',2,'Mer 23 Avr. 2025 09:09:38')
 info : ('208Z2','Dossiers médicaux agents expatriés Total Gabon',NULL,'20250203','20230527',2,'Mer 23 Avr. 2025 09:09:38')
 info : ('209Z2','Dossiers médicaux agents expatriés Total Gabon',NULL,'20250204','20230528',2,'Mer 23 Avr. 2025 09:09:38')
 info : ('210Z2','Dossiers médicaux agents expatriés Total Gabon',NULL,'20250205','20230529',2,'Mer 23 Avr. 2025 09:09:38')
 info : ('211Z2','Dossiers médicaux agents expatriés Total Gabon',68,'20250206','20230530',2,'Mer 23 Avr. 2025 09:09:38')
Mer 23 Avr. 2025 10:35:37 info : SQLSTATE[23503]: Foreign key violation: 7 ERROR:  insert or update on table "tb_consultation" violates foreign key constraint "fk_tb_conusltation_archive"
DETAIL:  Key (idarchive)=(1130) is not present in table "tb_archive"., query was: INSERT INTO "starged"."tb_consultation" ("dateconsultation", "idutilisateur", "idarchive") VALUES (?, ?, ?)
Mer 23 Avr. 2025 10:37:34 info : SQLSTATE[23503]: Foreign key violation: 7 ERROR:  insert or update on table "tb_consultation" violates foreign key constraint "fk_tb_conusltation_archive"
DETAIL:  Key (idarchive)=(1130) is not present in table "tb_archive"., query was: INSERT INTO "starged"."tb_consultation" ("dateconsultation", "idutilisateur", "idarchive") VALUES (?, ?, ?)
Mer 23 Avr. 2025 10:40:23 info : SQLSTATE[23503]: Foreign key violation: 7 ERROR:  insert or update on table "tb_consultation" violates foreign key constraint "fk_tb_conusltation_archive"
DETAIL:  Key (idarchive)=(1130) is not present in table "tb_archive"., query was: INSERT INTO "starged"."tb_consultation" ("dateconsultation", "idutilisateur", "idarchive") VALUES (?, ?, ?)
Mar 06 Mai 2025 11:20:13 info : SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint "tb_import_pkey"
DETAIL:  Key (id)=(12) already exists., query was: INSERT INTO public.tb_import (id, table_name, libelle) VALUES (12, 'starged.tb_archive', 'Archives numériques')
Mar 06 Mai 2025 11:20:13 info : SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint "tb_colonne_nom_entite_import_only_key"
DETAIL:  Key (nom, entite, import_only)=(code, starged.tb_archive, 1) already exists., query was: INSERT INTO tb_colonne (libelle, nom, entite, import_only, description)
VALUES ('Code', 'code', 'starged.tb_archive', 1, 'Code de l''archive')
ON CONFLICT (id) DO UPDATE SET libelle = 'Code', nom = 'code', entite='starged.tb_archive', import_only=1, description='Code de l''archive'
Mar 06 Mai 2025 11:20:13 info : SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint "tb_colonne_nom_entite_import_only_key"
DETAIL:  Key (nom, entite, import_only)=(titre, starged.tb_archive, 1) already exists., query was: INSERT INTO tb_colonne (libelle, nom, entite, import_only, description)
VALUES ('Titre', 'titre', 'starged.tb_archive', 1, 'Titre de l''archive')
ON CONFLICT (id) DO UPDATE SET libelle = 'Titre', nom = 'titre', entite='starged.tb_archive', import_only=1, description='Titre de l''archive'
Mar 06 Mai 2025 11:20:13 info : SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint "tb_colonne_nom_entite_import_only_key"
DETAIL:  Key (nom, entite, import_only)=(idclassement, starged.tb_archive, 1) already exists., query was: INSERT INTO tb_colonne (libelle, nom, entite, import_only, table_referenced, column_referenced, description)
VALUES ('Classement', 'idclassement', 'starged.tb_archive', 1, 'tb_classement', 'code', 'Code de la série du Plan de classement de l''archive')
ON CONFLICT (id) DO UPDATE SET libelle = 'Classement', nom = 'idclassement', entite='starged.tb_archive', import_only=1, table_referenced='tb_classement',  column_referenced='code', description='Code de la série du Plan de classement de l''archive'
Mar 06 Mai 2025 11:20:13 info : SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint "tb_colonne_nom_entite_import_only_key"
DETAIL:  Key (nom, entite, import_only)=(dua, starged.tb_archive, 1) already exists., query was: INSERT INTO tb_colonne (libelle, nom, entite, import_only, description)
VALUES ('DUA', 'dua', 'starged.tb_archive', 1, 'Format YYYY-MM-DD')
ON CONFLICT (id) DO UPDATE SET libelle = 'DUA', nom = 'dua', entite='starged.tb_archive', import_only=1, description='Format YYYY-MM-DD'
Mar 06 Mai 2025 11:20:13 info : SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint "tb_colonne_nom_entite_import_only_key"
DETAIL:  Key (nom, entite, import_only)=(duc, starged.tb_archive, 1) already exists., query was: INSERT INTO tb_colonne (libelle, nom, entite, import_only, description)
VALUES ('DUC', 'duc', 'starged.tb_archive', 1, 'Format YYYY-MM-DD')
ON CONFLICT (id) DO UPDATE SET libelle = 'DUC', nom = 'duc', entite='starged.tb_archive', import_only=1, description='Format YYYY-MM-DD'
Mar 06 Mai 2025 11:20:13 info : SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint "tb_colonne_nom_entite_import_only_key"
DETAIL:  Key (nom, entite, import_only)=(sof, starged.tb_archive, 1) already exists., query was: INSERT INTO tb_colonne (libelle, nom, entite, import_only, description)
VALUES ('SOF', 'sof', 'starged.tb_archive', 1, 'Destruction, A définir, Définitive')
ON CONFLICT (id) DO UPDATE SET libelle = 'SOF', nom = 'sof', entite='starged.tb_archive', import_only=1, description='Destruction, A définir, Définitive'
Mar 06 Mai 2025 11:20:13 info : SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint "tb_colonne_nom_entite_import_only_key"
DETAIL:  Key (nom, entite, import_only)=(datearchive, starged.tb_archive, 1) already exists., query was: INSERT INTO tb_colonne (libelle, nom, entite, import_only, description)
VALUES ('Date archive', 'datearchive', 'starged.tb_archive', 1, 'Format YYYY-MM-DD')
ON CONFLICT (id) DO UPDATE SET libelle = 'Date archive', nom = 'datearchive', entite='starged.tb_archive', import_only=1, description='Format YYYY-MM-DD'
Mar 06 Mai 2025 11:20:13 info : SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint "tb_colonne_nom_entite_import_only_key"
DETAIL:  Key (nom, entite, import_only)=(iddocument, starged.tb_archive, 1) already exists., query was: INSERT INTO tb_colonne (libelle, nom, entite, table_referenced, column_referenced, import_only, description)
VALUES ('Lien du document', 'iddocument', 'starged.tb_archive', 'tb_document', 'id', 1,  'Chemin complet du fichier')
ON CONFLICT (id) DO UPDATE SET libelle = 'Lien du document', nom = 'iddocument', entite='starged.tb_archive', import_only=1, table_referenced='tb_document',  column_referenced='id', description='Chemin complet du fichier'
Mar 06 Mai 2025 11:20:13 info : SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint "tb_colonne_nom_entite_import_only_key"
DETAIL:  Key (nom, entite, import_only)=(idsecurite, starged.tb_archive, 1) already exists., query was: INSERT INTO tb_colonne (libelle, nom, entite, table_referenced, column_referenced, import_only, description)
VALUES ('Niveau de sécurité', 'idsecurite', 'starged.tb_archive', 'tb_securite', 'code', 1, 'Code du niveau de sécurité de l''archive')
ON CONFLICT (id) DO UPDATE SET libelle = 'Niveau de sécurité', nom = 'idsecurite', entite='starged.tb_archive', import_only=1, table_referenced='tb_securite',  column_referenced='code', description='Code du niveau de sécurité de l''archive'
Mar 06 Mai 2025 11:20:13 info : SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint "tb_colonne_nom_entite_import_only_key"
DETAIL:  Key (nom, entite, import_only)=(idaffaire, starged.tb_archive, 1) already exists., query was: INSERT INTO tb_colonne (libelle, nom, entite, table_referenced, column_referenced, import_only, description)
VALUES ('Affaire', 'idaffaire', 'starged.tb_archive', 'tb_affaire', 'code', 1, 'Code de l''affaire de l''archive')
ON CONFLICT (id) DO UPDATE SET libelle = 'Affaire', nom = 'idaffaire', entite='starged.tb_archive', import_only=1, table_referenced='tb_affaire',  column_referenced='code', description='Code de l''affaire de l''archive'
Mar 06 Mai 2025 11:20:13 info : SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint "tb_colonne_nom_entite_import_only_key"
DETAIL:  Key (nom, entite, import_only)=(iddossier, starged.tb_archive, 1) already exists., query was: INSERT INTO tb_colonne (libelle, nom, entite, table_referenced, column_referenced, import_only, description)
VALUES ('Dossier', 'iddossier', 'starged.tb_archive', 'tb_dossier', 'code', 1, 'Code du dossier de l''archive')
ON CONFLICT (id) DO UPDATE SET libelle = 'Dossier', nom = 'iddossier', entite='starged.tb_archive', import_only=1, table_referenced='tb_dossier',  column_referenced='code', description='Code du dossier de l''archive'
Mar 06 Mai 2025 11:20:13 info : SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint "tb_colonne_nom_entite_import_only_key"
DETAIL:  Key (nom, entite, import_only)=(description, starged.tb_archive, 1) already exists., query was: INSERT INTO tb_colonne (libelle, nom, entite, import_only, description)
VALUES ('Description', 'description', 'starged.tb_archive', 1, 'Description de l''archive')
ON CONFLICT (id) DO UPDATE SET libelle = 'Description', nom = 'description', entite='starged.tb_archive', import_only=1, description='Description de l''archive'
Mar 06 Mai 2025 11:20:13 info : SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint "tb_colonne_nom_entite_import_only_key"
DETAIL:  Key (nom, entite, import_only)=(description, ardoc.tb_archive, 1) already exists., query was: INSERT INTO tb_colonne (libelle, nom, entite, import_only, description)
VALUES ('Description', 'description', 'ardoc.tb_archive', 1, 'Description de l''archive')
ON CONFLICT (id) DO UPDATE SET libelle = 'Description', nom = 'description', entite='ardoc.tb_archive', import_only=1, description='Description de l''archive'
Mar 06 Mai 2025 11:20:14 info : SQLSTATE[42701]: Duplicate column: 7 ERROR:  column "idardoc" of relation "tb_archive" already exists, query was: ALTER TABLE starged.tb_archive ADD COLUMN idardoc integer
Mar 06 Mai 2025 11:20:14 info : SQLSTATE[42710]: Duplicate object: 7 ERROR:  constraint "fk_tb_archive_tb_ardoc" for relation "tb_archive" already exists, query was: ALTER TABLE starged.tb_archive ADD CONSTRAINT fk_tb_archive_tb_ardoc FOREIGN KEY (idardoc) REFERENCES ardoc.tb_archive (id) MATCH SIMPLE ON UPDATE CASCADE ON DELETE CASCADE
Mar 06 Mai 2025 11:20:14 info : SQLSTATE[42701]: Duplicate column: 7 ERROR:  column "estarchive" of relation "tb_archive" already exists, query was: ALTER TABLE starged.tb_archive ADD COLUMN estarchive integer default 0
Mar 06 Mai 2025 11:20:14 info : SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint "pk_tb_droit"
DETAIL:  Key (id)=(80) already exists., query was: INSERT INTO public.tb_droit(id, libelle, description, estclassique, application)
	VALUES (80, 'Transfert archives physiques au SAE', 'Droit de transférer les archives physiques dans le système d''archivage électronique', 1, 3)
Mar 06 Mai 2025 11:20:14 info : SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint "pk_tb_droit"
DETAIL:  Key (id)=(81) already exists., query was: INSERT INTO public.tb_droit(id, libelle, description, estclassique, application)
	VALUES (81, 'Transfert courriers au SAE', 'Droit de transférer les courriers dans le système d''archivage électronique', 1, 1)
Mar 06 Mai 2025 19:23:26 info : SQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at or near "AND"
LINE 1: ...gatoire" = $2, "valeur" = $3 WHERE (idmetadata =  AND idarch...
                                                             ^, query was: UPDATE "ardoc"."tb_archive_metadata" SET "idmetadata" = ?, "estobligatoire" = ?, "valeur" = ? WHERE (idmetadata =  AND idarchive=1159)
Mar 06 Mai 2025 19:25:12 info : SQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at or near "AND"
LINE 1: ...gatoire" = $2, "valeur" = $3 WHERE (idmetadata =  AND idarch...
                                                             ^, query was: UPDATE "ardoc"."tb_archive_metadata" SET "idmetadata" = ?, "estobligatoire" = ?, "valeur" = ? WHERE (idmetadata =  AND idarchive=1159)
Mar 06 Mai 2025 19:26:59 info : SQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at or near "AND"
LINE 1: ...gatoire" = $2, "valeur" = $3 WHERE (idmetadata =  AND idarch...
                                                             ^, query was: UPDATE "ardoc"."tb_archive_metadata" SET "idmetadata" = ?, "estobligatoire" = ?, "valeur" = ? WHERE (idmetadata =  AND idarchive=1217)
Mar 06 Mai 2025 19:34:18 info : SQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at or near "AND"
LINE 1: ...gatoire" = $2, "valeur" = $3 WHERE (idmetadata =  AND idarch...
                                                             ^, query was: UPDATE "ardoc"."tb_archive_metadata" SET "idmetadata" = ?, "estobligatoire" = ?, "valeur" = ? WHERE (idmetadata =  AND idarchive=1159)