Problem viewing reports

[fret_24]

Hey guys, I'm having problems getting my reports page to load (/Analytics/Reporting.aspx). I'm getting a "Specified cast is not valid" error.

Source Error:
Line 48: <grd:LocalizedHeaderRadTemplateColumn DataField="IsActive" HeaderTextID="/pageText/reporting.aspx/isActive" SortExpression="IsActive" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center">
Line 49: <ItemTemplate>
Line 50: &nbsp;<asp:Image ID="_isActive" runat="server" ImageUrl='<%# Checkbox.Management.ApplicationManager.Application Root + "/Images/check2.gif" %>' Visible='<%# Eval("IsActive") %>' />&nbsp;
Line 51: </ItemTemplate>
Line 52: </grd:LocalizedHeaderRadTemplateColumn>

Any ideas? I'm thinking I have some bad data somewhere in my database that I need to clean up, but I'm not sure where to start looking.

[pwiesner]

This is not an issue we have seen before. To help get a better understanding of the situation please answer the following:

- What version of Checkbox are you using?
- Has anything in your environment changed recently? For example have you patched to a new version.
- Does this issue occur for all users or only some users? If the issue only occurs for some users what roles has this user been assigned?

[fret_24]

We were still on v4.1.something when this started a couple of days ago. The error was caught by the system and returned a very generic "An error occurred" message inside the wrapper. I thought this would be a good time to patch to the latest version and see if that fixed the problems, so we are now on v4.5.3.55. It did not and the error is actually quite worse in that the page doesn't load at all. Instead when running from a remote location you get "Server Error in '/' Application." and running locally you get the error I posted before.

The error happens for all users that I have had test it. All of those users are System Administrators.

I think I'm going to try and sort through all of the response submissions in the database from the last week or so and see what I can find.

[pwiesner]

Your best bet may be to contact the support team. They will be able to help review your database. You can either open an online ticket (Checkbox - Login To Customer Area) or contact them by phone (Checkbox Support - Phone Support).