Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archive) / D365 9.1 import organi...
Microsoft Dynamics CRM (Archive)
Answered

D365 9.1 import organization

(0) ShareShare
ReportReport
Posted on by baochau 95

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

: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)

Categories:
Administration and Setup
  • baochau Profile Picture
    baochau 95 on at
    RE: D365 9.1 import organization

    Thanks Pedro, I found the script and I resolved the issue. It's also discussed in the topic below

    community.dynamics.com/.../1240056

  • Suggested answer
    Pedro Cadavez de Freitas Profile Picture
    Pedro Cadavez de Fr... on at
    RE: D365 9.1 import organization

    Hello Baochau,

    Hope you are well.

    This is not a very common error on imports, but we've seen it sometimes on specific users querying the businessprocess table because of some inconsistency on the table or because of the query that is generated is not optimal based on some custom changes.

    The SQL script in context should be present under:

    C:\Program Files\Dynamics 365\LangPacks\1033\Xrm\sql\9\Scripts , where the language code depends on your context.

    When the import action is triggered, we also start standard logs on error mode that will go into the default folder:

    C:\Program Files\Dynamics 365\Trace

    If you can use findstr function on windows to find in what file that exception is, and then find what is the actual query that is throwing the error.

    Please let us know how that investigation goes, and if required, please open a ticket to Support.

    Thank you!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Blog subscriptions now enabled!

Follow your favorite blogs

TechTalk: How Dataverse and Microsoft Fabric powers ...

Explore the latest advancements in data export and integration within ...

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 283,860 Test role Public

#2
Ludwig Reinhard Profile Picture

Ludwig Reinhard Microsoft Employee

#3
Martin Dráb Profile Picture

Martin Dráb 225,155 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans