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.




2.2.7 --> 3.1.1 Invalid object name 'users'

web-app

Hi,

we are migrating our Gemini from 2.2.7 to 3.1.1 but we get the following error:

Invalid object name 'users'.

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: Ungültiger Objektname 'users'.

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 'users'.]
   CounterSoft.Gemini.DataProvider.x4f26f7a726757349.xd8280387c605aca4(CustomFieldEN x5a09e7cd54476202, Int32 xb378eaa6f96e5474) +768
   CounterSoft.Gemini.DataProvider.x4f26f7a726757349.xd8280387c605aca4(CustomFieldEN x5a09e7cd54476202) +7
   CounterSoft.Gemini.Business.xa07794653f9cfd6c.xdb93551b54005149() +118
   CounterSoft.Gemini.Workload.RenderHTMLView() +1466
   CounterSoft.Gemini.Workload.BindData() +48
   CounterSoft.Gemini.Workload.Page_Load(Object sender, EventArgs e) +103
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +33
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +47
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1436

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

AmaIT
· 1
AmaIT
Replies (8)
helpful
0
not helpful

Seem like you are accesssing the wrong site (2.2.7).

Note that by default the installer will install to a different directory, please double check IIS.


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

We are accessing the 3.1.1 site.

The database migrated correct and we use the correct web application.

The error comes there:

/user/Workload.aspx
/issue/ViewIssue.aspx

We have executed the following scripts:

CreateTables.sql
Create
Views.sql
CreateProcs.sql

Upgradev3-0-Step1.sql
Upgradev3-0-Step2.sql
Upgrade
v3-0-Step3Optional.sql

Upgradev3-0-1.sql
Upgrade_v3-1.sql


AmaIT
· 1
AmaIT
helpful
0
not helpful

How did you upgrade the web app? Did you just copy the new files on top of the old ones?

The users table is not accessed by 3.x, its gemini_users now.


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

I created a new Folder with the Files from the zip and configured it in IIS


AmaIT
· 1
AmaIT
helpful
0
not helpful

Did you configure the Full gemini url setting to point to the new site?


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Yes we did


AmaIT
· 1
AmaIT
helpful
0
not helpful

Now we have installed Gemini on an other Server an we have the same problem. Is the Serverinformation in any databasetable? Because the source System of the Database is also running, only on an other host.

Has anyone a solution to this problem?

 

 


AmaIT
· 1
AmaIT
helpful
0
not helpful

Please double-check the database connection string in the web.config file.


Harvey Kandola
· 212
Harvey Kandola