[csshenrapid]

Hi,
Why can’t the page load all the time？About CustomPageExample.

[csshenrapid]

Maybe, it is ScadaServer who generated current data without millisecond, not MySQL(5.5).
can I submit bug repairing for RapidScada by github?

[csshenrapid]

Dear Mikhail

Maybe I found the source of the problem.

ScadaServer generated current data with the millisecond of timestamp are all zero. And then, error export to DB MySQL was happened while insert data to MYSQL database because of the same key ‘PRIMARY’. After that ScadaServer could not insert any other data to database.

It worked while insert current data to MYSQL
database using the following sql string:
INSERT INTO cnldata (datetime, cnlnum, val, stat)
VALUES (@dateTime, @cnlNum, @val, @stat)
ON DUPLICATE KEY UPDATE val = @val, stat = @stat

[csshenrapid]

It is the same to MYSQL database, and the error information is following:
2018-04-18 13:35:31 Error export current data to DB MySQL – 192.168.88.139:3306: Duplicate entry ‘2018-04-18 13:35:00-21’ for key ‘PRIMARY’

[csshenrapid]

“stop the Communicator service and send current data using Server’s Generator”.
I did it, and it worked. Current and archive data were send to oracle database correctly, but the status value was not setting value.

“How many record already contained in the table cnldata?”
I executed “delete from cnldata”, and there was no data in the table cnldata.

[csshenrapid]

In Oracle database, the millisecond of timestamp are all zero:
17-4-18 11.55.08.000000000 am

[csshenrapid]

Dear Mikhail,
Could you give me some idea about it?

[csshenrapid]

while insert current data to Oracle database using the following sql string:
INSERT INTO CnlData (DateTime, CnlNum, Val, Stat)
VALUES (:dateTime, :cnlNum, :val, :stat)

The error was returned:
2018-04-17 09:04:37 Error export current data to DB Oracle – 192.168.88.139:1521: ORA-00001:Violation of unique constraints (SYSTEM.SYS_C007354)

[csshenrapid]

The connection string is:
Server=192.168.88.139:1521/orcl;User ID=system;Password=54325

[csshenrapid]

Everything looks well, but there is no archive data in Oracle Database.

[csshenrapid]

ModDBExport.log:
——————————————————————————–
2018-04-15 09:32:41 Start ModDBExport module
2018-04-15 09:34:17 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
2018-04-15 09:34:18 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
2018-04-15 09:34:19 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
2018-04-15 09:34:20 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
2018-04-15 09:34:21 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
2018-04-15 09:34:22 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
2018-04-15 09:34:22 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
2018-04-15 09:34:22 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
2018-04-15 09:34:23 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
2018-04-15 09:34:24 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
2018-04-15 09:34:24 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
2018-04-15 09:34:24 Unable to enqueue current data. The maximum size of the queue 100 is exceeded
2018-04-15 09:34:25 Unable to enqueue current data. The maximum size of the queue 100 is exceeded

[csshenrapid]

ScadaServerSvc.log:—————————–
——————————————————————————–
2018-04-15 09:32:41 <WIN-DRJLMJGU35K><SYSTEM><ACT> ScadaServerService 5.1.0.3 is started
2018-04-15 09:32:41 <WIN-DRJLMJGU35K><SYSTEM><ACT> Module is loaded from the file C:\SCADA\ScadaServer\Mod\ModDBExport.dll
2018-04-15 09:32:41 <WIN-DRJLMJGU35K><SYSTEM><ACT> Check the existence of the data directories is completed successfully
2018-04-15 09:32:41 <WIN-DRJLMJGU35K><SYSTEM><ACT> Check the existence of the configuration database files is completed successfully
2018-04-15 09:32:41 <WIN-DRJLMJGU35K><SYSTEM><ACT> Input channels are read from the configuration database. Active channel count: 47
2018-04-15 09:32:41 <WIN-DRJLMJGU35K><SYSTEM><ACT> Ouput channels are read from the configuration database
2018-04-15 09:32:41 <WIN-DRJLMJGU35K><SYSTEM><ACT> Users are read from the configuration database
2018-04-15 09:32:41 <WIN-DRJLMJGU35K><SYSTEM><ACT> Formulas are read from the configuration database
2018-04-15 09:32:41 <WIN-DRJLMJGU35K><SYSTEM><ACT> The formulas source code has been compiled
2018-04-15 09:32:41 <WIN-DRJLMJGU35K><SYSTEM><ACT> Connection listener is started
2018-04-15 09:32:41 <WIN-DRJLMJGU35K><SYSTEM><ACT> Start server
2018-04-15 09:32:41 <WIN-DRJLMJGU35K><SYSTEM><ACT> Current data are loaded
2018-04-15 09:32:50 <WIN-DRJLMJGU35K><SYSTEM><ACT> Connect to client 127.0.0.1
2018-04-15 09:32:50 <WIN-DRJLMJGU35K><SYSTEM><ACT> The user ScadaComm is successfully authenticated

ModDBExport.log:
——————————————————————————–
2018-04-15 09:32:41 Start ModDBExport module

[csshenrapid]

Thanks to Mikhail and your great software!
I find that The dashboard plugin works after installation and Registration for Chart Pro plugin.

[csshenrapid]

DashboardExample1.xml:

<DashboardConfig>
<DashboardOptions>
<Name>Dashboard Example 1</Name>
<ColumnCount>2</ColumnCount>
<AspectRatio>1.33</AspectRatio>
</DashboardOptions>
<Widgets>
<Widget type=”Chart” cnlNums=”21,22″ viewIDs=”23,23″ period=”2″ />
<Widget type=”CurData” cnlNums=”21,22″ viewIDs=”23,23″ />
<Widget type=”CustomUrl” url=”http://localhost/View.aspx?viewID=23&#8243; />
</Widgets>
</DashboardConfig>

When I used chart pro, the “Main Menu > Registration > Dashboard” can be seen. but the page showed “reCAPTCHA validation failed” while Geting a trial key.

[csshenrapid]

Dear Mikhail,

Thanks.

The development tool is VS 2013 and the SQL Server Compact is Version 4.0. I tried to add the following code before openning the file “ScadaBase.sdf” and it worked. Then, ScadaAdmin.exe can run correctly.

//….\ScadaAdmin\ScadaAdmin\AppCode\AppData.cs
……
var ce = new System.Data.SqlServerCe.SqlCeEngine(connStr);
ce.Upgrade();
……

[Author]

Posts