Problème d'enregistrement

Discussions à propos d'iCompta sur macOS
tsabes
Messages : 5
Inscription : 22 septembre 2022, 21:02

Problème d'enregistrement

Message par tsabes »

Bonjour

Je débute sur iCompta. J'ai complété pas mal de choses.
J'ai enregistré dernièrement mes budgets mais depuis impossible d'enregistrer. Il me met le message d'erreur que voici :

Le document « iCompta ONE.cdb » n’a pas pu être enregistré.
Error while executing update : INSERT INTO ICBudgetItemPeriod ("ID", "lastModificationDate", "item", "index", "amount", "startDate", "endDate") VALUES ('53ED4AD9-8E97-4BDB-8AF8-D624C03D87C4#0', NULL, '53ED4AD9-8E97-4BDB-8AF8-D624C03D87C4', 0, '-650', '2022-08-01', '2022-08-31')
UNIQUE constraint failed: ICBudgetItemPeriod.ID
Error while executing update : INSERT INTO ICBudgetItemPeriod ("ID", "lastModificationDate", "item", "index", "amount", "startDate", "endDate") VALUES ('CAF12852-2533-43F7-B420-5E029D41B5B9#0', NULL, 'CAF12852-2533-43F7-B420-5E029D41B5B9', 0, '-2850', '2022-08-01', '2022-08-31')
UNIQUE constraint failed: ICBudgetItemPeriod.ID
Error while executing update : INSERT INTO ICBudgetItemPeriod ("ID", "lastModificationDate", "item", "index", "amount", "startDate", "endDate") VALUES ('7868E2F6-C002-4F16-8C44-226A2649291D#0', NULL, '7868E2F6-C002-4F16-8C44-226A2649291D', 0, '4850', '2022-08-01', '2022-08-31')
UNIQUE constraint failed: ICBudgetItemPeriod.ID
Error while executing update : INSERT INTO ICBudgetItemPeriod ("ID", "lastModificationDate", "item", "index", "amount", "startDate", "endDate") VALUES ('45091E52-B501-450C-A452-DBC9DC1E5163#0', NULL, '45091E52-B501-450C-A452-DBC9DC1E5163', 0, '-868.61', '2022-08-01', '2022-08-31')
UNIQUE constraint failed: ICBudgetItemPeriod.ID
Error while executing update : INSERT INTO ICBudgetItemPeriod ("ID", "lastModificationDate", "item", "index", "amount", "startDate", "endDate") VALUES ('45091E52-B501-450C-A452-DBC9DC1E5163#1', NULL, '45091E52-B501-450C-A452-DBC9DC1E5163', 1, '-868.61', '2022-09-01', '2022-09-30')
UNIQUE constraint failed: ICBudgetItemPeriod.ID
Error while executing update : INSERT INTO ICBudgetItemPeriod ("ID", "lastModificationDate", "item", "index", "amount", "startDate", "endDate") VALUES ('45091E52-B501-450C-A452-DBC9DC1E5163#2', NULL, '45091E52-B501-450C-A452-DBC9DC1E5163', 2, '-868.61', '2022-10-01', '2022-10-31')
UNIQUE constraint failed: ICBudgetItemPeriod.ID
Error while executing update : INSERT INTO ICBudgetItemPeriod ("ID", "lastModificationDate", "item", "index", "amount", "startDate", "endDate") VALUES ('DCBBD288-8670-4EAD-B5E8-14A0B9B64A7B#0', NULL, 'DCBBD288-8670-4EAD-B5E8-14A0B9B64A7B', 0, '-800', '2022-08-01', '2022-08-31')
UNIQUE constraint failed: ICBudgetItemPeriod.ID


Je ne comprends pas. J'ai tenté de modifier des dates de budget. Mais je ne sais pas d'où vient l'erreur. J'ai mis un peu de temps à tout paramétrer.
Est-ce que vous avez un éclairage à m'apporter sur ce problème ?

Merci à vous.
Avatar de l’utilisateur
Angeman
Administrateur
Messages : 11731
Inscription : 28 décembre 2008, 21:28
Localisation : Toulouse, France
Contact :

Re: Problème d'enregistrement

Message par Angeman »

Vous avez des périodes de budget qui se retrouvent en double. Ce que vous pouvez essayer de faire c'est supprimer le budget puis sauver et si ça marche vous pouvez quitter puis le refaire ensuite.
tsabes
Messages : 5
Inscription : 22 septembre 2022, 21:02

Re: Problème d'enregistrement

Message par tsabes »

Merci pour votre retour.

J'ai supprimé tous mes budgets. Mais le message d'erreur est toujours présent.

Le document « iCompta ONE.cdb » n’a pas pu être enregistré automatiquement.

Error while executing update : INSERT INTO ICBudgetItemPeriod ("ID", "lastModificationDate", "item", "index", "amount", "startDate", "endDate") VALUES ('53ED4AD9-8E97-4BDB-8AF8-D624C03D87C4#0', NULL, '53ED4AD9-8E97-4BDB-8AF8-D624C03D87C4', 0, '-650', '2022-08-01', '2022-08-31')
UNIQUE constraint failed: ICBudgetItemPeriod.ID
Error while executing update : INSERT INTO ICBudgetItemPeriod ("ID", "lastModificationDate", "item", "index", "amount", "startDate", "endDate") VALUES ('CAF12852-2533-43F7-B420-5E029D41B5B9#0', NULL, 'CAF12852-2533-43F7-B420-5E029D41B5B9', 0, '-2850', '2022-08-01', '2022-08-31')
UNIQUE constraint failed: ICBudgetItemPeriod.ID
Error while executing update : INSERT INTO ICBudgetItemPeriod ("ID", "lastModificationDate", "item", "index", "amount", "startDate", "endDate") VALUES ('7868E2F6-C002-4F16-8C44-226A2649291D#0', NULL, '7868E2F6-C002-4F16-8C44-226A2649291D', 0, '4850', '2022-08-01', '2022-08-31')
UNIQUE constraint failed: ICBudgetItemPeriod.ID
Error while executing update : INSERT INTO ICBudgetItemPeriod ("ID", "lastModificationDate", "item", "index", "amount", "startDate", "endDate") VALUES ('7856A73B-761B-4860-85C9-48D570A57E15', NULL, NULL, -1, '-868.61', '2022-09-01', '2022-09-30')
NOT NULL constraint failed: ICBudgetItemPeriod.item
Error while executing update : INSERT INTO ICBudgetItemPeriod ("ID", "lastModificationDate", "item", "index", "amount", "startDate", "endDate") VALUES ('45091E52-B501-450C-A452-DBC9DC1E5163#0', NULL, '45091E52-B501-450C-A452-DBC9DC1E5163', 0, '-868.61', '2022-08-01', '2022-08-31')
UNIQUE constraint failed: ICBudgetItemPeriod.ID
Error while executing update : INSERT INTO ICBudgetItemPeriod ("ID", "lastModificationDate", "item", "index", "amount", "startDate", "endDate") VALUES ('45091E52-B501-450C-A452-DBC9DC1E5163#1', NULL, '45091E52-B501-450C-A452-DBC9DC1E5163', 1, '-868.61', '2022-09-01', '2022-09-30')
UNIQUE constraint failed: ICBudgetItemPeriod.ID
Error while executing update : INSERT INTO ICBudgetItemPeriod ("ID", "lastModificationDate", "item", "index", "amount", "startDate", "endDate") VALUES ('E511685A-0D6A-4205-AA05-5B09A2C11994', NULL, NULL, -1, '-868.61', '2022-10-01', '2022-10-31')
NOT NULL constraint failed: ICBudgetItemPeriod.item
Error while executing update : INSERT INTO ICBudgetItemPeriod ("ID", "lastModificationDate", "item", "index", "amount", "startDate", "endDate") VALUES ('33828B5F-10EF-44F0-9741-224D6BBCF6C4', NULL, NULL, -1, '-868.61', '2022-08-01', '2022-08-31')
NOT NULL constraint failed: ICBudgetItemPeriod.item
Error while executing update : INSERT INTO ICBudgetItemPeriod ("ID", "lastModificationDate", "item", "index", "amount", "startDate", "endDate") VALUES ('DCBBD288-8670-4EAD-B5E8-14A0B9B64A7B#0', NULL, 'DCBBD288-8670-4EAD-B5E8-14A0B9B64A7B', 0, '-800', '2022-08-01', '2022-08-31')
UNIQUE constraint failed: ICBudgetItemPeriod.ID
Error while executing update : INSERT INTO ICBudgetItemPeriod ("ID", "lastModificationDate", "item", "index", "amount", "startDate", "endDate") VALUES ('A6845F1A-12E7-4291-B7FE-086981BB5816', NULL, NULL, -1, '-420', '2022-08-01', '2023-07-31')
NOT NULL constraint failed: ICBudgetItemPeriod.item
Error while executing update : INSERT INTO ICBudgetItemPeriod ("ID", "lastModificationDate", "item", "index", "amount", "startDate", "endDate") VALUES ('61798CBE-6FD2-4E67-8D3A-DF1E8544797D', NULL, NULL, -1, '-37', '2022-09-01', '2022-09-30')
NOT NULL constraint failed: ICBudgetItemPeriod.item
Error while executing update : INSERT INTO ICBudgetItemPeriod ("ID", "lastModificationDate", "item", "index", "amount", "startDate", "endDate") VALUES ('7F9545A3-D772-402A-BD88-BCD4A75552A4', NULL, NULL, -1, '-1410.97', '2022-10-01', '2022-10-31')
NOT NULL constraint failed: ICBudgetItemPeriod.item
Error while executing update : INSERT INTO ICBudgetItemPeriod ("ID", "lastModificationDate", "item", "index", "amount", "startDate", "endDate") VALUES ('D89164A8-1534-4303-8FFC-73C918AD91B4', '2022-09-23 07:51:40', NULL, -1, '-20', '2022-08-01', '2022-08-31')
NOT NULL constraint failed: ICBudgetItemPeriod.item
Error while executing update : INSERT INTO ICBudgetItemPeriod ("ID", "lastModificationDate", "item", "index", "amount", "startDate", "endDate") VALUES ('8DD636DF-836A-4E5D-BD68-FF409E8A66E2', NULL, NULL, -1, '140', '2022-09-01', '2022-09-30')
NOT NULL constraint failed: ICBudgetItemPeriod.item
Error while executing update : INSERT INTO ICBudgetItemPeriod ("ID", "lastModificationDate", "item", "index", "amount", "startDate", "endDate") VALUES ('69627CF0-F8D7-4FBA-B3DC-1FABDBE08FE4#2', NULL, NULL, -1, '-155', '2022-10-01', '2022-10-31')
NOT NULL constraint failed: ICBudgetItemPeriod.item
Error while executing update : INSERT INTO ICBudgetItemPeriod ("ID", "lastModificationDate", "item", "index", "amount", "startDate", "endDate") VALUES ('D0189A0D-00B5-4E1E-B1BE-3E201D0566A7', NULL, NULL, -1, '-55', '2022-09-01', '2022-09-30')
NOT NULL constraint failed: ICBudgetItemPeriod.item
Error while executing update : INSERT INTO ICBudgetItemPeriod ("ID", "lastModificationDate", "item", "index", "amount", "startDate", "endDate") VALUES ('C1B26D83-8A52-4AC0-9FC3-476975FC5E22', '2022-09-23 07:51:40', NULL, -1, '-20', '2022-08-01', '2023-07-31')
NOT NULL constraint failed: ICBudgetItemPeriod.item
Error while executing update : INSERT INTO ICBudgetItemPeriod ("ID", "lastModificationDate", "item", "index", "amount", "startDate", "endDate") VALUES ('180E7715-182C-4782-BD9E-CA0688F504D6', NULL, NULL, -1, '-37', '2022-08-01', '2022-08-31')
NOT NULL constraint failed: ICBudgetItemPeriod.item
Error while executing update : INSERT INTO ICBudgetItemPeriod ("ID", "lastModificationDate", "item", "index", "amount", "startDate", "endDate") VALUES ('8F5C7413-45AD-4A97-AA93-5D61CF24DCDD#2', NULL, NULL, -1, '140', '2022-10-01', '2022-10-31')
NOT NULL constraint failed: ICBudgetItemPeriod.item
Error while executing update : INSERT INTO ICBudgetItemPeriod ("ID", "lastModificationDate", "item", "index", "amount", "startDate", "endDate") VALUES ('B70DECE8-7F0A-4A0E-9206-33C5D8D4D465#2', NULL, NULL, -1, '450', '2022-10-01', '2022-10-31')
NOT NULL constraint failed: ICBudgetItemPeriod.item
Error while executing update : INSERT INTO ICBudgetItemPeriod ("ID", "lastModificationDate", "item", "index", "amount", "startDate", "endDate") VALUES ('B049A28D-9059-4360-95EE-4D3815C34FE0', NULL, NULL, -1, '-155', '2022-09-01', '2022-09-30')
NOT NULL constraint failed: ICBudgetItemPeriod.item
Error while executing update : INSERT INTO ICBudgetItemPeriod ("ID", "lastModificationDate", "item", "index", "amount", "startDate", "endDate") VALUES ('3501F742-E9D3-42DB-9964-F446FE15E209', '2022-09-23 07:51:40', NULL, -1, '-50', '2022-08-01', '2023-07-31')
NOT NULL constraint failed: ICBudgetItemPeriod.item
Error while executing update : INSERT INTO ICBudgetItemPeriod ("ID", "lastModificationDate", "item", "index", "amount", "startDate", "endDate") VALUES ('8F0797B9-9559-459E-AD2F-F210ED1F0AD7', NULL, NULL, -1, '-155', '2022-08-01', '2022-08-31')
NOT NULL constraint failed: ICBudgetItemPeriod.item
Error while executing update : INSERT INTO ICBudgetItemPeriod ("ID", "lastModificationDate", "item", "index", "amount", "startDate", "endDate") VALUES ('12CCC8D6-EF94-4D29-AB10-C8594BA93A6A#2', NULL, NULL, -1, '-55', '2022-10-01', '2022-10-31')
NOT NULL constraint failed: ICBudgetItemPeriod.item
Error while executing update : INSERT INTO ICBudgetItemPeriod ("ID", "lastModificationDate", "item", "index", "amount", "startDate", "endDate") VALUES ('95D4F951-0D67-4651-83C5-3BBB0C96DC8D', NULL, NULL, -1, '-1410.97', '2022-08-01', '2022-08-31')
NOT NULL constraint failed: ICBudgetItemPeriod.item
Error while executing update : INSERT INTO ICBudgetItemPeriod ("ID", "lastModificationDate", "item", "index", "amount", "startDate", "endDate") VALUES ('22C38128-2CF0-4E5A-A9CA-27DB4BB45F51', '2022-09-23 07:51:16', NULL, -1, '-1250', '2022-09-01', '2022-09-30')
NOT NULL constraint failed: ICBudgetItemPeriod.item
Error while executing update : INSERT INTO ICBudgetItemPeriod ("ID", "lastModificationDate", "item", "index", "amount", "startDate", "endDate") VALUES ('41DE869E-046B-4797-9734-E3ACB3A964FA', NULL, NULL, -1, '140', '2022-08-01', '2022-08-31')
NOT NULL constraint failed: ICBudgetItemPeriod.item
Error while executing update : INSERT INTO ICBudgetItemPeriod ("ID", "lastModificationDate", "item", "index", "amount", "startDate", "endDate") VALUES ('6FADC8C2-789F-4068-ABBB-532E6C02D43E', NULL, NULL, -1, '-1410.97', '2022-09-01', '2022-09-30')
NOT NULL constraint failed: ICBudgetItemPeriod.item
Error while executing update : INSERT INTO ICBudgetItemPeriod ("ID", "lastModificationDate", "item", "index", "amount", "startDate", "endDate") VALUES ('CDB00FD6-3EB8-425A-BBDF-121D2834C14E', NULL, NULL, -1, '-420', '2022-08-01', '2023-07-31')
NOT NULL constraint failed: ICBudgetItemPeriod.item
Error while executing update : INSERT INTO ICBudgetItemPeriod ("ID", "lastModificationDate", "item", "index", "amount", "startDate", "endDate") VALUES ('B04B46DA-50FA-4334-B7AD-F3A184BE52D2', '2022-09-23 07:51:40', NULL, -1, '-20', '2022-09-01', '2022-09-30')
NOT NULL constraint failed: ICBudgetItemPeriod.item
Error while executing update : INSERT INTO ICBudgetItemPeriod ("ID", "lastModificationDate", "item", "index", "amount", "startDate", "endDate") VALUES ('58316A3F-4BB2-4281-9523-D713B8BE55CE', NULL, NULL, -1, '450', '2022-08-01', '2022-08-31')
NOT NULL constraint failed: ICBudgetItemPeriod.item
Error while executing update : INSERT INTO ICBudgetItemPeriod ("ID", "lastModificationDate", "item", "index", "amount", "startDate", "endDate") VALUES ('CBA76CF9-88C2-4ECE-B3BD-15A07F622CB0', '2022-09-23 07:51:16', NULL, -1, '-3000', '2022-08-01', '2022-08-31')
NOT NULL constraint failed: ICBudgetItemPeriod.item
Error while executing update : INSERT INTO ICBudgetItemPeriod ("ID", "lastModificationDate", "item", "index", "amount", "startDate", "endDate") VALUES ('4510FA27-EE5C-4D02-B209-F37E54112E79#2', NULL, NULL, -1, '-37', '2022-10-01', '2022-10-31')
NOT NULL constraint failed: ICBudgetItemPeriod.item
Error while executing update : INSERT INTO ICBudgetItemPeriod ("ID", "lastModificationDate", "item", "index", "amount", "startDate", "endDate") VALUES ('6E80BEA9-4BCF-4FE0-A28E-47DCFB040806', NULL, NULL, -1, '450', '2022-09-01', '2022-09-30')
NOT NULL constraint failed: ICBudgetItemPeriod.item
Error while executing update : INSERT INTO ICBudgetItemPeriod ("ID", "lastModificationDate", "item", "index", "amount", "startDate", "endDate") VALUES ('B3FDF391-DA54-4068-8021-66C5B16F945F', '2022-09-23 07:51:16', NULL, -1, '-1250', '2022-08-01', '2022-08-31')
NOT NULL constraint failed: ICBudgetItemPeriod.item
Error while executing update : INSERT INTO ICBudgetItemPeriod ("ID", "lastModificationDate", "item", "index", "amount", "startDate", "endDate") VALUES ('E279313A-4FBF-44B0-BD83-2E046A0F4D2D', '2022-09-23 07:51:40', NULL, -1, '-420', '2022-08-01', '2023-07-31')
NOT NULL constraint failed: ICBudgetItemPeriod.item
Error while executing update : INSERT INTO ICBudgetItemPeriod ("ID", "lastModificationDate", "item", "index", "amount", "startDate", "endDate") VALUES ('7E99668D-4891-4DCC-A182-5ACE5BA95BA9', '2022-09-23 07:51:40', NULL, -1, '-250', '2022-08-01', '2023-07-31')
NOT NULL constraint failed: ICBudgetItemPeriod.item
Error while executing update : INSERT INTO ICBudgetItemPeriod ("ID", "lastModificationDate", "item", "index", "amount", "startDate", "endDate") VALUES ('3B76DEDA-09A1-4EB4-92D2-AE2E947176D4', NULL, NULL, -1, '-55', '2022-08-01', '2022-08-31')
NOT NULL constraint failed: ICBudgetItemPeriod.item
Error while executing update : INSERT INTO ICBudgetItemPeriod ("ID", "lastModificationDate", "item", "index", "amount", "startDate", "endDate") VALUES ('5DDC48C6-CAB7-4A35-B181-F292752B47BD', '2022-09-23 07:51:16', NULL, -1, '-3000', '2022-09-01', '2022-09-30')
NOT NULL constraint failed: ICBudgetItemPeriod.item
tsabes
Messages : 5
Inscription : 22 septembre 2022, 21:02

Re: Problème d'enregistrement

Message par tsabes »

Ce qui me pose question, c'est que j'ai passé beaucoup de temps à tout personnaliser. Si je quitte sans enregistré, je vais perdre quelques heures de travail. :twisted:
Avatar de l’utilisateur
Angeman
Administrateur
Messages : 11731
Inscription : 28 décembre 2008, 21:28
Localisation : Toulouse, France
Contact :

Re: Problème d'enregistrement

Message par Angeman »

tsabes a écrit : 23 septembre 2022, 09:56 Ce qui me pose question, c'est que j'ai passé beaucoup de temps à tout personnaliser. Si je quitte sans enregistré, je vais perdre quelques heures de travail.
Non pas forcément parce qu'il y a une sauvegarde automatique régulière donc ça ne perdra que ce qui a été fait après que le problème est apparu. Et malheureusement de toute façon là c'est la seule chose à faire désolé…
tsabes
Messages : 5
Inscription : 22 septembre 2022, 21:02

Re: Problème d'enregistrement

Message par tsabes »

Merci. J'ai effacé mes budgets et cela a l'air de fonctionner.
Répondre