Login / Register  search  syndication  about

SalesLogix Support

SalesLogix Cloud / Web / LAN Support Topics from Mark Duthoy

Updating the DB Manager to Lengthen Fields For SalesLogix Web Deployments

Recently we ran into a problems with a user adding products to an Account tab on the web client. The exact error was - The statement has been terminated : string or binary data would be truncated. What the user was attempting to do was add several products in a multiple picklist field and the web client new the data exceeded the length of the field. Here are the steps we took to correct the issue. 1. In the Administrator open the DB Manager 2. Under the Account listing click on the plus sign and open the Prod_Account_Ext table 3. Find the Product Field, rt click, choose properties, and change the Field Length to 256 4. Click OK to close the Product Field window 5. At the top of the Database Manager find the Apply Changes Arrow and Click it 6. Close the Administrator 7. Open the Application Architect and Rebuild the web platform, deploy the slxclient, and run an iisreset. This method can be used to increase the size of VarChar fields. A word of caution, only perform these steps on a quite system and always create a backup first.
What's This?
  
Bookmark and Share

About Mark Duthoy

  


Related Content
   Saleslogix (now Infor CRM) Web Client- Changing Label Appearances on Quick Forms
 I wrote previously about setting a label's appearance on a quick form using server side code.&n
Posted on Oct 02, 2014 by Kris Halsrud to Kris Halsrud's Blog
 
   Error Attempting to Save an Entity: "E_FAIL(0x80004005)" in the Infor CRM (Saleslogix) Web Client
We recently had a client that was running into an issue when attempting to create one particular entity i
Posted on Sep 30, 2014 by Kris Halsrud to Kris Halsrud's Blog
 
   Video: Demystifying Infor CRM (Saleslogix) Updates
Watch it now! If you missed yesterdays demo, "Demystifying Infor CRM (Saleslogix) Updates" ,
Posted on Sep 26, 2014 by Brianna Ojard to The Inbox
 
   Official Infor CRM Acquisition FAQ
What to expect now that Saleslogix is Infor CRM. Like many of you, it will take some time (probably a
Posted on Sep 18, 2014 by Brianna Ojard to The Inbox
 
   Problem with the Clean Build Folders option in Application Architect
On occasion, it becomes necessary to clean out the build folders and deployed website prior to a build/de
Posted on Sep 16, 2014 by Jason Buss to Jason Buss' Blog
 
Comments

 

Twitter Trackbacks for Updating the DB Manager to Lengthen Fields For SalesLogix Web Deployments - SalesLogix Support [customerfx.com] on Topsy.com said:

Pingback from  Twitter Trackbacks for                 Updating the DB Manager to Lengthen Fields For SalesLogix Web Deployments - SalesLogix Support         [customerfx.com]        on Topsy.com

June 19, 2010 2:01 AM

Leave a Comment

(required)  
(optional)
(required)  
Add
All contents Copyright © 2014 Customer FX Corporation
Customer FX Corporation
2324 University Avenue West, Suite 115
Saint Paul, Minnesota 55114
Tel: 800.728.5783

  Follow @CustomerFX on twitter
Follow the best news, tips, and articles
  Subscribe to Customer FX on youtube
Watch SalesLogix tutorial videos from Customer FX
Login / Register