Hi,
After deploying latest HF’s for SF we get the below and cannot synchronize to IAM
2022-06-09T09:36:00.9225343+00:00 [err] Error in process procedure of process action 'do_job' in process flow 'system_flow_generate_sync_scripts'. (57b87444)
2022-06-09T09:36:00.9370848+00:00 [err] Error scheduling system flow 'system_flow_generate_sync_scripts' for application 284. (326083e9)
Microsoft.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'hotfix_pk'. Cannot insert duplicate key in object 'dbo.hotfix'. The duplicate key value is (20220603 - Fill reachable object tables upon syncing).
The statement has been terminated.
at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at Microsoft.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader(Boolean isInternal, Boolean forDescribeParameterEncryption)
at Microsoft.Data.SqlClient.SqlCommand.InternalEndExecuteNonQuery(IAsyncResult asyncResult, Boolean isInternal, String endMethod)
at Microsoft.Data.SqlClient.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
at Microsoft.Data.SqlClient.SqlCommand.EndExecuteNonQueryAsync(IAsyncResult asyncResult)
at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization)
Hi @mperrott,
There was indeed a bug in an existing hotfix. This has already been fixed and is currently being deployed to our hotfixes folder. It's named "20220603 - Fill reachable object tables when syncing.sql” and it will become available during the day. Sorry for the inconvenience.