Today our HR department got this error when they started polling Attendance in Hanvon FaceID Manager
Error Occurred while saving attendance to database Hanvon FACEID Manager
To find out why really the Hanvon is spitting out this error and not saving the records, I have to look at the Windonw NT Logs. To look at Windows NT logs, start SQL Server Management Studio, connect to your local SQL Server, then go to Management > SQL Server Logs. Select the log that start with “the current” and click view log. ON the left side, there is bunch of software you can select/deselect to filter the logs. Selects only Windows NT and deselect the rest. There was this error
Error Description:Invalid argument. Insert Into Attendance (MachineID,PinNumber,AttendanceDateTime,Status,MachineName,AttendanceDate,AttendanceTime,AttendancePhoto) Values(01,’7309′,’17-Aug-2015 14:19:07 PM’,’01’,’mydb’,’17-Aug-2015′,’02:19 PM’,@AttendancePhoto)
Access DB has gone Corrupted (once again)
After looking around on google, I found that the error was because Access Database has gone corrupted. For this to fix, click the round button in Access > Access Options > Current database and check
Compact on close.
This might take quite a bit. Just leave it running for some time (I left it at end of the day). After it is done, start Hanvon FaceID Manager and start polling, it should work as in my case.
If there is still some problem, you might have to look for the corrupted data that is causing the problem and have to delete it manually (slightly dangerous route).
I got the above error once again in a different scenario. In this case had I moved .dbm file to a different location and hence the above err. After looking at SQL Server Log (Hanvon), I was getting this error
Error Description:ExecuteNonQuery requires an open and available Connection. The connection’s current state is closed. Insert Into Tlog
I resolved this one after I copy the file back to its original location.