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

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