Monthly Archives: August 2015

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.

SECP Pakistan online form Tutorial

2015-08-17 11_03_08-Securities & Exchange Commission of Pakistan
Online form on might actually not work. It display this message next to the username and password field

Incompatible Browser.
Please use Internet Explorer for this site

I tried internet Explore (ver 11) but I got the same error. What you can do do is downgrade your IE. Hit F12 to go into F12 debugger mode, there select the last TAB “Emulation”. Go to “User Agent” and select “Internet Explorer 8”. At this point reload you should be able to see the login page which was other wised replaced by the message above.

But you might still get lots of other error esp from debugger. I was help out by SECP staff to try the following (I have not tried it yet myself).

1. To Internet Explorer (IE) > Options and add to trusted sites (he actually mentioned to add to to compatible sites).
2. To got IE > Options > Security TAB. Select Custom and enable all checkboxes.

Will have to try this myself but it is here if anyone else has problem with SECP website.