Data Migration Activities Fail and Error

We are running a rather large migration with 10,000 Accounts 50,000 Contacts
etc... and 250,000 Activities.

I am using the default migration order.

I go through all the setup steps for the cdf_ DB and kcik off the
Microsoft.Crm.DataMigration.CDFMigrationTool.exe. A handful of Accounts and
Contacts fail due to obvious data errors, but about 40,000 of the activities
fail (see bottom of this message for sample error) with only 60,000
attempted before it errors out with:

7/11/2004 - 2:08:38 AM -- ERROR:Unknown//Exception has been thrown by the
target of an invocation.

The it proceeds to migrate Annotations and 'complete' the migration process.

If I kick off the .exe again (making no changes or corrections) the same
Accounts and Contacts fail, some of the previously failed activiies
succeed - others continue to fail for no obvious reason and after attempting
about 50,000 activities it dies on the same error.

If I kick of the .exe yet again (3rd time here) the Account / Contact errors
are the same, but activities immediately fail with the
ERROR:Unknown//Exception has been thrown by the target of an invocation.
This now is identical any subsequent (4+) attempts.

So I have two problems:
(1) Why do seemingly fine activity records fail the first time and then
succeed the second
(2) What causes the Error Unkown... and what can I do to fix that?

Example of failed (1st Attempt) activity that succeeded on run #2:
7/11/2004 - 1:43:38 AM -- [ERROR] Failed to migrate object:
<description>Activity regarding object Id or type is
missing</description><details>CActivity::ValidateAccessToRegardingObject:
objectid doesn't match
objecttypecode</details><file>d:\crm\build\3297\src\platform\include\om\CRM\
Activity.inl</file><line>2513</line>
7/11/2004 - 1:43:38 AM --
<root><activity><StateCode>0</StateCode><owninguser>{8860F497-613E-4249-8C6D
-EE4F4827683C}</owninguser><activitytypecode>134</activitytypecode><billed>0
</billed><category>Ops/Marketing</category><isworkflowcreated>0</isworkflowc
reated><objecttypecode>1</objecttypecode><statuscode>0</statuscode><subject>
Residential Direct Mailer</subject></activity></root>

anna
Wed Jul 14 10:05:58 CDT 2004

The migration tool seems to fail if the load is too high,
i.e after so many records have been imported. One way to
get around this is to import an entity at a time and
leave the activities until last as they create activity
party records for each activity. You can run a sql trace
to see if you can optimise the clusters on the stored
procedures
>-----Original Message-----
>We are running a rather large migration with 10,000
Accounts 50,000 Contacts
>etc... and 250,000 Activities.
>
>I am using the default migration order.
>
>I go through all the setup steps for the cdf_ DB and
kcik off the
>Microsoft.Crm.DataMigration.CDFMigrationTool.exe. A
handful of Accounts and
>Contacts fail due to obvious data errors, but about
40,000 of the activities
>fail (see bottom of this message for sample error) with
only 60,000
>attempted before it errors out with:
>
>7/11/2004 - 2:08:38 AM -- ERROR:Unknown//Exception has
been thrown by the
>target of an invocation.
>
>The it proceeds to migrate Annotations and 'complete'
the migration process.
>
>If I kick off the .exe again (making no changes or
corrections) the same
>Accounts and Contacts fail, some of the previously
failed activiies
>succeed - others continue to fail for no obvious reason
and after attempting
>about 50,000 activities it dies on the same error.
>
>If I kick of the .exe yet again (3rd time here) the
Account / Contact errors
>are the same, but activities immediately fail with the
>ERROR:Unknown//Exception has been thrown by the target
of an invocation.
>This now is identical any subsequent (4+) attempts.
>
>So I have two problems:
>(1) Why do seemingly fine activity records fail the
first time and then
>succeed the second
>(2) What causes the Error Unkown... and what can I do to
fix that?
>
>Example of failed (1st Attempt) activity that succeeded
on run #2:
>7/11/2004 - 1:43:38 AM -- [ERROR] Failed to migrate
object:
><description>Activity regarding object Id or type is
>missing</description><details>CActivity::ValidateAccessTo
RegardingObject:
>objectid doesn't match
>objecttypecode</details><file>d:\crm\build\3297
\src\platform\include\om\CRM\
>Activity.inl</file><line>2513</line>
>7/11/2004 - 1:43:38 AM --
><root><activity><StateCode>0</StateCode><owninguser>
{8860F497-613E-4249-8C6D
>-EE4F4827683C}
</owninguser><activitytypecode>134</activitytypecode><bill
ed>0
></billed><category>Ops/Marketing</category><isworkflowcre
ated>0</isworkflowc
>reated><objecttypecode>1</objecttypecode><statuscode>0</s
tatuscode><subject>
>Residential Direct Mailer</subject></activity></root>
>
>
>
>
>
>
>
>
>
>
>.
>

Joe
Wed Jul 14 10:18:37 CDT 2004

Thanks. That seems to answer the first question... I can create a separate
migration just for activities. Anyone have any ideas on the second problem
where I get the Error Uknown???


"anna" <anonymous@discussions.microsoft.com> wrote in message
news:2c1b401c469b4$11cfb030$a601280a@phx.gbl...
> The migration tool seems to fail if the load is too high,
> i.e after so many records have been imported. One way to
> get around this is to import an entity at a time and
> leave the activities until last as they create activity
> party records for each activity. You can run a sql trace
> to see if you can optimise the clusters on the stored
> procedures
> >-----Original Message-----
> >We are running a rather large migration with 10,000
> Accounts 50,000 Contacts
> >etc... and 250,000 Activities.
> >
> >I am using the default migration order.
> >
> >I go through all the setup steps for the cdf_ DB and
> kcik off the
> >Microsoft.Crm.DataMigration.CDFMigrationTool.exe. A
> handful of Accounts and
> >Contacts fail due to obvious data errors, but about
> 40,000 of the activities
> >fail (see bottom of this message for sample error) with
> only 60,000
> >attempted before it errors out with:
> >
> >7/11/2004 - 2:08:38 AM -- ERROR:Unknown//Exception has
> been thrown by the
> >target of an invocation.
> >
> >The it proceeds to migrate Annotations and 'complete'
> the migration process.
> >
> >If I kick off the .exe again (making no changes or
> corrections) the same
> >Accounts and Contacts fail, some of the previously
> failed activiies
> >succeed - others continue to fail for no obvious reason
> and after attempting
> >about 50,000 activities it dies on the same error.
> >
> >If I kick of the .exe yet again (3rd time here) the
> Account / Contact errors
> >are the same, but activities immediately fail with the
> >ERROR:Unknown//Exception has been thrown by the target
> of an invocation.
> >This now is identical any subsequent (4+) attempts.
> >
> >So I have two problems:
> >(1) Why do seemingly fine activity records fail the
> first time and then
> >succeed the second
> >(2) What causes the Error Unkown... and what can I do to
> fix that?
> >
> >Example of failed (1st Attempt) activity that succeeded
> on run #2:
> >7/11/2004 - 1:43:38 AM -- [ERROR] Failed to migrate
> object:
> ><description>Activity regarding object Id or type is
> >missing</description><details>CActivity::ValidateAccessTo
> RegardingObject:
> >objectid doesn't match
> >objecttypecode</details><file>d:\crm\build\3297
> \src\platform\include\om\CRM\
> >Activity.inl</file><line>2513</line>
> >7/11/2004 - 1:43:38 AM --
> ><root><activity><StateCode>0</StateCode><owninguser>
> {8860F497-613E-4249-8C6D
> >-EE4F4827683C}
> </owninguser><activitytypecode>134</activitytypecode><bill
> ed>0
> ></billed><category>Ops/Marketing</category><isworkflowcre
> ated>0</isworkflowc
> >reated><objecttypecode>1</objecttypecode><statuscode>0</s
> tatuscode><subject>
> >Residential Direct Mailer</subject></activity></root>
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >.
> >