C360
Sign In
KB Articles : Summary not showing any activites for some records although there are activities in History
KBA-01176 : Summary not showing any activites for some records although there are activities in History
Summary not showing any activites for some records although there are activities in History
KBA-01176
Problem
Summary works for most records but there are some where no activites are displayed although there are activities in History. Also, when the criteria for displaying Summary activities is changed, users may see some activities.  For example, in a Contact record, if the Entity Category is changed from All Entity Categories to Sales, then activities are displayed.
Solution

Summary has a configurable key called SQLTextSize to limit the amount of characters returned from the Description field for an activity preview which in turn provides increased performance.  The reason that some records do not display Summary is that in some rare instances the SQLTextSize truncates an HTML tag within the activity's description field, making Summary incapable of parsing the data correctly.   Furthermore, Summary will not display any activities where it is included in the criteria filter results.  There are two options to correct this problem:

Option1:

You will need to change the SQLTextSize to the recommended 4000, but this may cause Summary to break in other records for the same reasons mentioned above.  

Pros/Cons:  If the customer values performance then they can use the SQLTextSize key, but they may not be able to view Summary in certain respects for all accounts.  If the recommended value does not produce the desired results, then increment the value of the SQLTextSize key slowly to get it the best balance of function and performance in your organization.

Option 2:

The second option is remove the SQLTextSize key from Summary.config and eliminate the uncertainty of improperly truncating data.  

Pros/Cons:  If the customer values the function of Summary on all records then removing the SQLTextSize key will allow this, but performance will decline. 

Related KB Articles:
KBA-01151 : Configuring fetch limit in Summary with the 'SqlTextSize' key


 Created On 4/17/2007
 Last Modified On 5/4/2007
 Last Modified By Jackson, Kanika
  Print Article
 Send This Article
 Notes:

No notes available for the Article