Erreur dans la bdd

Start
Prev
1
Next
End

Lucas
Topic Author
Offline
New Member

02 Feb 2016 10:47 - 02 Feb 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 Feb 2016 11:12 by Lucas.

Please Log in or Create an account to join the conversation.

babynus
Offline
Administrator
Moderator

02 Feb 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 Log in or Create an account to join the conversation.

Lucas
Topic Author
Offline
New Member

02 Feb 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 Log in or Create an account to join the conversation.

babynus
Offline
Administrator
Moderator

02 Feb 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 Log in or Create an account to join the conversation.

Lucas
Topic Author
Offline
New Member

02 Feb 2016 13:46 #5 by Lucas

Replied by Lucas on topic Erreur dans la bdd

thanks you i will look that.

Please Log in or Create an account to join the conversation.

Start
Prev
1
Next
End

Moderators: babynus, protion

Time to create page: 0.037 seconds

Erreur dans la bdd

Cookies settings

Functional Cookies

Session

Other cookies

Erreur dans la bdd

Cookies settings

Functional Cookies

Session

Other cookies

Login Form