Home | Forums | Contact | Search | Syndication  
 [login] [create account]   Monday, June 24, 2024 
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!
 Data & Imports Forums - SSIS/DTS
Forum to discuss using SQL SSIS or DTS to perform SalesLogix imports. View the code of conduct for posting guidelines.
Forums RSS Feed

 Back to Forum List | Back to SSIS/DTS | New ThreadView:  Search:  
 Author  Thread: Adapter error for SalesLogix in Scribe
Posts: 4
Adapter error for SalesLogix in ScribeYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 17 Feb 10 8:56 AM
I am currenlty using Scribe v.6.4 and saleslogix v7.5.1. The ongoing integration job which runs to get data from SQL DB(Source) to Saleslogix DB(target). I am getting this error message "An error occurred in the Adapter for SalesLogix: Validation for the field ACCOUNT.SECCODEID against the table SECCODE failed.
Value: #ERROR!". Because of this account and accountsummary tables seccodeid and accountmagerid value is updated as '#ERROR!'

Can anyone help me get it resolved?
Thanks in advance
Raul A. Chavez
Posts: 1300
Top 10 forum poster: 1300 posts
Re: Adapter error for SalesLogix in ScribeYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 18 Feb 10 9:45 AM
I haven't used Scribe that much lately, but as far as I recall, unless you are assigning an specific Owner and/or Account Manager, there is a way to set the default value.

Check how you are assigning this value, and if necessary set a default value (if you are assigning it via a lookup, maybe not all of the values are resolving, and as such you may need to catch the exceptions and assign to "Everyone").
 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 | Subscribe to the slxdeveloper.com Latest Article RSS feed
page cache (param): 6/24/2024 8:44:33 PM