LastHistoryDate and LastHistoryBy - Can we control these?

[rhelme1]

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

[mcessna]

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

Thanks

Mike

[rhelme1]

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

[rhelme1]

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.

[mcessna]

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

[rhelme1]

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?

[mcessna]

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

[rhelme1]

Thanks again Michael.