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.




Invalid object name versions when clicking on MyWork

web-app

 

Hello,

after the upgrade from 2.2.7 to 3.0.4 we made some tests to verify that everything looks/works as expected.

Then we ran the optional clean up script (Upgradev3-0-Step3Optional.sql).

When the users click on My Work they get the following error. I don't know if this error is related to the execution of the Upgradev3-0-Step3Optional.sql.

Do you have an idea, whats going wrong?

I 've checked our DB, there is no table "versions" it has tables: "geminiverisons" and versionstemp. Both of them have lots of data.

Server Error in '/' Application.

Invalid object name 'versions'.

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: Invalid object name 'versions'.

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 (0x80131904): Invalid object name 'versions'.]
   CounterSoft.Gemini.DataProvider.x4f26f7a726757349.xd8280387c605aca4(CustomFieldEN x5a09e7cd54476202, Int32 xb378eaa6f96e5474) +730
   CounterSoft.Gemini.DataProvider.x4f26f7a726757349.xd8280387c605aca4(CustomFieldEN x5a09e7cd54476202) +6
   CounterSoft.Gemini.Business.xa07794653f9cfd6c.xdb93551b54005149() +119
   CounterSoft.Gemini.Workload.RenderHTMLView() +1468
   CounterSoft.Gemini.Workload.BindData() +50
   CounterSoft.Gemini.Workload.PageLoad(Object sender, EventArgs e) +51
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +33
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +47
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1436

Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433

deniz
· 1 		deniz
Thursday, October 23, 2008, 10:39:48 AM
Replies (10)
helpful
0
not helpful

I' ve just restored the "old" versions table. And the problem is fixed, m now able to open My Work again.

BTW: View all Projects Issue reporting was also not possible anymore.

It looks like, that after the upgrade, some queries are still need old tables (without pre "gemini_").

 

 
deniz
· 1 		deniz
Thursday, October 23, 2008, 12:03:57 PM
helpful
0
not helpful

Looks like you were still using the 2.2.7 web app!
Mark Wing
· 9108 		Mark Wing
Thursday, October 23, 2008, 12:13:38 PM
helpful
0
not helpful

Where do I check this?

Cause the web appshows on the homepage and also within the mails: Gemini 3.0.4 (Build 2026)

But when I rename the table "versions" to an invalid name, My Work and Show all Issue Projects reporting run into the error reported above.
deniz
· 1 		deniz
Thursday, October 23, 2008, 12:22:00 PM
helpful
0
not helpful

3.0.x does not use any tables without the gemini_ prefix.

Please check the URL is correct. Also, check full gemini url setting.
Mark Wing
· 9108 		Mark Wing
Thursday, October 23, 2008, 1:41:31 PM
helpful
0
not helpful

Our installation of the gemini web app has been installed on Windows 2003 R2 64 Bit Server (active/active MS Webcluster with 2 Nodes) Due to the Clustering installed on a shared disk, between the two servers.   So we do not have a folder called Program Files its called Program Files [x86]. Therefore we had to copy the files manually into the directories. In past this wasn't a problem with Gemini 2.2.7. We anyway run the gemini web app msi, but this did not solve the problem. What else can we check?   In this particular case: the old versions table is called when executing this url: http://our-geminiURL-here/user/Workload.aspx or this:  http://our-geminiURL-here/Issues.aspx?PROJID=-2&m=1 All projects issue reporting LINK     This is the source of Workload.aspx:   <%@ Page Language="C#" MasterPageFile="~/MasterPages/MainMaster.Master" AutoEventWireup="true" CodeBehind="Workload.aspx.cs" Inherits="CounterSoft.Gemini.Workload" Title="Gemini" Theme="Default" %> <asp:Content ID="Content1" ContentPlaceHolderID="Main" runat="server"> <%if(Request["excel"] == null)
{
%>
<script language="javascript">
<!--
function ShowLogTimeWindow(itemID)
{   
    var oManager = $find("<%=RadWindowManager1.ClientID%>");
    var url = "../Issue/Windows/LogIssueTimePopup.aspx?id=" + itemID;
    var w = oManager.open(url, "RadWindowLogTime");     return false;
}
-->
</script>
<H2 align="center">
    <gem:geminisimpleliteral id="USERMyWorkTitle" runat="server" Key="USERMyWorkTitle" Colon="False"></gem:geminisimpleliteral>
</H2> <p align="right">
    <gem:GeminiSimpleLink id="lnkExcel" runat="server" NavigateUrl="Workload.aspx?excel=true" Target="new" Key="Excel" Colon="False">[lnkExcel]</gem:GeminiSimpleLink>&nbsp;
    <gem:GeminiSimpleLink id="lnkCustomise" runat="server" NavigateUrl="WorkloadView.aspx" Font-Bold="True" Key="Customise"></gem:GeminiSimpleLink>&nbsp;
</p> <p><asp:placeholder id="placeHolder" runat="server"></asp:placeholder></p> <telerik:radwindowmanager runat="server" ID="RadWindowManager1" Modal="true" Skin="Default" VisibleStatusbar="true" VisibleTitlebar="true">
    <Windows>
        <telerik:RadWindow ID="RadWindow_LogTime" runat="server"
            Title="Gemini"
            NavigateUrl="../Issue/Windows/LogIssueTimePopup.aspx"
            Modal="False"
            InitialBehaviors="Resize, Close, Move"
            Behaviors="Resize, Close, Move"
            Width="550px"
            Height="620px"
            ReloadOnShow="true"
            />
    </Windows>
</telerik:radwindowmanager> <%
}
%> </asp:Content>
deniz
· 1 		deniz
Thursday, October 23, 2008, 3:15:12 PM
helpful
0
not helpful

Check in IIS (inetmgr) if the MSI has created a new virtual directory for Gemini 3.0.
Saar Cohen
· 5000 		Saar Cohen
Thursday, October 23, 2008, 8:29:23 PM
helpful
0
not helpful

Yes, we checked it has created a new virtual directory. What else should we check?
deniz
· 1 		deniz
Monday, October 27, 2008, 11:52:54 AM
helpful
0
not helpful

I've created an empty "versions" table, when i then open the My Work site, I'm getting the error above. So its really accessing data from that table.

Than I've created a new version in a project, this version is only written into the gemini_versions table, not into the versions table.

This is a really strange behaviour.
deniz
· 1 		deniz
Monday, October 27, 2008, 2:04:46 PM
helpful
0
not helpful

Do you have a custom field that is based on the OLD versions table?
Saar Cohen
· 5000 		Saar Cohen
Monday, October 27, 2008, 7:45:48 PM
helpful
0
not helpful

Excellent hint!

There was really a custom field referencing to table "versions".

Problem solved!

Thank you very much.
deniz
· 1 		deniz
Tuesday, October 28, 2008, 10:46:27 AM