View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Reports don't work anymore on my project - ProjeQtOr
 
 

Reports don't work anymore on my project

More
22 Nov 2023 15:59 - 22 Nov 2023 17:07 #1 by brasal
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.
Last edit: 22 Nov 2023 17:07 by brasal.

Please Log in or Create an account to join the conversation.

More
23 Nov 2023 09:11 #2 by Arkhanje
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.

Please Log in or Create an account to join the conversation.

More
23 Nov 2023 09:48 - 23 Nov 2023 10:01 #3 by brasal
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

Please Log in or Create an account to join the conversation.

More
23 Nov 2023 10:08 - 23 Nov 2023 10:35 #4 by brasal
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.
Attachments:
Last edit: 23 Nov 2023 10:35 by brasal.

Please Log in or Create an account to join the conversation.

More
28 Nov 2023 17:18 #5 by babynus

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 ?

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
30 Nov 2023 17:08 #6 by brasal
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.

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.050 seconds

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.