Forum

DB Upgrade to V5.2 ...
 
Notifications
Retirer tout

DB Upgrade to V5.2 error on ProjectHistory

2 Posts
2 Utilisateurs
0 Reactions
2,691 Vu
 Dan
(@caccia)
Posts: 340
Contributor
Début du sujet
 
[#2949]

Hello,

I've been starting some testing with ugprading our DB to V5.2 - one small issue:
I have some parent projects which are now quite big: up to 50,000 man-days of work 🙂
Reason is we keep open one project for each department in our organization, so these keep growing even when individual projects inside each department are closed.

Issue I see is during DB upgrade, this error:
2016-01-21 14:24:22.722 ** ERROR ** Exception-[22003] SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'realWork' at row 1
2016-01-21 14:24:22.738 ** ERROR ** For query : insert into projecthistory ( idProject , day , realWork , leftWork , realCost , leftCost , totalRealCost , totalLeftCost ) values ('227', '20160121', '44802.18', '2717.18', '14316.58', '9400', '14316.58', '9400')

Do you think the ProjectHistory fields could be increased in size ? (perhaps at least up to 999,999 for work and 999,999,999 for costs ?)

Cheers !


 
Posté : 21 Jan PM 16:011
(@babynus)
Posts: 14952
Membre Admin
 

Request recorder as Ticket #1945


 
Posté : 22 Jan PM 21:011
Share:
Retour en haut