Historical data
Alarms
Audit and diagnostic
Communication interfaces
Configuration environment
Data acquisition
DataVue/Data Export
Development kits
General
Historical data
HMI
Known issues
Other Products
PcVue installation
PcVue miscellaneous
Real time data
Sample projects
Scripting
Security bulletin
SnapVue
System
TouchVue
UDC
Upgrade issues
Useful tools
Version Information
EmVue v1
FrontVue 15
FrontVue 16
PcVue 10.0
PcVue 11
PcVue 11.1
PcVue 11.2
PcVue 12
PcVue 15
PcVue 16
PcVue 6
PcVue 7.00
PcVue 7.20
PcVue 8.00
PcVue 8.10
PcVue 8.2
PcVue 9.0
PlantVue 2.6
WebVue
[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 […]
[KB20] Use of Chrono time-stamping to make SQL queries
Applies to : PcVue all versions with HDS. Summary : This article explains how to use Chrono for making SQL queries. Details : In HDS data storage, the TS field […]
[KB1244] How to import proprietary unit trends into HDS database
I- BASIC PRINCIPLE PcVue’s proprietary archiving was not designed to interact with third-party tools. As a result, only PcVue can retrieve the information contained in such archiving units. However, there […]
[KB1233] Optimisations for SQL database archiving with HDS
1. Limit HDS traces (especially on files as they generate continuous disk access), remove Audit traces especially Ojective: Reduce the load on the system by limiting HDS traces and removing […]
[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
[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 […]
[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. […]
[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 […]
[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 […]
[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. […]
[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 […]
[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 […]
[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, […]
[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 […]
[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 […]
[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 […]
[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 […]
[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 […]
[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. […]
[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 […]
[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 […]
[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 […]
[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 […]
[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 […]
[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 […]
[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”. […]
[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 […]
[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 […]
[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 […]
[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 […]
[KB21] How Proprietary Archiving Works
Applies to: PcVue up to version 9.0. The basic content of this article may also be applicable to later versions of Pcvue although the detail may vary. Summary: This article […]
[KB31] Warning about client server archive units
Applies to: All versions of PcVue until 8.00 that include the client-server archive unit functionality. Summary: Using a client-server archive unit, user actions that take place on the client – […]
[KB33] Double timestamp in archive units
Applies to: PcVue all versions. Summary: This article explains the difference between the two timestamp fields in proprietary archive unit files. Details: In the log files there are two timestamp […]
[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: […]
[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 […]
[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 […]
[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 […]
[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 […]
[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 […]
[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 […]
[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. […]
[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 […]
[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 […]
[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 […]
[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 […]
- 1
- 2