Forum

KPI : SQL error
 
Notifications
Retirer tout

KPI : SQL error

3 Posts
2 Utilisateurs
0 Reactions
3,189 Vu
(@louisc)
Posts: 58
Active Member
Début du sujet
 
[#4268]

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.


 
Posté : 13/04/2017 4:27 pm
(@babynus)
Posts: 14952
Membre Admin
 

Hi,

Could you please post the whole error stack ?


 
Posté : 14/04/2017 10:38 pm
(@louisc)
Posts: 58
Active Member
Début du sujet
 

Hi,

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


 
Posté : 07/07/2017 1:07 am
Share:
Retour en haut