Forum

Problem with Full t...
 
Notifications
Clear all

Problem with Full time equivalent (ETP in french)

22 Posts
2 Users
0 Reactions
9,628 Views
Bena
 Bena
(@bena)
Posts: 65
Active Member
Topic starter
 
[#5624]

Hello,

On my ressource profile, I have an ETP set to 1. When I compute the planning, projeqtor does not assign me 1 day of work. It's usually between 0.58 and 0.6 day.
So I tried to reduce my ETP. And when I set it below 0.4, I have the following error :

2018-12-17 11:14:23.162 ** ERROR ** [V7.2.7] ERROR **
2018-12-17 11:14:23.163
** ERROR ** [V7.2.7] on file '/projeqtor/projeqtor/model/ProjectMain.php' at line (647)
2018-12-17 11:14:23.163
** ERROR ***** [V7.2.7] cause = Creating default object from empty value

Can you help me ?

Regards,


--
Bena

 
Posted : 17 Dec 2018 13H27
(@babynus)
Posts: 14952
Member Admin
 

Can you show print screen of what you do ?
It's not clear as you deal with resource capacity and point out error on project...


 
Posted : 17 Dec 2018 16H42
Bena
 Bena
(@bena)
Posts: 65
Active Member
Topic starter
 

Sorry, i forget one step.
The error is displayed when I calculate all project from the gantt planning.


--
Bena

 
Posted : 17 Dec 2018 17H07
(@babynus)
Posts: 14952
Member Admin
 

Hello,

I really don't think is is linked to FTE of resource...
... but who really knows, except God
... and even God may not be sure when subject is computer programming.

But I cannot reproduce.
Could you try and reproduce on Demo ?
Could you also check for consistency issues (check is avaialble on admin screen)


 
Posted : 17 Dec 2018 19H40
Bena
 Bena
(@bena)
Posts: 65
Active Member
Topic starter
 

Hello,

No error with the consistency check.

I've try with an other ressource on the same instance of projeqtor and there is no error.

I've just the error with me (as ressource). An other strange thing, Projeqtor never allow me to work more than 0.6 day a day (with a FTE of 1).
The only way for me to have 1 day of work planned each day is to set my FTP to 1.4.

It's like that somewhere on the app, 0.4 is remove from my FTE. So if I set my FTE under 0.4, my true FTE is under 0 and the calculation of the planning crash.

Regards,


--
Bena

 
Posted : 18 Dec 2018 16H18
(@babynus)
Posts: 14952
Member Admin
 

Can you check with report "Color Monthly Reource planning" if your resource is used on another project ?


 
Posted : 19 Dec 2018 23H05
(@babynus)
Posts: 14952
Member Admin
 

I think you have some unconsistency in data, that is not displayed but generates issues.
We have completed consistency checks on V7.3, and fixed an issue on the subjet on V7.3.2 (that will soon be deployed).
I hope that consistence checks on V7.3.2 will fix your issue.


 
Posted : 20 Dec 2018 20H06
(@babynus)
Posts: 14952
Member Admin
 

Hi,

I think I've found your planning issue.
It does not come from FTE, but from use of global planning.
This issue should be fixed on V7.3.2

You FTE issue comes (almost sure) from a project "using" part of your availability.
Possibly a fixed project.
Check in reports for planned work.


 
Posted : 21 Dec 2018 11H52
Bena
 Bena
(@bena)
Posts: 65
Active Member
Topic starter
 

Hello,

I've just installed the version 7.3.3. It's better. Instead of loosing 0.4 day by day (with a FTE at 1), I juste loose 0.21 day.

When I set my FTE to 0.1 and try to calculate the planning I have the following error :

2019-01-03 18:33:28.489 ** ERROR ** [V7.3.3] ERROR **
2019-01-03 18:33:28.489 ** ERROR ** [V7.3.3] on file '/projeqtor/projeqtor/model/ProjectMain.php' at line (647)
2019-01-03 18:33:28.489 ** ERROR ***** [V7.3.3] cause = Creating default object from empty value

PS : I have run the check consistency in the admin part and it correct many error but I still have only 0.79 day planned each day.

Regards.


--
Bena

 
Posted : 04 Jan 2019 12H12
(@babynus)
Posts: 14952
Member Admin
 

Try and add one line before line 647 in /model/ProjectMain.php, like this

    
    debugLog($this);
    $this->ProjectPlanningElement->refName=$this->name;

Run the calculation that generates the error.
Then poste here log file.
Thanks.


 
Posted : 04 Jan 2019 22H24
Bena
 Bena
(@bena)
Posts: 65
Active Member
Topic starter
 

Hello,

The log is joined.

Regards,


--
Bena

 
Posted : 07 Jan 2019 12H16
(@babynus)
Posts: 14952
Member Admin
 

Try and change line 996 in model/ProjectMain.php from

$proj=SqlElement::getSingleSqlElementFromCriteria("ProjectPlanningElement",array('refType'=>'Project','refId'=>$id),true);

to

$proj=SqlElement::getSingleSqlElementFromCriteria("ProjectPlanningElement",array('refType'=>'Project','refId'=>$id),false);

Does it fix the issue ?


 
Posted : 07 Jan 2019 12H30
Bena
 Bena
(@bena)
Posts: 65
Active Member
Topic starter
 

nop, same error.


--
Bena

 
Posted : 07 Jan 2019 19H03
(@babynus)
Posts: 14952
Member Admin
 

Would it be possible to get an anonymized dump of your DB to reproduce ?
(we have a plugin to do this)


 
Posted : 08 Jan 2019 0H24
Bena
 Bena
(@bena)
Posts: 65
Active Member
Topic starter
 

I have an error with the plugin :

2019-01-08 09:49:09.522 ===== TRACE ===== New plugin found : backupDatabaseForSupport_V1.4.zip
2019-01-08 09:49:09.526 ===== TRACE ===== Plugin unzipped succefully
2019-01-08 09:49:09.529 ===== TRACE ===== Plugin descriptor information :
2019-01-08 09:49:09.529 ===== TRACE ===== => name : backupDatabaseForSupport
2019-01-08 09:49:09.529 ===== TRACE ===== => description : anonymized backup of a database to provide for support
2019-01-08 09:49:09.529 ===== TRACE ===== => version : 1.4
2019-01-08 09:49:09.529 ===== TRACE ===== => compatibility : V5.4.4
2019-01-08 09:49:09.531 ** ERROR ** [V7.3.3] ERROR **
2019-01-08 09:49:09.531
** ERROR ** [V7.3.3] on file '/projeqtor/projeqtor/plugin/backupDatabaseForSupport/backup.php' at line (71)
2019-01-08 09:49:09.531
** ERROR ***** [V7.3.3] cause = mysqli::__construct(): (HY000/2002): No such file or directory


--
Bena

 
Posted : 08 Jan 2019 11H52
Bena
 Bena
(@bena)
Posts: 65
Active Member
Topic starter
 

Hello,

Same error on a fresh install on the same server in a different location / same database server (in an other base).

No error on an other server (apache an mysql in the same physical server)

Maybe one linux package is missing ?

Regards.


--
Bena

 
Posted : 15 Jan 2019 15H49
(@babynus)
Posts: 14952
Member Admin
 

You must have mysqli installed.

We are working on upgrade of the the plugin to be full PDO compliant, but it's not finished yet.


 
Posted : 16 Jan 2019 21H10
Bena
 Bena
(@bena)
Posts: 65
Active Member
Topic starter
 

Hello,

Mysqli was already installed :


--
Bena

 
Posted : 23 Jan 2019 13H29
(@babynus)
Posts: 14952
Member Admin
 

It seems you did not use latest version.
Try this one : https://nextcloud.projeqtor.net/index.php/s/nwLqSqQyMqYgg48


 
Posted : 24 Jan 2019 18H52
Bena
 Bena
(@bena)
Posts: 65
Active Member
Topic starter
 

Hello,
I have uploaded the dump.
Regards.


--
Bena

 
Posted : 28 Jan 2019 19H35
Bena
 Bena
(@bena)
Posts: 65
Active Member
Topic starter
 

Any update ?


--
Bena

 
Posted : 22 Feb 2019 22H54
(@babynus)
Posts: 14952
Member Admin
 

Hi,

We had no time to test your dump.
We'll do it asap


 
Posted : 23 Feb 2019 14H17
Share:

Scroll to Top