Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.
Notifications
Clear all
Topic starter
Hi
We had errors in the data base, but i can't find the reason.
Is there an other way, then the logs , to see the modifications on activities and projects ?
logs :
Spoiler
ERREUR: une valeur NULL viole la contrainte NOT NULL de la colonne « idproject »
DÉTAIL: La ligne en échec contient (194, 43, null, null, null, 528, 0.25000, 2016-01-21, 20160121, 201603, 201601, 2016, null, null, null, null)
INSTRUCTION : insert into work ( idResource , idAssignment , work , workDate , day , week , month , year ) values ('43', '528', '0.25', '2016-01-21', '20160121', '201603', '201601', '2016')
ERREUR: une valeur NULL viole la contrainte NOT NULL de la colonne « idproject »
DÉTAIL: La ligne en échec contient (195, 43, null, null, null, 528, 0.25000, 2016-01-19, 20160119, 201603, 201601, 2016, null, null, null, null)
INSTRUCTION : insert into work ( idResource , idAssignment , work , workDate , day , week , month , year ) values ('43', '528', '0.25', '2016-01-19', '20160119', '201603', '201601', '2016')
ERREUR: une valeur NULL viole la contrainte NOT NULL de la colonne « idproject »
DÉTAIL: La ligne en échec contient (196, 43, null, null, null, 528, 0.25000, 2016-01-19, 20160119, 201603, 201601, 2016, null, null, null, null)
INSTRUCTION : insert into work ( idResource , idAssignment , work , workDate , day , week , month , year ) values ('43', '528', '0.25', '2016-01-19', '20160119', '201603', '201601', '2016')
ERREUR: une valeur NULL viole la contrainte NOT NULL de la colonne « idproject »
DÉTAIL: La ligne en échec contient (197, 43, null, null, null, 528, 0.25000, 2016-01-20, 20160120, 201603, 201601, 2016, null, null, null, null)
INSTRUCTION : insert into work ( idResource , idAssignment , work , workDate , day , week , month , year ) values ('43', '528', '0.25', '2016-01-20', '20160120', '201603', '201601', '2016')
ERREUR: une valeur NULL viole la contrainte NOT NULL de la colonne « reftype »
DÉTAIL: La ligne en échec contient (229, null, null, null, null, null, null, 2014-12-29, 2014-12-29, null, null, 2016-09-22, null, null, null, 454, null, 0.00000, 1297.50000, 1351.00000, 385.00000, 3, 003, null, null, null, 500, 0, 1, 966.00000, 1199.25000, null, null, 0, null, null, null, null, null, null, null, 28, 30, 0, 0, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 0.00000, null, null, null, null, 0.00000, 1.00000, 0.00000, 1.00000, 0.00)
INSTRUCTION : insert into planningelement ( plannedStartDate , realStartDate , plannedEndDate , plannedDuration , validatedWork , assignedWork , plannedWork , leftWork , realWork , progress , expectedProgress , wbs , wbsSortable , priority , elementary , idle , done , cancelled , validatedCalculated ) values ('2014-12-29', '2014-12-29', '2016-09-22', '454', '1297.5', '1199.25', '1351', '966', '385', '28', '30', '3', '003', '500', '1', '0', '0', '0', '0')
ERREUR: une valeur NULL viole la contrainte NOT NULL de la colonne « reftype »
DÉTAIL: La ligne en échec contient (230, null, null, null, null, null, null, 2014-12-29, 2014-12-29, null, null, 2016-09-22, null, null, null, 454, null, 0.00000, 1297.50000, 1351.00000, 385.00000, 3, 003, null, null, null, 500, 0, 1, 966.00000, 1199.25000, null, null, 0, null, null, null, null, null, null, null, 28, 30, 0, 0, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 0.00000, null, null, null, null, 0.00000, 1.00000, 0.00000, 1.00000, 0.00)
INSTRUCTION : insert into planningelement ( plannedStartDate , realStartDate , plannedEndDate , plannedDuration , validatedWork , assignedWork , plannedWork , leftWork , realWork , progress , expectedProgress , wbs , wbsSortable , priority , elementary , idle , done , cancelled , validatedCalculated ) values ('2014-12-29', '2014-12-29', '2016-09-22', '454', '1297.5', '1199.25', '1351', '966', '385', '28', '30', '3', '003', '500', '1', '0', '0', '0', '0')
ERREUR: une valeur NULL viole la contrainte NOT NULL de la colonne « reftype »
DÉTAIL: La ligne en échec contient (231, null, null, null, null, null, null, 2014-12-29, 2014-12-29, null, null, 2016-09-22, null, null, null, 454, null, 0.00000, 1297.50000, 1351.00000, 385.00000, 3, 003, null, null, null, 500, 0, 1, 966.00000, 1199.25000, null, null, 0, null, null, null, null, null, null, null, 28, 30, 0, 0, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 0.00000, null, null, null, null, 0.00000, 1.00000, 0.00000, 1.00000, 0.00)
INSTRUCTION : insert into planningelement ( plannedStartDate , realStartDate , plannedEndDate , plannedDuration , validatedWork , assignedWork , plannedWork , leftWork , realWork , progress , expectedProgress , wbs , wbsSortable , priority , elementary , idle , done , cancelled , validatedCalculated ) values ('2014-12-29', '2014-12-29', '2016-09-22', '454', '1297.5', '1199.25', '1351', '966', '385', '28', '30', '3', '003', '500', '1', '0', '0', '0', '0')
DÉTAIL: La ligne en échec contient (194, 43, null, null, null, 528, 0.25000, 2016-01-21, 20160121, 201603, 201601, 2016, null, null, null, null)
INSTRUCTION : insert into work ( idResource , idAssignment , work , workDate , day , week , month , year ) values ('43', '528', '0.25', '2016-01-21', '20160121', '201603', '201601', '2016')
ERREUR: une valeur NULL viole la contrainte NOT NULL de la colonne « idproject »
DÉTAIL: La ligne en échec contient (195, 43, null, null, null, 528, 0.25000, 2016-01-19, 20160119, 201603, 201601, 2016, null, null, null, null)
INSTRUCTION : insert into work ( idResource , idAssignment , work , workDate , day , week , month , year ) values ('43', '528', '0.25', '2016-01-19', '20160119', '201603', '201601', '2016')
ERREUR: une valeur NULL viole la contrainte NOT NULL de la colonne « idproject »
DÉTAIL: La ligne en échec contient (196, 43, null, null, null, 528, 0.25000, 2016-01-19, 20160119, 201603, 201601, 2016, null, null, null, null)
INSTRUCTION : insert into work ( idResource , idAssignment , work , workDate , day , week , month , year ) values ('43', '528', '0.25', '2016-01-19', '20160119', '201603', '201601', '2016')
ERREUR: une valeur NULL viole la contrainte NOT NULL de la colonne « idproject »
DÉTAIL: La ligne en échec contient (197, 43, null, null, null, 528, 0.25000, 2016-01-20, 20160120, 201603, 201601, 2016, null, null, null, null)
INSTRUCTION : insert into work ( idResource , idAssignment , work , workDate , day , week , month , year ) values ('43', '528', '0.25', '2016-01-20', '20160120', '201603', '201601', '2016')
ERREUR: une valeur NULL viole la contrainte NOT NULL de la colonne « reftype »
DÉTAIL: La ligne en échec contient (229, null, null, null, null, null, null, 2014-12-29, 2014-12-29, null, null, 2016-09-22, null, null, null, 454, null, 0.00000, 1297.50000, 1351.00000, 385.00000, 3, 003, null, null, null, 500, 0, 1, 966.00000, 1199.25000, null, null, 0, null, null, null, null, null, null, null, 28, 30, 0, 0, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 0.00000, null, null, null, null, 0.00000, 1.00000, 0.00000, 1.00000, 0.00)
INSTRUCTION : insert into planningelement ( plannedStartDate , realStartDate , plannedEndDate , plannedDuration , validatedWork , assignedWork , plannedWork , leftWork , realWork , progress , expectedProgress , wbs , wbsSortable , priority , elementary , idle , done , cancelled , validatedCalculated ) values ('2014-12-29', '2014-12-29', '2016-09-22', '454', '1297.5', '1199.25', '1351', '966', '385', '28', '30', '3', '003', '500', '1', '0', '0', '0', '0')
ERREUR: une valeur NULL viole la contrainte NOT NULL de la colonne « reftype »
DÉTAIL: La ligne en échec contient (230, null, null, null, null, null, null, 2014-12-29, 2014-12-29, null, null, 2016-09-22, null, null, null, 454, null, 0.00000, 1297.50000, 1351.00000, 385.00000, 3, 003, null, null, null, 500, 0, 1, 966.00000, 1199.25000, null, null, 0, null, null, null, null, null, null, null, 28, 30, 0, 0, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 0.00000, null, null, null, null, 0.00000, 1.00000, 0.00000, 1.00000, 0.00)
INSTRUCTION : insert into planningelement ( plannedStartDate , realStartDate , plannedEndDate , plannedDuration , validatedWork , assignedWork , plannedWork , leftWork , realWork , progress , expectedProgress , wbs , wbsSortable , priority , elementary , idle , done , cancelled , validatedCalculated ) values ('2014-12-29', '2014-12-29', '2016-09-22', '454', '1297.5', '1199.25', '1351', '966', '385', '28', '30', '3', '003', '500', '1', '0', '0', '0', '0')
ERREUR: une valeur NULL viole la contrainte NOT NULL de la colonne « reftype »
DÉTAIL: La ligne en échec contient (231, null, null, null, null, null, null, 2014-12-29, 2014-12-29, null, null, 2016-09-22, null, null, null, 454, null, 0.00000, 1297.50000, 1351.00000, 385.00000, 3, 003, null, null, null, 500, 0, 1, 966.00000, 1199.25000, null, null, 0, null, null, null, null, null, null, null, 28, 30, 0, 0, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 0.00000, null, null, null, null, 0.00000, 1.00000, 0.00000, 1.00000, 0.00)
INSTRUCTION : insert into planningelement ( plannedStartDate , realStartDate , plannedEndDate , plannedDuration , validatedWork , assignedWork , plannedWork , leftWork , realWork , progress , expectedProgress , wbs , wbsSortable , priority , elementary , idle , done , cancelled , validatedCalculated ) values ('2014-12-29', '2014-12-29', '2016-09-22', '454', '1297.5', '1199.25', '1351', '966', '385', '28', '30', '3', '003', '500', '1', '0', '0', '0', '0')
Thank you .
Posted : 02 Feb 2016 12H47
PLEASE POST IN ENGLISH.
You will find history of changes in table history.
Posted : 02 Feb 2016 13H04
Topic starter
Ok, thanks Babynus.
Do you know the cause of errors ?
Posted : 02 Feb 2016 13H21
It looks like some import of work (or API import of work) where data is not correctly defined (project, day, ...)
Posted : 02 Feb 2016 15H23
Topic starter
thanks you i will look that.
Posted : 02 Feb 2016 15H46