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
   Configuring and Packaging secured actions in Saleslogix 8.0
Using Secured Actions, you can restrict access to user interface elements in the Saleslogix web client.
Posted on Aug 12, 2014 by Jason Buss to Jason Buss' Blog
   How do you add a parameter for File Attachment Size and Timeout in Saleslogix 8.1?
Question: Is it possible to set a parameter for file attachment size and timeout in Salelogix? If
Posted on Aug 07, 2014 by Dale Richter to SalesLogix Questions & Answers
   Saleslogix XBar Installation
When installing the new XBar application I found the instructions a little vague so I thought I would pas
Posted on Jul 18, 2014 by Mark Duthoy to SalesLogix Support
   Finding the Current Parent Record ID in SalesLogix Web
Sometimes it's the easiest things that can be a big barrier to entry for getting started with somet
Posted on Jun 27, 2014 by Ryan Farley to Ryan Farley's Blog
   SalesLogix 8.1 Job Service Scheduling Executions Error Resolution
Often times a web implementation will have an application server that is used to deploy the web portals t
Posted on Jun 20, 2014 by Mark Duthoy to SalesLogix Support


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

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