Home Home
  login

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 Column name 'projectid'

install
usage
reporting

I am tyring to run some reports under all projects in version 4.1 and they system error log keeps displaying with this message. Any clues?

Invalid column name 'projectid'. at CounterSoft.Gemini.DataProvider.x4f26f7a726757349.xd8280387c605aca4(CustomFieldEN x5a09e7cd54476202, Int32 xb378eaa6f96e5474) at CounterSoft.Gemini.DataProvider.x4f26f7a726757349.GetProjectCustomFields(Int32 iProjID, String strMode, Int32 iIssueID) at CounterSoft.Gemini.Business.xa07794653f9cfd6c.xb47ee8b97695ab4d(Int32 xa8708020b9a21a3a) at CounterSoft.Gemini.Business.x95da312ae9372c2e.x3ea65f25dee0cd51(IssuesFilterEN x24b748b5be295dcb, List`1 x41ed9424bcef4dac, UserEN xfd92dbe2fa4bcb5a) at CounterSoft.Gemini.Business.x95da312ae9372c2e.xa91f976c95cc24f6(IssuesFilterEN x24b748b5be295dcb, Int32 x6085dd2d6dae9673, Int32 x870a8f396af517a1, Int32& x42a948eff01be1b6, Int32& x8c5725b36c3fef30, Int32& x93a2c901eb10cf80, UserEN xfd92dbe2fa4bcb5a) at CounterSoft.Gemini.Web.Controls.IssuesGridUC.BindData() at CounterSoft.Gemini.Web.Controls.IssuesGridUC.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 System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
rlevine
· 1 		rlevine
Tuesday, September 6, 2011, 5:44:22 PM
Replies (6)
helpful
0
not helpful

Seems like you have a custom field that is marked as "filter by project id" but the custom field table doesn't contain the project id column. Can you please check it in your custom field definitions (Administration -> Custom Fields)?
Saar Cohen
· 5000 		Saar Cohen
Tuesday, September 6, 2011, 6:39:15 PM
helpful
0
not helpful

Ok. I found it.

Now I am getting an error when trying to export a report (Activity Trend) to pdf.

Could not render the url. Could not get image from url.Navigation timeout.. at ExpertPdf.HtmlToPdf.ImgConverter.GetMetafileFromUrl(String url, nc& htmlParseInfo) at ExpertPdf.HtmlToPdf.PdfConverter.GetPdfBytes(String url, String htmlString, String internalLinksDocUrl, Boolean fromUrl) at ExpertPdf.HtmlToPdf.PdfConverter.GetPdfBytesFromUrl(String url) at CounterSoft.Gemini.Web.Controls.PDFControl.lnkPDF_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e) at System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) at System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
rlevine
· 1 		rlevine
Tuesday, September 6, 2011, 7:30:08 PM
helpful
0
not helpful

Please try and navigate to the same url when logged in on the web server, does it work? Are you running windows authentication in Gemini?
Saar Cohen
· 5000 		Saar Cohen
Tuesday, September 6, 2011, 7:42:34 PM
helpful
0
not helpful

Ok, I was able to export to pdf, however the report had an empty image.
Yes Windows Authentication is enabled.
rlevine
· 1 		rlevine
Tuesday, September 6, 2011, 7:52:41 PM
helpful
0
not helpful

Unfortunately, charts will not render in PDF when running windows authentication at the moment.
Saar Cohen
· 5000 		Saar Cohen
Tuesday, September 6, 2011, 8:40:08 PM
helpful
0
not helpful

Ok, thank you for the quick responses on all of these.
rlevine
· 1 		rlevine
Tuesday, September 6, 2011, 9:18:38 PM