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.
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.
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.
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 ?
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.