View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0002246||1 - Backlog||Bug||public||2017-09-11 12:55||2018-02-09 23:07|
|Priority||high||Severity||major||Reproducibility||have not tried|
|Summary||0002246: Award Tracking shows zeros|
Another ticket where the Awards all show as ZERO. Again I tried everything to resolve it but couldn't.
|Additional Information||It appears to be an issue caused by Office 365. This appears to happen if Office 365 is installed prior to installing HRD. Seems in the past a customer resolved his own issue by uninstalling Office 365 and a complete uninstall of HRD. Reinstalled HRD as if a new install, activated it, then rebuilt his log from a backup and the Awards worked. He then re-stalled Office 365 and everything still worked as it should.|
|Tags||No tags attached.|
||Another customer with same issue: Ticket #378192|
||Another customer with same problem Ticket #165680|
This is a bug in the loggers database code. The code is pretty complicated when it comes to creating the connection string, and making sure there is an Access driver on the machine. One thing it tries to do is latch on to the DSN called "MS Access Database". This is installed with Office, so it was probably used as a known DSN that had an access driver. However, if you have 64-bit Office installed, this driver is 64-bit and will fail from the logger software since it is 32-bit.
One workaround is to just tell the user to delete that ODBC data source from control panel.
I changed up the code so it will not try to keep using the "MS Access Database" DSN if it fails the first time.
This needs to be tested the next time the project is built.