Odd behavior in project summary page and gantt chart

[Enrique Ruibal]

Hello,

I found an odd behavior in the Project summary page and also in the
gantt chart drawing using postgreSQL 3.3 in my local instance, that you
can not reproduce using the current live demo from Hotwaxmedia:

1) Log in as ofbiz admin into the project app and select either one from
the two Demo Projects available. If you notice carefuly in the phases
and tasks widgets they appear descending in order instead of ascending
the way they appear in the live demo instance.

2) Also, the Gantt Chart appears distorted whereas in the demo instance
it appears ok.

I tested with different browsers and have come to the conclusion that is
got to be something related to using postgreSQL as the running database
in my local instance, I also tried using Derby in my local instance and
it behaved the same way as in the live demo instance.

I wonder if somebody can either reproduce and/or explain this behavior.

Regards,

Enrique Ruibal

[Bruno Busco]

How can I display the Gantt Chart?
Simply using this link
https://demo.hotwaxmedia.com/projectmgr/control/ganttChart?projectId=9100
I see nothing. Is this normal?
-Bruno

2008/9/15 Enrique Ruibal A. <[hidden email]>

> Hello,
>
> I found an odd behavior in the Project summary page and also in the gantt
> chart drawing using postgreSQL 3.3 in my local instance, that you can not
> reproduce using the current live demo from Hotwaxmedia:
>
> 1) Log in as ofbiz admin into the project app and select either one from
> the two Demo Projects available. If you notice carefuly in the phases and
> tasks widgets they appear descending in order instead of ascending the way
> they appear in the live demo instance.
>
> 2) Also, the Gantt Chart appears distorted whereas in the demo instance it
> appears ok.
>
> I tested with different browsers and have come to the conclusion that is
> got to be something related to using postgreSQL as the running database in
> my local instance, I also tried using Derby in my local instance and it
> behaved the same way as in the live demo instance.
>
> I wonder if somebody can either reproduce and/or explain this behavior.
>
> Regards,
>
> Enrique Ruibal
>
>
>
>
>
>

[Jacques Le Roux]

I tried on my local machine which is also the alternate demo server and I get exactly the same behaviour than on official demo
server. This machine uses Postres 8.3
BTW the Gant diagramme does not show (on both machines) in FF3 but is ok in Opera 9.02 and IE7

Please use rather user ML for such questions :
http://docs.ofbiz.org/display/OFBADMIN/Mailing+Lists#MailingLists-DeveloperList:dev@...

Thanks

Jacques


From: "Enrique Ruibal A." <[hidden email]>

> Hello,
>
> I found an odd behavior in the Project summary page and also in the gantt chart drawing using postgreSQL 3.3 in my local instance,
> that you can not reproduce using the current live demo from Hotwaxmedia:
>
> 1) Log in as ofbiz admin into the project app and select either one from the two Demo Projects available. If you notice carefuly
> in the phases and tasks widgets they appear descending in order instead of ascending the way they appear in the live demo
> instance.
>
> 2) Also, the Gantt Chart appears distorted whereas in the demo instance it appears ok.
>
> I tested with different browsers and have come to the conclusion that is got to be something related to using postgreSQL as the
> running database in my local instance, I also tried using Derby in my local instance and it behaved the same way as in the live
> demo instance.
>
> I wonder if somebody can either reproduce and/or explain this behavior.
>
> Regards,
>
> Enrique Ruibal
>
>
>
>
>

[Jacques Le Roux]

Ooops, sorry please forgot my remark about dev list. I thought I was on dev list (I can't say I should have had my coffee this
morning since I never drink any stimulants)

Jacques


From: "Jacques Le Roux" <[hidden email]>

>I tried on my local machine which is also the alternate demo server and I get exactly the same behaviour than on official demo
>server. This machine uses Postres 8.3
> BTW the Gant diagramme does not show (on both machines) in FF3 but is ok in Opera 9.02 and IE7
>
> Please use rather user ML for such questions :
> http://docs.ofbiz.org/display/OFBADMIN/Mailing+Lists#MailingLists-DeveloperList:dev@...
>
> Thanks
>
> Jacques
>
>
> From: "Enrique Ruibal A." <[hidden email]>
>> Hello,
>>
>> I found an odd behavior in the Project summary page and also in the gantt chart drawing using postgreSQL 3.3 in my local
>> instance, that you can not reproduce using the current live demo from Hotwaxmedia:
>>
>> 1) Log in as ofbiz admin into the project app and select either one from the two Demo Projects available. If you notice carefuly
>> in the phases and tasks widgets they appear descending in order instead of ascending the way they appear in the live demo
>> instance.
>>
>> 2) Also, the Gantt Chart appears distorted whereas in the demo instance it appears ok.
>>
>> I tested with different browsers and have come to the conclusion that is got to be something related to using postgreSQL as the
>> running database in my local instance, I also tried using Derby in my local instance and it behaved the same way as in the live
>> demo instance.
>>
>> I wonder if somebody can either reproduce and/or explain this behavior.
>>
>> Regards,
>>
>> Enrique Ruibal
>>
>>
>>
>>
>>
>

[Enrique Ruibal]

Mmm..this is so odd.

I connected to the alternative demo server from Jacques and it does show the correct order in those widgets using Postgres:

Phase1
Phase2
..

Task1
Task2
Task3
..
I wonder if somebody else can replicate this odd behavior I mean you see the phases and tasks in the opposite order:

Phase2
Phase1
..
..
Task4
Task3
Task2
..

I double checked on my environment:

Windows XP SP2
Java JDK 1.5.0_07, then upgraded to 1.5.0_16 and got the same wrong order
Postgresql 3.3
JDBC driver postgresql-8.3-603.jdbc3
My ofbiz version is trunk

Any ideas?

Enrique Ruibal

[Scott Gray]

My first guess without looking would be that for whatever reason your
data is loaded in the database in a different order and no sorting is
being applied to the query.

-Scott

2008/9/16 Enrique Ruibal <[hidden email]>:

>
> Mmm..this is so odd.
>
> I connected to the alternative demo server from Jacques and it does show the
> correct order in those widgets using Postgres:
>
> Phase1
> Phase2
> ..
>
> Task1
> Task2
> Task3
> ..
> I wonder if somebody else can replicate this odd behavior I mean you see the
> phases and tasks in the opposite order:
>
> Phase2
> Phase1
> ..
> ..
> Task4
> Task3
> Task2
> ..
>
> I double checked on my environment:
>
> Windows XP SP2
> Java JDK 1.5.0_07, then upgraded to 1.5.0_16 and got the same wrong order
> Postgresql 3.3
> JDBC driver postgresql-8.3-603.jdbc3
> My ofbiz version is trunk
>
> Any ideas?
>
> Enrique Ruibal
>
>
>
>
>
>
> --
> View this message in context: http://www.nabble.com/Odd-behavior-in-project-summary-page-and-gantt-chart-tp19486163p19499193.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
>

[Enrique Ruibal]

I am going to look into that...thanks a lot.

[Enrique Ruibal]

Just to let you know this is also reproducible now in Jacques alternate server running on postgres 3.0, please take look...

https://lamouline.myvnc.com:18443/projectmgr/control/login;jsessionid=6756E3C526B021C519278F52E57E696E.jvm1?projectId=9000

¿What would be causing this?

Regards,

-Enrique Ruibal