Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Upgrade issues 3.0 to 4.0 RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

     

    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