Error Occured while saving attendance to database Hanvon FACEID Manager

tis error when polling

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.

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.

Getting RAW Data in LIMTON TIS Time Management System

I had to pull raw data of an employee who hare marked his/her attendance more than 2 times (probably thinking to trick the system or otherwise), the regular table HRTAttendance show only In and Out time. In case of multiple entries, this tables does not record all entries.

All entries are record in HRTMachineData. The columns in this table show only employee number, CDate, CTime and couple of other fields. Every entry made by the system is record here, even if multiple entries are made. It also show weather weather is PunchIn our PunchOUt (Status field is used for that).