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.
