Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
CRM 2011 Import Wizard Pending RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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 

     

    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.Setup.Database.SharedDatabaseUtility.GrantReportingAccess(CrmDbConnection connection, String 

     

    user)

       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 

     

    privReportingGroup)

       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

  • Question
    Sign in to vote
    1
    Sign in to vote

    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.

     

    Regards,

    Vishnu Turlapati.

    http://osmosee.wordpress.com

    Friday, May 27, 2011 6:31 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    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,
    http://worldofdynamics.blogspot.com
    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