[kumajaya]

Yes, I analyzed Grafana communication using Wireshark, same result. I always got today minutes data (from 00:00) even Grafana asking for 5 minutes last data.

[kumajaya]

Yes, I did it like that. Use my laptop with Windows 10 to configure the project and upload it to RS running on Ubuntu. If something goes wrong, I always have a backup project.

[kumajaya]

I’m talking about Grafana Data Provider API access from Node-RED.

[kumajaya]

I expect last 5 minutes ‘minutes data’ = 5 datapoints but I got a thousands datapoints. My request:

{
   "panelId":1,
   "range":{
      "from":"2020-09-14T12:29:52.810Z",
      "to":"2020-09-14T12:34:52.811Z"
   },
   "interval":"30s",
   "intervalMs":30000,
   "targets":[
      {
         "target":"3201",
         "type":"timeserie"
      },
      {
         "target":"3202",
         "type":"timeserie"
      }
   ],
   "format":"json",
   "maxDataPoints":5
}

And no data update in between 23:59 – 06:59, it’s strange.

• This reply was modified 4 years, 11 months ago by kumajaya.

[kumajaya]

I confirm also work with latest version of https://www.nuget.org/packages/Newtonsoft.Json/ and https://www.nuget.org/packages/Microsoft.AspNetCore.Hosting.Abstractions/

[kumajaya]

You can configure it: https://rapidscada.net/doc/content/latest/en/software-configuration/communication-with-devices.html

[kumajaya]

Newtonsoft.Json.dll release 10.0.3 for net45 target from https://github.com/JamesNK/Newtonsoft.Json/releases/download/10.0.3/Json100r3.zip and Microsoft.AspNetCore.Hosting.Abstractions.dll from dotnet-sdk-2.1 https://docs.microsoft.com/en-us/dotnet/core/install/linux-ubuntu#scripted-install fix the problem. Big thanks!

[kumajaya]

Now I got “Could not load file or assembly ‘Microsoft.AspNetCore.Hosting.Abstractions, Version=1.1.3.0, Culture=neutral, PublicKeyToken=adb9793829ddae60’ or one of its dependencies.” Installing https://docs.microsoft.com/en-us/dotnet/core/install/linux-ubuntu still not solve the problem, maybe because older OPCUA library expect older version .NET core

[kumajaya]

Official release have a lot of target framework inside https://github.com/JamesNK/Newtonsoft.Json/releases Which one should I choose?

[kumajaya]

But OPCUA still doesn’t work with “Could not load file or assembly ‘Newtonsoft.Json, Version=10.0.0.0, Culture=neutral, PublicKeyToken=30ad4fe6b2a6aeed’ or one of its dependencies” error.

[kumajaya]

Mono version 6.10.0.104, Ubuntu 20.04 https://www.mono-project.com/download/preview/#download-lin-ubuntu

[kumajaya]

I managed to fix self signed certificate generation by changing ‘%LocalApplicationData%’ to ‘%CommonApplicationData%’. Certificate saved inside ‘/usr/share/OPC Foundation/’.

[kumajaya]

Copy KpOpcUa.Linux.xml as KpOpcUa.Logic.xml but replace all ‘%LocalApplicationData%’ string with ‘%CommonApplicationData%’ solve above problem but now I got:

Error connecting OPC server: System.AggregateException: One or more errors occurred. (The type initializer for ‘Opc.Ua.ServiceMessageContext’ threw an exception.) —> System.TypeInitializationException: The type initializer for ‘Opc.Ua.ServiceMessageContext’ threw an exception. —> System.TypeInitializationException: The type initializer for ‘Opc.Ua.EncodeableFactory’ threw an exception. —> System.TypeLoadException: Could not load type of field ‘Opc.Ua.JsonDecoder:m_reader’ (0) due to: Could not load file or assembly ‘Newtonsoft.Json, Version=10.0.0.0, Culture=neutral, PublicKeyToken=30ad4fe6b2a6aeed’ or one of its dependencies.
at (wrapper managed-to-native) System.RuntimeTypeHandle.type_is_assignable_from(System.Type,System.Type)
at System.RuntimeTypeHandle.CanCastTo (System.RuntimeType type, System.RuntimeType target) [0x00000] in <a17fa1457c5d44f2885ac746c1764ea5>:0
at System.RuntimeType.IsAssignableFrom (System.Type c) [0x00020] in <a17fa1457c5d44f2885ac746c1764ea5>:0
at System.RuntimeType.IsAssignableFrom (System.Reflection.TypeInfo typeInfo) [0x00012] in <a17fa1457c5d44f2885ac746c1764ea5>:0
at Opc.Ua.EncodeableFactory.AddEncodeableType (System.Type systemType) [0x00034] in <46754062c86e433a8050147004074236>:0
at Opc.Ua.EncodeableFactory.AddEncodeableTypes (System.Reflection.Assembly assembly) [0x00034] in <46754062c86e433a8050147004074236>:0
at Opc.Ua.EncodeableFactory..ctor () [0x0002d] in <46754062c86e433a8050147004074236>:0
at Opc.Ua.EncodeableFactory..cctor () [0x00000] in <46754062c86e433a8050147004074236>:0
— End of inner exception stack trace —
at Opc.Ua.ServiceMessageContext..ctor () [0x00053] in <46754062c86e433a8050147004074236>:0
at Opc.Ua.ServiceMessageContext..ctor (System.Boolean shared) [0x00000] in <46754062c86e433a8050147004074236>:0
at Opc.Ua.ServiceMessageContext..cctor () [0x00000] in <46754062c86e433a8050147004074236>:0
— End of inner exception stack trace —
at Opc.Ua.DiscoveryClient.Create (System.Uri discoveryUrl, Opc.Ua.EndpointConfiguration configuration) [0x0000a] in <46754062c86e433a8050147004074236>:0
at Opc.Ua.Client.CoreClientUtils.SelectEndpoint (System.String discoveryUrl, System.Boolean useSecurity, System.Int32 operationTimeout) [0x00041] in <bdddc5532da84081a96bd9e7feb3ef1e>:0
at Scada.Comm.Devices.OpcUa.OpcUaHelper.ConnectAsync (Scada.Comm.Devices.OpcUa.Config.ConnectionOptions connectionOptions, System.Int32 operationTimeout) [0x001e9] in <39294643693b45b3b8e6300c5758da94>:0
— End of inner exception stack trace —
at System.Threading.Tasks.Task.ThrowIfExceptional (System.Boolean includeTaskCanceledExceptions) [0x00011] in <a17fa1457c5d44f2885ac746c1764ea5>:0
at System.Threading.Tasks.Task`1[TResult].GetResultCore (System.Boolean waitCompletionNotification) [0x0002b] in <a17fa1457c5d44f2885ac746c1764ea5>:0
at System.Threading.Tasks.Task`1[TResult].get_Result () [0x0000f] in <a17fa1457c5d44f2885ac746c1764ea5>:0
at Scada.Comm.Devices.KpOpcUaLogic.ConnectToOpcServer () [0x00051] in <39294643693b45b3b8e6300c5758da94>:0
—> (Inner Exception #0) System.TypeInitializationException: The type initializer for ‘Opc.Ua.ServiceMessageContext’ threw an exception. —> System.TypeInitializationException: The type initializer for ‘Opc.Ua.EncodeableFactory’ threw an exception. —> System.TypeLoadException: Could not load type of field ‘Opc.Ua.JsonDecoder:m_reader’ (0) due to: Could not load file or assembly ‘Newtonsoft.Json, Version=10.0.0.0, Culture=neutral, PublicKeyToken=30ad4fe6b2a6aeed’ or one of its dependencies.
at (wrapper managed-to-native) System.RuntimeTypeHandle.type_is_assignable_from(System.Type,System.Type)
at System.RuntimeTypeHandle.CanCastTo (System.RuntimeType type, System.RuntimeType target) [0x00000] in <a17fa1457c5d44f2885ac746c1764ea5>:0
at System.RuntimeType.IsAssignableFrom (System.Type c) [0x00020] in <a17fa1457c5d44f2885ac746c1764ea5>:0
at System.RuntimeType.IsAssignableFrom (System.Reflection.TypeInfo typeInfo) [0x00012] in <a17fa1457c5d44f2885ac746c1764ea5>:0
at Opc.Ua.EncodeableFactory.AddEncodeableType (System.Type systemType) [0x00034] in <46754062c86e433a8050147004074236>:0
at Opc.Ua.EncodeableFactory.AddEncodeableTypes (System.Reflection.Assembly assembly) [0x00034] in <46754062c86e433a8050147004074236>:0
at Opc.Ua.EncodeableFactory..ctor () [0x0002d] in <46754062c86e433a8050147004074236>:0
at Opc.Ua.EncodeableFactory..cctor () [0x00000] in <46754062c86e433a8050147004074236>:0
— End of inner exception stack trace —
at Opc.Ua.ServiceMessageContext..ctor () [0x00053] in <46754062c86e433a8050147004074236>:0
at Opc.Ua.ServiceMessageContext..ctor (System.Boolean shared) [0x00000] in <46754062c86e433a8050147004074236>:0
at Opc.Ua.ServiceMessageContext..cctor () [0x00000] in <46754062c86e433a8050147004074236>:0
— End of inner exception stack trace —
at Opc.Ua.DiscoveryClient.Create (System.Uri discoveryUrl, Opc.Ua.EndpointConfiguration configuration) [0x0000a] in <46754062c86e433a8050147004074236>:0
at Opc.Ua.Client.CoreClientUtils.SelectEndpoint (System.String discoveryUrl, System.Boolean useSecurity, System.Int32 operationTimeout) [0x00041] in <bdddc5532da84081a96bd9e7feb3ef1e>:0
at Scada.Comm.Devices.OpcUa.OpcUaHelper.ConnectAsync (Scada.Comm.Devices.OpcUa.Config.ConnectionOptions connectionOptions, System.Int32 operationTimeout) [0x001e9] in <39294643693b45b3b8e6300c5758da94>:0 <—

[kumajaya]

Error on Ubuntu 20.04:
2020-07-09 14:44:00 Communication session with the Device 1002 “OPC UA 02”, type: KpOpcUa
Error connecting OPC server: System.AggregateException: One or more errors occurred. (Cannot access certificate private key. Subject=CN=KpOpcUa, O=OPC Foundation, DC=weighing-tx1310-m3) —> Opc.Ua.ServiceResultException: Cannot access certificate private key. Subject=CN=KpOpcUa, O=OPC Foundation, DC=weighing-tx1310-m3
at Opc.Ua.Configuration.ApplicationInstance.CheckApplicationInstanceCertificate (System.Boolean silent, System.UInt16 minimumKeySize, System.UInt16 lifeTimeInMonths) [0x0028d] in <257f0400988e4a10b271f6f92984b904>:0
at Scada.Comm.Devices.OpcUa.OpcUaHelper.ConnectAsync (Scada.Comm.Devices.OpcUa.Config.ConnectionOptions connectionOptions, System.Int32 operationTimeout) [0x00138] in <39294643693b45b3b8e6300c5758da94>:0
— End of inner exception stack trace —
at System.Threading.Tasks.Task.ThrowIfExceptional (System.Boolean includeTaskCanceledExceptions) [0x00011] in <a17fa1457c5d44f2885ac746c1764ea5>:0
at System.Threading.Tasks.Task`
1[TResult].GetResultCore (System.Boolean waitCompletionNotification) [0x0002b] in <a17fa1457c5d44f2885ac746c1764ea5>:0
at System.Threading.Tasks.Task`1[TResult].get_Result () [0x0000f] in <a17fa1457c5d44f2885ac746c1764ea5>:0
at Scada.Comm.Devices.KpOpcUaLogic.ConnectToOpcServer () [0x00051] in <39294643693b45b3b8e6300c5758da94>:0
—> (Inner Exception #0) Opc.Ua.ServiceResultException: Cannot access certificate private key. Subject=CN=KpOpcUa, O=OPC Foundation, DC=weighing-tx1310-m3
at Opc.Ua.Configuration.ApplicationInstance.CheckApplicationInstanceCertificate (System.Boolean silent, System.UInt16 minimumKeySize, System.UInt16 lifeTimeInMonths) [0x0028d] in <257f0400988e4a10b271f6f92984b904>:0
at Scada.Comm.Devices.OpcUa.OpcUaHelper.ConnectAsync (Scada.Comm.Devices.OpcUa.Config.ConnectionOptions connectionOptions, System.Int32 operationTimeout) [0x00138] in <39294643693b45b3b8e6300c5758da94>:0 <—

• This reply was modified 5 years, 1 month ago by kumajaya.

[kumajaya]

Please update module repository to 5.1.0 release.

[Author]

Posts