Вопрос
Field_surveys_for_Creatio
Sales_Creatio
7.17
Field surveys for Creatio ошибка при установке
Симонов Сергей Сергеевич
26 мая 2021 14:51

Добрый день. Зарегистрировал демо-стенд 7.18 CRM Creatio на сайте terrasoft. Установил модуль Field sales for Creatio https://marketplace.terrasoft.ua/app/field-sales-creatio



Затем запустил установку Field surveys for Creatio https://marketplace.terrasoft.ru/app/field-surveys-creatio



И установка завершилась с ошибками. Привожу выдержку из лога установки:

 

2021-05-25 10:18:28,380 Установлены справочные значения "Lookup" из пакета "Survey"
2021-05-25 10:18:28,567 Установлены справочные значения "SysModuleEdit_SysModuleEditManager_0025147610664656926b60679e27f195" из пакета "Survey"
2021-05-25 10:18:28,677 Установлены справочные значения "SysModuleEdit_SysModuleEditManager_ad7609be3dbf4cec9631ddb74f3bbc43" из пакета "Survey"
2021-05-25 10:18:28,739 Установлены справочные значения "SysModuleEdit_SysModuleEditManager_d7a8f0f8a35a487ba0266399131d3ef3" из пакета "Survey"
2021-05-25 10:18:28,817 Установлены справочные значения "SysModuleEdit_SysModuleEditManager_dd0cc098660140c6ae8ae04935bbba88" из пакета "Survey"
2021-05-25 10:18:28,927 Установлены справочные значения "SysModuleEdit_SysModuleEditManager_dd8558319b834d898f022c6d53f89f67" из пакета "Survey"
2021-05-25 10:18:29,083 Ошибка установки данных "SysModuleInWorkplace_SectionInWorkplaceManager_4dbd15cd925541cc8bcfe66862497b8e" из пакета "Survey". UId 331c519a-c43a-4c52-be67-3c645b90b04a: Npgsql.PostgresException (0x80004005): 23503: insert or update on table "SysModuleInWorkplace" violates foreign key constraint "FKiEw0PrrAuIapzcrL01PohOXeFM"
   at Npgsql.NpgsqlConnector.<DoReadMessage>d__157.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Npgsql.NpgsqlConnector.<ReadMessage>d__156.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at Npgsql.NpgsqlConnector.<ReadMessage>d__156.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Npgsql.NpgsqlDataReader.<NextResult>d__32.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Npgsql.NpgsqlDataReader.NextResult()
   at Npgsql.NpgsqlCommand.<Execute>d__71.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Npgsql.NpgsqlCommand.<ExecuteNonQuery>d__84.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Npgsql.NpgsqlCommand.ExecuteNonQuery()
   at Polly.Policy.<>c__DisplayClass119_0`1.<Execute>b__0(Context ctx, CancellationToken ct)
   at Polly.Policy.<>c__DisplayClass129_0`1.<ExecuteInternal>b__0(Context ctx, CancellationToken ct)
   at Polly.Policy.<>c__DisplayClass103_0.<NoOp>b__1(Context ctx, CancellationToken ct)
   at Polly.NoOp.NoOpEngine.Implementation[TResult](Func`3 action, Context context, CancellationToken cancellationToken)
   at Polly.Policy.<>c.<NoOp>b__103_0(Action`2 action, Context context, CancellationToken cancellationToken)
   at Polly.Policy.ExecuteInternal[TResult](Func`3 action, Context context, CancellationToken cancellationToken)
   at Polly.Policy.Execute[TResult](Func`3 action, Context context, CancellationToken cancellationToken)
   at Polly.Policy.Execute[TResult](Func`1 action)
   at Terrasoft.Core.DB.DBExecutor.<ExecuteCommandAsync>d__88`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Terrasoft.Core.DB.DBExecutor.ExecuteCommand[TResult](Func`2 commandExecutionCallback, String sqlText, QueryParameterCollection queryParameters, CancellationToken cancellationToken)
   at Terrasoft.DB.PostgreSql.PostgreSqlExecutor.<>c__DisplayClass45_0.<InternalExecute>b__0()
   at Terrasoft.DB.PostgreSql.PostgreSqlExecutor.ExecuteInLockIfInTransaction[TResult](Func`1 action)
   at Terrasoft.Core.DB.Query.<ExecuteAsync>d__76.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Terrasoft.Core.DB.Query.Execute(DBExecutor dbExecutor)
   at Terrasoft.Core.Entities.Entity.<ExecuteUpdateAsync>d__302.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Terrasoft.Core.Entities.Entity.ExecuteUpdate(Update update)
   at Terrasoft.Core.Entities.Entity.<UpdateInDBAsync>d__299.MoveNext()
UPDATE "public"."SysModuleInWorkplace"
SET
	"ModifiedOn" = TO_TIMESTAMP('2021-05-25 10:18:29.052', 'YYYY-MM-DD HH24:MI:SS.FF3'),
	"ModifiedById" = '{410006E1-CA4E-4502-A9EC-E54D922D2C00}',
	"SysWorkplaceId" = '{79770671-CDE2-4C0F-9078-A4FF68703DEF}',
	"SysModuleId" = '{D7DDAA53-677B-482F-A5B7-8EF2E39F1300}'
WHERE
	"Id" = '{4DBD15CD-9255-41CC-8BCF-E66862497B8E}'
2021-05-25 10:18:29,114 Terrasoft.Common.DbOperationException: Npgsql.PostgresException (0x80004005): 23503: insert or update on table "SysModuleInWorkplace" violates foreign key constraint "FKiEw0PrrAuIapzcrL01PohOXeFM"
   at Npgsql.NpgsqlConnector.<DoReadMessage>d__157.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Npgsql.NpgsqlConnector.<ReadMessage>d__156.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at Npgsql.NpgsqlConnector.<ReadMessage>d__156.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Npgsql.NpgsqlDataReader.<NextResult>d__32.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Npgsql.NpgsqlDataReader.NextResult()
   at Npgsql.NpgsqlCommand.<Execute>d__71.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Npgsql.NpgsqlCommand.<ExecuteNonQuery>d__84.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Npgsql.NpgsqlCommand.ExecuteNonQuery()
   at Polly.Policy.<>c__DisplayClass119_0`1.<Execute>b__0(Context ctx, CancellationToken ct)
   at Polly.Policy.<>c__DisplayClass129_0`1.<ExecuteInternal>b__0(Context ctx, CancellationToken ct)
   at Polly.Policy.<>c__DisplayClass103_0.<NoOp>b__1(Context ctx, CancellationToken ct)
   at Polly.NoOp.NoOpEngine.Implementation[TResult](Func`3 action, Context context, CancellationToken cancellationToken)
   at Polly.Policy.<>c.<NoOp>b__103_0(Action`2 action, Context context, CancellationToken cancellationToken)
   at Polly.Policy.ExecuteInternal[TResult](Func`3 action, Context context, CancellationToken cancellationToken)
   at Polly.Policy.Execute[TResult](Func`3 action, Context context, CancellationToken cancellationToken)
   at Polly.Policy.Execute[TResult](Func`1 action)
   at Terrasoft.Core.DB.DBExecutor.<ExecuteCommandAsync>d__88`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Terrasoft.Core.DB.DBExecutor.ExecuteCommand[TResult](Func`2 commandExecutionCallback, String sqlText, QueryParameterCollection queryParameters, CancellationToken cancellationToken)
   at Terrasoft.DB.PostgreSql.PostgreSqlExecutor.<>c__DisplayClass45_0.<InternalExecute>b__0()
   at Terrasoft.DB.PostgreSql.PostgreSqlExecutor.ExecuteInLockIfInTransaction[TResult](Func`1 action)
   at Terrasoft.Core.DB.Query.<ExecuteAsync>d__76.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Terrasoft.Core.DB.Query.Execute(DBExecutor dbExecutor)
   at Terrasoft.Core.Entities.Entity.<ExecuteUpdateAsync>d__302.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Terrasoft.Core.Entities.Entity.ExecuteUpdate(Update update)
   at Terrasoft.Core.Entities.Entity.<UpdateInDBAsync>d__299.MoveNext() ---> Npgsql.PostgresException: 23503: insert or update on table "SysModuleInWorkplace" violates foreign key constraint "FKiEw0PrrAuIapzcrL01PohOXeFM"
   at Npgsql.NpgsqlConnector.<DoReadMessage>d__157.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Npgsql.NpgsqlConnector.<ReadMessage>d__156.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at Npgsql.NpgsqlConnector.<ReadMessage>d__156.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Npgsql.NpgsqlDataReader.<NextResult>d__32.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Npgsql.NpgsqlDataReader.NextResult()
   at Npgsql.NpgsqlCommand.<Execute>d__71.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Npgsql.NpgsqlCommand.<ExecuteNonQuery>d__84.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
 

Список с ошибками намного длиннее, прикрепляю его к сообщению.



Вопрос. Данное дополнение ещё поддерживается? Могут ли данные ошибки повлиять на корректную работу решения?

Прикрепленные файлы
install.txt

Нравится

1 комментарий
Лучший ответ
Iryna Lazorenko
27 мая 2021 17:10

Сергей, добрый день!

ошибку установки воспроизвела и передала на ответственную команду.

Ошибка связана с установкой привязки данных - регистрации раздела в рабочем месте. Эта ошибка не влияет на функциональность решения, только раздел не появится по умолчанию в рабочем месте.

Iryna Lazorenko
27 мая 2021 17:10

Сергей, добрый день!

ошибку установки воспроизвела и передала на ответственную команду.

Ошибка связана с установкой привязки данных - регистрации раздела в рабочем месте. Эта ошибка не влияет на функциональность решения, только раздел не появится по умолчанию в рабочем месте.

Показать все комментарии
Подписаться на Field_surveys_for_Creatio