forums.lyricapps.fr

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.

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.

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

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.

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é…

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