Submitted by mca1 on 2011/09/15 14:33
Hi all,
 
I got over a bug/crash in IQ 0.925W build.
It occurs in the GanttChart.
 
To replay it:
Open a gantt chart and zoom in until you can see the Days (S-M-T... and so on). Now create a timechart-bar thats only a few millimeters long (so to say - e.g. one day from 0h to 12h). After releasing the mouse button your IQ should crash.
 
This happens both with installer and portable version and on both XP and Win7 machines...

Comments

Hi mca1,
Thanks for the bug report !
I tried to reproduce the problem, but I haven't been able to.
Maybe if you can post a small screen cast (1-click on the flash icon in the toolbar here, 2-  in the dialog click on "browse server", 3- then select & upload your  file and 4- enter the screencast,s dimensions), it will help.
 
Here's mine:
 
 
--------------------------------------------------------------------------------
Windows XP Home Edition, Service pack 2
Dell Vostro 1500, Ram:3gb, CPU:Core2Duo T7500 2.2ghz

mca1

2011/09/15 15:49

In reply to by Armando

Ok, I tried to record a screen... during upload it says invalid file. Its an avi with ~600kb.
 
During the movie you would see that the first timebar sets up correctly, but the second one (after I zoomed into the gantt chart via ctrl + mouse) crashes IQ.
 
 

Armando

2011/09/15 19:59

In reply to by mca1

The reason why a screenshot/screencast  can be useful is that it allows us to see if there are specific options turned on.
Il use the free Jing to create FLV SWF  screencasts.
 
Are you working with a sample DB ? What gantt options are you using ?

I just tried again for 5 min, with different options, creating several gantt bars, zooming in and out, etc., and I can't crash IQ.
 
 
--------------------------------------------------------------------------------
Windows XP Home Edition, Service pack 2
Dell Vostro 1500, Ram:3gb, CPU:Core2Duo T7500 2.2ghz

mca1

2011/09/16 13:49

In reply to by Armando

Hi,
 
sorry, I am not able to record a proper SWF or convert my AVI. In the end, it's not that important... The process is like I described it. The options I set doesn't bring any improvements. In all configurations IQ crashes when e.g. I zoom in to max and then draw a timebar of e.g. 2 hours.
 
This happens with all gantt-options possible in all files, new ones, the sample DB...
 

Armando

2011/09/16 15:19

In reply to by mca1

For 20min I tried to crash IQ with the gantt and wasn't able to.
 
- Created a brand new "installation" directory for IQ where I dumped the portable version -- so I left all options as they are defined in a brand new IQ "installation" (unzipping files in directory)
- created a new sample DB and a new blank one.
- tried creating various gantt bars at various zoom levels and then zoomed in and out.
 
I'm running out of idea and time...
If anyone else has an idea of what could happen.
 
 
--------------------------------------------------------------------------------
Windows XP Home Edition, Service pack 3
Dell Vostro 1500, Ram:3gb, CPU:Core2Duo T7500 2.2ghz

Jon

2011/09/16 15:56

In reply to by Armando

I wonder if it has anything to do with the was the user "installs" IQ. I usually wipe the directory completely, then unzip the latest version. I want to be able to test without inheriting past problems. This has occurred in the past. It also seems to work the other way around. Copying over an old install can mask problems unique to the new install (http://www.sqlnotes.net/drupal5/index.php?q=node/2499). 

Armando

2011/09/16 16:21

In reply to by Jon

It might be but I tried both scenarios : my own version W (which was unzipped on top of V), and a brand new folder with a "clean" W. In both cases, I can't reproduce the problem, whether I use a sample DB, my own or a completely blank one with no changes whatsoever made to the original settings.
 
I wonder if it's a gantt component compatibility problem within certain contexts. Mca tried it on 2 different machines though, with 2 diff. OSes installed : Win 7 and Win XP.
 
I'm puzzled.
 
--------------------------------------------------------------------------------
Windows XP Home Edition, Service pack 3
Dell Vostro 1500, Ram:3gb, CPU: Intel Core2Duo T7500 2.2ghz

mca1

2011/09/17 06:59

In reply to by Armando

Hi helping community,
 
I decided to have a look in the visual studio debugger. This brings the following details to this crash:
 
<<Unbehandelte Ausnahme bei 0x00000000 in InfoQube.exe: 0xC0000005: Zugriffsverletzung beim Lesen an Position 0x00000000.>>
 
The english translation should be an <<Unhandled Exception at 0x00000000 in InfoQube.exe0xC0000005: Access violation while reading at Position 0x00000000>>
 
Maybe this helps...

mca1

2011/09/17 09:21

In reply to by mca1

Just more infos:
 
The errorLog.txt contains the following entry every time InfoQube crashes:
17.09.2011 15:11:25    91    3    MDIForm_Load    17.09.2011 15:11:25    91    Objektvariable oder With-Blockvariable nicht festgelegt(l=0)    MDIForm_Load
 
The official translation for "Objektvariable oder With-Blockvariable nicht festgelegt" is (according to the MSDN): "Object variable or With block variable not set  ".
 
 

Armando

2011/09/17 12:01

In reply to by mca1

Hi mca1,
Thanks for the info. Maybe Pierre will find something in there, but these error seem pretty "generic".
 
--------------------------------------------------------------------------------
Windows XP Home Edition, Service pack 3
Dell Vostro 1500, Ram:3gb, CPU: Intel Core2Duo T7500 2.2ghz

mca1

2011/09/21 01:54

In reply to by Armando

Here I go again...this time with my screencast
 
 
 
Hope, this helps...
 
 
Update: ok, Flash won't work again. I attached the file now...

Armando

2011/09/24 15:33

In reply to by mca1

Thanks a lot for the screencast!
Yes, I see the problem, but we can mostly witness the crash -- which I always believed happened -- and not much more. We don't see the toolbars or anything else.
 
I noticed you're not using the sample file. But maybe does it happen with a "pure" sample file too ?
 
Maybe could it be a problem with localisation (your interface seems to be in German) ? I wonder if Tom (are you still in Germany, or using a German interface?) or someone else experienced this problem.
 
--------------------------------------------------------------------------------
Windows XP Home Edition, Service pack 3
Dell Vostro 1500, Ram:3gb, CPU: Intel Core2Duo T7500 2.2ghz

mca1

2011/09/25 14:23

In reply to by Armando

Hi again,
 
thank you for your reply. Your tips were interesting.
 
To go a bit deeper, some more info:
- yes, I use German Interface - my whole operating system is in German (Win7, 64bit). Changing the UI language to english doesn't help, by the way.
- the problem happens with blank files, the sample DB, with own/empty files...
 
I assume (really just an assumption) is has to do with the Ganttchart duration field "Task Duration".
When I generated the gantt I used the default configuration. In "manage grids", "Gantt chart" I can modifiy the correspondig fields.
Reomving the "Effort in days" or "Percent done" don't prevent the crash. Removing the TaskDuration field the crashed are gone (but of course the duration calculation won't work anymore.
 
Maybe here the error is risen. In the field properties of "Task Duration" I have this formula per default: =CalcTaskDuration( TaskActStart, TaskDuration, TaskActEnd )
Is this correct? TaskActStart and TaskActEnd are, e.g. not the correct fieldnames for Task beginning and end.
 
I assume that maybe this formula causes the error.
 
MAybe also any kind of Div by zero as the crash only comes up when I draw short lines on a high zoom level (so to say: the gantt bar is only a few hours long (not a whole day).
 
 
These things are all just assumptions but I can't figure out what else I could do...

mca1

2011/09/26 04:35

In reply to by mca1

I just checked it on another machine.
 
Also german environment but 32 bit, Intel Core2 Duo, P9700. Windows XP this time.
 
Same error/crash.
 
Once again when the TaskDuration is < 1 (so when the gantt bar is not stretched over a complete day, but just some hours) - I assume that a value of 1 for TaskDuration means one day?
 
I opened the grid then displaying the fields TaskStart, TaskEnd and TaskDuration (the ones that are important when calculating the gantt chart).
This time I entered the values manually.
 
TaskStart from 26.09.2011 to TaskEnd 27.09.2011 calculates correct, result in TaskDuration is "1".
TaskStart from 26.09.2011 08:00:00 to TaskEnd 27.09.2011 10:00:00 doesn't work. IQ however does not crash completely here but an error box is popping up:
"Error calculating function"
MAX
. Verify that the function exists (View --> User Code) for field 'TaskEnd'
 
 
I went into the Field properties. In "TaskEnd" below the point "Hierarchy Equation" there is "Parents" = MAX ((Children)). When I press on the update icon begind "((Children))" the same error message pops up.
 
 
Just for the sake of completeness I also checked  upon the field properties of TaskStart. Here the Hierarchy Equation is "Parents" = MIN ((Children)). When I click on the update button here the error message also pops up PLUS a red error line in the status bar pops up with "Error: 1: db_SetQueryDefSQL|26.09.2011 10:32:46|13|Typen unverträglich(|=0)"
 
"Typen unverträglich" should be something like "type mismatch" in english.
 
 
I hope this new infos help you to narrow down on the error.
 
 
By the way - I know that a ganttchart bar of smaller 1 day seems a bit unrealistic as projects and workpackage are always longer than 1 day. But I think hunting down that error is important anyway.
 
 
Thanks in advance and keep up the good work...

Hi mca1,
 
Thanks for all this info. I'll look at it today and should be able to reproduce it.
 
Have a great day !
 
 

Hi mca1,
 
I was able to trace the error, which was caused by the comma decimal separator (used in fractional days). It is now correctly handled.
 
Updated in v0.9.25W1
 

mca1

2011/09/28 10:42

In reply to by Pierre_Admin

Hi there,
 
this sounds like really great news. I am happy to be able to contribute to that bug fix.

Armando

2011/09/28 23:08

In reply to by mca1

 
--------------------------------------------------------------------------------
Windows XP Home Edition, Service pack 3
Dell Vostro 1500, Ram:3gb, CPU: Intel Core2Duo T7500 2.2ghz