locked
Upgrade issues 3.0 to 4.0 RRS feed

  • Question

  •  

    Hi Everyone

     

     

    I have issue with trying to upgrade from 3.0 to 4.0

     

    Error message i get  when trying to validate is

     

    The columns in the Microsoft Dynamics CRM database are not consistent with Microsoft Dynamics CRM 3.0 columns.  (red x)

    The stored procedures in the Crm database are not consistent with Crm 3.0 stored procedures. (!)

     

    0:41:45|Verbose| Connecting to database Data Source=CGL2006;Initial Catalog=Criterion_Furniture_Group_METABASE;Integrated Security=SSPI.
    10:41:45|Verbose| Connecting to database Data Source=CGL2006;Initial Catalog=Criterion_Furniture_Group_MSCRM;Integrated Security=SSPI.
    10:41:45|   Info| The following stored procedures are not consistent with Crm 3.0 stored procedures:
    10:41:45|Warning| remark:                                 added stored procedure
    10:41:45|Warning| sprocname:                              fn_getguidsfromstring
    10:41:45|Warning| 
    10:41:45|Warning| remark:                                 added stored procedure
    10:41:45|Warning| sprocname:                              p_grantaccessbulkforcreate
    10:41:45|Warning| 
    10:41:45|Warning| remark:                                 added stored procedure
    10:41:45|Warning| sprocname:                              p_grantaccessbulkforupdate
    10:41:45|Warning| 
    10:41:45|Warning| The stored procedures in the Crm database are not consistent with Crm 3.0 stored procedures.
    10:41:45|Warning| The stored procedures in the Crm database are not consistent with Crm 3.0 stored procedures.
    10:41:45|Warning| Check SqlStoredProcedureValidator : Warning: The stored procedures in the Crm database are not consistent with Crm 3.0 stored procedures.
    10:41:45|Verbose| Connecting to database Data Source=CGL2006;Initial Catalog=Criterion_Furniture_Group_METABASE;Integrated Security=SSPI.
    10:41:45|Verbose| Connecting to database Data Source=CGL2006;Initial Catalog=Criterion_Furniture_Group_MSCRM;Integrated Security=SSPI.

     

    I have gone in deleted  the second two but cant find fn_getguidsfromstring  (this was under the direction of ms support)

     

    Now i get the following from my logs

     

    10:01:19|   Info| Check SqlCollationValidator: Success
    10:01:19|Verbose| Connecting to database Data Source=CGL2006;Initial Catalog=Criterion_Furniture_Group_METABASE;Integrated Security=SSPI.
    10:01:19|Verbose| Connecting to database Data Source=CGL2006;Initial Catalog=Criterion_Furniture_Group_MSCRM;Integrated Security=SSPI.
    10:01:20|   Info| The following column(s) are not consistent with Microsoft Dynamics CRM 3.0 columns:
    10:01:20|  Error| remark:                                 deleted column
    10:01:20|  Error| tablename:                              accountextensionbase
    10:01:20|  Error| columnname:                             new_test
    10:01:20|  Error| 
    10:01:20|  Error| The columns in the Microsoft Dynamics CRM database are not consistent with Microsoft Dynamics CRM 3.0 columns.
    10:01:20|  Error| Check SqlColumnValidator : Failure: The columns in the Microsoft Dynamics CRM database are not consistent with Microsoft Dynamics CRM 3.0 columns.
    10:01:20|Verbose| Connecting to database Data Source=CGL2006;Initial Catalog=master;Integrated Security=SSPI

     

    Any help would be appreciated !!

    Sunday, May 11, 2008 2:03 AM

Answers