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 !!