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.




v2.0.2 to v2.0.3 Upgrade Error

web-app

Hello,

I followed the steps provided in the PDF doc (install new app using MSI and run Create_Procs.sql) and everything went fine.  However I get the following error when I try to access our Gemini site:

Invalid object name 'issueprioritylut'.

        <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: Invalid object name 'issueprioritylut'.<br><br>

        <b>Source Error:</b> <br></font><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> <br><br>

        <table bgcolor="#ffffcc" width="100%">
           <tbody><tr>
              <td>
                  <code></code><pre>[SqlException: Invalid object name 'issueprioritylut'.]<br>   CounterSoft.GeminiLib.GeminiHelper.GetImageData(String sql) +307<br>   CounterSoft.GeminiLib.GeminiHelper.GetIssuePriorityImages() +11<br>   Gemini.PageUtil.FillCache(HttpContext c) +69<br>   Gemini.GeminiHttpModule.Init(HttpApplication application) +191<br>   System.Web.HttpApplication.InitModules() +100<br>   System.Web.HttpApplication.InitInternal(HttpContext context, HttpApplicationState state, MethodInfo[] handlers) +1330<br>   System.Web.HttpApplicationFactory.GetNormalApplicationInstance(HttpContext context) +392<br>   System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext context) +256<br>   System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +414<br></pre>

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

        <br>

        <hr color="silver" size="1" width="100%">

        <b>Version Information:</b>&nbsp;Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET Version:1.1.4322.2300<br>
mvanbergen
· 1
mvanbergen
Replies (3)
helpful
0
not helpful

Did you amend the web.config file connection string to be the same as your 2.0.2 one?

Does the table exists in the database? Who is its owner?


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Sorry, this was my fault.  I did not notice that the username for the DB connect string defaulted back to "sa" after the upgrade.  I changed it to the "Gemini" user and all is well now.


mvanbergen
· 1
mvanbergen
helpful
0
not helpful

I have this error as well. How did you solve it?


Jelle Ossewaarde
· 1
Jelle Ossewaarde