Community
Showing results for 
Search instead for 
Do you mean 
Reply

Conversion Problem

Tuned Listener
Posts: 29
Country: USA

Re: Conversion Problem

I hate to ask a stupid question but what is ACTDIAG Maintenance that everyone references on these postings? I've done the database compress & reindex but am not sure what this other step is. I am trying to convert from ACT5 to ACT 2007, and keep getting an Error 3 statement about not being able to find the file path. Thanks.
Platinum Elite Contributor
Posts: 14,524
Country: Australia

Re: Conversion Problem

New Member
Posts: 2
Country: Canada

Re: Conversion Problem

I'm having the same issue, I've done both compress/reindex and a scan and repair in ACTDIAG... no luck.  Besides spending another $150 on Redflag, does anyone have another suggestions I could try?

 

 

Platinum Elite Contributor
Posts: 14,524
Country: Australia

Re: Conversion Problem

You could try this ACT! Knowledge Base article - http://tinyurl.com/3jq86u

 

Redflag or having a someone do a database repair are the only other options

Tuned Listener
Posts: 58
Country: United Kingdom

Re: Conversion Problem

[ Edited ]

Now then folks,

I have come across this problem a couple of times before. I agree with Mike that it is indeed a problem with the database. Try the following:

 

1. Open up your ACT! 6 database in ACT! 6. 

2. Make an empty copy of your database (http://tinyurl.com/6axdfm)

3. Login to the empty copy and import the contacts from your original database (http://tinyurl.com/6ynsfp) 

4. Now try to convert the *new* database

 

Using this method however will not retain the record manager so you might want to carry out the steps described in the knowledgebase article below *instead* of doing step 3

 

http://tinyurl.com/retainrm 

 

Kind regards,

Cesc 

Message Edited by CrazyCesc4 on 07-05-2008 03:42 PM
New Member
Posts: 2
Country: Canada

Re: Conversion Problem


CrazyCesc4 wrote:

Now then folks,

I have come across this problem a couple of times before. I agree with Mike that it is indeed a problem with the database. Try the following:

 

1. Open up your ACT! 6 database in ACT! 6. 

2. Make an empty copy of your database (http://tinyurl.com/6axdfm)

3. Login to the empty copy and import the contacts from your original database (http://tinyurl.com/6ynsfp) 

4. Now try to convert the *new* database

 

Using this method however will not retain the record manager so you might want to carry out the steps described in the knowledgebase article below *instead* of doing step 3

 

http://tinyurl.com/retainrm 

 

Kind regards,

Cesc 

Message Edited by CrazyCesc4 on 07-05-2008 03:42 PM

Hello,

 

This is precisely what I ended up doing to get it to work. We decided to live with the incorrect record manager.

 

Thanks for the replies.

 

Grant

New Member
Posts: 3
Country: USA

Re: Conversion Problem

In regards to the error message

 


The INSERT statement conflicted with the FOREIGN KEY constraint "NOTE_CREATEUSERID_FK"  the conflict occurred in database "conv0703Contacts", table "dbo.TBL_ACCESSOR", column 'ACCESSORID'.  The statement has been terminated.

 

I am getting this error as well.  However, what I noticed is I seem to be getting this error after the conversion is finished, but not necessarily ended.  My conversion output confirms that all 50366 records of 50366 recs were converted as well as all users.  However, no  converted database can be found once I click ok on the error screen.  I am thinking this a problem with the conversion program, not our data.    We are converting from ACT 6.0 Build 6.0.0.679 to Act 10 Build 10.0.2.191.  

 

Does anyone have any more information about this ?  It is crucial that we keep all notes/histories with the correct record manager for all our data, so the export/import into a new database is not an option.  

 

If RedFlag is the only answer, what does RedFlag do that an actdiag - scan and repair would not do ?  Especially,  if this is a problem with the conversion program,  and not the data.

 

Thanks for any help here. 

Platinum Elite Contributor
Posts: 14,524
Country: Australia

Re: Conversion Problem


aadams wrote:

In regards to the error message

 


The INSERT statement conflicted with the FOREIGN KEY constraint "NOTE_CREATEUSERID_FK"  the conflict occurred in database "conv0703Contacts", table "dbo.TBL_ACCESSOR", column 'ACCESSORID'.  The statement has been terminated.

 

I am getting this error as well.  However, what I noticed is I seem to be getting this error after the conversion is finished, but not necessarily ended.  My conversion output confirms that all 50366 records of 50366 recs were converted as well as all users.  However, no  converted database can be found once I click ok on the error screen.  I am thinking this a problem with the conversion program, not our data.    We are converting from ACT 6.0 Build 6.0.0.679 to Act 10 Build 10.0.2.191.  

I would always recommended doing the data repair with ACT! 6.03 and ACTDIAG 6.03

Does anyone have any more information about this ?  It is crucial that we keep all notes/histories with the correct record manager for all our data, so the export/import into a new database is not an option.  

 

If RedFlag is the only answer, what does RedFlag do that an actdiag - scan and repair would not do ?  Especially,  if this is a problem with the conversion program,  and not the data.

 These errors are always issues with the data.

Thanks for any help here. 


 

New Member
Posts: 3
Country: USA

Re: Conversion Problem

Mike, Thanks for  your help.  Per the  ACT  Downloads and Updates page at  http://www.act.com/support/updates/index.cfm?show_downloads=true&product=1&version=10&locale=6

 

The only download I see here is the ACT 6.0.2 Update.  I do not see any options to download ACT! 6.03 nor ACTDIAG 6.03.  Do you know of another  location where I may find this ?  After I applied the the ACT 6.0.2 Update,  the ACTDIAG vers still shows 6.00.   I checked the  ACTDIAG about info, just in case there was  an ACTDIAG update within the ACT 6.0.2 Update.

 

Thanks Again!

Platinum Elite Contributor
Posts: 14,524
Country: Australia

Re: Conversion Problem