04-28-2011 01:19 AM
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
04-28-2011 07:15 AM
This behavior is compiled into SalesLogix.exe and is not customizable.
Thanks
Mike
04-28-2011 07:41 AM
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"
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
04-28-2011 07:47 AM
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.
04-28-2011 08:11 AM
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
04-28-2011 08:27 AM
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?
04-28-2011 08:35 AM
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
04-28-2011 09:31 AM
Thanks again Michael.