Forum

Forums
Requests
Ask questions
Erreur dans la bdd
 
Notifications
Retirer tout

Erreur dans la bdd

 
Ask questions
Dernier post par Huchon Il y a 10 ans
5 Posts
2 Utilisateurs
0 Reactions
3,380 Vu
RSS
 Huchon
(@lucas)
Posts: 3
Active Member
Début du sujet
 
[#2984]

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')

Thank you .


 
Posté : 2 Fév PM 12:022
 babynus
(@babynus)
Posts: 14952
Membre Admin
 

PLEASE POST IN ENGLISH.

You will find history of changes in table history.


 
Posté : 2 Fév PM 13:022
 Huchon
(@lucas)
Posts: 3
Active Member
Début du sujet
 

Ok, thanks Babynus.

Do you know the cause of errors ?


 
Posté : 2 Fév PM 13:022
 babynus
(@babynus)
Posts: 14952
Membre Admin
 

It looks like some import of work (or API import of work) where data is not correctly defined (project, day, ...)


 
Posté : 2 Fév PM 15:022
 Huchon
(@lucas)
Posts: 3
Active Member
Début du sujet
 

thanks you i will look that.


 
Posté : 2 Fév PM 15:022
Forum Jump:
  Sujet précédent
Sujet suivant  
Share:
Retour en haut