Act conversion

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 ***
 >> Stay informed about: Act conversion 

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/en...er/std_

***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.


>> On Thursday, August 02, 2007 2:43 PM Hugo Kornelis wrote:

>> On Wed, 1 Aug 2007 23:22:02 -0700, Daz wrote:
>>
>>
>> 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


>>> On Tuesday, May 20, 2008 5:36 AM Robby angeles wrote:

>>> 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 ***


>>> 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-46...26ab782
 >> Stay informed about: Act conversion