If you have a problem when inserting fingerprint templates or face templates (binary data) to BioStar database, it is possible to be caused by ODBC Driver.

For example, when either you transfer users with fingerprint/face template from a device to BioStar SW or create new user with fingerprint/face template, you cannot complete to do that tasks successfully. Maybe, you got the error like below.


<Error: Enroll user failed. (209)>


<Error: One or more values are invalid. Check the values and try again. (800)>




What should you check to resolve the problem?


1. Open the system log file (biostar_yyyy-mm-dd) related to specific date when you face the issue in the following path.

  • C:\Program Files\BioStar 2(x64)\logs

2. Then, check if below statements are recorded in the log file.

42000 [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared.
42S02 [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'T_ZNDR'.
17/12/20 09:35:02.220803 E <SYS> [0x00001844] Cannot execute the command:

…

17/12/20 09:35:56.881844 E <SYS> [0x00000d74] Cannot execute the command:
MERGE T_FNGPTMPL AS Target
USING (SELECT USRUID, :1, :2, :3, :4, :5 FROM T_USR WHERE USRID = :6) AS Source (USRUID, FNGPIDX, DUR, TMPL0, TMPL1, CHS)
ON (Target.USRUID = Source.USRUID AND Target.FNGPIDX = Source.FNGPIDX)
WHEN NOT MATCHED BY TARGET THEN
INSERT (USRUID, FNGPIDX, DUR, TMPL0, TMPL1, CHS)
VALUES (USRUID, FNGPIDX, DUR, TMPL0, TMPL1, CHS);
Error code=0
HY104 [Microsoft][ODBC SQL Server Driver]Invalid precision value
17/12/20 09:35:56.881844 E <SYS> [0x00000d74] Failed but reason isn't retriable. Exit retry loop...
17/12/20 09:35:56.882843 E <SYS> [0x00000d74] Failed to enrollBulkUser!
17/12/20 09:35:56.882843 E <SYS> [0x00000d74] Unhandled exception on user bulk insert. This user will be not inserted.
17/12/20 09:35:56.882843 E <SYS> [0x00000d74] user json={


3. If you have similar logs like above, check if SQL Native Client is installed in your PC. You can check it in Control Panel > System and Security > Administrative Tools. Run ODBC Data Sources (32-bit or 64-bit - depending on OS version of PC) and go to Drivers tab.



4. If SQL Native Client has not been installed, follow the below instructions.

4-1. Check windows version either 64-bit or 32-bit.

4-2. Download SQL Native Client attached.

4-3. Install one of two which is matched with your OS.

4-4. Restart BioStar Server.

4-5. Check if your issue is resolved.