KPI : SQL error

Hello,

Looking at the logs while I can't manage to get consolidated KPI, I found a lot of Exceptions concerning essentially h.year and h.month column not found in the database.

2017-04-12 17:38:11.508 ***** ERROR ***** Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.y
ear' in 'where clause'
2017-04-12 17:38:11.508 ***** ERROR ***** For query : select * from deliverable where idProject=420 and h.year='2016' and deliverable.scope = 'Deliverable' order by plannedDate asc
2017-04-12 17:38:11.508 ***** ERROR ***** Strack trace :
2017-04-12 17:38:11.508 ***** ERROR ***** #0 Sql->query called at [/var/www/html/projeqtor/model/persistence/SqlElement.php:1840]
2017-04-12 17:38:11.508 ***** ERROR ***** #1 SqlElement->getSqlElementsFromCriteria called at [/var/www/html/projeqtor/report/kpiDeliverable.php:246]

I wonder if the problems comes from a bad database update when migrating to 6.1.3 or if the problem comes from elsewhere.

Thanks for your help.

Hi,

This was due to Organization not configured correctly.
When everything is well configured there are no more problems.