Act conversion

#11

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

#12

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

#13

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...&p_lva=125 37

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

Quote:

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.

Quote:

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

Quote:

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

Quote:

Submitted via EggHeadCafe - Software Developer Portal of Choice
Using ASP.NET Session with Silverlight and WCF Services
http://www.eggheadcafe.com/tutorials...-services.aspx

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Act conversion

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients

Re: Act conversion - 05-20-2008 , 04:36 AM

Re: Act conversion - 05-20-2008 , 04:36 AM

Re: Hi,Any luck with this issue? - 10-20-2010 , 10:18 AM