locked
UR10 Cannot Import Solution: duplicate key row in object 'dbo.DependencyNodeBase' RRS feed

  • 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
  • bump
    Friday, October 12, 2012 1:52 PM
  • Have also hit this issue and need to resolve urgently
    Friday, October 12, 2012 8:25 PM
  • I have the same issue after installing ru11
    Sunday, 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
  • 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