Asked by:
UR10 Cannot Import Solution: duplicate key row in object 'dbo.DependencyNodeBase'

Question
-
So after install UR10, version 2740 I can no longer import my solution. Here is the situation.
-Upgraded to UR10.
-Installed Unmanaged Solution on Integration Machine (Worked Fine)
-Add a few items to the Solution from a Dev Machine.
-Installed Unmanaged Solution again on Integration (Error)
I have check to ensure I don't actually have duplicate views in my solution entities and I have also checked the solution XML to determine if I have duplicates, which I do not. Any one have similar experience? I can also reproduce this by just importing the same unmanaged solution again without any changes.
>Web Service Plug-in failed in SdkMessageProcessingStepId: {1B830950-E106-4EE1-B3FD-D348CB65DC8D}; EntityName: none; Stage: 30; MessageName: ImportSolution; AssemblyName: Microsoft.Crm.Extensibility.InternalOperationPlugin, Microsoft.Crm.ObjectModel, Version=5.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35; ClassName: Microsoft.Crm.Extensibility.InternalOperationPlugin; Exception: Unhandled Exception: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. at System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at System.Web.Services.Protocols.LogicalMethodInfo.Invoke(Object target, Object[] values) at Microsoft.Crm.Extensibility.InternalOperationPlugin.Execute(IServiceProvider serviceProvider) at Microsoft.Crm.Extensibility.V5PluginProxyStep.ExecuteInternal(PipelineExecutionContext context) at Microsoft.Crm.Extensibility.VersionedPluginProxyStepBase.Execute(PipelineExecutionContext context) Inner Exception: Microsoft.Crm.Tools.ImportExportPublish.ImportGenericException: Import failed at Microsoft.Crm.Tools.ImportExportPublish.ImportXml.RunImport(String[] ImportEntities) at Microsoft.Crm.Tools.ImportExportPublish.ImportXml.RunImport() at Microsoft.Crm.WebServices.ImportXmlService.ImportSolution(Boolean overwriteUnmanagedCustomizations, Boolean publishWorkflows, Byte[] customizationFile, Guid importJobId, Boolean convertToManaged, ExecutionContext context) Inner Exception: System.Data.SqlClient.SqlException: Cannot insert duplicate key row in object 'dbo.DependencyNodeBase' with unique index 'ndx_DependencyObjectId'. The duplicate key value is (00000000-0000-0000-00aa-000000666000, 26). The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.Crm.CrmDbConnection.InternalExecuteWithRetry[TResult](Func`1 ExecuteMethod, IDbCommand command) at Microsoft.Crm.CrmDbConnection.InternalExecuteNonQuery(IDbCommand command, Boolean capturePerfTrace) at Microsoft.Crm.CrmDbConnection.ExecuteNonQuery(IDbCommand command, Boolean impersonate, Boolean capturePerfTrace) at Microsoft.Crm.BusinessEntities.SimpleBulkInserterWithType.Flush(ISqlExecutionContext context) at Microsoft.Crm.ObjectModel.DependencyHelperBase.BulkCreateDependencyNodes(BusinessEntityCollection nodesToCreate, ExecutionContext context) at Microsoft.Crm.Dependency.ComponentCollector.InitializeRecords(ExecutionContext context) at Microsoft.Crm.Dependency.ComponentCollector.ProcessRecords(ExecutionContext context) at Microsoft.Crm.BusinessEntities.ExecutionContext.ProcessDependencies(FlushCacheOption option, CreateNewCollectorOption createOption) at Microsoft.Crm.BusinessEntities.ExecutionContext.CommitTransaction(ProcessDependenciesOption option) at Microsoft.Crm.Tools.ImportExportPublish.RootImportHandler.RunImport(String[] ImportEntities) . [2012-10-10 12:35:59.573] Process: w3wp |Organization:e51394d0-aa30-e111-9144-c576a9089e0f |Thread: 3 |Category: Exception |User: 56bd0f6d-ab30-e111-9144-c576a9089e0f |Level: Error |ReqId: 8a7ffcd1-4d17-446b-b903-07aef0bdc676 | CrmException..ctor ilOffset = 0x0 at CrmException..ctor(String message, Exception innerException, Int32 errorCode, Boolean isFlowControlException) ilOffset = 0x0 at CrmException..ctor(String message, Exception innerException, Int32 errorCode) ilOffset = 0x0 at RuntimeMethodHandle._InvokeConstructor(IRuntimeMethodInfo method, Object[] args, SignatureStruct& signature, RuntimeType declaringType) ilOffset = 0xFFFFFFFF at RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) ilOffset = 0xD8 at RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes) ilOffset = 0x1E7 at VersionedPluginProxyStepBase.WrapExceptionToThrow(CrmException exception) ilOffset = 0xD3 at VersionedPluginProxyStepBase.Execute(PipelineExecutionContext context) ilOffset = 0x65 at Pipeline.Execute(PipelineExecutionContext context) ilOffset = 0x65 at MessageProcessor.Execute(PipelineExecutionContext context) ilOffset = 0x1C5 at InternalMessageDispatcher.Execute(PipelineExecutionContext context) ilOffset = 0xE4 at ExternalMessageDispatcher.ExecuteInternal(IInProcessOrganizationServiceFactory serviceFactory, IPlatformMessageDispatcherFactory dispatcherFactory, String messageName, String requestName, Int32 primaryObjectTypeCode, Int32 secondaryObjectTypeCode, ParameterCollection fields, CorrelationToken correlationToken, CallerOriginToken originToken, UserAuth userAuth, Guid callerId, Guid transactionContextId, Int32 invocationSource, Nullable`1 requestId, Version endpointVersion) ilOffset = 0x156 at OrganizationSdkServiceInternal.ExecuteRequest(OrganizationRequest request, CorrelationToken correlationToken, CallerOriginToken callerOriginToken, WebServiceType serviceType) ilOffset = 0x1E0 at OrganizationSdkServiceInternal.Execute(OrganizationRequest request, CorrelationToken correlationToken, CallerOriginToken callerOriginToken, WebServiceType serviceType) ilOffset = 0x24 at ilOffset = 0xFFFFFFFF at SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs) ilOffset = 0x226 at DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc) ilOffset = 0xE7 at ImmutableDispatchRuntime.ProcessMessage5(MessageRpc& rpc) ilOffset = 0x41 at ImmutableDispatchRuntime.ProcessMessage31(MessageRpc& rpc) ilOffset = 0xC6 at MessageRpc.Process(Boolean isOperationContextSet) ilOffset = 0x62 at ChannelHandler.DispatchAndReleasePump(RequestContext request, Boolean cleanThread, OperationContext currentOperationContext) ilOffset = 0x1D7 at ChannelHandler.HandleRequest(RequestContext request, OperationContext currentOperationContext) ilOffset = 0xF1 at ChannelHandler.AsyncMessagePump(IAsyncResult result) ilOffset = 0x21 at AsyncThunk.UnhandledExceptionFrame(IAsyncResult result) ilOffset = 0x0 at AsyncResult.Complete(Boolean completedSynchronously) ilOffset = 0xC2 at ReceiveItemAndVerifySecurityAsyncResult`2.InnerTryReceiveCompletedCallback(IAsyncResult result) ilOffset = 0x55 at AsyncThunk.UnhandledExceptionFrame(IAsyncResult result) ilOffset = 0x0 at AsyncResult.Complete(Boolean completedSynchronously) ilOffset = 0xC2 at AsyncQueueReader.Set(Item item) ilOffset = 0x21 at InputQueue`1.Dispatch() ilOffset = 0x121 at ScheduledOverlapped.IOCallback(UInt32 errorCode, UInt32 numBytes, NativeOverlapped* nativeOverlapped) ilOffset = 0x22 at IOCompletionThunk.UnhandledExceptionFrame(UInt32 error, UInt32 bytesRead, NativeOverlapped* nativeOverlapped) ilOffset = 0x5 at _IOCompletionCallback.PerformIOCompletionCallback(UInt32 errorCode, UInt32 numBytes, NativeOverlapped* pOVERLAP) ilOffset = 0x3C >Crm Exception: Message: Import failed, ErrorCode: -2147188706, InnerException: Microsoft.Crm.Tools.ImportExportPublish.ImportGenericException: Import failed ---> System.Data.SqlClient.SqlException: Cannot insert duplicate key row in object 'dbo.DependencyNodeBase' with unique index 'ndx_DependencyObjectId'. The duplicate key value is (00000000-0000-0000-00aa-000000666000, 26). The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.Crm.CrmDbConnection.InternalExecuteWithRetry[TResult](Func`1 ExecuteMethod, IDbCommand command) at Microsoft.Crm.CrmDbConnection.InternalExecuteNonQuery(IDbCommand command, Boolean capturePerfTrace) at Microsoft.Crm.CrmDbConnection.ExecuteNonQuery(IDbCommand command, Boolean impersonate, Boolean capturePerfTrace) at Microsoft.Crm.BusinessEntities.SimpleBulkInserterWithType.Flush(ISqlExecutionContext context) at Microsoft.Crm.ObjectModel.DependencyHelperBase.BulkCreateDependencyNodes(BusinessEntityCollection nodesToCreate, ExecutionContext context) at Microsoft.Crm.Dependency.ComponentCollector.InitializeRecords(ExecutionContext context) at Microsoft.Crm.Dependency.ComponentCollector.ProcessRecords(ExecutionContext context) at Microsoft.Crm.BusinessEntities.ExecutionContext.ProcessDependencies(FlushCacheOption option, CreateNewCollectorOption createOption) at Microsoft.Crm.BusinessEntities.ExecutionContext.CommitTransaction(ProcessDependenciesOption option) at Microsoft.Crm.Tools.ImportExportPublish.RootImportHandler.RunImport(String[] ImportEntities) --- End of inner exception stack trace --- at Microsoft.Crm.Tools.ImportExportPublish.ImportXml.RunImport(String[] ImportEntities) at Microsoft.Crm.Tools.ImportExportPublish.ImportXml.RunImport() at Microsoft.Crm.WebServices.ImportXmlService.ImportSolution(Boolean overwriteUnmanagedCustomizations, Boolean publishWorkflows, Byte[] customizationFile, Guid importJobId, Boolean convertToManaged, ExecutionContext context) [2012-10-10 12:35:59.576] Process: w3wp |Organization:e51394d0-aa30-e111-9144-c576a9089e0f |Thread: 3 |Category: Platform |User: 56bd0f6d-ab30-e111-9144-c576a9089e0f |Level: Error |ReqId: 8a7ffcd1-4d17-446b-b903-07aef0bdc676 | MessageProcessor.Execute ilOffset = 0x1C5 >MessageProcessor fail to process message 'ImportSolution' for 'none'. [2012-10-10 12:35:59.589] Process: w3wp |Organization:00000000-0000-0000-0000-000000000000 |Thread: 3 |Category: Platform |User: 00000000-0000-0000-0000-000000000000 |Level: Error |ReqId: 8a7ffcd1-4d17-446b-b903-07aef0bdc676 | ExceptionConverter.ConvertMessageAndErrorCode ilOffset = 0x23B >System.Data.SqlClient.SqlException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #C707912E: System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.DependencyNodeBase' with unique index 'ndx_DependencyObjectId'. The duplicate key value is (00000000-0000-0000-00aa-000000666000, 26). >The statement has been terminated. > at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) > at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() > at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) > at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) > at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) > at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) > at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) > at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() > at Microsoft.Crm.CrmDbConnection.InternalExecuteWithRetry[TResult](Func`1 ExecuteMethod, IDbCommand command) > at Microsoft.Crm.CrmDbConnection.InternalExecuteNonQuery(IDbCommand command, Boolean capturePerfTrace) > at Microsoft.Crm.CrmDbConnection.ExecuteNonQuery(IDbCommand command, Boolean impersonate, Boolean capturePerfTrace) > at Microsoft.Crm.BusinessEntities.SimpleBulkInserterWithType.Flush(ISqlExecutionContext context) > at Microsoft.Crm.ObjectModel.DependencyHelperBase.BulkCreateDependencyNodes(BusinessEntityCollection nodesToCreate, ExecutionContext context) > at Microsoft.Crm.Dependency.ComponentCollector.InitializeRecords(ExecutionContext context) > at Microsoft.Crm.Dependency.ComponentCollector.ProcessRecords(ExecutionContext context) > at Microsoft.Crm.BusinessEntities.ExecutionContext.ProcessDependencies(FlushCacheOption option, CreateNewCollectorOption createOption) > at Microsoft.Crm.BusinessEntities.ExecutionContext.CommitTransaction(ProcessDependenciesOption option) > at Microsoft.Crm.Tools.ImportExportPublish.RootImportHandler.RunImport(String[] ImportEntities) >ClientConnectionId:0a511a93-27bf-4b07-a021-5e0cf82a3914
Wednesday, October 10, 2012 4:51 PM
All replies
-
We've hit this issue too. Any thoughts from Microsoft would be appreciated.Thursday, October 11, 2012 9:22 AM
-
Update rollup 11 didn't provide a fix for this one. Newman! Anybody got anything?Thursday, October 11, 2012 6:14 PM
-
bumpFriday, October 12, 2012 1:52 PM
-
Have also hit this issue and need to resolve urgentlyFriday, October 12, 2012 8:25 PM
-
I have the same issue after installing ru11Sunday, October 14, 2012 9:48 PM
-
I Uninstalled RU11 (back to version 5.0.9690.2730) and Imported the solution without any problem. I think this is a problem with the rollup 11 which solution Microsoft has to publish urgently
Sunday, October 14, 2012 11:08 PM -
Monday, October 15, 2012 8:27 AM
-
Don't know if relevant but there seems to be extra metadata in UR11 export and the possiblity that installing UR11 did not actually update all org db structures. So check your org db in deployment manager and see if it's still on UR10, if so you may need to remove from deployment and re-add in order to get deployment manager to update the org version number. Could someone at Microsoft comment please?Monday, October 15, 2012 8:37 AM
-
We also crashed into this nice error.
Based on UR 10 v1 we installed the UR 11. => Could not import the solution zip file.
Uninstalling the ur 11 the import runns successfully.
I'm trying to install the UR 10 V2 after uninstalling UR 11 but this does not work. Missing file server.msi during installation
Monday, October 15, 2012 12:02 PM -
Microsoft Support just confirmed it as a bug in UR10V2 and UR11. They are working on a solution for this problem.Monday, October 15, 2012 4:43 PM
-
Thanks for the info.
- Edited by RWils Tuesday, October 16, 2012 1:05 PM
Monday, October 15, 2012 4:57 PM -
We are having the same issue since we installed UR10V2. I am scared to install UR11 now!!Tuesday, October 16, 2012 11:45 AM
-
Same issue here as well. These last 2 RU have included some pretty serious issues that one would think would have been caught during testing.
Hopefully the next RU will have some more comprehensive vetting before heading out the door.
This isn't leading to a lot of confidence in the Microsoft CRM team lately. :(
Tuesday, October 16, 2012 1:50 PM -
HI
Our Server was on RU 11 and our goal was to go back RU 8
I was able to de-install “RU 11” but “RU 10 v2” was not presented in Update list so we de-installed “RU 10”
Now:
CRM Deployment Manger, Organization view shows that Server is on version “RU 10 v2”
CRM Deployment Manger, Server view shows SQL on “RU 8” CRM on “RU 10”
Anyone knows how to get rid of “RU 10 v2” on the CRM Application Server?
Wednesday, October 17, 2012 11:45 AM -
Is there any update on this issue yet? We installed RUP10 V2 with out platform host yesterday and can't import solutions anymore since, either! Unbelievable how a re-release would have a new bug of this severity, Microsoft wake up please and solve this asap!Thursday, October 18, 2012 7:28 AM
-
I have a case opened with Microsoft right now, I'm going to contact them again today to see what is going on. If anyone want's to reference the case with MS it's 112101058725641.
--Rick
Thursday, October 18, 2012 12:51 PM -
Did Microsoft gave u already a workaround for this issue?
gruss Daniel Ovadia MBSS - Microsoft Dynamics CRM MCNPS
Monday, October 22, 2012 11:34 AM -
MS confirmed that this is an issue. They have put together a hotfix and are going to re-release UR11 to account for the error. I'm going to be testing the hotfix today.Monday, October 22, 2012 12:53 PM
-
Microsoft has now released version 2 of Microsoft Dynamics CRM 2011 Rollup 11 which includes a fix for this bug. (Note that version 2 is just released for server and client part of the Update Rollup 11 - all other CRM 2011 components continue working on Update Rollup 11 version 1)
http://www.microsoft.com/en-us/download/details.aspx?id=34969
- Proposed as answer by Daniel Ovadia Tuesday, October 23, 2012 7:50 AM
Tuesday, October 23, 2012 7:27 AM -
I installed the update yesterday on several box and was able to import my solutions successfully. If it breaks anything else I'll make sure to post it :)
- Proposed as answer by Daniel Ovadia Monday, March 2, 2015 3:11 PM
Tuesday, October 23, 2012 12:37 PM -
Hi,
It happened for me more or less the same after i delete system dashboards from production environment and imported to there with an un-managed solution with the dashboard in there.
Kind Regards,
Pedro Airo
Wednesday, October 24, 2012 8:19 AM -
We ran into the same issue with UR10 and UR10v2 and updated to UR11v2, now the CRMAppPool doesn't start after the system reboot. Running a repair installation fixes the issue until next reboot.
Any idea?
/Tom
Tuesday, November 20, 2012 8:23 AM -
We had the same problem with UR10 and UR10v2. After installing UR11v2 we've had no issues.Tuesday, November 20, 2012 1:25 PM
-
11v2 seemed to fix this issue for us. We're running in to another issue as documented in this thread which is preventing the CRM website from initializing. Maybe it will be the same thing you are seeing.
https://community.dynamics.com/product/crm/f/117/p/93178/178516.aspx
Tuesday, November 20, 2012 1:29 PM -
Yes, UR11v2 version 5.00.9690.2835 has the fix for it. We also have a hotfix over UR10 for this issue for those who do not want to install UR11 as of now but for that we need to open ticket with Microsoft which will be closed as No CHARGE.
Arpita
- Proposed as answer by Daniel Ovadia Monday, November 17, 2014 2:16 PM
Thursday, December 27, 2012 9:42 PM