locked
Upgrade from CRM 2011 to CRM 2013 Error RRS feed

  • Question

  • Hello,

    We received the following error while upgrading CRM 2011 to CRM 2013

    The INSERT statement conflicted with the FOREIGN KEY constraint "solution_base_dependencynode". The conflict occurred in database "BlackWolfSoft_MSCRM", table "dbo.SolutionBase", column 'SolutionId'.

    and here is the trace log:

    [2014-01-02 10:11:48.251] Process:Microsoft.Crm.Setup.Server |Organization:00000000-0000-0000-0000-000000000000 |Thread:   11(ProgressPage-ProcessingMethod) |Category: Shared |User: 00000000-0000-0000-0000-000000000000 |Level: Verbose |ReqId:  | CrmDbConnection.Open  ilOffset = 0x2E

    >ConnectionString: Workstation ID=CRM.Microsoft.Crm.Setup.Server;Data Source=sql.wolfsol.com;Initial Catalog=BlackWolfSoft_MSCRM;Integrated Security=True;Min Pool Size=2;Connect Timeout=150

    [2014-01-02 10:11:48.251] Process:Microsoft.Crm.Setup.Server |Organization:00000000-0000-0000-0000-000000000000 |Thread:   11(ProgressPage-ProcessingMethod) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Verbose |ReqId:  | CrmDbConnection.ExecuteNonQuery  ilOffset = 0x24

    >if (not exists (select * from sys.types st join sys.schemas ss on st.schema_id = ss.schema_id where st.name = N'DependencyNodeInsertTable' and ss.name = N'dbo'))

    begin

                    create type dbo.DependencyNodeInsertTable AS TABLE

                    (

                                    DependencyNodeId uniqueidentifier,

                                    ObjectId uniqueidentifier,

                                    ComponentType int,

                                    TopSolutionId uniqueidentifier,

                                    BaseSolutionId uniqueidentifier,

                                    ParentId uniqueidentifier

                    )

    end

    [2014-01-02 10:11:48.251] Process:Microsoft.Crm.Setup.Server |Organization:00000000-0000-0000-0000-000000000000 |Thread:   11(ProgressPage-ProcessingMethod) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Verbose |ReqId:  | CrmDbConnection.InternalExecuteNonQuery  ilOffset = 0x11D

    >Query execution time: 0.0 seconds; database: BlackWolfSoft_MSCRM; Server:sql.wolfsol.com; command: if (not exists (select * from sys.types st join sys.schemas ss on st.schema_id = ss.schema_id where st.name = N'DependencyNodeInsertTable' and ss.name = N'dbo'))

    begin

                    create type dbo.DependencyNodeInsertTable AS TABLE

                    (

                                    DependencyNodeId uniqueidentifier,

                                    ObjectId uniqueidentifier,

                                    ComponentType int,

                                    TopSolutionId uniqueidentifier,

                                    BaseSolutionId uniqueidentifier,

                                    ParentId uniqueidentifier

                    )

    end.

    [2014-01-02 10:11:48.251] Process:Microsoft.Crm.Setup.Server |Organization:00000000-0000-0000-0000-000000000000 |Thread:   11(ProgressPage-ProcessingMethod) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Verbose |ReqId:  | CrmDbConnection.ExecuteNonQuery  ilOffset = 0x24

    >insert into DependencyNodeBase(DependencyNodeId, ObjectId, ComponentType, TopSolutionId, BaseSolutionId, ParentId)

    select DependencyNodeId, ObjectId, ComponentType, TopSolutionId, BaseSolutionId, ParentId from System.Data.DataTableReader


    [2014-01-02 10:11:48.266] Process:Microsoft.Crm.Setup.Server |Organization:00000000-0000-0000-0000-000000000000 |Thread:   11(ProgressPage-ProcessingMethod) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Info |ReqId:  | CrmDbConnection.InternalExecuteNonQuery  ilOffset = 0x8E

    >System.Data.SqlClient.SqlException (0x80131904): The INSERT statement conflicted with the FOREIGN KEY constraint "solution_base_dependencynode". The conflict occurred in database "BlackWolfSoft_MSCRM", table "dbo.SolutionBase", column 'SolutionId'.

    >The statement has been terminated.

    [2014-01-02 10:11:48.266] Process:Microsoft.Crm.Setup.Server |Organization:00000000-0000-0000-0000-000000000000 |Thread:   11(ProgressPage-ProcessingMethod) |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Verbose |ReqId:  | CrmDbConnection.InternalExecuteNonQuery  ilOffset = 0x8E

    >Query execution time: 0.0 seconds; database: BlackWolfSoft_MSCRM; Server:sql.wolfsol.com; command: insert into DependencyNodeBase(DependencyNodeId, ObjectId, ComponentType, TopSolutionId, BaseSolutionId, ParentId)

    select DependencyNodeId, ObjectId, ComponentType, TopSolutionId, BaseSolutionId, ParentId from System.Data.DataTableReader.

    [2014-01-02 10:11:48.266] Process:Microsoft.Crm.Setup.Server |Organization:53679a44-d942-4008-84ea-4bf62f55659d |Thread:   11(ProgressPage-ProcessingMethod) |Category: Platform |User: 00000000-0000-0000-0000-000000000000 |Level: Verbose |ReqId:  | ExecutionContext.OnErrorRequest  ilOffset = 0x51

    >ExecutionContext not in use (OnErrorRequest) for organization {53679A44-D942-4008-84EA-4BF62F55659D}

    [2014-01-02 10:16:38.811] Process:Microsoft.Crm.Setup.Server |Organization:00000000-0000-0000-0000-000000000000 |Thread:   39 |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Verbose |ReqId:  | CrmDbConnection.OnRefreshSettingsEvent  ilOffset = 0x5A

    >Query execution time threshold: 10 seconds.

    ==========

    The problem now:

    1 - That we don't have backup from the database

    2 - Using the Microsoft Dynamics CRM Deployment Manager, we can't upgrade the Organization again because the status of the database is Failed.

    Please Help!!!!!!!!!!!!!!! What to do to get CRM back online again, with CRM 2011 or CRM 2013 whatever.

    Thursday, January 2, 2014 8:24 AM

All replies

  • are you doing an in place upgrade or are you trying to import your 2011 DB into a 2013 install?

    I would recommend trying to import the 2011 org into a 2013 install

    Saturday, January 4, 2014 3:55 PM