View Issue Details

IDProjectCategoryView StatusLast Update
00022461 - BacklogBugpublic2018-02-09 23:07
ReporterKB3NPH 
Assigned To 
PriorityhighSeveritymajorReproducibilityhave not tried
Status newResolutionopen 
Summary0002246: Award Tracking shows zeros
DescriptionTicket #840254
Another ticket where the Awards all show as ZERO. Again I tried everything to resolve it but couldn't.
Additional InformationIt 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.
TagsNo tags attached.
ModuleLogbook
Sub-ModuleAwards
TestingNot Started

Relationships

Activities

KB3NPH

2018-01-17 14:01

administrator   ~0004305

Another customer with same issue: Ticket #378192

KB3NPH

2018-01-18 15:13

administrator   ~0004306

Another customer with same problem Ticket #165680

doug

2018-02-09 23:07

developer   ~0004310

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.

Issue History

Date Modified Username Field Change
2017-09-11 12:55 KB3NPH New Issue
2018-01-17 14:01 KB3NPH Note Added: 0004305
2018-01-18 15:13 KB3NPH Note Added: 0004306
2018-02-09 23:07 doug Note Added: 0004310