locked
CRM 2011 Import Organization - Error RRS feed

  • Question

  • Hi,

         I have created a new data base and restore some CRM data to that database. Then i try for import option in CRM 2011 while do so i am getting the following error:

     

    Kindly guide me to resolve this issue!


    Cheers : Jeriesh
    Friday, November 11, 2011 9:45 AM

All replies

  • Hi,

    R u doing this using deployment manager ?

     


    Thanks & Regards, MS CRM Consultant, V.Surya.
    Friday, November 11, 2011 11:31 AM
    Answerer
  •  

     

    Hi,

         Yes, I am doing this using deployment manager->organizations->import organization

    kindly suggest me to resolve the issue.."Delete" is the organization name(Display Name) that i am trying to create in CRM




    • Edited by Jeriesh Friday, November 11, 2011 1:10 PM f
    Friday, November 11, 2011 12:18 PM
  • Hi,

    Please stop the asynchronous services in services.msc and try to import the organization again and start the asynchronous services.

     


    Thanks & Regards, MS CRM Consultant, V.Surya.
    Friday, November 11, 2011 12:34 PM
    Answerer
  • Hi,

       I have stopped the asynchronous services in that also i am facing the same issue.Is there is any other solution to resolve this issue.

    I tried by disabling the asynchronous service and there also i am receiving the same error.

     

    Thanks in advance

    Jeriesh


    Cheers : Jeriesh
    • Edited by Jeriesh Friday, November 11, 2011 1:23 PM f
    Friday, November 11, 2011 1:09 PM
  • Hi,

        In event id i am receiving the following error:


    Cheers : Jeriesh
    Saturday, November 12, 2011 5:27 AM
  • Hi,

    Pl find the following link it will be helpful for you.

    http://msdn.microsoft.com/en-us/library/dd182005%28v=sql.100%29.aspx

    http://social.msdn.microsoft.com/Forums/is/sqlreportingservices/thread/30d1328d-afde-4dd3-8fc7-c30fb24c4780

     

     


    Thanks & Regards, MS CRM Consultant, V.Surya.
    Monday, November 14, 2011 6:11 AM
    Answerer
  • Hi,

         Here i am attaching the error log for this error:

    20:51:57|  Error| Error while updating organization information: System.Data.SqlClient.SqlException (0x80131904): The DELETE statement conflicted with the REFERENCE constraint "FK_BusinessUnitExtensionBase_BusinessUnitBase". The conflict occurred in database "Demo_MSCRM", table "dbo.BusinessUnitExtensionBase", column 'BusinessUnitId'.
    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.Tools.Admin.DBImportHelper.UpdateBusinessReferences(IDbCommand command)
       at Microsoft.Crm.Tools.Admin.ImportOrganizationInstaller.UpdateOrganizationInfo(Guid organizationId, OrganizationGroupsInfo organizationInfo, String organizationFriendlyName, String organizationUniqueName, Uri reportServerUrl, Int32 PercentUpdateOrganization, ICollection`1 users)

    20:52:10|  Error| Import Organization (Name=Demo, Id=19aaeb7c-9d0f-e111-84c5-00155d01650d) failed with Exception:
    System.Data.SqlClient.SqlException (0x80131904): The DELETE statement conflicted with the REFERENCE constraint "FK_BusinessUnitExtensionBase_BusinessUnitBase". The conflict occurred in database "Demo_MSCRM", table "dbo.BusinessUnitExtensionBase", column 'BusinessUnitId'.
    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.Tools.Admin.DBImportHelper.UpdateBusinessReferences(IDbCommand command)
       at Microsoft.Crm.Tools.Admin.ImportOrganizationInstaller.UpdateOrganizationInfo(Guid organizationId, OrganizationGroupsInfo organizationInfo, String organizationFriendlyName, String organizationUniqueName, Uri reportServerUrl, Int32 PercentUpdateOrganization, ICollection`1 users)
       at Microsoft.Crm.Tools.Admin.ImportOrganizationInstaller.Import(Guid organizationId, String organizationUniqueName, String organizationFriendlyName, String sqlServerName, String databaseName, Uri reportServerUrl, ICollection`1 users, MultipleTenancy multipleTenancy, Int32 partitionNumber, Int32 fullTextSearchLocaleId)

    20:52:10|  Error| Import Organization (Name=Demo, Id=19aaeb7c-9d0f-e111-84c5-00155d01650d) failed with Exception:
    System.Data.SqlClient.SqlException (0x80131904): The DELETE statement conflicted with the REFERENCE constraint "FK_BusinessUnitExtensionBase_BusinessUnitBase". The conflict occurred in database "Demo_MSCRM", table "dbo.BusinessUnitExtensionBase", column 'BusinessUnitId'.
    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.Tools.Admin.DBImportHelper.UpdateBusinessReferences(IDbCommand command)
       at Microsoft.Crm.Tools.Admin.ImportOrganizationInstaller.UpdateOrganizationInfo(Guid organizationId, OrganizationGroupsInfo organizationInfo, String organizationFriendlyName, String organizationUniqueName, Uri reportServerUrl, Int32 PercentUpdateOrganization, ICollection`1 users)
       at Microsoft.Crm.Tools.Admin.ImportOrganizationInstaller.Import(Guid organizationId, String organizationUniqueName, String organizationFriendlyName, String sqlServerName, String databaseName, Uri reportServerUrl, ICollection`1 users, MultipleTenancy multipleTenancy, Int32 partitionNumber, Int32 fullTextSearchLocaleId)

    09:50:50|  Error| Error while updating organization information: System.Data.SqlClient.SqlException (0x80131904): The DELETE statement conflicted with the REFERENCE constraint "FK_BusinessUnitExtensionBase_BusinessUnitBase". The conflict occurred in database "Demo_MSCRM", table "dbo.BusinessUnitExtensionBase", column 'BusinessUnitId'.
    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.Tools.Admin.DBImportHelper.UpdateBusinessReferences(IDbCommand command)
       at Microsoft.Crm.Tools.Admin.ImportOrganizationInstaller.UpdateOrganizationInfo(Guid organizationId, OrganizationGroupsInfo organizationInfo, String organizationFriendlyName, String organizationUniqueName, Uri reportServerUrl, Int32 PercentUpdateOrganization, ICollection`1 users)
    09:51:11|  Error| Import Organization (Name=Demo, Id=a1061b47-0a10-e111-84c5-00155d01650d) failed with Exception:
    System.Data.SqlClient.SqlException (0x80131904): The DELETE statement conflicted with the REFERENCE constraint "FK_BusinessUnitExtensionBase_BusinessUnitBase". The conflict occurred in database "Demo_MSCRM", table "dbo.BusinessUnitExtensionBase", column 'BusinessUnitId'.
    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.Tools.Admin.DBImportHelper.UpdateBusinessReferences(IDbCommand command)
       at Microsoft.Crm.Tools.Admin.ImportOrganizationInstaller.UpdateOrganizationInfo(Guid organizationId, OrganizationGroupsInfo organizationInfo, String organizationFriendlyName, String organizationUniqueName, Uri reportServerUrl, Int32 PercentUpdateOrganization, ICollection`1 users)
       at Microsoft.Crm.Tools.Admin.ImportOrganizationInstaller.Import(Guid organizationId, String organizationUniqueName, String organizationFriendlyName, String sqlServerName, String databaseName, Uri reportServerUrl, ICollection`1 users, MultipleTenancy multipleTenancy, Int32 partitionNumber, Int32 fullTextSearchLocaleId)

    09:51:13|  Error| Import Organization (Name=Demo, Id=a1061b47-0a10-e111-84c5-00155d01650d) failed with Exception:
    System.Data.SqlClient.SqlException (0x80131904): The DELETE statement conflicted with the REFERENCE constraint "FK_BusinessUnitExtensionBase_BusinessUnitBase". The conflict occurred in database "Demo_MSCRM", table "dbo.BusinessUnitExtensionBase", column 'BusinessUnitId'.
    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.Tools.Admin.DBImportHelper.UpdateBusinessReferences(IDbCommand command)
       at Microsoft.Crm.Tools.Admin.ImportOrganizationInstaller.UpdateOrganizationInfo(Guid organizationId, OrganizationGroupsInfo organizationInfo, String organizationFriendlyName, String organizationUniqueName, Uri reportServerUrl, Int32 PercentUpdateOrganization, ICollection`1 users)
       at Microsoft.Crm.Tools.Admin.ImportOrganizationInstaller.Import(Guid organizationId, String organizationUniqueName, String organizationFriendlyName, String sqlServerName, String databaseName, Uri reportServerUrl, ICollection`1 users, MultipleTenancy multipleTenancy, Int32 partitionNumber, Int32 fullTextSearchLocaleId)

     


    Cheers : Jeriesh

    • Edited by Jeriesh Wednesday, November 16, 2011 4:50 AM
    Wednesday, November 16, 2011 4:45 AM
  • Does this database successfully import in another isolated environment - or do you have trouble importing it anywhere?

    I got this error when my MSCRM_CONFIG and the organizational databases were out of sync. Another cause of this is when removing an old org the db is deleted before the organization is disabled/deleted through the CRM Deployment Manager MMC. I had two options, either restore synched copes of the MSCRM_CONFIG/Organizational DB's or doing an uninstall/reinstall of CRM and attempting to reimport the org.


    Michael Mayo
    Wednesday, November 16, 2011 4:50 PM
  • Hi,

       I tried the same thing in another server, While restoring database to another SQL server there is no error.But, when trying to import organization in crm deployment manager i am facing the same issue.I am restoring only the Organization_MSCRM and trying with import organization ..is it is right?How to try option one can you explain little so that i can make a try...

     

    Thanks in advance

    Jeriesh


    Cheers : Jeriesh
    Thursday, November 17, 2011 4:09 AM
  • If you tried on a different server, then you didn't have the incontinuity with MSCRM_CONFIG that I had.

    This thread
    http://social.microsoft.com/Forums/en-US/crmdeployment/thread/b8dfb946-bb02-4fb9-a92f-22ffb8b7071c/

    ...suggests a couple of things - from Pavel and Adrian.

    Sounds like you could give that a try.


    Michael Mayo
    Thursday, November 17, 2011 4:47 AM
  • I am getting above error while importing CRM 4.0 organization into CRM 2011 (different server) using deployment manager.

    Before doing import, i have taken backup of CRM 4.0 org_MSCRM database (SQL 2005) and restored into new SQL 2008 R2 server.

     

    Could not allocate the space for object
    • Edited by mssahasr Thursday, December 22, 2011 11:36 PM
    Thursday, December 22, 2011 11:19 PM
  • This is a bug in Deployment Manager.  When you add a custom attribute to BusinessUnitExtensionBase..problem seems to be depmgr is deleting the parent record in BusinessUnitBase before deleting the corresponding record in BusinessUnitExtensionBase.  Right now it has been reported.  The only workaround we have so far is to save off the custom attributes and any attribute you may have in BusinessUnitBase that is functionally unique. 

    1) Backup your custom attribute records along with a unique field in BusinessUnitBase

    2) Run your import org in Deployment manager

    3) Import the saved data back into BusinessUnitExtensionBase keying on what unique field you saved to get the new BusinessUnitID from BusinessUnitBase

    Import wizard changes the guids for BusinessUnitID when creating the new org.. so saving off the guids from the source tenant wont help.

    If msft support comes back with a better workaround, i will post here.

     

    Friday, January 6, 2012 4:01 PM