...

Ошибка при отображении по зонам ответственности и исполнителям

Тема в разделе "Разработчикам", создана пользователем MikeG, 6 авг 2019.

  1. MikeG

    MikeG New Member

    В мониторе процессов при раскрытии "Отображение по зонам ответственности и исполнителям" выдаёт ошибку со следующим текстом:
    Devart.Data.PostgreSql.PgSqlException: ошибка синтаксиса (примерное положение: ".")
    в Devart.Data.PostgreSql.t.f(r A_0)
    в Devart.Data.PostgreSql.r.n()
    в Devart.Data.PostgreSql.PgSqlCommand.InternalPrepare(Boolean implicitPrepare, Int32 startRecord, Int32 maxRecords)
    в Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
    в NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd)
    в EleWise.ELMA.Runtime.NH.CustomBatcher.ahldFHfzXhLXIM2K0VYM(Object , Object )
    в EleWise.ELMA.Runtime.NH.CustomBatcher.ExecuteReader(IDbCommand cmd)
    в NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverTypes, Boolean callable, RowSelection selection, ISessionImplementor session)
    в NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer)
    в NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer)
    в NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer)
    NHibernate.Exceptions.GenericADOException: could not execute query [ SELECT header4_.Id as y0_, bm1_.ElementUid as y1_, count(this_.Id) as y2_ FROM TaskBase this_ inner join WorkflowBookmark bm1_ on this_.WorkflowBookmark=bm1_.Id inner join WorkflowInstance ins2_ on bm1_.Instance=ins2_.Id and ( ins2_.Id in (with recursive t_Rec as ( select Id from WorkflowInstance wi where wi.Process in (select wp.Id from WorkflowProcess wp where wp."Header" = @p0) union all select wi.Id from WorkflowInstance wi inner join t_Rec on t_Rec.Id = wi.ParentInstance ) select * from t_Recand wi.Id = bm1_.Instance) ) inner join WorkflowProcess prc3_ on ins2_.Process=prc3_.Id left outer join BPMNProcess prc3_1_ on prc3_.Id=prc3_1_.Id inner join ProcessHeader header4_ on prc3_."Header"=header4_.Id WHERE this_.Status in (@p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8) and ins2_.IsEmulation = @p9 GROUP BY header4_.Id, bm1_.ElementUid ] Name:cp0 - Value:NewOrder(34387afa-6b70-476f-9d34-748732059003) Name:cp1 - Value:InProgress(37a184b8-a81d-4177-9eb5-4ebe3dfae959) Name:cp2 - Value:Read(85707efe-806c-4ec6-8cd6-4d5e4edd8b19) Name:cp3 - Value:prepared(112ea757-36f7-4859-b0d3-6cc0f5a04705) Name:cp4 - Value:OnApproval(b9c9f74a-15ec-4337-9916-f02ffec83dd4) Name:cp5 - Value:OnApprovalExecutor(b0b6a339-ba74-4e46-b721-2733d7fb76a9) Name:cp6 - Value:RefuseApprovalExecutor(70918293-8b84-43be-ad39-181375d51373) Name:cp7 - Value:NoComplete(98ff43bd-b897-41f0-adf2-4eb3b3783851) Name:cp8 - Value:False Name:cp9 - Value:171 [SQL: SELECT header4_.Id as y0_, bm1_.ElementUid as y1_, count(this_.Id) as y2_ FROM TaskBase this_ inner join WorkflowBookmark bm1_ on this_.WorkflowBookmark=bm1_.Id inner join WorkflowInstance ins2_ on bm1_.Instance=ins2_.Id and ( ins2_.Id in (with recursive t_Rec as ( select Id from WorkflowInstance wi where wi.Process in (select wp.Id from WorkflowProcess wp where wp."Header" = @p0) union all select wi.Id from WorkflowInstance wi inner join t_Rec on t_Rec.Id = wi.ParentInstance ) select * from t_Recand wi.Id = bm1_.Instance) ) inner join WorkflowProcess prc3_ on ins2_.Process=prc3_.Id left outer join BPMNProcess prc3_1_ on prc3_.Id=prc3_1_.Id inner join ProcessHeader header4_ on prc3_."Header"=header4_.Id WHERE this_.Status in (@p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8) and ins2_.IsEmulation = @p9 GROUP BY header4_.Id, bm1_.ElementUid]
    в NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer)
    в NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters)
    в NHibernate.Impl.SessionImpl.List(CriteriaImpl criteria, IList results)
    в NHibernate.Impl.CriteriaImpl.List(IList results)
    в NHibernate.Impl.CriteriaImpl.List[T]()
    в EleWise.ELMA.Workflow.Managers.WorkflowTaskBaseManager.GetTasksCountByActivitiesSwimlayn(Int64 headerId, DetachedCriteria instanceFilter)
    в EleWise.ELMA.Workflow.Managers.WorkflowTaskBaseManager.GetTasksCountByActivitiesSwimlayn(Int64 headerId, Nullable`1 filterId)
    в EleWise.ELMA.Workflow.Processes.Web.Controllers.MonitorController.GetSwimlanesInfo(IProcessHeader header, Nullable`1 filterId, FilterModel filterModel)
    в EleWise.ELMA.Workflow.Processes.Web.Controllers.MonitorController.SwimlaneExecutors(Int64 id, Nullable`1 filterId, FilterModel filterModel)
    в lambda_method(Closure , ControllerBase , Object[] )
    в System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)
    в System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
    в System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClass13.b__10()
    в System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
    в System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
    в System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
    в System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
    в System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
    в System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
    в System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
    в System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
    в System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
    в System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
    в System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName)
    в System.Web.Mvc.Controller.ExecuteCore()
    в System.Web.Mvc.ControllerBase.Execute(RequestContext requestContext)
    в System.Web.Mvc.MvcHandler.ProcessRequest(HttpContextBase httpContext)
    в Orchard.Mvc.Routes.ShellRoute.HttpHandler.ProcessRequest(HttpContext context)
    в System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
    в System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)
    в System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

    Image2019080601.png

    Подскажите, что случилось и как можно исправить?
     
  2. AndySwan

    AndySwan New Member

    Вылечилось обновлением до последней версии системы.
     

Поделиться: