Errore: could not execute query [ select content0_.ContentId as ContentId1_, content0_.Language as Language1_, content0_.Version as Version1_, content0_.CustomerId as CustomerId1_, content0_.SubTitle as SubTitle1_, content0_.ContentText as ContentT6_1_, content0_.Category as Category1_, content0_.Status as Status1_, content0_.SharingType as SharingT9_1_, content0_.PermissionType as Permiss10_1_, content0_.MetaTag as MetaTag1_, content0_.IsPrivate as IsPrivate1_, content0_.Title as Title1_, content0_.Permalink as Permalink1_, content0_.InsertDate as InsertDate1_, content0_.ModifiedDate as Modifie16_1_, content0_.DeleteDate as DeleteDate1_, content0_.StartDate as StartDate1_, content0_.EndDate as EndDate1_, content0_.PublishDate as Publish20_1_, content0_.UnpublishDate as Unpubli21_1_, content0_.MasterPageName as MasterP22_1_, content0_.CssClass as CssClass1_, content0_.MasterContentId as MasterC24_1_, content0_.MasterVersion as MasterV25_1_, content0_.IsMandatory as IsManda26_1_, content0_.AuthorId as AuthorId1_ from [Content] content0_ inner join ContentToSubCategory subcategor1_ on content0_.ContentId=subcategor1_.ContentId and content0_.Language=subcategor1_.Language and content0_.Version=subcategor1_.Version and content0_.CustomerId=subcategor1_.CustomerId inner join [SubCategory] subcategor2_ on subcategor1_.SubCategoryId=subcategor2_.SubCategoryId where (content0_.DeleteDate is null) and content0_.CustomerId=@p0 and content0_.Category=@p1 and subcategor2_.SubCategoryId=@p2 and content0_.Language=@p3 and content0_.Status<>@p4 and (content0_.Version in (select MAX(content3_.Version) from [Content] content3_ where content0_.ContentId=content3_.ContentId and content3_.CustomerId=@p0 and content3_.Language=@p3 and content3_.Category=@p1)) ] Name:subCategory - Value:96 Name:customer - Value:Cantine Ferrari Trento Name:category - Value:NEWS Name:language - Value:CR2.Common.ObjectModel.Language Name:status - Value:DRAFT [SQL: select content0_.ContentId as ContentId1_, content0_.Language as Language1_, content0_.Version as Version1_, content0_.CustomerId as CustomerId1_, content0_.SubTitle as SubTitle1_, content0_.ContentText as ContentT6_1_, content0_.Category as Category1_, content0_.Status as Status1_, content0_.SharingType as SharingT9_1_, content0_.PermissionType as Permiss10_1_, content0_.MetaTag as MetaTag1_, content0_.IsPrivate as IsPrivate1_, content0_.Title as Title1_, content0_.Permalink as Permalink1_, content0_.InsertDate as InsertDate1_, content0_.ModifiedDate as Modifie16_1_, content0_.DeleteDate as DeleteDate1_, content0_.StartDate as StartDate1_, content0_.EndDate as EndDate1_, content0_.PublishDate as Publish20_1_, content0_.UnpublishDate as Unpubli21_1_, content0_.MasterPageName as MasterP22_1_, content0_.CssClass as CssClass1_, content0_.MasterContentId as MasterC24_1_, content0_.MasterVersion as MasterV25_1_, content0_.IsMandatory as IsManda26_1_, content0_.AuthorId as AuthorId1_ from [Content] content0_ inner join ContentToSubCategory subcategor1_ on content0_.ContentId=subcategor1_.ContentId and content0_.Language=subcategor1_.Language and content0_.Version=subcategor1_.Version and content0_.CustomerId=subcategor1_.CustomerId inner join [SubCategory] subcategor2_ on subcategor1_.SubCategoryId=subcategor2_.SubCategoryId where (content0_.DeleteDate is null) and content0_.CustomerId=@p0 and content0_.Category=@p1 and subcategor2_.SubCategoryId=@p2 and content0_.Language=@p3 and content0_.Status<>@p4 and (content0_.Version in (select MAX(content3_.Version) from [Content] content3_ where content0_.ContentId=content3_.ContentId and content3_.CustomerId=@p0 and content3_.Language=@p3 and content3_.Category=@p1))]

web: http://www.ferraritrento.it/news/notizie/ferrari-tra-le-star-degli-emmy-awards

stack trace: at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters)
at NHibernate.Hql.Ast.ANTLR.Loader.QueryLoader.List(ISessionImplementor session, QueryParameters queryParameters)
at NHibernate.Hql.Ast.ANTLR.QueryTranslatorImpl.List(ISessionImplementor session, QueryParameters queryParameters)
at NHibernate.Engine.Query.HQLQueryPlan.PerformList(QueryParameters queryParameters, ISessionImplementor session, IList results)
at NHibernate.Impl.SessionImpl.List(String query, QueryParameters queryParameters, IList results)
at NHibernate.Impl.SessionImpl.List[T](String query, QueryParameters parameters)
at NHibernate.Impl.QueryImpl.List[T]()
at CR2.Business.ContentManager.GetContentsBySubCategory(Customer customer, CategoryType category, Int32 subCategory, Language language)
at CR2.Business.ContentManager.GetPublishedContentsBySubCategoryForView(Customer customer, CategoryType category, Int32 subCategory, Language language, Boolean PutInDynamicBox)
at CR2.Web.ViewProcess.Generators.ContentListGenerator.queryList()
at CR2.Web.ViewProcess.Generators.ContentListGenerator.getDynamicBoxes(DynamicBox parentBox, Boolean OrderByPublishDate)
at CR2.Web.Models.BaseModel.GetDynamicBoxesFromFirstListBox(String tag)
at ASP._Page_Views_Themes_CantineFerrari_masterNewsInPrimoPiano_cshtml.Execute() in e:\Websites\web\ferraritrento.it\Views\Themes\CantineFerrari\masterNewsInPrimoPiano.cshtml:line 154
at System.Web.WebPages.WebPageBase.ExecutePageHierarchy()
at System.Web.Mvc.WebViewPage.ExecutePageHierarchy()
at System.Web.WebPages.WebPageBase.ExecutePageHierarchy(WebPageContext pageContext, TextWriter writer, WebPageRenderingBase startPage)
at System.Web.Mvc.ViewResultBase.ExecuteResult(ControllerContext context)
at System.Web.Mvc.ControllerActionInvoker.InvokeActionResultFilterRecursive(IList`1 filters, Int32 filterIndex, ResultExecutingContext preContext, ControllerContext controllerContext, ActionResult actionResult)
at System.Web.Mvc.ControllerActionInvoker.InvokeActionResultFilterRecursive(IList`1 filters, Int32 filterIndex, ResultExecutingContext preContext, ControllerContext controllerContext, ActionResult actionResult)
at System.Web.Mvc.ControllerActionInvoker.InvokeActionResultWithFilters(ControllerContext controllerContext, IList`1 filters, ActionResult actionResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass21.b__1e(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeAction(IAsyncResult asyncResult)
at System.Web.Mvc.Controller.b__1d(IAsyncResult asyncResult, ExecuteCoreState innerState)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult)
at System.Web.Mvc.Controller.EndExecuteCore(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult)
at System.Web.Mvc.Controller.EndExecute(IAsyncResult asyncResult)
at System.Web.Mvc.MvcHandler.b__5(IAsyncResult asyncResult, ProcessRequestState innerState)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult)
at System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

inner exception: Value was either too large or too small for an Int32. ---
---
at System.Convert.ToInt32(Int64 value) at NHibernate.Type.PersistentEnumType.AbstractEnumConverter`1.ToObject(Type enumClass, Object code) at NHibernate.Type.PersistentEnumType.GetInstance(Object code) at NHibernate.Type.NullableType.NullSafeGet(IDataReader rs, String name) at NHibernate.Persister.Entity.AbstractEntityPersister.Hydrate(IDataReader rs, Object id, Object obj, ILoadable rootLoadable, String[][] suffixedPropertyColumns, Boolean allProperties, ISessionImplementor session) at NHibernate.Loader.Loader.LoadFromResultSet(IDataReader rs, Int32 i, Object obj, String instanceClass, EntityKey key, String rowIdAlias, LockMode lockMode, ILoadable rootPersister, ISessionImplementor session) at NHibernate.Loader.Loader.InstanceNotYetLoaded(IDataReader dr, Int32 i, ILoadable persister, EntityKey key, LockMode lockMode, String rowIdAlias, EntityKey optionalObjectKey, Object optionalObject, IList hydratedObjects, ISessionImplementor session) at NHibernate.Loader.Loader.GetRow(IDataReader rs, ILoadable[] persisters, EntityKey[] keys, Object optionalObject, EntityKey optionalObjectKey, LockMode[] lockModes, IList hydratedObjects, ISessionImplementor session) at NHibernate.Loader.Loader.GetRowFromResultSet(IDataReader resultSet, ISessionImplementor session, QueryParameters queryParameters, LockMode[] lockModeArray, EntityKey optionalObjectKey, IList hydratedObjects, EntityKey[] keys, Boolean returnProxies) at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)

Back to top