csshenrapid

Forum Replies Created

Viewing 15 posts - 1 through 15 (of 16 total)
  • Author
    Posts
  • in reply to: Custom Page #10368
    csshenrapid
    Participant

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

    in reply to: ModDBExport to Oracle #3543
    csshenrapid
    Participant

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

    in reply to: ModDBExport to Oracle #3528
    csshenrapid
    Participant

    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

    in reply to: ModDBExport to Oracle #3525
    csshenrapid
    Participant

    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’

    in reply to: ModDBExport to Oracle #3522
    csshenrapid
    Participant

    “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.

    in reply to: ModDBExport to Oracle #3515
    csshenrapid
    Participant

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

    in reply to: ModDBExport to Oracle #3514
    csshenrapid
    Participant

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

    in reply to: ModDBExport to Oracle #3513
    csshenrapid
    Participant

    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)

    in reply to: ModDBExport to Oracle #3512
    csshenrapid
    Participant

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

    in reply to: ModDBExport to Oracle #3506
    csshenrapid
    Participant

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

    in reply to: ModDBExport to Oracle #3505
    csshenrapid
    Participant

    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

    in reply to: ModDBExport to Oracle #3504
    csshenrapid
    Participant

    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

    in reply to: How to Use Dashboard plugins #3413
    csshenrapid
    Participant

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

    in reply to: How to Use Dashboard plugins #3404
    csshenrapid
    Participant

    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.

    in reply to: ScadaAdmin.exe can not be started #3185
    csshenrapid
    Participant

    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();
    ……

Viewing 15 posts - 1 through 15 (of 16 total)