Hi All,

While migrating a package from dev to staging environment, encountering this error message which is logged from SysUsrProjectsLog - (UsrProjects - is a custom object and Change log is enabled ).

The error message from the log file is as below:

Error occurred while saving schema database structure "SysUsrProjectsLog" in package "". UId 00000000-0000-0000-0000-000000000000: Error "ALTER TABLE ALTER COLUMN failed because column 'UsrNationalPriority' does not exist in table 'SysUsrProjectsLog'." occurred when updating schema structure. SQL script text: "ALTER TABLE [dbo].[SysUsrProjectsLog] ALTER COLUMN [UsrNationalPriority] NVARCHAR(250) NOT NULL"
2022-03-31 14:08:39,621 Terrasoft.Core.DB.DBMetaActionExecuteException: Error "ALTER TABLE ALTER COLUMN failed because column 'UsrNationalPriority' does not exist in table 'SysUsrProjectsLog'." occurred when updating schema structure. SQL script text: "ALTER TABLE [dbo].[SysUsrProjectsLog] ALTER COLUMN [UsrNationalPriority] NVARCHAR(250) NOT NULL" ---> System.Data.SqlClient.SqlException: ALTER TABLE ALTER COLUMN failed because column 'UsrNationalPriority' does not exist in table 'SysUsrProjectsLog'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.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.DB.MSSql.MSSqlExecutor.FailoverExecute[TResult](DbCommand command, Func`1 func)
   at Terrasoft.Core.DB.DBExecutor.<ExecuteCommandAsync>d__96`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.Core.DB.DBExecutor.InternalExecute(String sqlText, QueryParameterCollection queryParameters)
   at Terrasoft.Core.DB.DBMetaAction.QueryExecute()
   at Terrasoft.Core.DB.DBMetaAction.Execute(ActionsConfig actionsConfig)
   at Terrasoft.Core.DB.DBMetaActionCollection.Execute(ActionsConfig actionsConfig)
   --- End of inner exception stack trace ---
2022-03-31 14:08:39,621 Error occured while performing operation on "" item, UId = .

The field which is causing the problem is called "UsrNationalPriority" lookup field and the functionality is similar to Manager Mood in Opportuntity page. Below link was followed to develop the functionality:

Add Manager Mood from Opportunities to Accounts | Community Creatio

Appreciate your suggestion on where could be the issue as the functionality implemented is working as expected except that the field is not getting added in the Changelog relevant db table.

Thanks

Anupama

Hello,



I'm trying to deploy a custom package to a cloud env. It is created by CLIO and basically it is almost empty. I have created 1 object through the Section wizard with 1 integer field. Then exported the package from my local env as a .zip file.



My local env is vers "7.17.4.2265", while I'm trying to install it on "7.17.3.1377" (our main test env) and on trial version env "7.18.0.1353".





When I try to install it via the Installed applications (I've exported the package), it cannot install properly and shows this in the installation logs:



Errors and (or) warnings occurred while compiling configuration dll

Error : Errors occurred while compiling configuration. See logs for more details.

When application installed, an error(s) occured



or this:



Compiling configuration dll

Errors and (or) warnings occurred while compiling configuration dll

Error MSB1025: An internal failure occurred while running MSBuild.

When application installed, an error(s) occured