GDOT web viewer trends not showing up
Download as pdf :
Products:
Last Updated:
07-Jul-2021
Last Updated:
07-Jul-2021
Versions:
Article ID:
000098779
Article ID:
000098779
Primary Subject:
Problem Statement
After registering an application on the GDOT web viewers, GDOT-Simulation or GDOT-Online, it is not possible to see the trends for MVs or CVs, however, it is possible to see the application connecting correctly to the web viewer.
The following error message can show up related to the variable which has been opened in the web viewer:
It is possible to see in the
SQL Management Studio
that the respective database,
GDOTSimulationHistory
or
GDOTOnlineHistory
(depending on the web viewer in which the problem is being experienced), that the
dbo.GDOThistory
table is not being filled:
Solution
To solve this issue, it is necessary to perform the next procedure:
Go to the
SQL Management Studio
and in the left column expand
Databases
and then expand
GDOTSimulationHistory
or
GDOTOnlineHistory
database, expand
Tables
and locate
dbo.GDOThistory
table.
Right click on the
dbo.GDOThistory
table and click on
Delete
. One the Delete Object window shows up, click on
OK
.
Once the table has been deleted, left click on the respective database, in this example we selected
GDOTOnlineHistory
.
Go to
File
, and select
Open
, then
File
, and go to the next path:
C:\Program Files (x86)\AspenTech\GDOT Online\V12.1\WebBackEnd\sql –
For GDOTOnlineHistory
C:\Program Files (x86)\AspenTech\GDOT Offline\V12.1\WebBackEnd\sql –
For GDOTSimulationHistory
Open the file
located in the desired path:
or
Edit the
AppKey
and the
VarName VARCHAR
definition and change the number inside the parenthesis to
255
.
Make sure that the database selected is the desired one,
this is a very important step
.
Click on
Execute
. Ignore the error message related to dropping the table.
Right click on the database and click on
Refresh
, make sure that the
dbo.GDOThistory
table has been successfully created.
To confirm that the data is being collected correctly in the database right click on the
dbo.GDOThistory
and select
Edit Top 200 Rows
,
you will expect that the table is being filled now.
NOTE:
Make sure that the GDOT application has been successfully registered on the Web Core and Web Historian text files and that it is connected to the console.
If the database is still not being filled, try to restart the next services:
For GDOT-Online:
For GDOT-Simulation:
Trends in GDOT web viewer should work now.
Keywords
GDOT web viewer, GDOT Simulation, GDOT Online, trends