CRM 2011 Import Wizard Pending RRS feed

  • Question

  • Hi.. I m having a weird issue.

    I m having CRM 4.,0 data base. I have installed CRM 2011 in to a new machine and installation went fine. i tried to import CRM 4.0 data base, and it detected old database. started mapping users.. and went fine.. But after few seconds it showed and error saying pending.

    I retried several times, and same issue, How can i solve this..?

    I m pasting the Log file here..



    17:17:22|  Error| Import Organization (Name=XXXXXXX, Id=d95cea3f-86b8-4c08-b680-231850199a86) failed with Exception:

    System.Data.SqlClient.SqlException (0x80131904): Cannot find the object 'fn_GetFormatStrings', because it does not 


    exist or you do not have permission.

       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 



       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 



       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 



       at Microsoft.Crm.Setup.Database.SharedDatabaseUtility.GrantReportingAccess(CrmDbConnection connection, String 



       at Microsoft.Crm.Setup.Database.DatabaseUtility.GrantReportingAccess(InstallDatabase database, String user)

       at Microsoft.Crm.Setup.Database.Helpers.GrantReportAccess(String user, String privReportingGroup, Guid 


    organizationId, Boolean replaceExistingUser)

       at Microsoft.Crm.Setup.Database.DatabaseUtility.grantAccessInternal(String sqlAccessGroup, String reportingGroup, 


    String privReportingGroup)

       at Microsoft.Crm.Setup.Database.DatabaseUtility.GrantAccess(String sqlAccessGroup, String reportingGroup, String 



       at Microsoft.Crm.Tools.Admin.ImportOrganizationInstaller.GrantAccessOnCrmSecurityGroups(Guid organizationId, 


    String sqlAccessGroupName, String reportingGroupName, String privilegedReportingGroupName)

       at Microsoft.Crm.Tools.Admin.ImportOrganizationInstaller.UpdateOUGroupsInDatabase(String sqlServerName, String 


    databaseName, Guid organizationId)

       at Microsoft.Crm.Tools.Admin.ImportOrganizationInstaller.ImportAndUpgrade(OrganizationInfo organizationInfo)

       at Microsoft.Crm.Tools.Admin.ImportOrganizationInstaller.Execute(Object obj)

    17:17:22|   Info| GetDBUpdateRevisionThresholdForServer(): Threshold = 583.

    Monday, May 23, 2011 2:36 PM

All replies

  • Hi Shajas,

                    Looks like a permission issue please ensure that the User has the right privileges in creating records in CRM. Please let me know the status of the issue.



    Vishnu Turlapati.


    Friday, May 27, 2011 6:31 PM
  • Hi Shujas,

    Make sure that the function exsist in Micrsoft Dynamics CRM Organizaiton database or the current use has appropriate permissions for the object. Follow steps for object exsistance verificaiton:

    1. Run SQL Server Management Studio

    2. In Object Explorer, Navigate to Micrsoft Dynamics CRM Organizaiton database i.e. if my Organization name is contoso then it will be Contoso_MSCRM

    3. Expand database node and navigate to Programmability->Funcitons->Table-valued Functions

    4. Check if function "dbo.fn_GetFormatStrings" exsists

    5. if it exsist then in Object Expplorer navigate to node Securiety->Logins 

    6. Double click on the current logged int user

    7. In Server Roles options make sure user have Server Admin securiety privillages

    8. In Suer Mapping make sure user have been assigned db_owner, ddl admin and dataacessadmin role for Microsoft Dynamics CRM database.

    I hope this helps.

    Thank You,
    Jehanzeb Javeed,
    Linked-In Profile |CodePlex Profile

    If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".
    Saturday, May 28, 2011 10:23 AM