Stack Overflow
Stack Overflow

Questions tagged [wonderware]

Wonderware is a brand of industrial software sold by Aveva.

Wonderware is a brand of industrial software sold by Aveva. Previously, Wonderware had been a part of Invensys plc, which was acquired in January 2014 by Schneider Electric.

Wonderware Application Server supports and extends its own Wonderware QuickScript language with QuickScript .NET, an easy-to-use scripting language that supports almost any data type.

Additionally, objects can be imported into Wonderware application server with the following caveats:

  • Starting a GUI application from within a server script is not supported.

  • Although QuickScript supports import libraries built with .NET CLR version 2.0.50727, it does not support any of the new language features introduced with .NET 2.0, such as generics.

This tag should be used on any Wonderware related scripting or .NET question.

To learn more, you can visit the official US or UK sites.

73 questions
4
votes
2 answers

SQLAlchemy session management in long-running process

Scenario: A .NET-based application server (Wonderware IAS/System Platform) hosts automation objects that communicate with various equipment on the factory floor. CPython is hosted inside this application server (using Python for .NET). The…
codeape
  • 97,830
  • 24
  • 159
  • 188
4
votes
1 answer

What historian databases are available currently?

I have a question related to the historian databases. Here is our requirement. We need a historian database that is capable of collecting data from equipment at the rate of 1000 updates / sec on an average. And there will be one equipment for each…
AnswerSeeker
  • 203
  • 4
  • 16
3
votes
1 answer

You have attempted to use a rendering extension that is either not registered for this report

i try to generate a reports automaticly, i use wonderware archestra. but i have this problem when i wante to generate and save a report: Exception in GenerateReport: System.Web.Services.Protocols.SoapException: You have attempted to use a rendering…
sitchu
  • 51
  • 1
  • 2
2
votes
1 answer

Suitelink Reference Table

I work with Wonderware software. One of the objects used to perform communication between Wonderware and the PLC is called Suitelink. In it, I have a table defined that has the name of one of my application fields on the left side and the name of…
Tleilax
  • 77
  • 10
2
votes
3 answers

Replacing null values with the previous non-null value in each group

I'm connecting to Microsoft SQL Server on Tableau through a custom SQL query. I have a table with 3 fields DateTime, TagName, Value, and I want to replace null values in the Value field by the last (respecting the DateTime value) non-null value in…
sgokce
  • 53
  • 9
2
votes
2 answers

Wonderware Historian: query the Runtime.Events view

I'd like to query the Runtime.Events view with SQL. I have tried the followings: select * from Runtime.dbo.Events gives the following error: OLE DB provider "INSQL" for linked server "INSQL" returned message "Event History no longer supports queries…
Endre
  • 374
  • 6
  • 18
2
votes
1 answer

How to call SOAP web service from InTouch Wonderware or SQL Server 2014

I've been trying for a while to call an existing SOAP web service from InTouch Wonderware or MS SQL 2014. It doesn't matter which of the two calls it, as the Wonderware project reads/writes to the SQL Server database anyway. My knowledge is mostly…
Dynat
  • 161
  • 5
2
votes
2 answers

Deserialize JSON in Wonderware's ArchestrA / Quickscript.NET

I'm using VB/.NET through Wonderware's ArchestraIDE Quickscript.net scripting language. I see there's quite a few ways to deal with JSON deserialization in .NET (DataContractJsonSerializer, JavaScriptSerializer, Json.net/Newtonsoft.Json) - but can't…
mijiturka
  • 434
  • 6
  • 18
2
votes
1 answer

Export data from Intouch to Excel

I'm programming an SCADA with Intouch R2 SP1. In this SCADA I have to make some reports in excel. The report it's simply writting 10 values into specific cells. The thing is that the code I'm using is working with Office 2010 which is the version I…
salonso
  • 41
  • 2
  • 8
2
votes
0 answers

CEFSharp (Chromium Embedded Framework) - Wonderware

As you may know, the .net controls (webBrowser-control) and activeX control (webBrowser-control) can be finicky to say the least. I am looking to utilize the CEFSharp (Chromium Embedded Framework) but with Wonderware - InTouch. Does any one have…
user3324834
  • 59
  • 4
2
votes
3 answers

Simple SQL - using format inside openquery

I have the following query, using MS SQL Server in a Wonderware (Industrial HMI) Historian application. The keywords beginning with 'ww' are Wonderware specific, wwResolution is getting the results every 24 hours: SET QUOTED_IDENTIFIER OFF SELECT *…
Bill J.
  • 163
  • 8
1
vote
1 answer

Spark action throws "Cannot execute the query against OLE DB provider "INSQL" for linked server "INSQL" from Wonderware Historian DB

Using Spark, I have successfully loaded a Dataframe from a Wonderware Historian SQL DB (see this SO question). Listing the column…
Oliver Angelil
  • 1,099
  • 15
  • 31
1
vote
2 answers

How to query Wonderware live values with python?

I'd like to query live tag value from Wonderware historian with python. The following sql query works inside SQL server management studio and returns the live value of the tag: USE Runtime DECLARE @TempTable TABLE(Seq INT IDENTITY, tempTagName…
Nili
  • 91
  • 8
1
vote
0 answers

SQL OPENQUERY does not work for Provider = INSQL

INSQL is linked server that uses INSQL provider (from Wonderware Historian) Query SELECT * FROM OPENQUERY(INSQL,' SELECT 1') gives error as below: Msg 7399, Level 16, State 1, Line 27 The OLE DB provider "INSQL" for linked server "INSQL" reported an…
Michał Krasuski
  • 11
  • 3
1
vote
0 answers

What is the structure of *.bin files ( also called Late Data files) in Historian Wonderware Server?

I'm trying to parse *.bin file of Late Data. I found out some meanings of some group of bytes (look at the picture), but some group of bytes I could't veryfied (in red circles). Does anyone knows what are they mean?
Mike K
  • 63
  • 1
  • 7
1
2 3 4 5