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.




custom field creation help: Invalid object name error

web-app

Hello everyone,

I was wondering if anyone here could help me create a script to create the custome field tables....

The custome field will define subcomponents in our system and it will be in a drop-down list.

Any help will be greatly appreciated.
Gemini version  Gemini 2.2.6

Thank you,

Garifo
 

garifo
· 1
garifo
Replies (5)
helpful
0
not helpful

I created the tables but when going to my project and click on create I get the following error message:

Server Error in '/GeminiB' Application.

        <h2> <i>Invalid object name 'subcomponent'.</i> </h2></span>

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

        <b> Description: </b>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.

        <b> Exception Details: </b>System.Data.SqlClient.SqlException: Invalid object name 'subcomponent'.<br><br>

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

        <table bgcolor="#ffffcc" width="100%">
           <tbody><tr>
              <td>
                  <code>

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.

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

        <br>

        <b>Stack Trace:</b> <br><br>

        <table bgcolor="#ffffcc" width="100%">
           <tbody><tr>
              <td>
                  <code></code><pre>[SqlException (0x80131904): Invalid object name 'subcomponent'.]<br>   CounterSoft.Gemini.DataProvider.x4f26f7a726757349.xd8280387c605aca4(CustomFieldEN x5a09e7cd54476202) +525<br>   CounterSoft.Gemini.DataProvider.x4f26f7a726757349.xa291203dfbe52cd9(Int32 xa8708020b9a21a3a, String xebbec3a16b54a08f, Int32 x663e02d322c995c9) +495<br>   CounterSoft.Gemini.Business.xa07794653f9cfd6c.x5ded85495bbe6fab(Int32 xa8708020b9a21a3a) +46<br>   CounterSoft.Gemini.CreateIssue.Page_Load(Object sender, EventArgs e) +240<br>   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15<br>   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +34<br>   System.Web.UI.Control.OnLoad(EventArgs e) +99<br>   CounterSoft.Gemini.Business.BasePage.OnLoad(EventArgs e) +4<br>   System.Web.UI.Control.LoadRecursive() +47<br>   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061<br></pre></td></tr></tbody></table></font><br>What do I need to do to fix this error?<br><br>Also in the section where the custom field is created...when I click on the custom field link I created I get the same error message.<br><br><br>Any help is greatly appreciated.<br>

garifo
· 1
garifo
helpful
0
not helpful

Did you create the subcomponent table?


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

subcomponent table is created...now...does that table need to be prepoluated with data before it's used?


garifo
· 1
garifo
helpful
0
not helpful

Yes, Gemini only selects from this table


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

I figure what the problem was....damn extract character in the subcomponent table name..


garifo
· 1
garifo