Forum

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.

DB Upgrade to V5.2 ...
 
Notifications
Clear all

DB Upgrade to V5.2 error on ProjectHistory

2 Posts
2 Users
0 Reactions
2,704 Views
 Dan
(@caccia)
Posts: 340
Contributor
Topic starter
 
[#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 !


 
Posted : 21 Jan 2016 16H47
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Request recorder as Ticket #1945


 
Posted : 22 Jan 2016 21H06
Share:

Scroll to Top