Redmine 1.3.0 (stable)

Jan 31, 2012 at 1:59 PM
Edited Jan 31, 2012 at 1:59 PM

Hi Guys, we use L&L 17 in our software (Match-IT_ and would like to make use of your redmine reporting tool too.  However we are running redmine 1.3.0 (stable).  Your requirement says 1.2.2.  Have you tried it with redmine 1.3.0?  Any plans to go there...?  Thanks...

Developer
Feb 1, 2012 at 5:05 AM

Hi sailwave,

it should run on Redmine 1.3.0 (stable) without any problems. Please check this and give me some feedback if it works for you.

-Ben

Feb 1, 2012 at 9:45 AM

Thanks Ben.  I'll give it a whirl and get back to you.

Feb 1, 2012 at 10:14 AM
Edited Feb 1, 2012 at 10:32 AM

Hi Ben.  Installed to c:\RedmineReports.  Installed connector 6.4.4.0.  Edit config. Fired it up.  I can see the projects fine and the sub projects.  I can run the supplied Report.lst on top level projects OK.  But when I select a sub-project (one level deep) and click "Design" I get "Specified cast is not valid" and the log below.  It allows me to carry on if I click continue but the select report dialog doesn't appear.  

(Windows 2008 server 64bit)

See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************System.InvalidCastException: Specified cast is not valid.   at combit.RedmineReports.RedmineDataAccessBase.CreateIssueHistory(String projectId, String sqlCommand, Int32 startDate)   at combit.RedmineReports.RedmineDataAccessBase.GetRedmineData(String projectId, String sqlCommand, Int32 startDate)   at combit.RedmineReports.RedmineReportsForm.InitDataSource()   at combit.RedmineReports.RedmineReportsForm.btnDesign_Click(Object sender, EventArgs e)   at System.Windows.Forms.Control.OnClick(EventArgs e)   at System.Windows.Forms.Button.OnClick(EventArgs e)   at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)   at System.Windows.Forms.Control.WndProc(Message& m)   at System.Windows.Forms.ButtonBase.WndProc(Message& m)   at System.Windows.Forms.Button.WndProc(Message& m)   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

************** Loaded Assemblies **************mscorlib    Assembly Version: 2.0.0.0    Win32 Version: 2.0.50727.4963 (win7RTMGDR.050727-4900)    CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll----------------------------------------RedmineReports    Assembly Version: 1.0.3.0    Win32 Version: 1.0.3.0    CodeBase: file:///C:/RedmineReports/RedmineReports.exe----------------------------------------System.Windows.Forms    Assembly Version: 2.0.0.0    Win32 Version: 2.0.50727.4961 (win7RTMGDR.050727-4900)    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll----------------------------------------System    Assembly Version: 2.0.0.0    Win32 Version: 2.0.50727.4962 (win7RTMGDR.050727-4900)    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll----------------------------------------System.Drawing    Assembly Version: 2.0.0.0    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll----------------------------------------System.Configuration    Assembly Version: 2.0.0.0    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll----------------------------------------System.Xml    Assembly Version: 2.0.0.0    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll----------------------------------------MySql.Data    Assembly Version: 6.4.4.0    Win32 Version: 6.4.4.0    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/MySql.Data/6.4.4.0__c5687fc88969c44d/MySql.Data.dll----------------------------------------System.Data    Assembly Version: 2.0.0.0    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)    CodeBase: file:///C:/Windows/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll----------------------------------------System.Transactions    Assembly Version: 2.0.0.0    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)    CodeBase: file:///C:/Windows/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll----------------------------------------System.EnterpriseServices    Assembly Version: 2.0.0.0    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)    CodeBase: file:///C:/Windows/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll----------------------------------------combit.ListLabel17    Assembly Version: 17.1.4352.16935    Win32 Version: 17.1.0.0    CodeBase: file:///C:/RedmineReports/combit.ListLabel17.DLL----------------------------------------System.Core    Assembly Version: 3.5.0.0    Win32 Version: 3.5.30729.4926 built by: NetFXw7    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Core/3.5.0.0__b77a5c561934e089/System.Core.dll----------------------------------------System.Web    Assembly Version: 2.0.0.0    Win32 Version: 2.0.50727.4955 (win7RTMGDR.050727-4900)    CodeBase: file:///C:/Windows/assembly/GAC_32/System.Web/2.0.0.0__b03f5f7f11d50a3a/System.Web.dll----------------------------------------System.Data.OracleClient    Assembly Version: 2.0.0.0    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)    CodeBase: file:///C:/Windows/assembly/GAC_32/System.Data.OracleClient/2.0.0.0__b77a5c561934e089/System.Data.OracleClient.dll----------------------------------------
************** JIT Debugging **************To enable just-in-time (JIT) debugging, the .config file for thisapplication or computer (machine.config) must have thejitDebugging value set in the system.windows.forms section.The application must also be compiled with debuggingenabled.
For example:
<configuration>    <system.windows.forms jitDebugging="true" /></configuration>
When JIT debugging is enabled, any unhandled exceptionwill be sent to the JIT debugger registered on the computerrather than be handled by this dialog box.


Developer
Feb 1, 2012 at 10:50 AM

Hi sailwave,

Thanks for the detailed description. From the stack, a possible reason could be that your ticket statuses don't have a default done ratio assigned (which the code currently doesn't expect). Could you try to (in Redmine!) go to Administration, Ticket Statuses and make sure all statuses have a done ratio assigned (like 0%, 100% etc)? Does that help? If that doesn't help, could you try to compile the sources and see, which exact line is causing trouble?

Your reply is appreciated,

-Ben

Feb 1, 2012 at 11:29 AM

Hi Ben, I created a test sub-project with one issue and set 10% done and make sure every other field was filled in.  Still fails.  Not set up for compiling on the server.  Can maybe do it locally... 

Coordinator
Feb 1, 2012 at 12:20 PM

Hi sailwave,

Ben meant to switch the default done ratio for the ticket status to something like 0% or 100%, not the ratio on the original ticket. This can be done as Redmine Administrator only. Then go to Administration > Ticket Statuses and check for the different default done ratios there.

-John

Feb 1, 2012 at 1:59 PM

Hi John, either I'm being totally dull (quite possible) or Redmine 1.3 does not have default ratios...  Nothing in Issue Statuses (or theri detail) or workflow or...

Coordinator
Feb 1, 2012 at 2:24 PM

Hi sailwave,

no problem - for me it's there however <g>. Click "Administration" (on Redmine's top navigation), then "Issue statuses". You should see your list of statuses and a column labeled "% done". This is the ratio we're talking about. Make sure that there's a number in each line or edit your ticket statuses to have it read something like "0 %" or "100 %" (there's a handy combo selection for that in the Edit Status window). You can revert this operation afterwards, however it would help us to see if we found the root cause for your problem.

It's a pity you cannot attach screenshots to forum posts (or can you?!)...

-John

Feb 1, 2012 at 2:47 PM
Edited Feb 1, 2012 at 2:47 PM

:) I know why i cant see the defaults - adminstration | settings | issue tracking | calculate... = "use the issue field",  but it needs to be changed to use the issue status.

Sorry - one day old Redmine user here.

Will try now with defaults set... I can see them now.

....

Feb 1, 2012 at 2:55 PM

woo

it works

thanks guys - sorry for being a bit slow - new to Redmine. 

Redmine 1.3.0(stable) rails 2.3.14.

let me know if you want me to try anything else with 1.3.0

Coordinator
Feb 2, 2012 at 6:22 AM

Hi sailwave,

Thanks for taking the time to report this and checking the workaround. However, your initial configuration was totally valid, too. I created a work item at http://redminereports.codeplex.com/workitem/14720 for a real fix that will come with the next release then.

-John

Feb 2, 2012 at 8:25 AM

My pleasure. I'll keep an eye open for updates.