Login / Register  search  syndication  about

          Kris Halsrud's Blog

Kris Halsrud on development and Integration with CRM and Development

Errors with Activities after upgrading to SalesLogix 7.5.3 in the web client

 I have had a couple of clients who recently have reported issues being able to update existing activities after upgrading to the SalesLogix web client.  In the web server's event logs you see errors similar to this:

2011-06-10 14:22:58,872 ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute command: UPDATE ACTIVITY SET ALARMTIME = ?, LEADID = ?, LEADNAME = ?, MODIFYDATE = ?, STARTDATE = ? WHERE ACTIVITYID = ?
System.Data.OleDb.OleDbException: The statement has been terminated. : The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value.
   at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)
   at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
   at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
   at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
   at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
   at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
   at NHibernate.AdoNet.AbstractBatcher.ExecuteNonQuery(IDbCommand cmd)

I think there is a flaw in the upgrade of SalesLogix where extra fields are added to the USER_ACTIVITY table when upgrading.  These fields are not populated and thus the system is expecting values in fields that are not there.  The end result are the cryptic errors about being unable to convert the datetime2 to a datetime datatype.

To fix this I have found running the following SQL statement against the database resolves the issue:

 update USER_ACTIVITY set
 ALARMTIME=b.ALARMTIME, MODIFYDATE=b.MODIFYDATE, CREATEDATE=b.CREATEDATE,
 CREATEUSER=b.CREATEUSER, MODIFYUSER=b.MODIFYUSER, ALARM=b.ALARM from activity b
 where USER_ACTIVITY.ACTIVITYID=b.
ACTIVITYID and USER_ACTIVITY.CREATEDATE is null

go

update activity set alarmtime=startdate where alarmtime is null
go

update user_activity set alarmtime=b.ALARMTIME
from activity b
where USER_ACTIVITY.ACTIVITYID=b.ACTIVITYID
and USER_ACTIVITY.alarmtime is null
go

What's This?
  
Bookmark and Share

About Kris Halsrud

   Kris Halsrud is a Senior Analyst / Developer for Customer FX Corporation.


Related Content
   CRITICAL Issue with Saleslogix v8.1 Web SNC 02- Breaks Compatability with SQL 2008R2
One of the listed fixes in SNC 02 for Saleslogix 8.1 is listed as:14095222 Enhance the SQL generation to
Posted on Apr 17, 2014 by Kris Halsrud to Kris Halsrud's Blog
 
   Bug in the Saleslogix Web LiveGrid Lookup dialog
I recently ran into an issue with the Opportunity Products grid in the Saleslogix web client.  I cli
Posted on Apr 04, 2014 by Kris Halsrud to Kris Halsrud's Blog
 
   Major Problem in Saleslogix v8.1 Cloud Instances
I have been working with a new client who is on the hosted cloud solution for Saleslogix version 8.1.&nbs
Posted on Mar 19, 2014 by Kris Halsrud to Kris Halsrud's Blog
 
   Correct Build Search Path for Saleslogix Web v8.1
Despite what the help file says, the correct value to be in the build search path field under Tools...Bui
Posted on Mar 17, 2014 by Kris Halsrud to Kris Halsrud's Blog
 
   Attempting to add the Processes tab to the Contact middle pane in the SalesLogix LAN client breaks visibility to Contacts
I recently had a client call saying that one particular user could no longer access contacts from any met
Posted on Sep 18, 2013 by Kris Halsrud to Kris Halsrud's Blog
 
Comments

No Comments

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