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
[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 […]
[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. 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 […]
[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