Nhibernate issue: {"in expected: from blah blah blah" }

Problem:

The exception is:

{"in expected: pc [select pc.parentCategory from ProductCategory pc]"}
[NHibernate.QueryException]: {"in expected: pc [select pc.parentCategory from ProductCategory pc]"}
Data: {System.Collections.ListDictionaryInternal}
HelpLink: null
InnerException: null
Message: "in expected: pc [select pc.parentCategory from ProductCategory pc]"
Source: "NHibernate"
StackTrace: " at NHibernate.Hql.FromParser.Token(String token, QueryTranslator q)\r\n at NHibernate.Hql.ClauseParser.Token(String token, QueryTranslator q)\r\n at NHibernate.Hql.PreprocessingParser.End(QueryTranslator q)\r\n at NHibernate.Hql.ParserHelper.Parse(IParser p, String text, String seperators, QueryTranslator q)\r\n at NHibernate.Hql.QueryTranslator.Compile()\r\n at NHibernate.Hql.QueryTranslator.Compile(ISessionFactoryImplementor factory, IDictionary replacements, Boolean scalar)\r\n at NHibernate.Impl.SessionFactoryImpl.GetQuery(String queryString, Boolean shallow)\r\n at NHibernate.Impl.SessionImpl.GetQueries(String query, Boolean scalar)\r\n at NHibernate.Impl.SessionImpl.Find(String query, QueryParameters parameters)\r\n at NHibernate.Impl.SessionImpl.Find(String query, Object[] values, IType[] types)\r\n at NHibernate.Impl.SessionImpl.Find(String query)\r\n at Castle.Facilities.NHibernateIntegration.SessionDelegate.Find(String query)\r\n at Cuyahoga.Modules.Ecommer
ce.CatalogueModule.GetSubCategories(Int32 node)\r\n at Cuyahoga.Modules.Ecommerce.Web.CatNav.Page_Load(Object sender, EventArgs e)"
TargetSite: {Void Token(System.String, NHibernate.Hql.QueryTranslator)}

Solution:

There could be several causes for this error, but the main reason behind this error is mapping.

1. Make sure your ClassName.hbm.xml file is set as "Embedded Resource".

2. Make sure table name, column names are correct and their types are correct.