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.




Post Sharepoint WSS 3.0 Install Problem - Gemini Half Works

web-app

Environment: Windows 2003 Server, IIS 6.0, SQL Server 2005

When attempting to run under the default site created by the Sharepoint Services 3.0 install, I couldn't get the page to server up. I had the site running previously under it's own default website which the Sharepoint installation disabled. I expected problems, and new I would have to do some modifications to get an ASP.NET application to run under the new wss website. I modified the web.config file of Gemini (as recommended by CounterSoft/Microsoft) and had to also add the anonymous user [server]IUSR to the database (strange had to do so). Everything appeared to work fine. I was able to log in, click in a project, but ran into an error when clicking to display the issues within the project. I received the following error:

-----------------------------------------------------------------------------------------
SOURCE: CounterSoft.Gemini.Business TARGETSITE: Int32 get
MaxIssuesPerPage() STACKTRACE: at CounterSoft.Gemini.Business.BasePage.Profile.getMaxIssuesPerPage() at CounterSoft.Gemini.IssuesWeb.PageLoad(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) 
-----------------------------------------------------------------------------------------

Is there anything else I need to add to the web.config file to get this to work?

 

Jake
· 1
Jake
Replies (16)
helpful
0
not helpful

Seems like you are missing the profile database. Please check the web.config for the profile connection string and that the database exist and setup.


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

Thanks for the quick reply. Would the profiles database be a separate database or in the same database as Gemini? IssueTracker is my Gemini database. Here is what I have in the web.config file:

<add name="ProfilesServer" connectionString="data source=Athos\SQL2K5;initial catalog=IssueTracker;Trusted_Connection=true" providerName="System.Data.SqlClient"/>

<anonymousIdentification enabled="true" />
<profile defaultProvider="SqlProvider">
     <providers>
        <clear />
        <add name="SqlProvider"
                type="System.Web.Profile.SqlProfileProvider"
                connectionStringName="ProfilesServer"
                applicationName="Gemini"
                description="SqlProfileProvider for Gemini" />
</providers>


Jake
· 1
Jake
helpful
0
not helpful

Some additional info...I added the following entries to the web.config file:

httpHandlers...
<add verb="" path=".aspx" type="System.Web.UI.PageHandlerFactory, System.Web, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />


after httpHandlers...
<trust level="Full" originUrl="" />

under httpModules...
<add name="Session" type="System.Web.SessionState.SessionStateModule"/>
<add name="FormsAuthentication" type="System.Web.Security.FormsAuthenticationModule"/>
<add name="PassportAuthentication" type="System.Web.Security.PassportAuthenticationModule"/>
<add name="UrlAuthorization" type="System.Web.Security.UrlAuthorizationModule"/>
<add name="FileAuthorization" type="System.Web.Security.FileAuthorizationModule"/>


Modified (but also tried as validateRequest=true)...
<pages validateRequest="false" enableSessionState="true" enableViewState="true" enableViewStateMac="true" enableEventValidation="false">


Jake
· 1
Jake
helpful
0
not helpful

The profile database can be within the Gemini database. Did you run InstallCommon.sql and InstallProfile.sql in the Gemini database?


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

Yes, all of the tables/stored procs exist. Again, the original installation was working fine, then tried to move as a virtual directory/application under a Sharepoint website. It was weird that I had to add the {server}IUSR to SQL Server because it wasn't in there before and it was working fine. We have been using the profiles in Gemini and there are entries in the aspnetProfile table.


Jake
· 1
Jake
helpful
0
not helpful

Can you send the complete error?

Also, check that the user can "see" the profile tables. If you moved from one machine to another this will change as you are using trusted connection.


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

I can see the tables in SQL Server management studio. Also, this is on the same machine. The only thing that is different is running under a non-Sharepoint site vs. Sharepoint website in IIS.

Server Error in '/IssueTracker' Application.

Object reference not set to an instance of an object.

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.NullReferenceException: Object reference not set to an instance of an object.

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:

[NullReferenceException: Object reference not set to an instance of an object.]
   CounterSoft.Gemini.Business.Profile.getMaxIssuesPerPage() +56
   CounterSoft.Gemini.IssuesWeb.PageLoad(Object sender, EventArgs e) +8601
   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
   CounterSoft.Gemini.Business.BasePage.OnLoad(EventArgs e) +4
   System.Web.UI.Control.LoadRecursive() +47
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061


Jake
· 1
Jake
helpful
0
not helpful

Any thoughts on what could be the problem?  -Jake


Jake
· 1
Jake
helpful
0
not helpful

This seems like an issue with the profile provider (ASP.NET profile provider) and share point.

I could not find anything on the web, but you might want to check your sharepoint config for this.


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

I've researched and tried everything I could think of on the WSS 3.0 side, and no luck. There is a problem with the Issues.aspx page, but I can't debug it. This is the ONLY page that is having a problem. I get the following:

Object reference not set to an instance of an object.

on any url using Issues.aspx:
http://myintraspek.com/issuetracker/Issues.aspx?m=1&PROJID=3

http://myintraspek.com/issuetracker/Issues.aspx?m=1&c=6&v=1

http://myintraspek.com/issuetracker/Issues.aspx?m=1&c=5&v=2

and others.

Why would all of the other pages work on the Gemini site, but not the Issues.aspx page???

 


Jake
· 1
Jake
helpful
0
not helpful

Hi,

 

I'm suffering the same issue.

if Gemini runs under a virtual folder where WSS 3.0 orMOSS is installed, the access to the user profile properties failed.

if Gemini is in his own virtual server, then everything works fine.

not sure if its really related to Gemini or a problem in the profile system, but it's certainly possible to handle the error and return a fixed value.


willgart
· 1
willgart
helpful
0
not helpful

We understand your frustrations and are working on a fix for this for 3.0.

This, as you've said, is an ASP.NET profile issue (although we could return default values).


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Hi,

I am having the same issue. Did you find out a way to fix this ?

Best regards,

Etienne


Plumest
· 1
Plumest
helpful
0
not helpful

Which version of Gemini are you running?


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

It's the 2.2.6.

 


Plumest
· 1
Plumest
helpful
0
not helpful

I would strongly recommend that you move up to release 3.0 and then try running under MOSS/WSS.  The ASPNET Profile DB has been dropped in this release and we have introduced AJAX support.  These are all things that may affect how your get Gemini to run under MOSS/WSS.

 


Harvey Kandola
· 212
Harvey Kandola