After initiating the Import People routine, a message appears (on top of the Results window) with the text “Overflow Error”. This is caused by an exceedence limit of a variable within Simply Safety! the increments the total number of historic people imported. Once 32768 records are reached, the variable used cannot store the new value. If a customer only imports once during installation and the number of total people are less that 32,000 this error should have no impact. If however, a customer imports employees on a weekly or monthly schedule, the number of total record imported could eventually reach 32,000.
When the above error is encountered. the customer will need to contact CCD so that the appropriate database tables can be reset back to 1. This is done using the following script:
delete from tblImportRuns
DBCC CHECKIDENT (tblImportRuns, reseed, 1)
delete from tblImportResults
DBCC CHECKIDENT (tblImportResults, reseed, 1)
0
0