Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




Bug saving filter

beta

Using build 1952

Tried to save a filter and promptly got my ass wooped!

Server Error in '/Gemini' Application.

        <h2> <i>Cannot

insert the value NULL into column 'projectid', table 'Gemini3.dbo.gemini_personalfilters'; column does not allow nulls. INSERT fails.
The statement has been terminated.

        <font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif ">

        <b> Description: </b>An

unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

        <b> Exception Details: </b>System.Data.SqlClient.SqlException:

Cannot insert the value NULL into column 'projectid', table 'Gemini3.dbo.gemini_personalfilters'; column does not allow nulls. INSERT fails.
The statement has been terminated.

SimonASE
· 1
SimonASE
Replies (7)
helpful
0
not helpful

Thanks, this had been fixed for the release (build  1955).

 


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

No it hasnt - just downloaded 1955, installed it fine and tried to save a filter with the error:

Server Error in '/Gemini' Application.

        <h2> <i>Cannot

insert the value NULL into column 'projectid', table 'Gemini3.dbo.gemini_personalfilters'; column does not allow nulls. INSERT fails.
The statement has been terminated.

        <font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif ">

        <b> Description: </b>An

unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

        <b> Exception Details: </b>System.Data.SqlClient.SqlException:

Cannot insert the value NULL into column 'projectid', table 'Gemini3.dbo.gemini_personalfilters'; column does not allow nulls. INSERT fails.
The statement has been terminated.

        <b>Source Error:</b> <br><br>

        <table bgcolor="#ffffcc" width="100%">
           <tbody><tr>
              <td>
                  <code>

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

              </td>
           </tr>
        </tbody></table>

        <br>

        <b>Stack Trace:</b> </font><br>

SimonASE
· 1
SimonASE
helpful
0
not helpful

Some clarification is needed now, just done more testing. This does not happen if you set a personal filter on a single project.

I get the error when I perform the following:

  1. Main gemini page, select "All Projects Issue Reporting"
  2. Set my filters according and click View
  3. Enter a name into the "Saved Filters" area and the error occurs
We have multiple projects hence why this may occur to us and not specifically everyone else - i'm trying to save a default set of filters for a global view of the projects

Regards

Simon


SimonASE
· 1
SimonASE
helpful
0
not helpful

Are you using an old 3.0 database? Please check that the column projectid allows nulls n the gemini_userissuesviews table.


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

Yes that column allows nulls - the db was upgraded from V2.2 through 3 beta then RC1, RC2 and final build


SimonASE
· 1
SimonASE
helpful
0
not helpful

Sorry, wrong table, it should be gemini_personalfilters


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

It didnt but it does now that i've set it and indeed it does fix the problem - thanks


SimonASE
· 1
SimonASE