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.
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.
Last edit: 23 Nov 2023 10:01 by brasal. Reason: additional information
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.
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 ?
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.
En poursuivant votre navigation, vous acceptez le dépôt de cookies tiers destinés au bon fonctionnement et à la sécurisation du site (gestion de session, reCaptcha) et à une analyse statistique anonymisée des accès sur notre site (Google Analytics). Si vous vous inscrivez, les informations que vous fournirez ne seront jamais divulguées à un tiers sous quelque forme que ce soit. En savoir plus
Cookies settings
×
Functional Cookies
Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.
Session
Please login to see yours activities!
Other cookies
Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.