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!

Architect Forums - SalesLogix Scripting & Customization
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix Scripting & Customization | New Thread

View: Search:

Author

Thread: Error When Running A Customized Contact Process - getting Violation of PRIMARY KEY constraint error in Production only

Bailey1
Posts: 57

Error When Running A Customized Contact Process - getting Violation of PRIMARY KEY constraint error in Production only Your last visit to this thread was on 1/1/1970 12:00:00 AM

Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 20 Aug 08 8:19 AM

I created a contact process that will automatically create 2 To-Do activities for a group of contacts. Step 3 is a call to a Basic script (we are on SLX ver 6.1.3) to update the Activity and User Activity records so that the owner of the activity = owner of the Contact. I needed to do this because the Contact Process will add the 2 new To-Do activities, but the activities will be assigned to the Process Owner instead of the Contact Owner as it should be. We have a Sales Support group that runs the process for the Sales Reps., so they are the process owner, but we want the activities assigned to the Sales Rep that owns the contact. This contact process works in both our development and staging environments, but I get an error when I run it in Production: "SQL Error updating User_Activity records. $$$ERROR : the statement has been terminated. Violation of PRIMARY KEY constraint 'PK_USER_ACTIVITY'. Cannot insert duplicate key in object 'USER_ACTIVITY'.

Does anyone have any ideas as to how I can fix this 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 © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 8/25/2025 1:09:49 AM