locked
Problems importing 4.0 organization to 2011 - SQL error on fn_GetFormatStrings RRS feed

  • Question

  • I am trying to migrate a CRM 4.0 installation to 2011, and keep banging against this wall. - After installing a fresh 2011 installation i try to import the 4.0 Organization, however i keep getting this error below, and the organization ends up with status "pending" and has not been converted to version 5.0. 15:02:25| Error| An error occurred when trying import and upgrade organization database SERVER\ORG_MSCRM: System.Data.SqlClient.SqlException (0x80131904): Cannot find the object 'fn_GetFormatStrings', because it does not exist or you do not have permission. I have done quite some reading and searching trying to get around this, and so far i have been pointed to triggers in the database (we have none) and sql-user permissions (i am the database owner, so no more permissions should be necessary). When i check in the database i cannot find fn_GetFormatStrings , so im not sure how to move on or what is really the cause of this.
    Friday, December 23, 2011 9:23 AM

All replies

  • I assume you may have done this already... best way is to make sure you are on the latest rollup of crm 4.0 before you attempt an import.

    What about an in place upgrade... does that throw same error as well during upgrade?

    Sam


    Web: http://www.inogic.com
    Blog: http://inogic.blogspot.com
    Email: news@inogic.com
    If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".
    Saturday, December 24, 2011 2:31 AM