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.




Can't View ANY Issues After 2.2 Upgrade!!

web-app

the section of the error below that says I have an error in web.config is set to:
  <connectionStrings>
          <add name="ProfilesServer" connectionstring="data source=(local);initial catalog=Gemini;user id=myusernam;password=mypassword" />
  </connectionStrings>

Also note, I had to view source of the page to copy the log data, I could not select text on the page, maybe a bug??

ERROR:
Unrecognized attribute 'connectionstring'. Note that attribute names are case-sensitive. (C:\Inetpub\Projects\Gemini Web Application\web.config line 29)</td><td>28/07/2007 03:49:46</td><td>
SOURCE: System.Web
TARGETSITE: Void InitializeStatic()
STACKTRACE: at System.Web.Profile.ProfileBase.InitializeStatic()
at System.Web.Profile.ProfileBase.Create(String username, Boolean isAuthenticated)
at System.Web.HttpContext.getProfile()
at CounterSoft.Gemini.Business.BasePage.Profile.getMaxIssuesPerPage()
at CounterSoft.Gemini.IssuesWeb.Page_Load(Object sender, EventArgs e)
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at CounterSoft.Gemini.Business.BasePage.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
pauldes
· 1 		pauldes
Saturday, July 28, 2007, 11:00:07 AM
Replies (9)
helpful
0
not helpful

Also of note, my aspnetusers table has NO data in it. the Install* SPROCS ran when I upgraded but had some strange results as follows:

INSTALLCOMMON
(159 row(s) affected)
Cannot grant, deny, or revoke permissions to sa, dbo, informationschema, sys, or yourself.
Cannot grant, deny, or revoke permissions to sa, dbo, informationschema, sys, or yourself.

(0 row(s) affected)

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

INSTALLPROFILE
Cannot grant, deny, or revoke permissions to sa, dbo, informationschema, sys, or yourself.

(0 row(s) affected)

(1 row(s) affected)
Cannot grant, deny, or revoke permissions to sa, dbo, informationschema, sys, or yourself.
pauldes
· 1 		pauldes
Saturday, July 28, 2007, 11:11:13 AM
helpful
0
not helpful

Also, I ran these 4 steps first, without incident....

1
Execute “UPGRADEv2-1.sql” in Gemini Issues Database (core component #2)
2
Execute “UPGRADEv2-2.sql” in Gemini Issues Database (core component #2)
3
Execute “CREATEVIEWS.sql” in Gemini Issues Database (core component #2)
4
Execute “CREATEPROCS.sql” in Gemini Issues Database (core component #2)
pauldes
· 1 		pauldes
Saturday, July 28, 2007, 11:19:19 AM
helpful
0
not helpful

And just to make sure you have all info possible... :)

I now have 4 aspnet tables, applications, profile, schemaversions and users. All with no data in them.
pauldes
· 1 		pauldes
Saturday, July 28, 2007, 11:21:38 AM
helpful
0
not helpful

and, I have restarted IIS....
pauldes
· 1 		pauldes
Saturday, July 28, 2007, 11:35:30 AM
helpful
0
not helpful

Hello,

I think your connection string is not correct. See here:

 

  <connectionStrings>
    <add name="ProfilesServer" connectionString="data source=localhost;initial catalog=Gemini;user id=sa;password=sa" providerName="System.Data.SqlClient"/>
  </connectionStrings>
Harvey Kandola
· 212 		Harvey Kandola
Saturday, July 28, 2007, 11:49:03 AM
helpful
0
not helpful

I still get the same unrecognized attribute "connectionstring" error. I've amended the profilesserver name to read

  <connectionStrings>
          <add name="ProfilesServer" connectionstring="data source=localhost;initial catalog=Gemini;userid=xxxxx;password=xxxxx" providerName="System.Data.SqlClient"/>
  </connectionStrings>
pauldes
· 1 		pauldes
Saturday, July 28, 2007, 1:55:00 PM
helpful
0
not helpful

You need upper case S:

  <connectionStrings>
          <add name="ProfilesServer" connectionString="data source=localhost;initial catalog=Gemini;userid=xxxxx;password=xxxxx" providerName="System.Data.SqlClient"/>
  </connectionStrings>
Saar Cohen
· 5000 		Saar Cohen
Saturday, July 28, 2007, 2:51:24 PM
helpful
0
not helpful

OK, made the correction as indicated, restarted IIS completely, now I have "userid" keyword not supported...

The doc does not contain the full <add name= node as it should be constructed. Could you check a working web.config and paste the string here so I can get the correct case syntax?

Thanks
pauldes
· 1 		pauldes
Saturday, July 28, 2007, 5:00:34 PM
helpful
0
not helpful

GOT IT!!
"user id" not "userid"

Thanks
pauldes
· 1 		pauldes
Saturday, July 28, 2007, 5:05:31 PM