Forum

Reports don't work ...
 
Notifications
Retirer tout

Reports don't work anymore on my project

6 Posts
3 Utilisateurs
0 Reactions
875 Vu
(@brasal)
Posts: 52
Trusted Member
Début du sujet
 
[#9153]

Hi, I used to using reports but for unexpected reasons, they have stopped to work. When I ask one, the gear turns a while, stops, and then nothing appears, on a project it had worked before. I have tested many reports.

What could be the cause please?

Note: The planning can be updated without error.


 
Posté : 22/11/2023 5:59 pm
(@marylene)
Posts: 592
Membre Admin
 

Hello,
Have you tried clearing your browser cache?
Do you have errors in the projector logs? In the browser (console)? The Apache logs ?
Some additional information could help us see things more clearly.


 
Posté : 23/11/2023 11:11 am
(@brasal)
Posts: 52
Trusted Member
Début du sujet
 

Hello,
* Emptying browser cache changes nothing
* The search for errors returns everything is alright
* In the projeqtor logs, except expected errors for "Error sending mail" and "Cannot check Version" due to no mail server installed and not opened to web, I have this one:

2023-11-21 16:09:30.442 ** ERROR ** [V10.2.3] Exception-[22008] SQLSTATE[22008]: Datetime field overflow: 7 ERREUR: valeur du champ date/time en dehors des limites : « 2023-11-31 »
LINE 1: ...here (1=1 and idle=0 and ( idle=0 and startdate>'2023-11-3...
^
2023-11-21 16:09:30.442 ** ERROR ** [V10.2.3] For query : select id as id, fullName as name from resource where (1=1 and idle=0 and ( idle=0 and startdate>'2023-11-31' )) order by resource.fullName
2023-11-21 16:09:30.442 ** ERROR ** [V10.2.3] Strack trace :
2023-11-21 16:09:30.442 ** ERROR ** [V10.2.3] #0 Sql->query called at [/var/www/html/projeqtor/model/persistence/SqlList.php:339]
2023-11-21 16:09:30.442 ** ERROR ** [V10.2.3] #1 SqlList->fetchListWithCrit called at [/var/www/html/projeqtor/model/persistence/SqlList.php:81]
2023-11-21 16:09:30.442 ** ERROR ** [V10.2.3] #2 SqlList->getListWithCrit called at [/var/www/html/projeqtor/report/colorPlan.php:164]

Translation : value of date out of limits: « 2023-11-31 ». As date field format is proteted inside every input field, I don't understand how it can happen.

I understand a bad date can block projeqtor operation. But I have no information where is this error.


 
Posté : 23/11/2023 11:48 am
(@brasal)
Posts: 52
Trusted Member
Début du sujet
 

But pdf reports work. Though, there are none consistant results between resource planning and report: the first one shows activities between november 2023 and october 2024 except on august while the report has gaps from february 2024 to july 2024.


 
Posté : 23/11/2023 12:08 pm
(@babynus)
Posts: 14952
Membre Admin
 

Hi, I used to using reports but for unexpected reasons, they have stopped to work. When I ask one, the gear turns a while, stops, and then nothing appears, on a project it had worked before. I have tested many reports.

Hi,
You say many reports fail...
The error you joined concerns one single report.
It's been fixed, and will be deployed in next patch.
Any other report in error ?


 
Posté : 28/11/2023 7:18 pm
(@brasal)
Posts: 52
Trusted Member
Début du sujet
 

Hi,

I did test most reports and they did fail. But to answer you precisely, I have started testing again all of them, and the result is the ones which failed all work again.

I have no explanation on what did happen. In the time between, I have edited many things: tasks in the task GUI or via a Kanban, mostly status and assignment changes, created another kanban for activities.


 
Posté : 30/11/2023 7:08 pm
Share:
Retour en haut