Skip to main content

Notifications

Microsoft Dynamics CRM (Archived)

On Premise V9 import failure

(0) ShareShare
ReportReport
Posted on by 4
I am trying to import my Organization into the Onpremise V9 update and I get and error trying to drop the constraint on the topicmodelbase table.

*This post is locked for comments

  • Suggested answer
    indlad Profile Picture
    indlad 450 on at
    RE: On Premise V9 import failure

    Hi CRMDevPL,

                 If you have the Dynamics 365 version 9.0.2 or above , this issue will not happen. But if you have run the Import on the Database and the Import failed, you need restore the database before the Import failure occurred as the Import will make changes to the database and doesn't roll back if the Import fails. So if you have database from 8.2.xx and you installed Dynamics 365 9.0.2 or above the Import will successed.

    Daniel.

  • CRMDevPL Profile Picture
    CRMDevPL 40 on at
    RE: On Premise V9 import failure

    Was this import issue ever resolved?  

  • Suggested answer
    Javeds Profile Picture
    Javeds 30 on at
    RE: On Premise V9 import failure

    www.microsoft.com/.../confirmation.aspx

  • Suggested answer
    Javeds Profile Picture
    Javeds 30 on at
    RE: On Premise V9 import failure

    Here You go-

    www.microsoft.com/.../confirmation.aspx

  • Suggested answer
    Javeds Profile Picture
    Javeds 30 on at
    RE: On Premise V9 import failure

    Guys -- Try you luck with this release

    www.microsoft.com/.../confirmation.aspx

  • Javeds Profile Picture
    Javeds 30 on at
    RE: On Premise V9 import failure

    Even 0.3 patch didn't work...

    I have open case with MSP let see what they reply on this...

  • Charles Lafleur Profile Picture
    Charles Lafleur 5 on at
    RE: On Premise V9 import failure

    In case it could help, here is a link to Dynamics 365 V9.0.3.0007

    www.microsoft.com/.../details.aspx

  • Verified answer
    indlad Profile Picture
    indlad 450 on at
    RE: On Premise V9 import failure

    To fix this issue request hotfix from Microsoft for V9 with version number 9.0.2.4010.

    OR

    Take backup of your organization Database

    run the following script and drop all the Constraints from the tables.

    IF OBJECT_ID('tempdb..#DropForeignKeysStatement') IS NOT NULL DROP TABLE #DropForeignKeysStatement

    SELECT DropStatement = 'ALTER TABLE [dbo].[' + st.name + '] DROP CONSTRAINT [' + sfk.name + ']'

       INTO #DropForeignKeysStatement

       FROM sys.foreign_keys sfk

       INNER JOIN sys.tables st ON sfk.parent_object_id = st.object_id

           AND sfk.schema_id = st.schema_id

       WHERE sfk.schema_id = schema_id('dbo')

    SELECT DropStatement FROM #DropForeignKeysStatement

    DECLARE dropStatementCursor CURSOR FOR

       (SELECT DropStatement FROM #DropForeignKeysStatement);

    OPEN dropStatementCursor;

    DECLARE @currentStatement NVARCHAR(max);

    FETCH NEXT FROM dropStatementCursor INTO @currentStatement;

    WHILE @@FETCH_STATUS = 0

    BEGIN

       EXEC sp_executesql @currentStatement;

       FETCH NEXT FROM dropStatementCursor INTO @currentStatement;

    END

    CLOSE dropStatementCursor;

    DEALLOCATE dropStatementCursor;

    IF OBJECT_ID('tempdb..#DropForeignKeysStatement') IS NOT NULL DROP TABLE #DropForeignKeysStatement

    Re-import your organization. During the import process, these deleted constraints will be added back.

  • Steeve G Profile Picture
    Steeve G on at
    RE: On Premise V9 import failure

    a quick question, topics.... tables error are not in full text search. Why do we need to deactivate Full Text Search and why should I wait 24 hours?

  • awalters Profile Picture
    awalters 3,079 on at
    RE: On Premise V9 import failure

    This was the advice given to me last upgrade (note: I didn't do it this way this time, so can't vouch, but seems like it should still work):  community.dynamics.com/.../201943

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,162 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,962 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans