2

Resolved

Subsection Manage Workflow Definitions, filter All values produces an error

description

Oops. Something went wrong ... sorry

An unhandled exception has occurred and the request was terminated. Please refresh the page. If the error persists, go back

could not execute query [ select workflowde0_.Id as Id33_, workflowde0_.Enabled as Enabled33_, workflowde0_.Name as Name33_ from Orchard_Workflows_WorkflowDefinitionRecord workflowde0_ order by workflowde0_.Name asc OFFSET @p0 ROWS FETCH NEXT @p1 ROWS ONLY ] Name:p1 - Value:0 Name:p2 - Value:0 [SQL: select workflowde0_.Id as Id33_, workflowde0_.Enabled as Enabled33_, workflowde0_.Name as Name33_ from Orchard_Workflows_WorkflowDefinitionRecord workflowde0_ order by workflowde0_.Name asc OFFSET @p0 ROWS FETCH NEXT @p1 ROWS ONLY]

NHibernate.Exceptions.GenericADOException: could not execute query [ select workflowde0_.Id as Id33_, workflowde0_.Enabled as Enabled33_, workflowde0_.Name as Name33_ from Orchard_Workflows_WorkflowDefinitionRecord workflowde0_ order by workflowde0_.Name asc OFFSET @p0 ROWS FETCH NEXT @p1 ROWS ONLY ] Name:p1 - Value:0 Name:p2 - Value:0 [SQL: select workflowde0_.Id as Id33_, workflowde0_.Enabled as Enabled33_, workflowde0_.Name as Name33_ from Orchard_Workflows_WorkflowDefinitionRecord workflowde0_ order by workflowde0_.Name asc OFFSET @p0 ROWS FETCH NEXT @p1 ROWS ONLY] ---> System.Data.SqlServerCe.SqlCeException: The number of lines in a sentence FETCH must be an integer greater than zero. in System.Data.SqlServerCe.SqlCeDataReader.ProcessResults(Int32 hr) in System.Data.SqlServerCe.SqlCeDataReader.IsEndOfRowset(Int32 hr) in System.Data.SqlServerCe.SqlCeDataReader.Move(DIRECTION direction) in System.Data.SqlServerCe.SqlCeDataReader.Read() in NHibernate.Driver.NHybridDataReader.Read() in NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) in NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) in NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) --- End of inner exception stack trace --- in NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) in NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) in NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet1 querySpaces, IType[] resultTypes) in NHibernate.Hql.Ast.ANTLR.Loader.QueryLoader.List(ISessionImplementor session, QueryParameters queryParameters) in NHibernate.Hql.Ast.ANTLR.QueryTranslatorImpl.List(ISessionImplementor session, QueryParameters queryParameters) in NHibernate.Engine.Query.HQLQueryPlan.PerformList(QueryParameters queryParameters, ISessionImplementor session, IList results) in NHibernate.Impl.SessionImpl.List(IQueryExpression queryExpression, QueryParameters queryParameters, IList results) in NHibernate.Impl.AbstractSessionImpl.List(IQueryExpression queryExpression, QueryParameters parameters) in NHibernate.Impl.ExpressionQueryImpl.List() in NHibernate.Linq.DefaultQueryProvider.ExecuteQuery(NhLinqExpression nhLinqExpression, IQuery query, NhLinqExpression nhQuery) in NHibernate.Linq.DefaultQueryProvider.Execute(Expression expression) in NHibernate.Linq.DefaultQueryProvider.Execute[TResult](Expression expression) in Remotion.Linq.QueryableBase1.GetEnumerator() in System.Collections.Generic.List1..ctor(IEnumerable1 collection) in System.Linq.Enumerable.ToList[TSource](IEnumerable1 source) in Orchard.Workflows.Controllers.AdminController.Index(AdminIndexOptions options, PagerParameters pagerParameters) in e:\orchard_d70b75f4c925\src\Orchard.Web\Modules\Orchard.Workflows\Controllers\AdminController.cs:line 88 in lambda_method(Closure , ControllerBase , Object[] ) in System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters) in System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary2 parameters) in System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary2 parameters) in System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClass13.<InvokeActionMethodWithFilters>b__10() in System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func1 continuation) in System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClass13.<>c__DisplayClass15.<InvokeActionMethodWithFilters>b__12() in System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func1 continuation) in System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClass13.<>c__DisplayClass15.<InvokeActionMethodWithFilters>b__12() in System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func1 continuation)

Clone: d70b75f4c925

comments

sebastienros wrote May 14, 2013 at 7:48 PM

Repro:
In Workflows list, select All in the number of items.

sebastienros wrote Jul 8, 2013 at 11:29 PM

Fixed in changeset db0bfc2fc1f9

sfmskywalker wrote Mar 28 at 12:28 AM

Fixed in changeset 3c195471d687753d6cdb22ae4b0a96eb25ec182f