Help‎ > ‎

TimeQ Error 45060

posted Oct 5, 2015, 2:07 PM by Surendra Dhanpaul   [ updated Oct 31, 2015, 8:15 AM ]
A client of mine experienced an error in TimeQPlus that read: 45060 exception error when trying to add a new employee. 

The problem occurs when your employees fields do not have the exact number of digits. 

Example: 

1. The UserId field has only 2 digits.

2. The badge field has only 8 or 9 digits. 

3. The number field less than 9 digits. 

To fix, find the field that has the wrong field length and correct it.

If you are familiar with Microsoft SQL Server, you might be able to find and fix very quickly. 

You can find the bad pin by using this query:

SELECT * 
FROM Employees
WHERE LEN(PIN)<4

If you are having difficulties, please feel free to contact me and I will be more than happy to help. 

Good luck.