




Historical data

























[KB1243] How to configure a database transactional replication
Document attached: How to configure SQL replication SQL script attached: DBO.MSrepl_error: SQL query for trigger creation
[KB1232] Replication of two SQL Data Base
The architecture : PcVue Configuration:You can configure two databases for each instance, assigning them different names, while ensuring that the table names remain identical across both databases.Below is an example […]
[KB1242] SQL Server Native Replication (Standard edition)Template
See attached pdf document. Download attachments: KB1242.pdf
[KB1241] SQL Server Native Replication (Enterprise Edition)
See attached pdf document. Download attachments: KB1241.pdf
[KB1221] Cassandra provider – Version 1
Applies to: PcVue 16 onwards Summary: This article contains attached files at the end. Apache Cassandra is commonly used by large organizations for applications such as social media, […]
[KB1075] How to create a sample project
To use this project, you will need to :1/ Unzip the attachment in your USR folder.2/ Rename the project according to your needs.3/ Start the project and modify the window […]
[KB1235] Oracle 21c with UDC
First, you need to download 3 installers: The server, the ADO.net provider and a GUI client for easy testing Oracle XE installation steps :– Unzip the OracleXE213_Win64.zip archive and run […]
[KB1219] EmVue v1 – Software download
Download link EmVue v1 EmVue_1.1.180.iso : Download Hash (SHA256) : 777343936F0D13EB827F55CA246AAC54FFF9074A3D9B8F72D73BD647BFB3310F How to verify the integrity of downloaded files? Prior to installing the software, it is important to check the integrity of […]
[KB1218] EmVue v1 – Release Information
Key features – An overview of the key features in version 1 Initial Release (1.0) What’s new in 1.1 – An overview of the main new features in the Release […]
[KB1237] Adding a Development station to a Multi-station Architecture
The DEV station remains passive under normal conditions but can be temporarily activated for testing purposes. Here are the steps to add a DEV station to a multi-station architecture: Configuration: […]
[KB1236] Not possible to archive in SQL database
If the traces are activated you could have this kind of error: CSchTable::AbleToWrite on ‘TRENDTABLE1′ is FALSE ID=’2’ Here’s what we recommend you check in this case: Is the database […]
[KB1233] Optimisations for SQL database archiving with HDS
1. Dedicated disk for mdf file Objective: Improve database performance by isolating data files (mdf) on a dedicated disk. Action: Configure the system so that mdf files are stored on […]
[KB1231] Error loading the Application Architect configuration
This type of message appears when there are inconsistencies in the project configuration. An error message is systematically displayed in the event viewer: The error indicates the blocking point for […]
[KB1230] Protected: [Draft] How to import proprietary unit trends into HDS database
There is no excerpt because this is a protected post.
[KB1188] PcVue 16 – Software and License Utility download
[KB1228] DIMO Maint MX provider – Version 1
Applies to: PcVue 16 onwards Summary: This article contains attached files at the end. This provider is a solution that interacts with DIMO Maint MX and retrieves information on […]
[KB1224] Salesforce provider – Version 1
Applies to: PcVue 16 onwards Summary: This article contains attached files at the end. This provider is a solution to connect Salesforce Platform to PcVue to get data from CRM […]
[KB1225] Telegram provider – Version 1
Applies to: PcVue 16 onwards Summary: This article contains attached files at the end. This provider is a solution to Send message with emoji, bolt, italic… Send command, inline keyboards… […]
[KB1226] Twilio provider – Version 1
Applies to: PcVue 16 onwards Summary: This article contains attached files at the end. This provider is a solution to send an SMS from a data center or a Cloud […]
[KB1227] X provider – Version 1
Applies to: PcVue 16 onwards Summary: This article contains attached files at the end. This provider is a solution to create or send a tweet. Status: This provider has the […]
[KB1223] Netatmo provider – Version 1
Applies to: PcVue 16 onwards Summary: This article contains attached files at the end. This provider is a solution to access famous Netatmo IoT platform and Netatmo partner from PcVue. […]
[KB1222] Operat provider – Version 1
Applies to: PcVue 16 onwards Summary: This article contains attached files at the end. This provider is a solution to publish energy consumption in the tertiary sector from PcVue. Status: […]
[KB1220] Automatic Acknowledgment of Alarms with the Same Priority
Applies to: PcVue – Multiple versions Summary: This article explains how to modify the PARAM.DAT file, specifically the COLORWDWALARM lines, to enable automatic acknowledgment of alarms at the same level. […]
[KB1216] Sofrel OPC UA Server Validation Results
Applies to: PcVue 16.1 and later Summary: This article contains the results from validation tests of the Sofrel OPC UA Server v2.20.27 and PcVue. Originator: ELCH Details: This guide contains […]
[KB1130] HDS Files format PcVue 15
Applies to: PcVue 15 onwards Summary: This document describes the content of each HDS configuration files.Warning 1: Modifying manually these files can cause irreversible damage.Warning 2: This article is only […]
[KB1131] HDS diagnostics
Applies to: PcVue 15 onwards Summary: This article proposes different ways to diagnose proper functioning of HDS.Warning 1: Modifying manually these files can cause irreversible damage.Warning 2: This article is […]
[KB1129] HDS Files list
Applies to: PcVue 15 onwards Summary: This article lists all the files managed by the HDS.Warning 1: Modifying manually these files can cause irreversible damage.Warning 2: This article is only […]
[KB1211] How to import a local library into a PcVue project
Applies to: PcVue 12 onwards Summary: Here are the steps to import an existing library into a project. Details: To integrate an existing library into your project, you will have […]
[KB1212] How to display the networking architecture in a PcVue mimic?
Applies to: PcVue 16 onwards Summary: Whenever you create a PcVue multi-station project, you logically want to display real-time information from all stations in a dedicated view. For […]
[KB1214] PcVue Automatic Deployment
Applies to: PcVue 16.2 onwards Summary: How to install or update PcVue on a complete architecture in a more efficient way? This article describes the procedure to automatize the deployment […]
[KB1205] Migrating a PcVue project containing LON communication
Applies to: PcVue 15 onwards Summary: Prerequisites for migrating a PcVue project containing LON communication. Details: Prerequisites to take into account: – Plan for updating the LON license (LON server […]
[KB1197] Security Alerts
Despite the strict methods and precautions employed when designing, developing and packaging our products, security vulnerabilities may occur. This page lists all known security alerts on products designed by ARC […]
[KB1172] SQLite Provider – Installation tutorial
Applies to: PcVue 16 Summary: SQLite is probably one of the most used database engine. But SQLite editor does no more share installer (.msi).However it is possible to […]
[KB1213] PcVue as a Service – Open Application Explorer
Applies to: PcVue 11.2 onwards Summary: Since PcVue is able to run as a Windows service the use of options in AIExplorer command line becomes very useful. We will describe […]
[KB1203] CPU at 100% with in web Navigator using Webvue in a VM
Applies to: PcVue 16 onwards Summary: With PcVue 16, WebVue uses WebGL technologie. By default, WebVue tries to refresh the whole WebGL view at the refresh rate of the screen, […]
[KB1202] How to disable the native menu in WebVue
Applies to: PcVue 16 (Not included in V15.2.6, but should be available in the next uptdate) Summary: This article aims to show how to disable the native menu in WebVue: Details: […]
[KB1201] Could not load type ‘System.ServiceModel.Activation.HttpModule’ from assembly
Applies to: WebVue, Web Services using IIS Symptom: While trying to access WebVue, or a PcVue Web Services page, or testing web functionalities with the SvWebDiag tool, this error appears: […]
[KB1194] How to create an Exprv.dat file with the Application Architect
Applies to: PcVue 12 onwards Summary: This article explains how to create an Exprv.dat or another file with the Application Architect. Details: In the following example, the expressions are used to […]
[KB1193] JSON provider – Version 1
Applies to: PcVue 16 onwards Summary: This article contains attached files at the end. This provider allows interaction between JSON files and PcVue. Status: This provider has the status: Release […]
[KB1192] Excel provider – Version 1
Applies to: PcVue 15.2 onwards Summary: This article contains attached files at the end. This provider allows interaction between Excel files and PcVue. Status: This provider has the status: Release […]
[KB1191] Cosmos DB Provider – Version 1
Applies to: PcVue 16 onwards Summary: This article contains attached files at the end. This provider will allow direct interaction with the NoSQL database engine provided by Microsoft in SaaS […]
[KB1190] WebVue good practices
Applies to:PcVue 12, 15 and 16 Summary:This article aims to provide some best practices for the deployment of WebVue. Everything in this article, from the introduction to the end is […]
[KB1187] PcVue 16 – Extra Documentation
Applies to: PcVue 16 This article was last updated to include information related to PcVue 16.0.0. Summary: This article contains the extra documentation supplied with PcVue 16. Details: Note: These […]
[KB1186] PcVue 16 – Libraries and Demonstration projects
Applies to: PcVue 16 Summary: This article contains the pre-defined libraries and demonstration projects supplied with PcVue 16 in English, French, Russian and Chinese language. If you wish to use […]
[KB1183] REST provider – Version 1
Applies to: PcVue 16 onwards Summary: This article contains attached files at the end. This provider allows direct interaction with a multitude of REST API. Note that some APIs do […]
[KB1184] PcVue 16 – Release Information
Applies to: PcVue 16 This article was last updated to include information related to PcVue 16.2.0. Summary: This article contains the so-called “readme first” information for PcVue 16. Files attached […]
[KB1182] CSV provider – Version 1
Applies to: PcVue 15.2 onwards Summary: This article contains attached files at the end. This provider allows interaction between csv files and PcVue. Status: This provider has the status: Release […]
[KB1185] FrontVue 16 – Release Information
Applies to: FrontVue 16 This article was last updated to include information related to FrontVue 16.0.0. Summary: This article contains the so-called “readme first” information for FrontVue 16. Files attached […]
[KB1174] RTE Ecowatt Provider – Version 1
Applies to: PcVue 15.2 onwards Summary: Véritable météo de l’électricité, Ecowatt qualifie en temps réel le niveau de consommation des Français. A chaque instant, des signaux clairs guident le consommateur […]
[KB1173] Networking errors: The remote client station is not configured in local station
Applies to: PcVue 12 onwards. Summary: This article describes a simple issue we can encounter sometimes between two PcVue stations. Note that there is a more generic article about understanding […]
[KB1243] How to configure a database transactional replication
Document attached: How to configure SQL replication SQL script attached: DBO.MSrepl_error: SQL query for trigger creation
[KB1232] Replication of two SQL Data Base
The architecture : PcVue Configuration:You can configure two databases for each instance, assigning them different names, while ensuring that the table names remain identical across both databases.Below is an example […]
[KB1242] SQL Server Native Replication (Standard edition)Template
See attached pdf document. Download attachments: KB1242.pdf
[KB1241] SQL Server Native Replication (Enterprise Edition)
See attached pdf document. Download attachments: KB1241.pdf
[KB1236] Not possible to archive in SQL database
If the traces are activated you could have this kind of error: CSchTable::AbleToWrite on ‘TRENDTABLE1′ is FALSE ID=’2’ Here’s what we recommend you check in this case: Is the database […]
[KB1233] Optimisations for SQL database archiving with HDS
1. Dedicated disk for mdf file Objective: Improve database performance by isolating data files (mdf) on a dedicated disk. Action: Configure the system so that mdf files are stored on […]
[KB1130] HDS Files format PcVue 15
Applies to: PcVue 15 onwards Summary: This document describes the content of each HDS configuration files.Warning 1: Modifying manually these files can cause irreversible damage.Warning 2: This article is only […]
[KB1131] HDS diagnostics
Applies to: PcVue 15 onwards Summary: This article proposes different ways to diagnose proper functioning of HDS.Warning 1: Modifying manually these files can cause irreversible damage.Warning 2: This article is […]
[KB1129] HDS Files list
Applies to: PcVue 15 onwards Summary: This article lists all the files managed by the HDS.Warning 1: Modifying manually these files can cause irreversible damage.Warning 2: This article is only […]
[KB1145] Database status check at startup
Applies to: PcVue 11.2 onwards Summary: Program and mimic to be set up to check if connection to a database is valid at project startup. Details: At project startup, HDS […]
[KB1128] How to open SQL Server Configuration Manager
Applies to: SQL Server Summary: You may need to change the default configuration of your SQL Server instance, for example to allow TCP/IP access. The SQL Server Configuration Manager is not […]
[KB1104] Sql Variables and Data Archiving
Applies to: PcVue15 onwards Summary: This article describes how to configure data archiving when you use Sql variables with row selection mode “All Rows” or “By Field Value”. […]
[KB1096] Sql Variables – Avoid SQL Injections
Applies to: PcVue 15 onwards Summary: Embedding SQL scripting in PcVue is extremely powerful, but this feature can be exploited to perform a malicious act, erase data, read sensitive data […]
[KB1089] How to check if HDS is running before starting PcVue?
Applies to: PcVue 8.10 onwards Summary:It is not advised to start PcVue if the HDS has not stopped properly. The HDS can sometimes take a long time to stop because […]
[KB1046] HDS performance tests
Applies to: PcVue 11 onwards Summary: The aim of this document is to provide best practices when using SQL Server with PcVue in giving a simple overview of the performance […]
[KB869] SQL SERVER 2012 USER RIGHT
Applies to: PcVue 11.0 onwards when using SQL Server 2012 Summary: The HDS is unable to record in SQL Server 2012 database when PcVue is started with a User with […]
[KB868] REPLICATION WITH 1 SQL SERVER EXPRESS AND 1 SQL SERVER STANDARD EDITION
Applies to: PcVue all versions. SQL Server Express 2008 R2 Summary: One possible and tested way to backup historical data from SQL Express to SQL Standard.Originator:AC Details: The following script […]
[KB859] HOW PCVUE HANDLES SQL SERVER CONNECTIONS
Applies to: All versions of PcVue Summary: How PcVue handles SQL Server connections.Originator: LM Details: When you start a PcVue project which uses the HDS and SQL Server for archiving […]
[KB849] Trend recording – New invalid point management on shut-down
Applies to: PcVue 11.1 update and later Summary: The trend recording invalid point management, which occurs when PcVue shuts down and restarts, has been improved for equipment with time-stamped protocols. […]
[KB844] Estimating SQL Server Database Size
Applies to: All versions of PcVue supporting the HDS All versions of SQL Server supported by PcVue Summary: How to estimate the size requirements for an SQL Server database when […]
[KB840] How to import .HDS files
Applies to:PcVue 8.10 onwards Summary:.hds files are generated by the HDS, during abnormal operation, as temporary storage for events. The HDS will attempt to recover the information in them when […]
[KB876] SQL Server Purge Mechanisms Used By PcVue
Applies to: All versions of PcVue that include the Historical Data Server Summary: Technical information about the two purge mechanisms used by the HDS to control the size of an […]
[KB769] HDS failed to connect to SQL server with test connection success
Applies to: Any PcVue version running HDS Summary: How to resolve the following error on HDS at start-up ” Failed to connect to SQL server …..” Details: If your SQL […]
[KB732] How to copy the contents of an HDS table to another SQL table or other relational database
Applies to: All PcVue versions including the HDS Originator: AD Summary: The SQL Server tools allow you to copy the contents of a table using two methods. On the fly […]
[KB700] How PcVue manages summer & winter time changes
Applies to: PcVue 9.0 and later Summary: This article describes how PcVue manages its archives during the summer and winter time change periods. It follows a verification plan made in […]
[KB666] Client station trying to connect to the SQL Server instance
Applies to: PcVue version 10.0 onwards. Summary: This article warns you about what could happen in a HDS archiving configuration, when a station that is not a historical server, tries […]
[KB654] How .hds files work ?
Applies to: PcVue version 8.10 onwards. Summary: This article explains why the file “ProjectName_DatabaseName_TableName.hds” in the Databases directory contains records. Details: .hds files are created in the directory containing the […]
[KB621] Periodic Trend Recording (svmgrHisTrendPeriod.dll)
Applies to: PcVue version 8.10 onwards. From PcVue version 11.0 onwards periodic recording is available as a standard configuration option. Summary: The svmgrHisTrendPeriod DLL allows you to force the periodic […]
[KB620] HDS FAQ
Question: What is the meaning of the colors in the HDS icon? From PcVue 10.0 SP1 the HDS icon displayed in the System Tray changes color. Answer: The color of […]
[KB613] Compatibility issue with Client-Server Archiving
Applies to: PcVue version 8.10 SP1 onwards. Summary: This affects networked architectures using client – server archive units. There was a change in what actions and events could be logged, […]
[KB592] The origin of quality value 64 in the HDS trend tables
Applies to: PcVue all versions. Summary: In article KB243 there is a description of the quality values you can find in HDS tables. However, the quality value 64 is very […]
[KB568] How to create and export a custom table in the HDS
Applies to: PcVue version 9.0 onwards Summary: When using a Maintenance Plan & Export Task to export data from a database, the format of the output is defined by the […]
[KB537] Migration of the HDS Databases to PcVue 10.0
Applies to: PcVue versions 10.0, 11.0, and 11.1. The basic content of this article may also be applicable to other versions of PcVue although the detail may vary. Summary: This […]
[KB520] PcVue historical database – Log and trend tables description
Applies to: PcVue version 8.10 onwards. Summary: This article describes LOG and TRD columns in PcVue database, created when configuring a HDS archive unit Details: General In attached file, you […]
[KB491] Using a Free Archive Unit in a file named by a variable
Applies to: PcVue all versions Summary: This article is a supplement to the online help and explains how to force the data recording of a Free Archive Unit in a […]
[KB490] Database export limit
Applies to: PcVue version 8.10 onwards. Summary: This article describes a limitation on the export of data from the HDS. Details: Any export via the HDS is limited to 1.4 […]
[KB488] Changing the HDS tables
Applies to: PcVue version 8.10 onwards. Summary: This article explains how a manual modification of the tables created by the HDS can cause certain errors and in particular memory leaks. […]
[KB484] Troubleshooting HDS database creation or connection
Applies to: PcVue version 8.10 onwards. Summary: You start PcVue with a data archiving configuration using the HDS and that doesn’t work! Here is a checklist for troubleshooting the problem. […]
[KB479] How to generate TS column if it is absent from the database
Applies to: PcVue all versions. Summary: This article explains how, when using the HDS, to generate a TS column by using an SQL query. Details: TS is an optional column. […]
[KB478] When replication doesn’t work anymore
Applies to: PcVue versions 8.10 to 10.0. Summary: If an error occurs when using the Replication Manager it may prevent success of the replication. For example, if you lose the […]
[KB460] Maintenance plan – Purge
Applies to: PcVue version 8.10 onwards. Summary: This article helps you to understand why the Purge task is useful and how best to control it. Details: What’s the difference between […]
[KB435] HDS Maintenance task
Applies to: PcVue version 8.10 and version 8.2. Summary: This article concerns any PcVue 8.10 project that has been migrated to PcVue 8.2 onwards and which uses the HDS.The technical […]
[KB370] ODBC with PcVue x64 OS
Applies to: PcVue all versions. Summary: This article describes how to use PcVue and ODBC on an x64 operating system Details: First read the article titled Managing Data Sources on […]
[KB359] HDS Replication and SCADA Basic
Applies to: PcVue all versions. Summary: A SCADA Basic program to manage HDS replication. Details: To use it, unzip it and copy the .ini file in TP directory (the program […]
[KB277] HDS trendgroup update rate applied to timestamped protocols should be set to 0s
Applies to: PcVue version 8.10 SP4 onwards. Summary: HDS trendgroup update rate applied to timestamped protocols should be set to 0s Details: This concerns only trends. When archiving trends with […]
[KB276] HDS archiving – Error when using compressed disk options
Applies to: PcVue version 8.10 onwards. Summary: HDS archiving – How to fix the error which occurs if using compressed disk options. Details: If following compressed options are ticked on […]
[KB45] How to export an ODBC Link used in a PcVue project
Applies to: PcVue all versions. While the basic content of this article remains valid, details may have changed since it was written. Summary: This article describes how to export an […]
[KB36] Proprietary archiving: binary and ASCII index files
Applies to: PcVue all versions.While the basic content of this article remains valid, details may have changed since it was written. Summary: This article describes the relations between index files […]
[KB35] Improving the performance of ODBC queries
Applies to: PcVue all versions. Summary: This article describes how to improve the performance of queries via ODBC (Open DataBase Connectivity). Details: For convenience this facility replaces coded ODBC queries […]
[KB34] Compatibility problems with ODBC archiving
Applies to: PcVue version 7.20a onwards. Summary: This article describes how to deal with a change in the format of log tables for use with ODBC (Open DataBase Connectivity). Details: […]
- 1
- 2