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.




I have moved my instance to other hosting party, but now it does not work...

web-app

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 (0x80131904): Invalid object name 'issueprioritylut'.]
   CounterSoft.GeminiLib.GeminiHelper.GetImageData(String sql) +280
   CounterSoft.GeminiLib.GeminiHelper.GetIssuePriorityImages() +11
   Gemini.PageUtil.FillCache(HttpContext c) +66
   Gemini.GeminiHttpModule.Init(HttpApplication application) +254
   System.Web.HttpApplication.InitModules() +267
   System.Web.HttpApplication.InitInternal(HttpContext context, HttpApplicationState state, MethodInfo[] handlers) +1251
   System.Web.HttpApplicationFactory.GetNormalApplicationInstance(HttpContext context) +243
   System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext context) +106
   System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +214

 

I get the above error. I moved my complete webfiles and my database to a new hosting party. Also I changed the web.config to the new connection string. I am able to login on the database and I have verified if there where no duplicate entries. It is not clear why this error appears...the only thing that might be different is that I am on a virtual directory?
Jelle Ossewaarde
· 1 		Jelle Ossewaarde
Thursday, September 14, 2006, 3:13:28 PM
Replies (10)
helpful
0
not helpful

It is probably to do with the user in sql.

If you have moved your database it might be that your tables belong to user X but now you access the database with user Y....
Mark Wing
· 9108 		Mark Wing
Friday, September 15, 2006, 10:17:39 AM
helpful
0
not helpful

I have same user with slight different password that is db owner. However, the initial database was created with sa as db owner (or that is the one that holds the ownership). Now it is a different user. So what to do about it?
Jelle Ossewaarde
· 1 		Jelle Ossewaarde
Tuesday, September 19, 2006, 4:00:58 PM
helpful
0
not helpful

When you log in to SQL, run SP_WHO2.

Who is the owner of the Gemini tables?
Saar Cohen
· 5000 		Saar Cohen
Tuesday, September 19, 2006, 9:36:52 PM
helpful
0
not helpful

I get the next result where <login> is the same login as in my web.config. It is (except for the password), the same user as on the other installation.

53    RUNNABLE                       <login>  V4A002   .   V4ACASETOOL SELECT INTO 31 6 09/20 14:40:39  53    0   

Might collation have to do with it? I have nowSQLLatin1GeneralCP1CIAS instead of Latin1GeneralCP1CIAS. The other database was 2000 and this one is 2005?
Jelle Ossewaarde
· 1 		Jelle Ossewaarde
Wednesday, September 20, 2006, 11:42:30 PM
helpful
0
not helpful

Opps, sorry i meant run sp_help.
Saar Cohen
· 5000 		Saar Cohen
Thursday, September 21, 2006, 12:06:01 AM
helpful
0
not helpful

All Gemini tables, sp etc. belong to the same user as my web.config user. (390 lines returned with this user). Other lines like dtproperties belong to dbo and from Checkcontraints to INFORMATIONSCHEMA, all_columns to sys
Jelle Ossewaarde
· 1 		Jelle Ossewaarde
Thursday, September 21, 2006, 5:02:04 PM
helpful
0
not helpful

Try login with the same user as Gemini and run:

select * from issueprioritylut

does it work?
Mark Wing
· 9108 		Mark Wing
Thursday, September 21, 2006, 6:09:22 PM
helpful
0
not helpful

select * from <username>.issueprioritylut works, the select * from issueprioritylut not: invalid object name 'issueprioritylut'. It seems all my tables have an objectqualifier with the username in front. Same for my stored procedures. Strange that it works on the first hosting party and here not?
Jelle Ossewaarde
· 1 		Jelle Ossewaarde
Thursday, September 21, 2006, 11:42:17 PM
helpful
0
not helpful

Use sp_changeobjectowner to change the owner of the Gemini objects to dbo.
Mark Wing
· 9108 		Mark Wing
Friday, September 22, 2006, 10:00:05 AM
helpful
0
not helpful

Hi Mark,


This works. However using this statement would rather be tedious. I found the next on the internet. The script generates all statements for you (about 218). Copy these statements to another query window and execute. Please take case to make a copy in case things might work out differently!

Thank for your help

Jelle

SELECT 'EXEC(''sp_changeobjectowner @objname = '''''+

ltrim(u.name) + '.' + ltrim(s.name) + '''''' + ', @newowner = dbo'')'

FROM sysobjects s, sysusers u WHERE s.uid = u.uid

AND u.name <> 'dbo' AND xtype in ('V', 'P', 'U') AND

u.name not like 'INFORMATION%'order by s.name

 
Jelle Ossewaarde
· 1 		Jelle Ossewaarde
Friday, September 22, 2006, 11:37:21 AM