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.




Application error after upgrading to 2.1.1

web-app

Hi, we are trying to upgrade 2.0.2 to 2.1.1. I ran these scripts (this order)

CREATEVIEWS.SQL
CREATEPROCS.SQL
InstallCommon.SQL
InstallProfile.SQL
Upgradev2-0.sql
Upgradev2-1.SQL

and some errors messages are in output:

InstallCommon:
---------------------------------------
(149 row(s) affected)
Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, informationschema, sys, or yourself.
Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, informationschema, sys, or yourself.

(1 row(s) affected)

(1 row(s) affected)
Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, informationschema, sys, or yourself.
Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, informationschema, sys, or yourself.
Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, informationschema, sys, or yourself.

InstallProfile:
---------------------------------------
Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, informationschema, sys, or yourself.

(1 row(s) affected)

(1 row(s) affected)
Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself.

Upgrade 2.0:
---------------------------------------

(1 row(s) affected)
Msg 2705, Level 16, State 4, Line 3
Column names in each table must be unique. Column name 'tstamp' in table 'projects' is specified more than once.
Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'tstamp' in table 'projectresource' is specified more than once.
Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'tstamp' in table 'versions' is specified more than once.
Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'tstamp' in table 'components' is specified more than once.
Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'tstamp' in table 'issues' is specified more than once.
Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'tstamp' in table 'issuecomments' is specified more than once.
Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'tstamp' in table 'issueattachments' is specified more than once.
Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'tstamp' in table 'users' is specified more than once.
Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'tstamp' in table 'userroles' is specified more than once.
Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'tstamp' in table 'usersettings' is specified more than once.
Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'tstamp' in table 'issuelinktypes' is specified more than once.
Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'tstamp' in table 'issuelinks' is specified more than once.
Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'tstamp' in table 'customfielddefs' is specified more than once.
Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'tstamp' in table 'customfielddata' is specified more than once.
Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'tstamp' in table 'personalfilters' is specified more than once.
Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'tstamp' in table 'securityschemes' is specified more than once.
Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'tstamp' in table 'sourcecontrolissuefiles' is specified more than once.
Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'tstamp' in table 'timetracking' is specified more than once.
Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'tstamp' in table 'projectrepository' is specified more than once.
Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'tstamp' in table 'issuetypelut' is specified more than once.
Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'tstamp' in table 'issueprioritylut' is specified more than once.
Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'tstamp' in table 'issuestatuslut' is specified more than once.
Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'tstamp' in table 'issuestatetransitionlut' is specified more than once.
Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'tstamp' in table 'issueresolutionlut' is specified more than once.
Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'tstamp' in table 'issuerisklevellut' is specified more than once.

(0 row(s) affected)
Msg 207, Level 16, State 1, Line 10
Invalid column name 'compid'.
Msg 207, Level 16, State 1, Line 11
Invalid column name 'fixedinverid'.
Msg 207, Level 16, State 1, Line 12
Invalid column name 'assignedto'.
Msg 207, Level 16, State 1, Line 13
Invalid column name 'isstype'.
Msg 207, Level 16, State 1, Line 14
Invalid column name 'isspriority'.
Msg 207, Level 16, State 1, Line 15
Invalid column name 'issstatus'.
Msg 207, Level 16, State 1, Line 16
Invalid column name 'issresolution'.
Msg 2705, Level 16, State 4, Line 3
Column names in each table must be unique. Column name 'comment' in table 'timetracking' is specified more than once.
Msg 2705, Level 16, State 4, Line 3
Column names in each table must be unique. Column name 'isclosing' in table 'issuecomments' is specified more than once.

(0 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

Upgrade 2.1:
---------------------------------------

(1 row(s) affected)
Msg 2705, Level 16, State 4, Line 3
Column names in each table must be unique. Column name 'resolveddate' in table 'issues' is specified more than once.
Msg 2705, Level 16, State 4, Line 3
Column names in each table must be unique. Column name 'rowid' in table 'projectresource' is specified more than once.
Msg 2705, Level 16, State 4, Line 2
Column names in each table must be unique. Column name 'rowid' in table 'issuestatetransitionlut' is specified more than once.

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(0 row(s) affected)



So, I have replace Gemini app files (except web.config). And there is the problem...How I have to do?

        <span><h1>Server Error in '/Gemini' Application.<hr color="silver" size="1" width="100%"></h1>

        <h2> <i>Parser Error</i> </h2></span>

        <font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif ">

        <b> Description: </b>An

error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately. 

        <b> Parser Error Message: </b>Could not load type 'CounterSoft.Gemini.Global'.<br><br>

        <b>Source Error:</b> <br><br>

        <table bgcolor="#ffffcc" width="100%">
           <tbody><tr>
              <td>
                  <code></code><pre><font color="red">Line 1:  &lt;%@ Application Codebehind="Global.asax.cs" Inherits="CounterSoft.Gemini.Global" %&gt;<br></font></pre>

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

        <br>

        <b> Source File: </b> c:\www\Gemini\global.asax<b> &nbsp;&nbsp; Line: </b> 1
        <br><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

        </font>

<!--

[HttpException]: Could not load type 'CounterSoft.Gemini.Global'. at System.Web.UI.TemplateParser.GetType(String typeName, Boolean ignoreCase) at System.Web.UI.TemplateParser.ProcessMainDirective(IDictionary mainDirective) at System.Web.UI.TemplateParser.ProcessDirective(String directiveName, IDictionary directive) at System.Web.UI.TemplateParser.ParseStringInternal(String text) at System.Web.UI.TemplateParser.ParseString(String text, String virtualPath, String basePhysicalDir) [HttpParseException]: Parser Error: Could not load type 'CounterSoft.Gemini.Global'. at System.Web.UI.TemplateParser.ParseString(String text, String virtualPath, String basePhysicalDir) at System.Web.UI.TemplateParser.ParseFile(String filename, String virtualPath) at System.Web.UI.TemplateParser.Parse() at System.Web.UI.TemplateParser.GetParserCacheItemThroughCompilation() at System.Web.UI.TemplateParser.GetParserCacheItemInternal(Boolean fCreateIfNotFound) at System.Web.UI.TemplateParser.GetParserCacheItemWithNewConfigPath() at System.Web.UI.TemplateParser.GetParserCacheItem() at System.Web.UI.ApplicationFileParser.GetCompiledApplicationType(String inputFile, HttpContext context, ApplicationFileParser& parser) at System.Web.HttpApplicationFactory.CompileApplication(HttpContext context) at System.Web.HttpApplicationFactory.Init(HttpContext context) at System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext context) at System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) -->
stepand76
· 504 		stepand76
Wednesday, April 25, 2007, 12:50:57 PM
Replies (9)
helpful
0
not helpful

You do not need to run the Upgrade 2.0 script.

The errors from the Install* scripts can be ignored.

Please make sure that Gemini runs under .NET 2.0.
Mark Wing
· 9108 		Mark Wing
Wednesday, April 25, 2007, 12:59:55 PM
helpful
0
not helpful

[quote user="MarkWing"]

You do not need to run the Upgrade 2.0 script.

The errors from the Install*** scripts can be ignored.

Please make sure that Gemini runs under .NET 2.0.

[/quote]

Switched to .NET 2.0 and this error ocurred:

Server Error in '/Gemini' Application.

Parser Error

Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately.

Parser Error Message: Unknown server tag 'gem:ExternalHeader'.

Source Error: 

Line 9:  <body>
Line 10:     <form id="frmMain" runat="server" autocomplete="off">
Line 11:         <p><gem:ExternalHeader id="Header1" runat="server"></gem:ExternalHeader></p>
Line 12:         <P>&nbsp;</P>
Line 13:         <P>&nbsp;</P>

Source File: /Gemini/MasterPages/ExternalMaster.Master    Line: 11

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727
stepand76
· 504 		stepand76
Wednesday, April 25, 2007, 1:40:07 PM
helpful
0
not helpful

Are you using the old web.config file?
Mark Wing
· 9108 		Mark Wing
Wednesday, April 25, 2007, 1:40:51 PM
helpful
0
not helpful

[quote user="MarkWing"]Are you using the old web.config file?[/quote]

Yes. If I try to use the new (default) then gemini main page is shown correctly, but for example issue list in a project show the Gemini application error:

Cannot open database "GEMINIASPNETDB" requested by the login. The login failed. Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.25/04/2007 13:51:30 SOURCE: .Net SqlClient Data Provider TARGETSITE: System.Data.ProviderBase.DbConnectionInternal GetConnection(System.Data.Common.DbConnection) STACKTRACE: at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) at System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) at System.Web.Profile.SqlProfileProvider.GetPropertyValuesFromDatabase(String userName, SettingsPropertyValueCollection svc) at System.Web.Profile.SqlProfileProvider.GetPropertyValues(SettingsContext sc, SettingsPropertyCollection properties)   SendToHome() invoked25/04/2007 13:51:08   Cannot open database "GEMINIASPNETDB" requested by the login. The login failed. Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.25/04/2007 13:51:05 SOURCE: .Net SqlClient Data Provider TARGETSITE: System.Data.ProviderBase.DbConnectionInternal GetConnection(System.Data.Common.DbConnection) STACKTRACE: at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) at System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) at System.Web.Profile.SqlProfileProvider.GetPropertyValuesFromDatabase(String userName, SettingsPropertyValueCollection svc) at System.Web.Profile.SqlProfileProvider.GetPropertyValues(SettingsContext sc, SettingsPropertyCollection properties)   Path '/gemini/web.config' is forbidden.25/04/2007 13:48:02 SOURCE: System.Web TARGETSITE: Void ProcessRequest(System.Web.HttpContext) STACKTRACE: at System.Web.HttpForbiddenHandler.ProcessRequest(HttpContext context) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)  Cannot open database "GEMINIASPNETDB" requested by the login. The login failed. Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.25/04/2007 13:46:57 SOURCE: .Net SqlClient Data Provider TARGETSITE: System.Data.ProviderBase.DbConnectionInternal GetConnection(System.Data.Common.DbConnection) STACKTRACE: at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) at System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) at System.Web.Profile.SqlProfileProvider.GetPropertyValuesFromDatabase(String userName, SettingsPropertyValueCollection svc) at System.Web.Profile.SqlProfileProvider.GetPropertyValues(SettingsContext sc, SettingsPropertyCollection properties)   Cannot open database "GEMINIASPNETDB" requested by the login. The login failed. Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.25/04/2007 13:33:16 SOURCE: .Net SqlClient Data Provider TARGETSITE: System.Data.ProviderBase.DbConnectionInternal GetConnection(System.Data.Common.DbConnection) STACKTRACE: at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) at System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) at System.Web.Profile.SqlProfileProvider.GetPropertyValuesFromDatabase(String userName, SettingsPropertyValueCollection svc) at System.Web.Profile.SqlProfileProvider.GetPropertyValues(SettingsContext sc, SettingsPropertyCollection properties)   Cannot open database "GEMINIASPNETDB" requested by the login. The login failed. Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.25/04/2007 13:32:57 SOURCE: .Net SqlClient Data Provider TARGETSITE: System.Data.ProviderBase.DbConnectionInternal GetConnection(System.Data.Common.DbConnection) STACKTRACE: at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) at System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) at System.Web.Profile.SqlProfileProvider.GetPropertyValuesFromDatabase(String userName, SettingsPropertyValueCollection svc) at System.Web.Profile.SqlProfileProvider.GetPropertyValues(SettingsContext sc, SettingsPropertyCollection properties)   Cannot open database "GEMINIASPNETDB" requested by the login. The login failed. Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.25/04/2007 13:32:51 SOURCE: .Net SqlClient Data Provider TARGETSITE: System.Data.ProviderBase.DbConnectionInternal GetConnection(System.Data.Common.DbConnection) STACKTRACE: at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) at System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) at System.Web.Profile.SqlProfileProvider.GetPropertyValuesFromDatabase(String userName, SettingsPropertyValueCollection svc) at System.Web.Profile.SqlProfileProvider.GetPropertyValues(SettingsContext sc, SettingsPropertyCollection properties)   SendToHome() invoked25/04/2007 13:32:48   Cannot open database "GEMINIASPNETDB" requested by the login. The login failed. Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.25/04/2007 13:32:47 SOURCE: .Net SqlClient Data Provider TARGETSITE: System.Data.ProviderBase.DbConnectionInternal GetConnection(System.Data.Common.DbConnection) STACKTRACE: at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) at System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) at System.Web.Profile.SqlProfileProvider.GetPropertyValuesFromDatabase(String userName, SettingsPropertyValueCollection svc) at System.Web.Profile.SqlProfileProvider.GetPropertyValues(SettingsContext sc, SettingsPropertyCollection properties)   SendToHome() invoked25/04/2007 13:32:39   Cannot open database "GEMINIASPNETDB" requested by the login. The login failed. Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.25/04/2007 13:32:36 SOURCE: .Net SqlClient Data Provider TARGETSITE: System.Data.ProviderBase.DbConnectionInternal GetConnection(System.Data.Common.DbConnection) STACKTRACE: at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) at System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) at System.Web.Profile.SqlProfileProvider.GetPropertyValuesFromDatabase(String userName, SettingsPropertyValueCollection svc) at System.Web.Profile.SqlProfileProvider.GetPropertyValues(SettingsContext sc, SettingsPropertyCollection properties)
stepand76
· 504 		stepand76
Wednesday, April 25, 2007, 1:53:45 PM
helpful
0
not helpful

Please make sure that you have set the connection string for the profile database in the new web.config file.
Mark Wing
· 9108 		Mark Wing
Wednesday, April 25, 2007, 2:09:55 PM
helpful
0
not helpful

[quote user="MarkWing"]Please make sure that you have set the connection string for the profile database in the new web.config file.[/quote]

Thanks. Problem was the gemini_aspnetdb database wasn't exists. I've created it manually. Seems to it works. Thank you.
I noticed little problem in mails from gemini. The link to the issue in message is link to localhost:

http://localhost/gemini/Default.aspx?p=3&i=494

Where I have to setup the host name?
stepand76
· 504 		stepand76
Wednesday, April 25, 2007, 3:10:50 PM
helpful
0
not helpful

In the Administration -> General - section within the Gemini web app (when logged is as admin).
Mark Wing
· 9108 		Mark Wing
Wednesday, April 25, 2007, 3:18:43 PM
helpful
0
not helpful

[quote user="MarkWing"]In the Administration -> General - section within the Gemini web app (when logged is as admin).[/quote]

My settings:

Full Gemini URL: "http://airforceone/gemini/"

but still receiving localhost links to issues
stepand76
· 504 		stepand76
Wednesday, April 25, 2007, 3:44:06 PM
helpful
0
not helpful

Try and reboot the web app.
Saar Cohen
· 5000 		Saar Cohen
Thursday, April 26, 2007, 10:09:50 PM