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
   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
 
   Saleslogix 8.1 Web Access Tab Throws Null Reference Error
 I recently had a client experiencing a problem access the Contact's Web Access tab.  Whene
Posted on Jun 18, 2014 by Kris Halsrud to Kris Halsrud's Blog
 
   Unable to Win Opportunities for Some Records in the Saleslogix web client
We recently ran into a client issue that I have just reported to Swiftpage as a bug (Ticket 8010151686)Th
Posted on May 06, 2014 by Kris Halsrud to Kris Halsrud's Blog
 
   Saleslogix v7.5.4 Web Client - Unable to Drag and Drop files
I recently had a customer who had one user who was unable to use the drag and drop feature of the Saleslo
Posted on Apr 23, 2014 by Kris Halsrud to Kris Halsrud's Blog
 
   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
 
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