*EleWise.ELMA.Runtime.Db.DbStructureException: Ошибка обновления структуры БД: Не удалось создать процедуру "GetUserChiefsHierarchy" ---> System.Data.DataException: Не удалось выполнить запрос
create or replace function GetUserChiefsHierarchy(StartUserId bigint)
returns table (
StartItemId bigint,
OrgItemId bigint,
Lvl bigint,
UserId bigint
)
as
$$
select us.OrgItemId as StartItemId, oih.*
from UserSecuritySetCache us
left join GetOrgItemHierarchy(us.OrgItemId) oih on 1=1
left join OrganizationItem oi on oi.Id = us.OrgItemId
left join OrganizationItem oi1 on oi1.Id = oih.OrgItemId
where us.UserId = $1
and us.UserCount != -1
and us.OrgItemId is not null
and oi.ItemType in (1,2)
and oi1.ItemType in (1)
$$
language sql;
---> Devart.Data.PostgreSql.PgSqlException: в элементе предложения FROM неверная ссылка на таблицу "us"
в Devart.Data.PostgreSql.PgSqlDataReader.f(Int32 A_0)
в Devart.Data.PostgreSql.PgSqlCommand.InternalExecute(CommandBehavior behavior, IDisposable stmt, Int32 startRecord, Int32 maxRecords)
в Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
в Devart.Common.DbCommandBase.ExecuteNonQuery()
в EleWise.ELMA.Runtime.Db.Migrator.Providers.TransformationProvider.g8VrEq3JoW55fxYRoIPH(Object )
в EleWise.ELMA.Runtime.Db.Migrator.Providers.TransformationProvider.ExecuteNonQuery(String sql, String[] paramnames, Object[] paramvalues)
--- Конец трассировки внутреннего стека исключений ---
в EleWise.ELMA.Runtime.Db.Migrator.Providers.TransformationProvider.ExecuteNonQuery(String sql, String[] paramnames, Object[] paramvalues)
в EleWise.ELMA.Runtime.Db.Migrator.Providers.TransformationProvider.ExecuteNonQuery(String sql, Dictionary`2 paramValues)
в EleWise.ELMA.Runtime.Db.DbStructureReader.CreateProcedures()
--- Конец трассировки внутреннего стека исключений ---
в EleWise.ELMA.Runtime.Db.DbStructureReader.CreateProcedures()
в EleWise.ELMA.Runtime.Db.DbStructureReader.ExecuteCreateRecreatedTransaction()
в Castle.DynamicProxy.AbstractInvocation.Proceed()
в EleWise.ELMA.Runtime.NH.DiagnosticsInterceptor.GBhsCj7ZYEgx94rlVRRp(Object )
в EleWise.ELMA.Runtime.NH.DiagnosticsInterceptor.Intercept(IInvocation invocation)
в Castle.DynamicProxy.AbstractInvocation.Proceed()
в EleWise.ELMA.Runtime.NH.TransactionInterceptor.D9NOXng5U2hoNpLB41lg(Object )
в EleWise.ELMA.Runtime.NH.TransactionInterceptor.Intercept(IInvocation invocation)
в Castle.DynamicProxy.AbstractInvocation.Proceed()
в EleWise.ELMA.Runtime.Db.DbStructureReader.aEulGM3PIbMKNcoPLobW(Object )
в EleWise.ELMA.Runtime.Db.DbStructureReader.ExecuteMain()
в Castle.DynamicProxy.AbstractInvocation.Proceed()
в EleWise.ELMA.Runtime.NH.DiagnosticsInterceptor.GBhsCj7ZYEgx94rlVRRp(Object )
в EleWise.ELMA.Runtime.NH.DiagnosticsInterceptor.Intercept(IInvocation invocation)
в Castle.DynamicProxy.AbstractInvocation.Proceed()
в EleWise.ELMA.Runtime.NH.TransactionInterceptor.D9NOXng5U2hoNpLB41lg(Object )
в EleWise.ELMA.Runtime.NH.TransactionInterceptor.Intercept(IInvocation invocation)
в Castle.DynamicProxy.AbstractInvocation.Proceed()
в EleWise.ELMA.Runtime.Db.DbStructureReader.Read(IEnumerable`1 structures, IEnumerable`1 handlers)
в EleWise.ELMA.Runtime.Providers.NHProvider.InitComplete()
в EleWise.ELMA.Runtime.RuntimeApplication.yhsUTtgFA3pJN5B7i6Iq(Object )
в EleWise.ELMA.Runtime.RuntimeApplication.InitComplete()
в EleWise.ELMA.ComponentModel.ComponentManager.dhwuiZ3IEiso6EVmcDTR(Object )
в EleWise.ELMA.ComponentModel.ComponentManager.<Init>b__6(Object h)
в EleWise.ELMA.ComponentModel.ComponentManager.InvokeInitHandlers(Action`1 action)
в EleWise.ELMA.ComponentModel.ComponentManager.Init()
в EleWise.ELMA.ComponentModel.ComponentManager.shYyMu3cXX8gi2f2VDQA(Object )
в EleWise.ELMA.ComponentModel.ComponentManager.Init(String[] assembliesPaths, String workDirectory)
в EleWise.ELMA.BPM.Mvc.Application.Orchard.ELMAEnviromentStarter.BC8TtQ2FEgaSwp5LCI(Object , Object , Object )
в EleWise.ELMA.BPM.Mvc.Application.Orchard.ELMAEnviromentStarter.StartApplicationInThread()
Ошибка обновления структуры БД: Не удалось создать процедуру "GetUserChiefsHierarchy"
EleWise.ELMA.SDK
в EleWise.ELMA.Runtime.Db.DbStructureReader.CreateProcedures()
в EleWise.ELMA.Runtime.Db.DbStructureReader.ExecuteCreateRecreatedTransaction()
в Castle.DynamicProxy.AbstractInvocation.Proceed()
в EleWise.ELMA.Runtime.NH.DiagnosticsInterceptor.GBhsCj7ZYEgx94rlVRRp(Object )
в EleWise.ELMA.Runtime.NH.DiagnosticsInterceptor.Intercept(IInvocation invocation)
в Castle.DynamicProxy.AbstractInvocation.Proceed()
в EleWise.ELMA.Runtime.NH.TransactionInterceptor.D9NOXng5U2hoNpLB41lg(Object )
в EleWise.ELMA.Runtime.NH.TransactionInterceptor.Intercept(IInvocation invocation)
в Castle.DynamicProxy.AbstractInvocation.Proceed()
в EleWise.ELMA.Runtime.Db.DbStructureReader.aEulGM3PIbMKNcoPLobW(Object )
в EleWise.ELMA.Runtime.Db.DbStructureReader.ExecuteMain()
в Castle.DynamicProxy.AbstractInvocation.Proceed()
в EleWise.ELMA.Runtime.NH.DiagnosticsInterceptor.GBhsCj7ZYEgx94rlVRRp(Object )
в EleWise.ELMA.Runtime.NH.DiagnosticsInterceptor.Intercept(IInvocation invocation)
в Castle.DynamicProxy.AbstractInvocation.Proceed()
в EleWise.ELMA.Runtime.NH.TransactionInterceptor.D9NOXng5U2hoNpLB41lg(Object )
в EleWise.ELMA.Runtime.NH.TransactionInterceptor.Intercept(IInvocation invocation)
в Castle.DynamicProxy.AbstractInvocation.Proceed()
в EleWise.ELMA.Runtime.Db.DbStructureReader.Read(IEnumerable`1 structures, IEnumerable`1 handlers)
в EleWise.ELMA.Runtime.Providers.NHProvider.InitComplete()
в EleWise.ELMA.Runtime.RuntimeApplication.yhsUTtgFA3pJN5B7i6Iq(Object )
в EleWise.ELMA.Runtime.RuntimeApplication.InitComplete()
в EleWise.ELMA.ComponentModel.ComponentManager.dhwuiZ3IEiso6EVmcDTR(Object )
в EleWise.ELMA.ComponentModel.ComponentManager.<Init>b__6(Object h)
в EleWise.ELMA.ComponentModel.ComponentManager.InvokeInitHandlers(Action`1 action)
в EleWise.ELMA.ComponentModel.ComponentManager.Init()
в EleWise.ELMA.ComponentModel.ComponentManager.shYyMu3cXX8gi2f2VDQA(Object )
в EleWise.ELMA.ComponentModel.ComponentManager.Init(String[] assembliesPaths, String workDirectory)
в EleWise.ELMA.BPM.Mvc.Application.Orchard.ELMAEnviromentStarter.BC8TtQ2FEgaSwp5LCI(Object , Object , Object )
в EleWise.ELMA.BPM.Mvc.Application.Orchard.ELMAEnviromentStarter.StartApplicationInThread()*
развернул систему, пытаюсь запустить.