Erreur dans la bdd

Début
Précédent
1
Suivant
Fin

Lucas
Topic Author
Offline
New Member

02 Fév 2016 10:47 - 02 Fév 2016 11:12 #1 by Lucas

Erreur dans la bdd was created by Lucas

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 :

Warning: Spoiler!

< 2016-01-21 17:54:20.823 CET >ERREUR: une valeur NULL viole la contrainte NOT NULL de la colonne « idproject »
< 2016-01-21 17:54:20.823 CET >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)
< 2016-01-21 17:54:20.823 CET >INSTRUCTION : insert into work ( idResource , idAssignment , work , workDate , day , week , month , year ) values ('43', '528', '0.25', '2016-01-21', '20160121', '201603', '201601', '2016')
< 2016-01-21 17:54:33.584 CET >ERREUR: une valeur NULL viole la contrainte NOT NULL de la colonne « idproject »
< 2016-01-21 17:54:33.584 CET >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)
< 2016-01-21 17:54:33.584 CET >INSTRUCTION : insert into work ( idResource , idAssignment , work , workDate , day , week , month , year ) values ('43', '528', '0.25', '2016-01-19', '20160119', '201603', '201601', '2016')
< 2016-01-21 17:54:48.755 CET >ERREUR: une valeur NULL viole la contrainte NOT NULL de la colonne « idproject »
< 2016-01-21 17:54:48.755 CET >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)
< 2016-01-21 17:54:48.755 CET >INSTRUCTION : insert into work ( idResource , idAssignment , work , workDate , day , week , month , year ) values ('43', '528', '0.25', '2016-01-19', '20160119', '201603', '201601', '2016')
< 2016-01-21 17:55:15.592 CET >ERREUR: une valeur NULL viole la contrainte NOT NULL de la colonne « idproject »
< 2016-01-21 17:55:15.592 CET >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)
< 2016-01-21 17:55:15.592 CET >INSTRUCTION : insert into work ( idResource , idAssignment , work , workDate , day , week , month , year ) values ('43', '528', '0.25', '2016-01-20', '20160120', '201603', '201601', '2016')
< 2016-01-21 18:02:10.593 CET >ERREUR: une valeur NULL viole la contrainte NOT NULL de la colonne « reftype »
< 2016-01-21 18:02:10.593 CET >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)
< 2016-01-21 18:02:10.593 CET >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')
< 2016-01-21 18:02:15.891 CET >ERREUR: une valeur NULL viole la contrainte NOT NULL de la colonne « reftype »
< 2016-01-21 18:02:15.891 CET >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)
< 2016-01-21 18:02:15.891 CET >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')
< 2016-01-21 18:02:28.135 CET >ERREUR: une valeur NULL viole la contrainte NOT NULL de la colonne « reftype »
< 2016-01-21 18:02:28.135 CET >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)
< 2016-01-21 18:02:28.135 CET >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 .

Last edit: 02 Fév 2016 11:12 by Lucas.

Please Connexion or Create an account to join the conversation.

babynus
Offline
Administrator
Moderator

02 Fév 2016 11:04 #2 by babynus

Replied by babynus on topic Erreur dans la bdd

PLEASE POST IN ENGLISH.

You will find history of changes in table history.

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

Lucas
Topic Author
Offline
New Member

02 Fév 2016 11:21 #3 by Lucas

Replied by Lucas on topic Erreur dans la bdd

Ok, thanks Babynus.

Do you know the cause of errors ?

Please Connexion or Create an account to join the conversation.

babynus
Offline
Administrator
Moderator

02 Fév 2016 13:23 #4 by babynus

Replied by babynus on topic Erreur dans la bdd

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

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

Lucas
Topic Author
Offline
New Member

02 Fév 2016 13:46 #5 by Lucas

Replied by Lucas on topic Erreur dans la bdd

thanks you i will look that.

Please Connexion or Create an account to join the conversation.

Début
Précédent
1
Suivant
Fin

Moderators: babynus, protion

Time to create page: 0.038 seconds

Prochaines sessions de formation

Démonstration de ProjeQtOr

(gratuit, sur inscription)

Planifiez avec ProjeQtOr

Administrez avec ProjeQtOr

Erreur dans la bdd

Paramétrages de cookies

Cookies fonctionnels

Session

Autres cookies

Prochaines sessions de formation

Démonstration de ProjeQtOr

(gratuit, sur inscription)

Planifiez avec ProjeQtOr

Administrez avec ProjeQtOr

Erreur dans la bdd

Paramétrages de cookies

Cookies fonctionnels

Session

Autres cookies

Login Form