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
   Confirming Actions With an "Are you sure?" Prompt in Infor CRM (Saleslogix)
I'm not a huge fan of bugging end users. I figure, if an end user clicked something, he or she meant
Posted on Nov 18, 2014 by Ryan Farley to Ryan Farley's Blog
 
   Manipulating the DependencyLookup Control in the Infor CRM Web Client (Formerly Saleslogix)
 The Dependency Lookup control in the Saleslogix web client is what is used for the hierarchical Are
Posted on Nov 14, 2014 by Kris Halsrud to Kris Halsrud's Blog
 
   Infor CRM (formerly Saleslogix) Statement of Direction
Learn more about the future of Infor CRM. Recently I received my login information for the Infor Partn
Posted on Nov 13, 2014 by Brianna Ojard to The Inbox
 
   Adding a report link to the Common Tasks pane in Infor CRM (formerly Saleslogix)
When you are viewing an Entity Detail page, the Common Tasks pane on the right of the page provides a nu
Posted on Nov 12, 2014 by Jason Buss to Jason Buss' Blog
 
   How to Sum a Collection using Hibernate Criteria and Projections
 To sum the results of a criteria collection you can use code such as the following, which gets the
Posted on Nov 07, 2014 by Kris Halsrud to Kris Halsrud's 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