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
   Problems running Crystal Reports in the Infor CRM (formerly Saleslogix) LAN client
We recently had a client that was using the Crystal RDC object in VBScript within the LAN client to run a
Posted on Jan 20, 2015 by Kris Halsrud to Kris Halsrud's Blog
 
   Unable to Insert Opportunities in Infor CRM (formerly Saleslogix) Web Client
 I recently ran into an issue where a client was unable to insert Opportunities when logged in as pa
Posted on Jan 14, 2015 by Kris Halsrud to Kris Halsrud's Blog
 
   Infor CRM (formerly Saleslogix) Web Client - How Time Zones Work
The Infor CRM web client utilizes  a couple of methods to determine and then present what timezones
Posted on Jan 09, 2015 by Kris Halsrud to Kris Halsrud's Blog
 
   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
 
Comments

No Comments

Leave a Comment

(required)  
(optional)
(required)  
Add
All contents Copyright © 2015 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