Error Installing 2.1
After upgrading 2.0.5 to 2.1 using the EXE, when I navigate to the Website I get the following error:
Server Error in '/' Application.
Could not find stored procedure 'geminigetuserid'.
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: Could not find stored procedure 'geminigetuserid'.
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: Could not find stored procedure 'geminigetuserid'.]
Gemini.Default.2d89ab686c6ce5fb(String 01977eb99b48e8da) +738
Gemini.Default.PageLoad(Object sender, EventArgs e) +448
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573
TekkGuy
· 1 |
|
Thursday, March 29, 2007, 4:39:37 PM |
0
|
It seems like website upgrade did not work. Did you specify a different name for website? |
||||
|
0
|
I uninstalled, restored to my 2.0.5 settings and then re-installed 2.1, this time using a blank as the Virtual Directory name.... It looked like it installed properly now but....now I get this: Server Error in '/' Application.Login failed for user 'GEMINI\ASPNET'.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. [ADOException: cannot open connection] CounterSoft.Gemini.DataProvider.BaseProvider.xdd71a6c437ce97cd(Type x86c43ef36e14f2a3, Object[] xdbd7e0681bb13f72) +465 CounterSoft.Gemini.DataProvider.BaseProvider.xc5a6238415274e6d(Type x86c43ef36e14f2a3, Object[] xdbd7e0681bb13f72) +14 CounterSoft.Gemini.DataProvider.ApplicationSettingsProvider.x1a95834709519378(String x2335cd6458013014) +89 CounterSoft.Gemini.Business.DatabaseApplicationSettings.Initialise() +1669 CounterSoft.Gemini.Business.DatabaseApplicationSettings..ctor() +48 CounterSoft.Gemini.Business.Initialiser..cctor() +20 [TypeInitializationException: The type initializer for 'Initialiser' threw an exception.] CounterSoft.Gemini.Business.DatabaseApplicationSettings.get_GetInstance() +14 CounterSoft.Gemini.Business.ApplicationSettingsFactory.GetAppSettings() +5 CounterSoft.Gemini.Business.ApplicationSettings..cctor() +5 [TypeInitializationException: The type initializer for 'CounterSoft.Gemini.Business.ApplicationSettings' threw an exception.]
CounterSoft.Gemini.Business.ApplicationSettings.getShowUserRegistrationLink() +0
CounterSoft.Gemini.Default.PageLoad(Object sender, EventArgs e) +255
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +34
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210 |
||||
|
0
|
Ben, Silly question, but is your new web.config configured with the correct database connection strings? Remember, that from 2.1 there are two places where you need to update connection strings. |
||||
|
0
|
I didn't make any changes to the connection string. I was under the impression that the Auto-Installer was supposed to take care of all of that? |
||||
|
0
|
Yes, it should have done. Did it not amend the web.config file? |
||||
|
0
|
I see 3 Places in the WebConfig... <add key="hibernate.connection.connectionstring" value="data source=Gemini;initial catalog=Gemini;TrustedConnection=true"/> <add name="ProfilesServer" connectionString="data source=Gemini;initial catalog=GEMINIASPNETDB;TrustedConnection=true" providerName="System.Data.SqlClient"/> <sessionState mode="InProc" stateConnectionString="tcpip=127.0.0.1:42424" sqlConnectionString="data source=127.0.0.1;user id=sa;password=sa" cookieless="false" timeout="60"/> The 1st looks fine, the second is strange because there is no GEMINI_ASPNETDB database in my SQL Server, and the third I am not sure what it should be pointing at. |
||||
|
0
|
Ok, the problem is that you are using trusted connection, but ASP.NET does not have access to the database. Add ASP.NET as a trusted user to SQL or are you using identity impresonate = true? |
||||
|
0
|
Oooo I can't win. LOL I added the Local ASP.NET Username to the list of Logins on the SQL Server. Now I get a different error... Server Error in '/' Application.SELECT permission denied on object 'geminiappsettings', database 'Gemini', owner 'dbo'.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. [ADOException: could not execute query[SQL: SELECT this.settingid as settingid340, this.settingname as settingn2340, this.settingcategory as settingc3340, this.settingvalue as settingv4340, this.settingdesc as settingd5340, this.tstamp as tstamp340 FROM geminiappsettings this_ WHERE this_.settingname = ?]] CounterSoft.Gemini.DataProvider.BaseProvider.xdd71a6c437ce97cd(Type x86c43ef36e14f2a3, Object[] xdbd7e0681bb13f72) +465 CounterSoft.Gemini.DataProvider.BaseProvider.xc5a6238415274e6d(Type x86c43ef36e14f2a3, Object[] xdbd7e0681bb13f72) +14 CounterSoft.Gemini.DataProvider.ApplicationSettingsProvider.x1a95834709519378(String x2335cd6458013014) +89 CounterSoft.Gemini.Business.DatabaseApplicationSettings.Initialise() +1669 CounterSoft.Gemini.Business.DatabaseApplicationSettings..ctor() +48 CounterSoft.Gemini.Business.Initialiser..cctor() +20 [TypeInitializationException: The type initializer for 'Initialiser' threw an exception.] CounterSoft.Gemini.Business.DatabaseApplicationSettings.get_GetInstance() +14 CounterSoft.Gemini.Business.ApplicationSettingsFactory.GetAppSettings() +5 CounterSoft.Gemini.Business.ApplicationSettings..cctor() +5 [TypeInitializationException: The type initializer for 'CounterSoft.Gemini.Business.ApplicationSettings' threw an exception.] CounterSoft.Gemini.Business.ApplicationSettings.getShowUserRegistrationLink() +0 CounterSoft.Gemini.Default.PageLoad(Object sender, EventArgs e) +255 System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +34 System.Web.UI.Control.OnLoad(EventArgs e) +99 System.Web.UI.Control.LoadRecursive() +47 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061 Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210 |
||||
|
0
|
That is because the SQL user (ASP.NET) does not have permission on the database. The easiest thing to do is to give it db_owner permission. |
||||
|
0
|
Nope that is not the case. I already set ASP.NET to have db-owner permissions. |
||||
|
0
|
Are you sure it has db_owner on the Gemini database? The error states the it does not have permissions. |
||||
|
0
|
Try rebooting the web app. |
||||
|
0
|
By rebooting you mean Stopping and then Starting the Website through IIS? If so, I already tried that. |
||||
|
0
|
I mean restart the application pool that Gemini uses or save the web.config file. |
||||
|
0
|
Ok, I restarted the IIS Server, and now it seems to be working....but now I have a Licensing problem...
Who do I contact to get my License fixed? |
||||
|
0
|
Ok, I restarted IIS Server and now all seems to be working....so far. I am now having an issue with my License, who do I contact to get my License fixed? --------------- Oops, excuse the double post, I didn't realize it went to a page 2. :-) Tried to delete this post...wouldn't let me. |
||||
|
0
|
What is the issue with the license? Please send details to support@countersoft.com including the license key. |
||||
|
0
|
I am getting the same error. What was the resolution to this? |
||||
|
0
|
What errors do you get? |
||||
|