Act conversion

Daz

unread,

Aug 2, 2007, 2:22:02 AM8/2/07

to

Hi Im converting our Act 6 database to Act9 and I keep getting this error
right near the end of conversion.
Converting Notes and Histories...
The INSERT statement conflicted with the FOREIGN KEY constraint
"NOTE_CREATEUSERID_FK". The conflict occurred in database "MTA2008", table
"dbo.TBL_ACCESSOR", column 'ACCESSORID'.
The statement has been terminated.
I am a bit stuck with this error plz if anyone can help fix this would be
appreciated.
Thanks.

Hugo Kornelis

unread,

Aug 2, 2007, 2:43:46 PM8/2/07

to

Hi Daz,

A foreign key constraint implies that each value inserted in a specific
column or set of columns (in this case the column ACCESSORID in the
table dbo.TBL_ACCESSOR) has to be present in another table (the error
message doesn't tell us which table that is; you'll have to find out by
examining the constraint yourself).

You are getting this error message because, apparently, at least one of
the value you are trying to insert does not fulfill this requirement.

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

Robby angeles

unread,

May 20, 2008, 5:36:31 AM5/20/08

to

Hi,

Any luck with this issue? I know its been months but i hope you could
shed some light to this cause i've been stucked with the same issue for
hours now.

Thanks!

*** Sent via Developersdex http://www.developersdex.com ***

evan wake

unread,

Oct 20, 2010, 11:18:57 AM10/20/10

to

I found a solution for this issue that does not involve sending your Act Database out for repair.

The reason this error occurs is because there are corrupt records that have "Unknown User" as the Record Manager in the Notes/Activities. You can manually assign these to a user from selecting a user in the drop down box while in Act... or you can correct the entire database using Import/Export.

follow this link to create a clean version of your corrupt Act 6 database:

http://kb.sagesoftwareonline.com/cgi-bin/sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=11718&p_sid=e6HJOzck&p_lva=12537

***I strongly suggest creating a backup of your new database with the imported users before importing the entire corrupt database***

***Also, BEFORE importing the corrupt database to your new database...in the new database turn off duplicate checking. Edit ? Define Fields ? Advanced - Uncheck "Enable Duplicate Checking". If you do not do this, Act will incorrectly identify and merge non duplicate records***

***Also to keep in mind...when you import the corrupt database to the new databse, any record where the Record Manager has "Unknown User" the unknown user will be replaced with the name of the user who is performing the import. So, log in as the most appropriate user when performing the import.

> On Thursday, August 02, 2007 2:22 AM Da wrote:

> Hi Im converting our Act 6 database to Act9 and I keep getting this error
> right near the end of conversion.
> Converting Notes and Histories...
> The INSERT statement conflicted with the FOREIGN KEY constraint
> "NOTE_CREATEUSERID_FK". The conflict occurred in database "MTA2008", table
> "dbo.TBL_ACCESSOR", column 'ACCESSORID'.
> The statement has been terminated.
> I am a bit stuck with this error plz if anyone can help fix this would be
> appreciated.
> Thanks.

>>> Submitted via EggHeadCafe - Software Developer Portal of Choice
>>> Using ASP.NET Session with Silverlight and WCF Services
>>> http://www.eggheadcafe.com/tutorials/aspnet/c72cc77a-bf84-4180-a35b-46b8726ab782/using-aspnet-session-with-silverlight-and-wcf-services.aspx