Microsoft 1.2 to 3.0 Migration... SOS!

Hi All,

We're attempting to migrate a test enviroment, currently running Windows
2003 Enterprise Server and Microsoft CRM 1.2. During the upgrade advisor I
get a warning message stating the following:

Microsoft CRM Database

----------------------------------------------------------------------------------------
Warning: The Indexes on the Microsoft CRM database are not consistent with
Microsoft CRM 1.2 indexes
----------------------------------------------------------------------------------------

We've never did any customizations on the Microsoft CRM databases therefore
all indexes should be "out of the box" unless a hotfix messed with them.

I proceed with the installation anyways and get the following error during
installation.

Installation Error Message:

-----------------------------------------------------------------------------------------
Action Microsoft.Crm.Setup;Server.INstallDatabaseAction Failed. The Index
'ndx_entity_name' is dependent on column 'Name'. Alter Table Alter COLUMN
Name failed because one or more objects access this column.
-----------------------------------------------------------------------------------------

I'm assuming this is directly related to the warning I received during the
requirements check. I've tried removing the index 'ndx_entity_name' but
during another install attempt I get an error saying the index is missing...
Ugh!

Again, we never played nor changed any tables, indexes, or procedures within
the Microsoft CRM databases.

Any help would be greatly appreciated!

Thanks,

Frank
Sun Apr 09 14:28:14 CDT 2006

I have seen this before on one of my upgrades. I had to compare the table
that was having the problem with another clean 1.2 install and made the
proper structure/index changes before I did the upgrade. I have upgraded
all my clients, so you might want to post the table structure and indexes so
others can tell you what it should be.

Thanks,

Frank
Prosoft Systems



"Aphex3000" <Aphex3000@discussions.microsoft.com> wrote in message
news:D366F5DC-F998-4A31-B7B9-3D5CF6B19CDF@microsoft.com...
> Hi All,
>
> We're attempting to migrate a test enviroment, currently running Windows
> 2003 Enterprise Server and Microsoft CRM 1.2. During the upgrade advisor
> I
> get a warning message stating the following:
>
> Microsoft CRM Database
>
> ----------------------------------------------------------------------------------------
> Warning: The Indexes on the Microsoft CRM database are not consistent with
> Microsoft CRM 1.2 indexes
> ----------------------------------------------------------------------------------------
>
> We've never did any customizations on the Microsoft CRM databases
> therefore
> all indexes should be "out of the box" unless a hotfix messed with them.
>
> I proceed with the installation anyways and get the following error during
> installation.
>
> Installation Error Message:
>
> -----------------------------------------------------------------------------------------
> Action Microsoft.Crm.Setup;Server.INstallDatabaseAction Failed. The Index
> 'ndx_entity_name' is dependent on column 'Name'. Alter Table Alter COLUMN
> Name failed because one or more objects access this column.
> -----------------------------------------------------------------------------------------
>
> I'm assuming this is directly related to the warning I received during the
> requirements check. I've tried removing the index 'ndx_entity_name' but
> during another install attempt I get an error saying the index is
> missing...
> Ugh!
>
> Again, we never played nor changed any tables, indexes, or procedures
> within
> the Microsoft CRM databases.
>
> Any help would be greatly appreciated!
>
> Thanks,
>
>
>
>