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.




Web Service Gemini Generates Error

web-app

I tried installing Gemini when i view any issue it generates the following Error:

Object reference not set to an instance of an object.   
at CounterSoft.GeminiBiz.TimeTrackingBiz.GetIssueTotalTimeLogged(Int32 issueID) at Gemini.ViewIssue.BindData()

Please can anyone provide solution for that.


Rupinder
· 1
Rupinder
Replies (11)
helpful
0
not helpful

I presume you are talking about the website here, not a web service call.

Is this a fresh install or an upgrade? How did you install (MSI)?

Does this error occur for every issue?


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Hi,
its me Rupinder i created new UserName

Let me explain you from start First of all i downloaded Geminiv203
Then  from Deploy folder i installed Gemini it created virtual directory and everything on my local machine
Then I uploaded the Gemini folder from IIS to online url :
http://www.globecomnetworks.com/Main.aspx
Admin UserName :: vishal and PassWord :: infact
When i login using the following username and password
If i view any Issue by clicking on All Issues
after that when i click on any of the Issue
then it gives me the following error :

Object reference not set to an instance of an object. at CounterSoft.GeminiBiz.TimeTrackingBiz.GetIssueTotalTimeLogged(Int32 issueID) at Gemini.ViewIssue.BindData()

I get above error if i click on each issue.

You can try using the online url and username and password.

I think this error is created by webservice named gemini in Gemini
v203 project

Thanx in Advance


Connie
· 1
Connie
helpful
0
not helpful

Please post the contents of your web.config file.

Also, you do realise that anybody can see these posts. So if this is a live site you better change your password!


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

hi,

 rupinder here.
 i am sending you web.config that i have uploaded for that web project Gemini
these are the contents of web.config file for gemini

<?xml version="1.0" encoding="Windows-1252" ?>
<configuration>
    <configSections>
        <sectionGroup name="GeminiPlugins">
            <section name="MailPlugin" type="System.Configuration.NameValueFileSectionHandler,System,Version=1.0.3300.0,Culture=neutral,PublicKeyToken=b77a5c561934e089" />
        </sectionGroup>
        <section name="nhibernate" type="System.Configuration.NameValueSectionHandler, System, Version=1.0.5000.0,Culture=neutral, PublicKeyToken=b77a5c561934e089" />
        <section name="microsoft.web.services2" type="Microsoft.Web.Services2.Configuration.WebServicesConfiguration, Microsoft.Web.Services2, Version=2.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
    </configSections>
    <!-- **************-->
    <!--
**************-->
    <!-- Gemini application settings go here -->
    <!-- **************-->
    <!--
**************-->
    <GeminiPlugins>
        <MailPlugin>
            <!-- SMTPServer - specify IP number or machine name -->
            <add key="SMTPServer" value="smtpout.secureserver.net" />
            <!-- SMTP authentication values: OFF, BASIC, NTLM. -->
             
            <add key="SMTPAuthentication" value="OFF" />
            <add key="SMTPUserName" value="xxxxxx@xxxxxx.com" />
            <add key="SMTPPassword" value="xxxxx" />
            <!-- Global email alert type on/off settings -->
            <add key="IssueCreateAlert" value="true" />
            <add key="IssueUpdateAlert" value="true" />
            <add key="IssueCommentAlert" value="true" />
            <add key="IssueStatusChangeAlert" value="true" />
            <add key="IssueResolutionChangeAlert" value="true" />
            <add key="IssueDeleteAlert" value="true" />
            <add key="IssueAssignedAlert" value="true" />
            <add key="IssueClosedAlert" value="true" />
            <add key="IssueResolvedAlert" value="true" />
            <add key="IssueWatcherAlert" value="true" />
            <!-- Options -->
            <add key="FromEmailAddress" value="xxxx@wirelessexchangegroup.info" />
            <add key="Debug" value="false" />
            <add key="SendAlerts" value="true" />
            <!-- Email encoding values: ASCII, DEFAULT, UNICODE, UTF7, UTF8. -->
            <add key="Encoding" value="UTF8" />
            <!-- TemplateEngine values: NVELOCITY, STRINGTEMPLATE -->
            <add key="TemplateEngine" value="NVELOCITY" />
            <!-- TemplatesPath: Optional setting that can contain absolute path to "templates\mail" folder
                    - leave empty to let Gemini work it out
                    - or, specify full path , e.g. "c:\inetpub\wwwroot\gemini\templates\mail\"
            -->
            <add key="TemplatesPath" value="" />
        </MailPlugin>
    </GeminiPlugins>
    <nhibernate>
        <!-- The SQL Server dialect (Gemini supports "MsSql2000Dialect" or "MsSql7Dialect") -->
        <add key="hibernate.dialect" value="xxxxxxx" />
        <!-- The SQL Server database connection string -->
        <add key="hibernate.connection.connectionstring" value="data source=xxxxxxxx;database=xxxxxx;initial catalog=xxxxx;uid=xxxxx;pwd=xxxxx" />
        <!-- Misc -->
        <add key="hibernate.connection.provider" value="NHibernate.Connection.DriverConnectionProvider" />
        <add key="hibernate.connection.driver
class" value="NHibernate.Driver.SqlClientDriver" />
    </nhibernate>
    <appSettings>
        <!-- OrganisationName - Name of your organisation -->
        <add key="OrganisationName" value="CounterSoft" />
        <!-- RegisteredTo - The email address of whom the product is registered to -->
        <add key="RegisteredTo" value="" />
        <!-- RegistrationCode - The product registration keycode as provided by CounterSoft -->
        <add key="RegistrationCode" value="" />
       
        <!-- FullGeminiURL - requires trailing forward-slash! -->
        <add key="FullGeminiURL" value="http://globecomnetworks.com/" />
        <!-- GeminiAdmins - Email address for Gemini administrators -->
        <add key="GeminiAdmins" value="admin@globecomnetworks.com" />
       
        <!-- WelcomeTitle - Commercial Licensees only !! -->
        <add key="WelcomeTitle" value="Welcome" />
        <!-- WelcomeMessage - Commercial Licensees only !! -->
        <add key="WelcomeMessage" value="Customise this message via the WEB.CONFIG file." />
       
        <!-- DateFormat - "EU" or "US"    -->
        <add key="DateFormat" value="EU" />
        <!-- TimeInWorkingDay - specify as HH:MM (example "7:30" which equals 7 hours 30 minutes) -->
        <add key="TimeInWorkingDay" value="7:30" />
       
        <!-- WebServicesAccessCode - Security code that must be used when using Gemini web services -->
        <add key="WebServicesAccessCode" value="ABC123" />
        <!-- WinWebServicesAccessCode - Security code that must be used by Gemini Desktop application -->
        <add key="WinWebServicesAccessCode" value="WIN123" />
        <!-- UseAccessCodeForSourceControl - Should we authenticate access to the AddSCFile.aspx? -->
        <add key="UseAccessCodeForSourceControl" value="NO" />
       
        <!-- GlobalAssignResourceAtIssueCreation
                - Controls if ALL USERS can assign resource to an issue during issue creation
                - Possible values = "YES" or "NO"
                - If this is set to YES, then ANY USER can assign a resource to an issue during issue creation
        -->
        <add key="GlobalAssignResourceAtIssueCreation" value="NO" />
        <!-- AutoAlertForIssueCreator
                - Controls if the user creating an issue is automatically an ISSUE WATCHER (get issue alerts)
                - Possible values = "YES" or "NO"
                - If this is set to YES, then alerts will be sent to issue creators whenever the issue is updated
        -->
        <add key="AutoAlertForIssueCreator" value="NO" />
        <!-- AutoAlertForIssueResource
                - Controls if the user working on an issue is automatically an ISSUE WATCHER (get issue alerts)
                - Possible values = "YES" or "NO"
                - If this is set to YES, then alerts will be sent to issue workers whenever the issue is updated
        -->
        <add key="AutoAlertForIssueResource" value="NO" />
       
        <!-- ShowUserRegistrationLink
                - controls whether the logon page displays a link that would allow anyone to register as a member.
                - possible values = "YES" or "NO"
        -->
        <add key="ShowUserRegistrationLink" value="YES" />
       
        <!-- AllowAnonymousUsers- Controls if anonymous users can access Gemini (e.g. no logon required)
                - If this is set to YES, then anyone can view and use Gemini without logging-in
        -->
        <add key="AllowAnonymousUsers" value="YES" />
       
        <!-- ViewAllProjects  - Are all projects visible to everyone?
                - Setting this option to "NO" will mean you can control visibility of projects at user level
        -->
        <add key="ViewAllProjects" value="YES" />
       
        <!-- AlwaysShowGeminiStats - Controls if the Gemini statistics panel is always shown on the main page
                - By default, the stats panel is only visible if you are an admin user or ViewAllProjects=YES
        -->
        <add key="AlwaysShowGeminiStats" value="NO" />
       
        <!-- ResetPasswordSubject - The email subject line used for sending password reset requests -->
        <add key="ResetPasswordSubject" value="Gemini Password Reset Request" />
        <!-- ResetPasswordMessage - The email message used for sending password reset requests -->
        <add key="ResetPasswordMessage" value="Please click on the link below to reset your Gemini password." />
        <!-- When creating a new user, you can send a reset password request:
            - AUTO      = Will always send reset password.
            - BLANK     = Will send a reset password only if password is blank.
            - NEVER     = Will not send a reset password.
        -->
        <add key="NewUserResetPassword" value="BLANK" />
       
        <!-- IssueDescriptionType - Possible values: Text, FreeTextBox or RichText -->
        <add key="IssueDescriptionType" value="RichText" />
        <!-- IssueCommentType - Possible values: Text, FreeTextBox or RichText-->
        <add key="IssueCommentType" value="RichText" />
       
        <!-- PluginPath - path to plugin directory under bin folder (required) -->
        <add key="PluginPath" value="bin/plugins" />
        <!-- DictionaryFolder - Location of the spell check files -->
        <add key="DictionaryFolder" value="dic" />
        <!-- Default Project Repository File Click Behaviour (None or View) -->
        <add key="ProjReposFileClick" value="None" />
        <!-- EnableHTMLPosts - Controls if HTML tags can be entered into text boxes -->
        <add key="EnableHTMLPosts" value="YES" />
        <!-- CharSetForExcel - The character set used when exporting issues to Excel -->
        <add key="CharSetForExcel" value="ISO-8859-1" />
       
        <!-- Make a never expired session (refresh in seconds) -->
        <add key="SessionRefresher" value="600" />
   
        <!-- Single Sign On [method of passing user credentials (SSO.aspx)]
                - DBHASHED= This is taking the actual password as it is on the DB (converted to base 64 string) and hash it with a key that is in the web.config (SSOKey).
                - DB      =    This is taking the actual password as it is on the DB (converted to base 64 string).
                - HASHED  = This is taking the clear text password and hash it with a key that is in the web.config (SSOKey, see below).
                - PLAIN   = This is just sending the password as clear text.
         -->
        <add key="SSOPasswordType" value="DB" />
        <add key="SSOKey" value="" />
       
        <!-- Any issue id with this qualified found will automatically link to the issue -->
        <add key="IssueLinkQualifier" value="GEM:" />
    </appSettings>
    <system.web>
        <compilation defaultLanguage="c#" debug="false" />
        <!--  CUSTOM ERROR MESSAGES
          Set customError mode values to control the display of user-friendly
          error messages to users instead of error details (including a stack trace):

          "On" Always display custom (friendly) messages 
          "Off" Always display detailed ASP.NET error information.
          "RemoteOnly" Display custom (friendly) messages only to users not running
          on the local Web server. This setting is recommended for security purposes, so
          that you do not display application detail information to remote clients.
    -->
        <customErrors mode="On" />
        <!--  AUTHENTICATION  (Gemini possible modes are "Windows", "Forms") -->
        <authentication mode="Forms">
            <forms
                name="Gemini203"
                loginUrl="Default.aspx"
                timeout="60"
                path="/">
            </forms>
        </authentication>
        <authorization>
            <deny users="?"></deny>
        </authorization>
        <!--  APPLICATION-LEVEL TRACE LOGGING
          Application-level tracing enables trace log output for every page within an application.
          Set trace enabled="true" to enable application trace logging.  If pageOutput="true", the
          trace information will be displayed at the bottom of each page.  Otherwise, you can view the
          application trace log by browsing the "trace.axd" page from your web application
          root.
    -->
        <trace enabled="false" requestLimit="10" pageOutput="false" traceMode="SortByTime" localOnly="true" />
        <!--  SESSION STATE SETTINGS
          By default ASP .NET uses cookies to identify which requests belong to a particular session.
          If cookies are not available, a session can be tracked by adding a session identifier to the URL.
          To disable cookies, set sessionState cookieless="true".
         
          InProc
          SQLServer (http://support.microsoft.com/default.aspx?kbid=317604)
          StateServer
    -->
        <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" />
           
        <!--  GLOBALIZATION - This section sets the globalization settings of the application. -->
        <globalization culture="en-GB" uiCulture="en-GB" requestEncoding="utf-8" responseEncoding="utf-8" />
        <!-- File Upload Settings -->
        <httpRuntime executionTimeout="90" maxRequestLength="44096" useFullyQualifiedRedirectUrl="false" />
        <!-- The following blockers only come into affect if IIS is also configured
            http://support.microsoft.com/?kbid=815152
    -->
        <httpHandlers>
            <add type="System.Web.HttpForbiddenHandler" path=".xsl" verb="" />
            <add type="System.Web.HttpForbiddenHandler" path=".vm" verb="" />
            <add type="System.Web.HttpForbiddenHandler" path=".log" verb="" />
            <add type="System.Web.HttpForbiddenHandler" path=".config" verb="" />
            <add type="FreeTextBoxControls.AssemblyResourceHandler, FreeTextBox" path="FtbWebResource.axd"
                verb="GET" />
        </httpHandlers>
        <httpModules>
            <add name="GeminiHttpModule" type="Gemini.GeminiHttpModule, CounterSoft.Gemini" />
        </httpModules>
        <!-- This allows HTML text to be entered into Gemini -->
        <pages validateRequest="true" enableSessionState="true" enableViewState="true" enableViewStateMac="true" />
        <browserCaps>
            <!-- GECKO Based Browsers (Netscape 6+, Mozilla/Firebird, ...) //-->
            <case match="^Mozilla/5.0 ([^)]) (Gecko/[-\d]+)? (?'type'[^/\d])([\d])/(?'version'(?'major'\d+)(?'minor'.\d+)(?'letters'\w)).">
            browser=Gecko
            type=${type}
            frames=true
            tables=true
            cookies=true
            javascript=true
            javaapplets=true
            ecmascriptversion=1.5
            w3cdomversion=1.0
            css1=true
            css2=true
            xml=true
            tagwriter=System.Web.UI.HtmlTextWriter
            <case match="rv:(?'version'(?'major'\d+)(?'minor'.\d+)(?'letters'\w
))">
                version=${version}
                majorversion=${major}
                minorversion=${minor}
                <case match="^b" with="${letters}">
                    beta=true
                </case></case></case>
            <!-- AppleWebKit Based Browsers (Safari...) //-->
            <case match="AppleWebKit/(?'version'(?'major'\d)(?'minor'\d+)(?'letters'\w))">
            browser=AppleWebKit
            version=${version}
            majorversion=${major}
            minorversion=0.${minor}
            frames=true
            tables=true
            cookies=true
            javascript=true
            javaapplets=true
            ecmascriptversion=1.5
            w3cdomversion=1.0
            css1=true
            css2=true
            xml=true
            tagwriter=System.Web.UI.HtmlTextWriter
            <case match="AppleWebKit/(?'version'(?'major'\d)(?'minor'\d+)(?'letters'\w
))( (KHTML, like Gecko) )?(?'type'[^/\d])/.$">
                type=${type}
            </case></case>
            <!-- Konqueror //-->
            <case match="Konqueror/(?'version'(?'major'\d+)(?'minor'.\d+)(?'letters'));\w(?'platform'[^)])">
            browser=Konqueror
            version=${version}
            majorversion=${major}
            minorversion=${minor}
            platform=${platform}
            type=Konqueror
            frames=true
            tables=true
            cookies=true
            javascript=true
            javaapplets=true
            ecmascriptversion=1.5
            w3cdomversion=1.0
            css1=true
            css2=true
            xml=true
            tagwriter=System.Web.UI.HtmlTextWriter
        </case>
        </browserCaps>
        <webServices>
            <soapExtensionTypes>
                <add type="Microsoft.Web.Services2.WebServicesExtension, Microsoft.Web.Services2, Version=2.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
                    priority="1" group="0" />
            </soapExtensionTypes>
        </webServices>
    </system.web>
    <location path="Register.aspx">
        <system.web>
            <authorization>
                <allow users=""></allow>
            </authorization>
        </system.web>
    </location>
    <location path="ForgotPassword.aspx">
        <system.web>
            <authorization>
                <allow users="
"></allow>
            </authorization>
        </system.web>
    </location>
    <location path="ResetPassword.aspx">
        <system.web>
            <authorization>
                <allow users=""></allow>
            </authorization>
        </system.web>
    </location>
    <location path="Error.aspx">
        <system.web>
            <authorization>
                <allow users="
"></allow>
            </authorization>
        </system.web>
    </location>
    <location path="webservices/Gemini.asmx">
        <system.web>
            <authorization>
                <allow users=""></allow>
            </authorization>
        </system.web>
    </location>
    <location path="IssuesExcel.aspx">
        <system.web>
            <authorization>
                <allow users="
"></allow>
            </authorization>
        </system.web>
    </location>
    <location path="xproject/IssuesExcel.aspx">
        <system.web>
            <authorization>
                <allow users=""></allow>
            </authorization>
        </system.web>
    </location>
    <location path="admin">
        <system.web>
            <authorization>
                <deny users="?"></deny>
            </authorization>
        </system.web>
    </location>
    <location path="sc/AddSCFile.aspx">
        <system.web>
            <authorization>
                <allow users="
"></allow>
            </authorization>
        </system.web>
    </location>
    <location path="issue/StopWatch.aspx">
        <system.web>
            <authorization>
                <allow users=""></allow>
            </authorization>
        </system.web>
    </location>
    <location path="SSO.aspx">
        <system.web>
            <authorization>
                <allow users="
"></allow>
            </authorization>
        </system.web>
    </location>
    <location path="webservices/CustomFieldsWS.asmx">
        <system.web>
            <authorization>
                <allow users=""></allow>
            </authorization>
        </system.web>
    </location>
    <location path="webservices/VersionsWS.asmx">
        <system.web>
            <authorization>
                <allow users="
"></allow>
            </authorization>
        </system.web>
    </location>
    <location path="webservices/ComponentsWS.asmx">
        <system.web>
            <authorization>
                <allow users=""></allow>
            </authorization>
        </system.web>
    </location>
    <location path="webservices/AuthWS.asmx">
        <system.web>
            <authorization>
                <allow users="
"></allow>
            </authorization>
        </system.web>
    </location>
    <location path="webservices/GeminiLookUpsWS.asmx">
        <system.web>
            <authorization>
                <allow users=""></allow>
            </authorization>
        </system.web>
    </location>
    <location path="webservices/IssuesWS.asmx">
        <system.web>
            <authorization>
                <allow users="
"></allow>
            </authorization>
        </system.web>
    </location>
    <location path="webservices/ProjectsWS.asmx">
        <system.web>
            <authorization>
                <allow users=""></allow>
            </authorization>
        </system.web>
    </location>
    <location path="webservices/GeminiWSE.asmx">
        <system.web>
            <authorization>
                <allow users="
"></allow>
            </authorization>
        </system.web>
    </location>
    <location path="webservices/TimeTracking.asmx">
        <system.web>
            <authorization>
                <allow users=""></allow>
            </authorization>
        </system.web>
    </location>
    <location path="Refresher.aspx">
        <system.web>
            <authorization>
                <allow users="
"></allow>
            </authorization>
        </system.web>
    </location>
    <microsoft.web.services2>
        <diagnostics />
        <security>
            <securityTokenManager type="CounterSoft.GeminiBiz.GeminiUsernameTokenManager, CounterSoft.GeminiBiz" xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd"
                qname="wsse:UsernameToken" />
        </security>
    </microsoft.web.services2>
</configuration>

Thanx in Advance for helping me out


Connie
· 1
Connie
helpful
0
not helpful

The web.config file seems fine.

Is this an upgrade? If not what's changed?


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Hi,

Yes this is the Web.Config file that is uploaded.

But when i configured this project on my local machine by Installing the Gemini.msi
then it works fine on my machine.

Then i uploaded all the contents of the Virtual Directory Gemini from my IIS to online server
can this might be the cause due to which problem comes.






Connie
· 1
Connie
helpful
0
not helpful

Did you upgrade the database? You should do!


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

Hi,

yes i have upgraded the database with all the scripts. But still i am get the same problem.
do i have to upgrade all the scripts in some particular order.

from where the error comes from database or coding portion.

Thanx In Advance.
Rupinder.


Connie
· 1
Connie
helpful
0
not helpful

Which SQL scripts did you run?


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful


I run scripts that were in folder named Deploy >> Step1SQLDatabase.





Connie
· 1
Connie
helpful
0
not helpful

Did you run createprocs.sql?

Please try and run (using query analyzer) geminigetissuetimespent stored procedure passing an issue id to it. What do you get back?

Also, I notice that you have not entered your registration code in the web.config file. Please do so, as at the moment you are violating the license agreement.


Saar Cohen
· 5000
Saar Cohen