Hi all,
I have installed D365 9.1, then I import Organization from old system 8.2 to new D365 9.1. but it have some exception below. How can I resolve errors ? Where can I find the sql script ? Thanks
13:03:58| Info| Insert placeholder BPF definition for missing OOB BPFs
13:03:58| Info| Action Scripts\InsertPlaceholderBPFDefinitions.sql with id 5f7837d7-176a-49ad-81b1-a70c88c6ed76 of type SqlScript to Insert placeholder BPF definition for missing OOB BPFs failed on attempt 2. Retrying in 30 seconds. Exception: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
13:04:28| Info| Action Scripts\InsertPlaceholderBPFDefinitions.sql with id 5f7837d7-176a-49ad-81b1-a70c88c6ed76 of type SqlScript to Insert placeholder BPF definition for missing OOB BPFs failed on attempt 3. Retrying in 30 seconds. Exception: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
13:04:58| Info| CrmAction execution time; UpgradeDatabaseAction; 00:05:34.9797387
13:04:58| Error| Installer Complete: OrganizationUpgrader - Error encountered
13:04:58| Error| Exception occurred during Microsoft.Crm.Tools.Admin.OrganizationUpgrader: Error.ActionFailed Microsoft.Crm.Tools.Admin.UpgradeDatabaseAction
InnerException:
Microsoft.Crm.CrmException: Error in Action: Scripts\InsertPlaceholderBPFDefinitions.sql on attempt 3. System.Data.SqlClient.SqlException (0x80131904): Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
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()