Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
New Member
Posts: 15
Registered: ‎08-18-2009

LastHistoryDate and LastHistoryBy - Can we control these?

SLX LAN 7.5.3

I can't see any code updating the LastHistoryDate and LastHistoryBy on Account/Contact/Opportunity.

It's being updated after adding a History.

I would like to disable or change it - Is this possible?

 

Thanks,

Roy Helmer

ISSI

Employee
Posts: 629
Registered: ‎04-24-2009

Re: LastHistoryDate and LastHistoryBy - Can we control these?

This behavior is compiled into SalesLogix.exe and is not customizable.

 

Thanks

 

Mike

New Member
Posts: 15
Registered: ‎08-18-2009

Re: LastHistoryDate and LastHistoryBy - Can we control these?

I Believe I'm fighting a bug in the code which updates these fields.

 

Seems like it fails to convert the time correctly for dates which are in the same day when the DST was changed (i.e. 3/13/2011)..

If you execute the following then browse from the SLX client to the modified opp I believe you'll get an error saying the row cannot be located for updating"

 

 

UPDATE OPPORTUNITY 
SET LASTHISTORYDATE= '20110313 07:00:00.000'
Where OPPORTUNITYID = 'SomeOppID'

 

 

When checking the SLX Profiler I can see it tries to execute the below which affects 0 rows and produces a warning. (notice the 1 hour difference between the SET and WHERE)

 

UPDATE OPPORTUNITY SET MODIFYUSER=[DBTYPE_STR,"ADMIN       "],MODIFYDATE=[DBTYPE_DBTIMESTAMP,20110428 14:11:10.000],LASTHISTORYDATE=[DBTYPE_DBTIMESTAMP,20110313 06:00:00.000] WHERE OPPORTUNITYID=[DBTYPE_STR,"O6UJ9A006IK8"] AND MODIFYUSER=[DBTYPE_STR,"U6UJ9A00004V"] AND MODIFYDATE=[DBTYPE_DBTIMESTAMP,20110325 02:19:18.000] AND LASTHISTORYDATE=[DBTYPE_DBTIMESTAMP,20110313 07:00:00.000

 

Roy Helmer

ISSI

New Member
Posts: 15
Registered: ‎08-18-2009

Re: LastHistoryDate and LastHistoryBy - Can we control these?

swiw, I happened to work late on that night (3/13/2011) and was experiencing similar errors when trying to save plugins in Architect.

These errors went away a few hours later so I suspect the same issue.

Employee
Posts: 629
Registered: ‎04-24-2009

Re: LastHistoryDate and LastHistoryBy - Can we control these?

A similar scenario was addressed in 7.5.3 LAN HF11 (1-79612 Error: "Row cannot be located for updating. Some values may have been changed since it was last read." Editing database records with date values set around the DST change-over time). I don't believe this hotfix has been released yet; please check with support.

 

Thanks

 

Mike

New Member
Posts: 15
Registered: ‎08-18-2009

Re: LastHistoryDate and LastHistoryBy - Can we control these?

Michael,

Thanks much for your help.

Who would be the best person to contact regarding this hot fix?

What is the next version release and when is it planned for?

Employee
Posts: 629
Registered: ‎04-24-2009

Re: LastHistoryDate and LastHistoryBy - Can we control these?

When hotfixes are ready they can be downloaded from http://support.saleslogix.com.

 

Technical Support (USA)
Tel: 800-944-5709 6:00am to 5:00pm (MST)

I'm not sure of the exact date of the next release.

 

Thanks

 

Mike

Highlighted
New Member
Posts: 15
Registered: ‎08-18-2009

Re: LastHistoryDate and LastHistoryBy - Can we control these?

Thanks again Michael.