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.




Removal of historical filters

find-filter

Hi,

After a recent upgrade I noticed that I had filters that were no longer working and were generating error logs whenever used - I understand that this is probably caused by them referencing entities that no longer exist.

Is there any way these can be removed, as the normal method of deletion (selecting a filter then deleting) does not work as when clicked, I am navigated to the error log page?

The urls for the two filters are:

http://gemini/gemini//Project/Project.aspx?Tab=Issues&SubTab=Issues&PROJID=5&filter=6 http://gemini/gemini//Project/Project.aspx?Tab=Issues&SubTab=Issues&PROJID=5&filter=7

The error log is as follows:

could not resolve property: StatusDesc of: CounterSoft.Gemini.Commons.Entity.IssueEN at NHibernate.Persister.Entity.AbstractPropertyMapping.ToType(String propertyName) at NHibernate.Persister.Entity.AbstractEntityPersister.ToType(String propertyName) at NHibernate.Loader.Criteria.CriteriaQueryTranslator.GetType(ICriteria subcriteria, String propertyName) at NHibernate.Criterion.PropertyProjection.GetTypes(ICriteria criteria, ICriteriaQuery criteriaQuery) at NHibernate.Criterion.ProjectionList.GetTypes(ICriteria criteria, ICriteriaQuery criteriaQuery) at NHibernate.Criterion.Distinct.GetTypes(ICriteria criteria, ICriteriaQuery criteriaQuery) at NHibernate.Loader.Criteria.CriteriaQueryTranslator.getProjectedTypes() at NHibernate.Loader.Criteria.CriteriaJoinWalker..ctor(IOuterJoinLoadable persister, CriteriaQueryTranslator translator, ISessionFactoryImplementor factory, ICriteria criteria, String rootEntityName, IDictionary2 enabledFilters) at NHibernate.Loader.Criteria.CriteriaLoader..ctor(IOuterJoinLoadable persister, ISessionFactoryImplementor factory, CriteriaImpl rootCriteria, String rootEntityName, IDictionary2 enabledFilters) at NHibernate.Impl.SessionImpl.List(CriteriaImpl criteria, IList results) at NHibernate.Impl.CriteriaImpl.List(IList results) at NHibernate.Impl.CriteriaImpl.List() at CounterSoft.Gemini.DataProvider.xc0186e148e957052.GetFilteredIssuesID(IssuesFilterEN ifeFilter, Int32[] closedStatus, UserEN user, List1 customFields) at CounterSoft.Gemini.Business.x95da312ae9372c2e.GetFilteredIssuesID(IssuesFilterEN ifeFilter, List1 allCustomFields, UserEN user) at CounterSoft.Gemini.Business.x95da312ae9372c2e.xa91f976c95cc24f6(IssuesFilterEN x24b748b5be295dcb, Int32 x6085dd2d6dae9673, Int32 x870a8f396af517a1, Int32& x42a948eff01be1b6, Int32& x8c5725b36c3fef30, Int32& x93a2c901eb10cf80, UserEN xfd92dbe2fa4bcb5a) at CounterSoft.Gemini.Business.x95da312ae9372c2e.xa44cba2c5079bbd3(IssuesFilterEN xb0f684c47236959a, Int32 xac5137055166e071, Int32 x1e9480f13fb31614, UserEN xfd92dbe2fa4bcb5a) at CounterSoft.Gemini.Web.Controls.IssuesGridUC.BindData() at CounterSoft.Gemini.Web.Controls.IssuesGridUC.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 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)

Any help as always, would be greatly appreciated.

chrisb
· 1
chrisb
Replies (2)
helpful
0
not helpful
ANSWER

You will have to do that in SQL, run:

delete from gemini_personalfilters where filterid=7

Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

Mark, many thanks. I will give this a try.


chrisb
· 1
chrisb