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.




'issueprioritylut' error right after install

web-app

Hi everyone, I've been wanting to try your software, it looks very nice judging from the screens and features.

Anyway, I've manually set up the DB, IIS site, and general configurations; but get the error below before I even see a log-in screen.

I am on Windows XP Pro and use SQLExpress2005 as my DB.  I believe my user permissions and connection string are OK, condsidering I don't see any "access denied" or "cannot locate server" messages.  I see the 'issueprioritylut' table existing in the DB, and I can open/edit it from SQL, with the user I specified in web.config.

I have a side by side install of the .NET Framework, both 1.1 and 2.0.  If you browse the the ASP.NET tab in IIS, I have selected the 1.1 version, hopefully that shouldn't cause any problems.

Also, I'm not sure how to verify that my SQL server is case insensitive, is this important?

Anyway, If anyone can point me in the right direction on this one, it would be much appriciated.

Server Error in '/Gemini' Application.

Invalid object name 'issueprioritylut'.

Description: 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.

Exception Details: System.Data.SqlClient.SqlException: Invalid object name 'issueprioritylut'.

Source Error:

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.
Stack Trace:

[SqlException: Invalid object name 'issueprioritylut'.]
   CounterSoft.GeminiLib.GeminiHelper.GetImageData(String sql) +307
   CounterSoft.GeminiLib.GeminiHelper.GetIssuePriorityImages() +11
   Gemini.PageUtil.FillCache(HttpContext c) +66
   Gemini.GeminiHttpModule.Init(HttpApplication application) +184
   System.Web.HttpApplication.InitModules() +100
   System.Web.HttpApplication.InitInternal(HttpContext context, HttpApplicationState state, MethodInfo[] handlers) +1295
   System.Web.HttpApplicationFactory.GetNormalApplicationInstance(HttpContext context) +392
   System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext context) +256
   System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +414

Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573

mlayton
· 1
mlayton
Replies (4)
helpful
0
not helpful

Seems like your database is case sensative. If you open managment studio and click properties on your database you will see the "Collation" property (under General).

If it has _CS_* then it is case sensative.


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

Under database collation, my gemini database reads "SQLLatin1GeneralCP1CI_AS".

I take it the 'CI' means case insensitive.  It looks like my system DBs are case insensitive as well.


mlayton
· 1
mlayton
helpful
0
not helpful

Oh, I see you are so close to releasing the new version, maybe I will just check that out instead. 

Would you reccommend waiting for the stable release before doing any serious customizations?  Or is upgrading from the beta to the real release going to be no problem in any configuration?


mlayton
· 1
mlayton
helpful
0
not helpful

Suggest you wait for the final release. It should be out within the next few days.


Saar Cohen
· 5000
Saar Cohen