Data Migration Problem

Hello,

i had just read the data migration frameworkguide, and i'm trying to migrate
data into the crm database.
But i have not the same entries in my cdf_Account_info table, but data is in
cdf_Account table present. What is working wrong?? log files are correct.

I hope someone can help me!

ali

Datapac
Fri Jan 14 05:03:03 CST 2005

Hi Ali,
This sometimes happens if the triggers on the cdf_Account table don't fire.
I'm not sure as to the reason behind this but you can manually update the
cdf_Account_info and cdf_Account_ext files with the AccountId from
cdf_Account.

Try use the following SQL:
Insert Into cdf_Account_info (AccountId) select AccountId from cdf_Account
Insert Into cdf_Account_ext (AccountId) select AccountId from cdf_Account

Hope this helps,
Richie
"ALI" wrote:

> Hello,
>
> i had just read the data migration frameworkguide, and i'm trying to migrate
> data into the crm database.
> But i have not the same entries in my cdf_Account_info table, but data is in
> cdf_Account table present. What is working wrong?? log files are correct.
>
> I hope someone can help me!
>
> ali

ALI
Fri Jan 14 07:07:02 CST 2005

Hello Datapac,

I get this message:

Server: Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_Account_ext'. Cannot insert
duplicate key in object 'cdf_Account_ext'.
The statement has been terminated.

I got the same message for the cdf_Account_info query!

what is wrong?

"Datapac" wrote:

> Hi Ali,
> This sometimes happens if the triggers on the cdf_Account table don't fire.
> I'm not sure as to the reason behind this but you can manually update the
> cdf_Account_info and cdf_Account_ext files with the AccountId from
> cdf_Account.
>
> Try use the following SQL:
> Insert Into cdf_Account_info (AccountId) select AccountId from cdf_Account
> Insert Into cdf_Account_ext (AccountId) select AccountId from cdf_Account
>
> Hope this helps,
> Richie
> "ALI" wrote:
>
> > Hello,
> >
> > i had just read the data migration frameworkguide, and i'm trying to migrate
> > data into the crm database.
> > But i have not the same entries in my cdf_Account_info table, but data is in
> > cdf_Account table present. What is working wrong?? log files are correct.
> >
> > I hope someone can help me!
> >
> > ali

ALI
Fri Jan 14 07:43:02 CST 2005

Hello Datapac,

it worked!!!

thank you for your help!!

"ALI" wrote:

> Hello Datapac,
>
> I get this message:
>
> Server: Msg 2627, Level 14, State 1, Line 1
> Violation of PRIMARY KEY constraint 'PK_Account_ext'. Cannot insert
> duplicate key in object 'cdf_Account_ext'.
> The statement has been terminated.
>
> I got the same message for the cdf_Account_info query!
>
> what is wrong?
>
> "Datapac" wrote:
>
> > Hi Ali,
> > This sometimes happens if the triggers on the cdf_Account table don't fire.
> > I'm not sure as to the reason behind this but you can manually update the
> > cdf_Account_info and cdf_Account_ext files with the AccountId from
> > cdf_Account.
> >
> > Try use the following SQL:
> > Insert Into cdf_Account_info (AccountId) select AccountId from cdf_Account
> > Insert Into cdf_Account_ext (AccountId) select AccountId from cdf_Account
> >
> > Hope this helps,
> > Richie
> > "ALI" wrote:
> >
> > > Hello,
> > >
> > > i had just read the data migration frameworkguide, and i'm trying to migrate
> > > data into the crm database.
> > > But i have not the same entries in my cdf_Account_info table, but data is in
> > > cdf_Account table present. What is working wrong?? log files are correct.
> > >
> > > I hope someone can help me!
> > >
> > > ali