Dear Sir,

 There are error messages in Service Log

================================================================================================== 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's gravatar image

shelleyen02
160112
accept rate: 0%


"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:

  • Install a newer version of PA Server Monitor

-or-

  • If you don't need the ping history, stop the service and delete C:\Program Files (x86)\PA Server Monitor\Databases\PingResponse.db. It will be re-created when you start the service back up.
link

answered 23 Oct '12, 17:14

Doug's gravatar image

Doug ♦♦
10.2k122138
accept rate: 21%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×1
×1

Asked: 23 Oct '12, 10:37

Seen: 7,024 times

Last updated: 23 Oct '12, 17:14

Related questions