Dynamics Community Forum Thread Details

Import Organization from D365 8.2 to D365 9.1 Error

Hi All,

I have installed new D365 9.1 and import an Organization from D365 8.2. It happen issue below. Anyone have any idea for the issue, thanks

2022-06-15 15:18:44.152| Error| An error occurred when trying import and upgrade organization database xxxxvissql01.xxxx_MSCRM:
Microsoft.Crm.CrmException: Initialization of the database connection or transaction failed. This operation should be retried later. Initialization exception message: 'CURRENT_TRANSACTION_ID'
is not a recognized built-in function name. ---> System.Data.SqlClient.SqlException: 'CURRENT_TRANSACTION_ID' is not a recognized built-in function name.
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.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at Microsoft.Crm.Core.DataServices.Connection.CrmSqlDataAccessHelper.TryGetSpidAndTransactionId(ICrmDbConnection connection, IsolationLevel isoLevel, Nullable`1& spid, Nullable`1& transactionId)
at Microsoft.Crm.CrmTransaction.<>c__DisplayClass8_0.<StartTransaction>b__