Business Contact Manager import error

Hi All.

I'm using the new Data Migration Pack for Microsoft Dynamics CRM
3.0. to import data from Microsoft Business Contact Manager into a new,
clean, CRM 3.0 system.

The import is failing, and I don't know why. I get as far as Map Users > Map
Territories > Mapping Summary. When I click 'Configure' the migration stops
with an unexpected error. I've included an extract of the activity log below,
which shows more details. Any help or suggestions would be greatly
appreciated!

R

28/03/2006 11:38:11------>Next Screen Request: From ConfigurationSummary
screen To ConfigureCRM screen
28/03/2006 11:38:12------>Initializing CDF database...
28/03/2006 11:38:22------>Resolving Outlook with Business Contact Manager
configuration IDs to Microsoft CRM
28/03/2006 11:38:22------>Application Terminated: Unable to write into CDF
database.
28/03/2006 11:38:22------>Application Terminated: Unable to resolve CDF
database IDs

RussC
Tue Mar 28 12:01:01 CST 2006

I think I've fixed my own problem!
It was a stinker, so I'll post the solution. It was to do with collation
settings on the CDF_EntityIDMap table in the cdf_mscrm database. The varchar
columns in that table had a non-default collation setting, which caused the
errors described below.

My fix, which is working so far (I'm still watching the progress bar on the
wizard while I type, but it is importing accounts) is to use SQL Enterprise
Manager to design this table, edit each nvarchar column in turn and reset the
collation back to default.

There is a possibility this change will cause errors at later stages. If
this happens, I'll have a go at removing the collation settings from every
varchar field in all of the affected databases. If that fails, I'll be back
on here!

R


"RussC" wrote:

> Hi All.
>
> I'm using the new Data Migration Pack for Microsoft Dynamics CRM
> 3.0. to import data from Microsoft Business Contact Manager into a new,
> clean, CRM 3.0 system.
>
> The import is failing, and I don't know why. I get as far as Map Users > Map
> Territories > Mapping Summary. When I click 'Configure' the migration stops
> with an unexpected error. I've included an extract of the activity log below,
> which shows more details. Any help or suggestions would be greatly
> appreciated!
>
> R
>
> 28/03/2006 11:38:11------>Next Screen Request: From ConfigurationSummary
> screen To ConfigureCRM screen
> 28/03/2006 11:38:12------>Initializing CDF database...
> 28/03/2006 11:38:22------>Resolving Outlook with Business Contact Manager
> configuration IDs to Microsoft CRM
> 28/03/2006 11:38:22------>Application Terminated: Unable to write into CDF
> database.
> 28/03/2006 11:38:22------>Application Terminated: Unable to resolve CDF
> database IDs
>

lapointe
Mon Apr 10 15:46:23 CDT 2006

Hi!

I got the same issue as you and I did your fix but now i'm getting
this:=
4/10/2006 4:38:47 PM------>Next Screen Request: From
ConfigurationSummary screen To ConfigureCRM screen
4/10/2006 4:38:48 PM------>Initializing CDF database...
4/10/2006 4:39:13 PM------>Resolving Outlook with Business Contact
Manager configuration IDs to Microsoft CRM
4/10/2006 4:39:13 PM------>Reading transactional data...
4/10/2006 4:39:15 PM------>Application Terminated: Unable to read data
from Outlook with Business Contact Manager.

Any idea why?

Thanks

RussC
Tue Apr 11 03:12:01 CDT 2006

I've not seen that specific error before, but the technique I used was as
follows:

1) Run SQL Profiler to trace the SQL statements issued by the import wizard.
I recall that the application name contained '.net' which might be an easy
way to filter the trace, but I just traced all activity.

2) Start the import wizard

3) Within about 3 seconds of the wizard erroring, pause the trace in SQL
Profiler and inspect the recent SQL statements. Try to run any suspect
statements against the cdf_mscrm or BCM databases using query analyser. If
you get a SQL Error (other than 'object not found', which would indicate the
query is being run against the wrong db), then this is likely to be the real
error.

I found I had some issues with specific BCM data records, which was causing
some of the complex string manipulation in the wizard's queries to fail. I
simply deleted the offending rows from my BCM database. Looking at your
error, you could have a similar issue.

Good Luck!

R.

"lapointe.eric@gmail.com" wrote:

> Hi!
>
> I got the same issue as you and I did your fix but now i'm getting
> this:=
> 4/10/2006 4:38:47 PM------>Next Screen Request: From
> ConfigurationSummary screen To ConfigureCRM screen
> 4/10/2006 4:38:48 PM------>Initializing CDF database...
> 4/10/2006 4:39:13 PM------>Resolving Outlook with Business Contact
> Manager configuration IDs to Microsoft CRM
> 4/10/2006 4:39:13 PM------>Reading transactional data...
> 4/10/2006 4:39:15 PM------>Application Terminated: Unable to read data
> from Outlook with Business Contact Manager.
>
> Any idea why?
>
> Thanks
>
>

AlessandroTiberti
Sun Apr 16 06:06:01 CDT 2006

Hi Russ!

I've got the perfect same error but I'm not much into SQL so I don't know
how to apply what you say. could you please give me some
detailed/Stepp-by-step infos?

I'm using outlook with bcm, latest patches, italian localization on the
client side, sql 2000 standard edition sp4 and crm 3.0 on the server side
(always italian loc.); all of the products are correctly licensed (we've got
a MAPS subscription and I received the CRM 3.0 disks last week).

Thank you,
Alessandro

PS: I tried to do it myself looking for sql 2000 collation on google but I
understanding my SQL skills are too basic to understand what to do.


"RussC" ha scritto:

> I think I've fixed my own problem!
> It was a stinker, so I'll post the solution. It was to do with collation
> settings on the CDF_EntityIDMap table in the cdf_mscrm database. The varchar
> columns in that table had a non-default collation setting, which caused the
> errors described below.
>
> My fix, which is working so far (I'm still watching the progress bar on the
> wizard while I type, but it is importing accounts) is to use SQL Enterprise
> Manager to design this table, edit each nvarchar column in turn and reset the
> collation back to default.
>
> There is a possibility this change will cause errors at later stages. If
> this happens, I'll have a go at removing the collation settings from every
> varchar field in all of the affected databases. If that fails, I'll be back
> on here!
>
> R
>
>
> "RussC" wrote:
>
> > Hi All.
> >
> > I'm using the new Data Migration Pack for Microsoft Dynamics CRM
> > 3.0. to import data from Microsoft Business Contact Manager into a new,
> > clean, CRM 3.0 system.
> >
> > The import is failing, and I don't know why. I get as far as Map Users > Map
> > Territories > Mapping Summary. When I click 'Configure' the migration stops
> > with an unexpected error. I've included an extract of the activity log below,
> > which shows more details. Any help or suggestions would be greatly
> > appreciated!
> >
> > R
> >
> > 28/03/2006 11:38:11------>Next Screen Request: From ConfigurationSummary
> > screen To ConfigureCRM screen
> > 28/03/2006 11:38:12------>Initializing CDF database...
> > 28/03/2006 11:38:22------>Resolving Outlook with Business Contact Manager
> > configuration IDs to Microsoft CRM
> > 28/03/2006 11:38:22------>Application Terminated: Unable to write into CDF
> > database.
> > 28/03/2006 11:38:22------>Application Terminated: Unable to resolve CDF
> > database IDs
> >

Marco
Sun Apr 16 12:05:02 CDT 2006



"Alessandro Tiberti" wrote:
> I've got the perfect same error ...
>
> I'm using outlook with bcm, latest patches, italian localization on the
> client side, sql 2000 standard edition sp4 and crm 3.0 on the server side
> (always italian loc.); all of the products are correctly licensed (we've got
> a MAPS subscription and I received the CRM 3.0 disks last week).

I'm in the same situation as Alessandro and I too have Italian loc. of all
the items that Alessandro said. Could it be an Italian loc. trouble?
Alessandro let's keep in touch if any of us finds the solution.

Bye

Marco

AlessandroTiberti
Mon Apr 17 19:41:02 CDT 2006

Marco,

I tried to contact the small business+ support: as I microsoft certified
small business psecialist I had some free support (which usaually is not for
free) but they told me they don't support Microsoft Dynamics CRM 3.0 (!) and
pointed me to another page. But there's no free support unless you are a
microsoft business solutions partner.

So our only hope to solve this issue without paying is to wait for someone
to answer here or open a ticket paying for it and then having the cash back
if Microsoft discovers that the problem is due to some product-related
error...

In the meanwhile I'll try to ask some friends who are much more expert about
SQL than I am if they know something more about SQL collate... I'll let you
know if I discover something.

saluti,
Alessandro

"Marco" wrote:

>
>
> "Alessandro Tiberti" wrote:
> > I've got the perfect same error ...
> >
> > I'm using outlook with bcm, latest patches, italian localization on the
> > client side, sql 2000 standard edition sp4 and crm 3.0 on the server side
> > (always italian loc.); all of the products are correctly licensed (we've got
> > a MAPS subscription and I received the CRM 3.0 disks last week).
>
> I'm in the same situation as Alessandro and I too have Italian loc. of all
> the items that Alessandro said. Could it be an Italian loc. trouble?
> Alessandro let's keep in touch if any of us finds the solution.
>
> Bye
>
> Marco

pippobaccello
Tue Apr 18 02:28:10 CDT 2006

Ok Alessandro, let's keep reciprocally update.
Funny to speak english being both italian!

bye for now

Rick
Tue Apr 18 13:16:00 CDT 2006

Guys,
I'm having this issue with French Canadian localization + French
collation on the sql server 2k/SP4.
Let me know if you find something.
I'll post updates.

Marco
Thu Apr 20 09:44:57 CDT 2006

I found in this newsgroup another person who has trouble with its
german loc.
Can it be something with the european date system, that's different
from the US one?

Marco
Thu Apr 20 10:17:22 CDT 2006

this is the link
http://groups.google.it/group/microsoft.public.de.crm/browse_frm/thread/3473e9678c6f2bbf/f129b1b6e7ec6169?lnk=raot&hl=it#f129b1b6e7ec6169
bye

LarsD
Sat Apr 29 13:21:02 CDT 2006

Hi all!

I had exactly the same problem in Sweden, but i changed the collation like
RussC.
In database: cdf_mscrm, table: cdf_EntityIdMap, there is 3 columns with
collation SQL_Latin1_General_CP1_CI_AS.
I changed the collation to Finnish_Swedish_CI_AS then my migration worked.
The only thing i did was to execute the following script in Queryanalyser to
change collation:
---------------------
USE cdf_mscrm
GO
Alter table cdf_EntityIdMap alter column [sourceentityidvalue] nvarchar(255)
COLLATE Finnish_Swedish_CI_AS NULL
GO
Alter table cdf_EntityIdMap alter column [attributename] nvarchar(255)
COLLATE Finnish_Swedish_CI_AS NULL
GO
Alter table cdf_EntityIdMap alter column [targetentityidvalue] nvarchar(255)
COLLATE Finnish_Swedish_CI_AS NULL
GO
---------------------
Change "Finnish_Swedish_CI_AS" in the script to your local database
collation, then run your migration.

/Lars

"Marco" wrote:

> this is the link
> http://groups.google.it/group/microsoft.public.de.crm/browse_frm/thread/3473e9678c6f2bbf/f129b1b6e7ec6169?lnk=raot&hl=it#f129b1b6e7ec6169
> bye
>
>

Dorota
Thu May 11 06:01:01 CDT 2006

I have this same problem, but I try looking for errors - I have only one
error "Invalid object name". What errors you have?
Isn't it errors with language? (i'm from Poland).
I don't know how migrate records.

"RussC" wrote:

> I've not seen that specific error before, but the technique I used was as
> follows:
>
> 1) Run SQL Profiler to trace the SQL statements issued by the import wizard.
> I recall that the application name contained '.net' which might be an easy
> way to filter the trace, but I just traced all activity.
>
> 2) Start the import wizard
>
> 3) Within about 3 seconds of the wizard erroring, pause the trace in SQL
> Profiler and inspect the recent SQL statements. Try to run any suspect
> statements against the cdf_mscrm or BCM databases using query analyser. If
> you get a SQL Error (other than 'object not found', which would indicate the
> query is being run against the wrong db), then this is likely to be the real
> error.
>
> I found I had some issues with specific BCM data records, which was causing
> some of the complex string manipulation in the wizard's queries to fail. I
> simply deleted the offending rows from my BCM database. Looking at your
> error, you could have a similar issue.
>
> Good Luck!
>
> R.
>
> "lapointe.eric@gmail.com" wrote:
>
> > Hi!
> >
> > I got the same issue as you and I did your fix but now i'm getting
> > this:=
> > 4/10/2006 4:38:47 PM------>Next Screen Request: From
> > ConfigurationSummary screen To ConfigureCRM screen
> > 4/10/2006 4:38:48 PM------>Initializing CDF database...
> > 4/10/2006 4:39:13 PM------>Resolving Outlook with Business Contact
> > Manager configuration IDs to Microsoft CRM
> > 4/10/2006 4:39:13 PM------>Reading transactional data...
> > 4/10/2006 4:39:15 PM------>Application Terminated: Unable to read data
> > from Outlook with Business Contact Manager.
> >
> > Any idea why?
> >
> > Thanks
> >
> >

MikeD
Wed May 31 07:07:02 CDT 2006

Thanks RussC,

I opened database management studio and reset the collations and it works
fine.

Nice one

"RussC" wrote:

> I think I've fixed my own problem!
> It was a stinker, so I'll post the solution. It was to do with collation
> settings on the CDF_EntityIDMap table in the cdf_mscrm database. The varchar
> columns in that table had a non-default collation setting, which caused the
> errors described below.
>
> My fix, which is working so far (I'm still watching the progress bar on the
> wizard while I type, but it is importing accounts) is to use SQL Enterprise
> Manager to design this table, edit each nvarchar column in turn and reset the
> collation back to default.
>
> There is a possibility this change will cause errors at later stages. If
> this happens, I'll have a go at removing the collation settings from every
> varchar field in all of the affected databases. If that fails, I'll be back
> on here!
>
> R
>
>
> "RussC" wrote:
>
> > Hi All.
> >
> > I'm using the new Data Migration Pack for Microsoft Dynamics CRM
> > 3.0. to import data from Microsoft Business Contact Manager into a new,
> > clean, CRM 3.0 system.
> >
> > The import is failing, and I don't know why. I get as far as Map Users > Map
> > Territories > Mapping Summary. When I click 'Configure' the migration stops
> > with an unexpected error. I've included an extract of the activity log below,
> > which shows more details. Any help or suggestions would be greatly
> > appreciated!
> >
> > R
> >
> > 28/03/2006 11:38:11------>Next Screen Request: From ConfigurationSummary
> > screen To ConfigureCRM screen
> > 28/03/2006 11:38:12------>Initializing CDF database...
> > 28/03/2006 11:38:22------>Resolving Outlook with Business Contact Manager
> > configuration IDs to Microsoft CRM
> > 28/03/2006 11:38:22------>Application Terminated: Unable to write into CDF
> > database.
> > 28/03/2006 11:38:22------>Application Terminated: Unable to resolve CDF
> > database IDs
> >