Dear Sir,
================================================================================================== TID:03920, PID:02860, ERROR: #### sqlite_step failed with 19 (constraint failed) for SQL=[begin immediate;INSERT INTO Statistic (OwnerType, ItemName, StatName, OwningComputer) VALUES (8, 'WEB2.MYZION.NET', 'PingTime', 'HOST');; end;] TID:03920, PID:02860, ERROR: begin immediate;INSERT INTO Statistic (OwnerType, ItemName, StatName, OwningComputer) VALUES (8, 'WEB2.MYZION.NET', 'PingTime', 'HOST');; end; TID:03920, PID:02860, ERROR: SQL_PRIMARY = C:Program Files (x86)PA Server MonitorDatabasesPingResponse.db TID:03920, PID:02860, ERROR: #### sqlite_exec failed with 19 (Statistic.CompID may not be NULL) for SQL=[begin immediate;INSERT INTO Statistic (OwnerType, ItemName, StatName, OwningComputer) VALUES (8, 'WEB2.MYZION.NET', 'PingTime', 'HOST');; end;]. Will re-open ========================================================================================== Could you tell me how to fix the errors ? asked 23 Oct '12, 10:37 shelleyen02 |
"Statistic.CompID may not be NULL" seems to indicate the database version and the software version aren't a match since that CompID field became a required field a while back. Easy fixes:
-or-
answered 23 Oct '12, 17:14 Doug ♦♦ |