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.





Like 0



Hello Anupama,


Thank you for also registering case SR-01107137, we will duplicate the solution here it is found.


Best regards,


Show all comments

Hi Creatio community,


I am using Creatio sale. I want to ask that How can I manage my Sale teams KPI on Creatio sale?


For example: 

- I can set up the Target KPI to my Sale team members such as: Number of Call, Message, Mails; Revenue

- I can control the KPIs of my team members by seeing how each person has performed


Please help me on that

Like 0



Hi there,


Thank you for your question,


To control KPI of each member, we would recommend using Dashboards. With it, you display the results of each member of your team. More information you can find in the article here.


As for target KPI, at the moment there is no corresponding functionality to setup constant numbers in Dashboard section. Our R&D team works on implementing such tool in future releases.


As for now, we would recommend using Gauge dashboard to set up KPI requirements.


Please let us know if any additional questions arise!


Best regards,



Show all comments