[Rich Ex]

Hi , date as requested ,

2021-02-22 09:36:40 <V-SCADA-01><DefaultAppPool><ACT> Application shutdown
——————————————————————————–
——————————————————————————–
2021-02-22 09:42:26 <V-SCADA-01><DefaultAppPool><ACT> Initialize common web application data
2021-02-22 09:42:26 <V-SCADA-01><DefaultAppPool><ACT> Connect to SCADA-Server “localhost”
2021-02-22 09:42:26 <V-SCADA-01><DefaultAppPool><ACT> Refresh the tables of the configuration database
2021-02-22 09:42:27 <V-SCADA-01><DefaultAppPool><ACT> Fill input channels properties
2021-02-22 09:42:27 <V-SCADA-01><DefaultAppPool><ACT> Fill output channels properties
2021-02-22 09:42:27 <V-SCADA-01><DefaultAppPool><ACT> Fill input channel statuses properties
2021-02-22 09:42:27 <V-SCADA-01><DefaultAppPool><ACT> User information has been added. IP address: 10.1.0.99. Session: qcgpwkn51mr3xi3y5frj3wsi
2021-02-22 09:42:28 <V-SCADA-01><DefaultAppPool><ACT> Login: admin (Administrator). IP address: 10.1.0.99
2021-02-22 09:42:28 <V-SCADA-01><DefaultAppPool><ACT> User information has been updated. IP address: 10.1.0.99. Session: qcgpwkn51mr3xi3y5frj3wsi
2021-02-22 09:42:28 <V-SCADA-01><DefaultAppPool><ACT> Retrieve components from the installed plugins
2021-02-22 09:43:08 <V-SCADA-01><DefaultAppPool><ACT> Logout: admin. IP address: 10.1.0.99
2021-02-22 09:43:20 <V-SCADA-01><DefaultAppPool><ACT> User information has been added. IP address: ::1. Session: drmo402hd3wl2rac0fue5auy
2021-02-22 09:43:27 <V-SCADA-01><DefaultAppPool><ACT> Login: admin (Administrator). IP address: ::1
2021-02-22 09:43:27 <V-SCADA-01><DefaultAppPool><ACT> User information has been updated. IP address: ::1. Session: drmo402hd3wl2rac0fue5auy
2021-02-22 09:43:27 <V-SCADA-01><DefaultAppPool><ACT> Retrieve components from the installed plugins
2021-02-22 09:43:46 <V-SCADA-01><DefaultAppPool><ACT> Check “Chart Pro” registration:
Registration key is valid. Expiration date is 23/02/2021
Computer code: =0AAB8F2568031BE8-62CD277682F0E4D0-D53E5B16E5CE474F-66A5C6A3327FDFAC-63BD67BC4DDCAB88-630AE59F4EBCA807-5EC21FE4FB7E503E-C4F6F90346DA6721=
2021-02-22 09:43:46 <V-SCADA-01><DefaultAppPool><ACT> Receive input channel 218 trend from SCADA-Server. File: m210222.dat
2021-02-22 09:44:10 <V-SCADA-01><DefaultAppPool><ACT> Receive input channel 218 trend from SCADA-Server. File: m210222.dat
2021-02-22 09:44:10 <V-SCADA-01><DefaultAppPool><ACT> Receive input channel 213 trend from SCADA-Server. File: m210222.dat
2021-02-22 09:44:10 <V-SCADA-01><DefaultAppPool><ACT> Receive input channel 257 trend from SCADA-Server. File: m210222.dat
2021-02-22 09:44:32 <V-SCADA-01><DefaultAppPool><ACT> Generate “Minute data” report by the user admin
2021-02-22 09:44:32 <V-SCADA-01><DefaultAppPool><ACT> Receive input channel 218 trend from SCADA-Server. File: m210222.dat
2021-02-22 09:44:33 <V-SCADA-01><DefaultAppPool><ACT> Receive input channel 213 trend from SCADA-Server. File: m210222.dat
2021-02-22 09:44:33 <V-SCADA-01><DefaultAppPool><ACT> Receive input channel 257 trend from SCADA-Server. File: m210222.dat

Versions are , Webstation = 5.1.2.0
Chartpro = 5.1.0.1

I only have Libra office not MS Excel , is this an issue ?

Thanks
Rich

[Rich Ex]

Hi Mikhail ,
C:\SCADA\ScadaWeb\plugins\Chart\lang\PlgChart.en-GB.xml YES exists as does the en-GB file in the Chartpro folder.

Here is the latest from the ScadaWeb.log … as you see I’m using Chartpro to generate the Excel files…

Registration key is valid. Expiration date is 20/02/2021
Computer code: =0AAB8F2568031BE8-62CD277682F0E4D0-D53E5B16E5CE474F-66A5C6A3327FDFAC-63BD67BC4DDCAB88-630AE59F4EBCA807-5EC21FE4FB7E503E-C4F6F90346DA6721=
2021-02-19 08:56:56 <V-SCADA-01><DefaultAppPool><ACT> Receive input channel 213 trend from SCADA-Server. File: m210219.dat
2021-02-19 08:57:10 <V-SCADA-01><DefaultAppPool><ACT> Receive input channel 213 trend from SCADA-Server. File: m210219.dat
2021-02-19 08:57:10 <V-SCADA-01><DefaultAppPool><ACT> Receive input channel 218 trend from SCADA-Server. File: m210219.dat
2021-02-19 08:57:23 <V-SCADA-01><DefaultAppPool><ACT> Generate “Minute data” report by the user admin
2021-02-19 08:57:23 <V-SCADA-01><DefaultAppPool><ACT> Receive input channel 213 trend from SCADA-Server. File: m210219.dat
2021-02-19 08:57:23 <V-SCADA-01><DefaultAppPool><ACT> Receive input channel 218 trend from SCADA-Server. File: m210219.dat
2021-02-19 08:58:11 <V-SCADA-01><DefaultAppPool><ACT> Receive input channel 213 trend from SCADA-Server. File: m210219.dat
2021-02-19 08:58:11 <V-SCADA-01><DefaultAppPool><ACT> Receive input channel 218 trend from SCADA-Server. File: m210219.dat
2021-02-19 08:59:12 <V-SCADA-01><DefaultAppPool><ACT> Receive input channel 213 trend from SCADA-Server. File: m210219.dat
2021-02-19 08:59:12 <V-SCADA-01><DefaultAppPool><ACT> Receive input channel 218 trend from SCADA-Server. File: m210219.dat

Thank you
Rich

[Rich Ex]

Hi Mikhail
Here are the screenshots of the 2 files .

https://ibb.co/S7jxNKs
https://ibb.co/L63sRS2

Thank you
Rich

[Rich Ex]

Hi Mikhail ,
In Webstation I had the ‘Application Parameters’ ‘Culture’= “” at first , I have now changed them to “en-GB” as I am British , but the excel file is still showing the column headings as [ValColTitle].

Thanks
Rich

[Rich Ex]

Dear Mikhail ,

Many thanks , that fixed it .

Kind Regards
Rich

[Rich Ex]

Thank you Mikhail , thank you Manjey .

Yes I see that I should not add the delay in the formula . I will try what you said about making another channel and using a timestamp for comparison .

As always thank you.

Rich

[Rich Ex]

Hi , yes it did happen again even after updating to the latest version .

—I have found the problem that caused the Webstation to grind to a halt —

I had a ‘calculated real’ channel that was writing events , unfortunately the input was changing very fast , this caused the Server events .dat file to get very big , over 68Mb in a short time and then slow the whole web station down to a crawl .

Once I turned off the ‘write events’ on the channel the issue stopped .

Hope this helps , Rich

[Rich Ex]

Hi All
On a final note … how do I add screen shots on here ?

[Rich Ex]

All sorted !

Thank you gentlemen , I was near but missed the Cmd out !

So to enter data by hand into a table and make it usable ….

Add an INPUT Channel , (231 in my case ) ,Type = Calculated real , enter the OUTPUT Channel on the same line (1231 in my case).
Then …
Add an OUTPUT ,command type = Standard , tick FORMULA used , formula = SetVal(231,Cmd) .

Hope this helps .
Thanks Again
Rich

[Rich Ex]

Hi Mikhail ,
No I have none of what you mention .
It was a very strange issue .
I have fixed it now , I had to uninstall and then reinstall the software for Rapid Scada and now it is working again , this does show that it was not actually Rapid Scada that caused the problem I suppose so may have been a windows related issue as I did notice that there were Win10 updates waiting to be installed after the restart .

Thank you Sir for your help
Rich

[Rich Ex]

As always Mikhail

Thank you

[Rich Ex]

Hi ,

Think I have found it myself , CnlStat ..

So If CnlStat>0 we have a good signal on this channel , thats my understanding .
Is this correct .

Thanks
Rich

[Rich Ex]

Hi Mikhail ,
Thanks very much for the info , understood .
I now have the SetVal working , I was trying to use it in the result channel and not the source channel .

Thank you.

[Rich Ex]

Hi Mikhail ,

Thank you for the information .

Rich

[Rich Ex]

Hi Mikhail ,

Sorry I cant provide a link , my work is behind a secure firewall .

Basically I have a counter , signal 1 from my Scada device which is set to channel 201 “real” , this works fine each hour , example — 06:00 total 33 , 07:00 total 70, 08:00 total 99 , 09:00 total 133 and so on .

I need to get an hourly usage total so I can show Kw/h .
I have channel 210 set up as a “hourly discrete” reading Val(201) but all it shows is the same as channel 201 , i want it to show just the count for that hour , example 06:00 total 33 , 07:00 total 37, 08:00 total 29 , 09:00 total 34 and so on .

Thank you
Rich

[Author]

Posts