The following error shows up in the server Application Event Log every few minutes:
Event Type: Error
Event Source: PSDatabaseSvr
Event Category: None
Event ID: 4000
Time: 8:22:38 PM
Description: Caught a general error with message '[PSComDBServer::ComputerSessionInsert] COM -- ADO error: IDispatch error #3119. Description: INSERT statement conflicted with COLUMN CHECK constraint 'CK__transaction__qty__76619304'. The conflict occurred in database 'pharos', table 'transactions', column 'qty'.'
This error occurs when data being sent from the Signup Client(s) does not match the expected format of the database. In this case the 'qty' column in the transactions table.
This problem should not occur in Pharos 7.1 and later. If upgrading is not currently an option, this problem can be solved as follows:
For additional information see: The conflict occurred in database 'pharos', table 'computer_transactions'