slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Administration Forums - Synchronization
Forum to discuss SalesLogix synchronization and remote database management. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to Synchronization | New Thread

View: Search:

Author

Thread: Note Insertion Error on newly cut remote

Steve Knowles
Posts: 657

Note Insertion Error on newly cut remote Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 03 Dec 07 3:52 PM

I have one user with a newly cut remote getting the following error when trying to Insert a note:

An unusual error has occurred when executing Insert:Not. Contact your system administrator. 0x1 @0: Function Insert:Note Exception: Exception EOleException: The Statement has been terminated. : Cannot Insert duplicate key row in object 'dbo.HISTORY' with unique index 'XPKHISTORY'
Exception Location: [0056D38C]{SalesLogix.exe}

He is the only user I know of gettting this error... He says he gets a similar error when trying to drop emails - I am assuming on the history grid. Also to note, a table called dbo.history doesn't exist in the main db..

Has anyone else seen this? Any idea why it might happen and how to fix? Thanks

[Reply][Quote]

Jeff Weight
Posts: 219

Re: Note Insertion Error on newly cut remote Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 04 Dec 07 10:05 AM

Sounds like something is off in the sitekeys table. Probably the best thing you can do is cut a new remote for that user - that should solve the problem.

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/25/2024 6:35:03 PM