✅ Ошибка JSON на странице "Очередь исполнения"

При переходе с версии 3.13 (и возможно более ранних) на 3.15 может возникнуть вот такая проблема:

image-1598868529415.png

А в логах видим:

ERROR [CallContextUid=366d0238-be7b-46e0-b0a2-c74447312d0b] 2020-08-31 12:28:32,965 [82] EleWise.ELMA.Workflow.Processes.Web.Controllers.WorkflowQueueController - System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> NHibernate.Exceptions.GenericADOException: could not execute query
[ SELECT top(15) tv.Id as Id509_0_, tv.Uid as Uid509_0_, tv.ElementUid as ElementUid509_0_, tv.CreationDate as Creation4_509_0_, tv.Attempt as Attempt509_0_, tv.LastExecuteDate as LastExec6_509_0_, tv.NextExecuteDate as NextExec7_509_0_, tv.LastError as LastError509_0_, tv.SkipExecution as SkipExec9_509_0_, tv.SkipConnectorUid as SkipCon10_509_0_, tv.Timeout as Timeout509_0_, tv.LastExceptionData as LastExc12_509_0_, tv.ServerConnectionUid as ServerC13_509_0_, tv.Instance as Instance509_0_, tv.Author as Author509_0_, tv.BackgroundOperation as Backgro16_509_0_ FROM (SELECT wqi.Id, wqi.Uid, wqi.Instance, wqi.ElementUid, wqi.CreationDate, wqi.Attempt, wqi.LastExecuteDate, wqi.NextExecuteDate, wqi.LastError, wqi.Author, wqi.SkipExecution, wqi.SkipConnectorUid, wqi.Timeout, wqi.LastExceptionData, 0 OnceExecuteStatus, wqi.ServerConnectionUid, wqi.BackgroundOperation
FROM WorkflowQueueItem wqi WITH(NOLOCK)
LEFT JOIN WorkflowInstance wi WITH(NOLOCK) ON wi.Id = wqi.Instance
LEFT JOIN WorkflowProcess wp WITH(NOLOCK) ON wi.Process = wp.Id
LEFT JOIN ProcessHeader ph WITH(NOLOCK) ON wp.Header = ph.Id
WHERE Attempt = 0 ) tv ORDER BY Status ]
[SQL: SELECT top(15) tv.Id as Id509_0_, tv.Uid as Uid509_0_, tv.ElementUid as ElementUid509_0_, tv.CreationDate as Creation4_509_0_, tv.Attempt as Attempt509_0_, tv.LastExecuteDate as LastExec6_509_0_, tv.NextExecuteDate as NextExec7_509_0_, tv.LastError as LastError509_0_, tv.SkipExecution as SkipExec9_509_0_, tv.SkipConnectorUid as SkipCon10_509_0_, tv.Timeout as Timeout509_0_, tv.LastExceptionData as LastExc12_509_0_, tv.ServerConnectionUid as ServerC13_509_0_, tv.Instance as Instance509_0_, tv.Author as Author509_0_, tv.BackgroundOperation as Backgro16_509_0_ FROM (SELECT wqi.Id, wqi.Uid, wqi.Instance, wqi.ElementUid, wqi.CreationDate, wqi.Attempt, wqi.LastExecuteDate, wqi.NextExecuteDate, wqi.LastError, wqi.Author, wqi.SkipExecution, wqi.SkipConnectorUid, wqi.Timeout, wqi.LastExceptionData, 0 OnceExecuteStatus, wqi.ServerConnectionUid, wqi.BackgroundOperation
FROM WorkflowQueueItem wqi WITH(NOLOCK)
LEFT JOIN WorkflowInstance wi WITH(NOLOCK) ON wi.Id = wqi.Instance
LEFT JOIN WorkflowProcess wp WITH(NOLOCK) ON wi.Process = wp.Id
LEFT JOIN ProcessHeader ph WITH(NOLOCK) ON wp.Header = ph.Id
WHERE Attempt = 0 ) tv ORDER BY Status ] ---> System.Data.SqlClient.SqlException: Invalid column name 'Status'.


В результате обновления изменились параметры сортировки по полю Статус. Необходимо просто выбрать колонку сортировку "мышкой" по колонке Статус или какой-то другой и ошибка уйдет.

image-1598870528011.png


Версия #5
Вербовик М. А. создал Mon, Aug 31, 2020 1:05 PM
Вербовик М. А. обновил Mon, Aug 31, 2020 1:44 PM