Welcome, Guest
Username: Password: Remember me

TOPIC: SevHist - configuration

SevHist - configuration 8 years 6 months ago #7772

  • eslavko
  • eslavko's Avatar
  • OFFLINE
  • Expert Boarder
  • Posts: 158
  • Karma: 0
Hello...

I have trouble on one computer and don't know why other work but this not.
Seems that database is not created at all. But don't know why on other computer work.

When I start runtime I got error in console log:

Failed to connect to database: Error: Unknown database 'pwrp__mesalnica'

I look in sql database and there are no such database so I
try to manually create database in mySql with

'CREATE DATABASE pwrp__mesalnica;'

after restart of runtime the database seems found but of course not initialized.
There is part of console log
table sev_version do no exist
old sev_version: 1, new sev_version: 3
Updating database tables to sev version 2
I Adding application. aix: 1
I Starting pwr_plc_plc, file: plc_podstresnik_0999_plc, prio: 5
I Started pwr_plc_plc_999_0, prio: 5, pid: 6465
  file: plc_podstresnik_0999_plc
In ../../sev_dbms.cpp row 363:
updateDBToSevVersion2: Table 'pwrp__mesalnica.items' doesn't exist
Updating database tables to sev version 3
In ../../sev_dbms.cpp row 942:
Get Items: Table 'pwrp__mesalnica.items' doesn't exist
I Process pwr_elog_999 exited with status 256
I Process pwr_webmon_999 exited with status 32512
I Process pwr_webmonmh_999 exited with status 32512
I Process pwr_webmonelog_999 exited with status 32512
rt_sevhistmon: Node up received
rt_sevhistmon: node podstresnik connected
Sev podstresnik 1 1
rt_sevhistmon: ItemList sent
In ../../sev_dbms.cpp row 904:
Store item: Table 'pwrp__mesalnica.items' doesn't exist

So what I do wrong?
pwrp has granted privileges with:

grant all privileges on *.* to pwrp@localhost;
The administrator has disabled public write access.

SevHist - configuration 8 years 6 months ago #7773

  • claes
  • claes's Avatar
  • OFFLINE
  • Platinum Boarder
  • Posts: 3176
  • Thank you received: 502
  • Karma: 133
Proview will create the database with all tables at startup if it doesn't exist. At the same time the directory $pwrp_db/pwrp__'projectname'.db is created. If the directory is created, but the creation of the database fails, the directory has to be removed before a new attempt to create the database will be done. In your case, remove the directory and the database, and a new database will hopefully be created when you restart Proview.

The syntax for the storage time input is 'd h:m:s', and you can have storage times of several years.

/Claes
The administrator has disabled public write access.

SevHist - configuration 8 years 6 months ago #7774

  • eslavko
  • eslavko's Avatar
  • OFFLINE
  • Expert Boarder
  • Posts: 158
  • Karma: 0
Hello...

I tried near all characters to include days in StorageTime but not the space :sick:

The history now work as I expect.
Just didn't find the object how to show history window from clicking element in XttGraph.
The administrator has disabled public write access.

SevHist - configuration 8 years 6 months ago #7775

  • claes
  • claes's Avatar
  • OFFLINE
  • Platinum Boarder
  • Posts: 3176
  • Thank you received: 502
  • Karma: 133
You can state an xtt command in XttGraph.Action. The command to show process history is 'open history'.

/Claes
The administrator has disabled public write access.

SevHist - configuration 8 years 6 months ago #7776

  • eslavko
  • eslavko's Avatar
  • OFFLINE
  • Expert Boarder
  • Posts: 158
  • Karma: 0
Cant find it how to run...

I like to have button in xttGraph and when I click it the new history window popup. I think I need to select which history graph to open.
The administrator has disabled public write access.

SevHist - configuration 8 years 6 months ago #7777

  • eslavko
  • eslavko's Avatar
  • OFFLINE
  • Expert Boarder
  • Posts: 158
  • Karma: 0
...fell stupid.
Really just need to add right parameter.
Work now.


How to show more values on same hist graph?
The administrator has disabled public write access.
Time to create page: 8.093 seconds