PcVue Forum - Recent Topics

PostgreSQL Error creating insertion cursor

pcvue_administrator — Thu, 21 Dec 2023 09:44:10 +0000

PostgreSQL Error creating insertion cursor

Number max of items per group in OPC UA

pcvue_administrator — Thu, 21 Dec 2023 09:43:51 +0000

Number max of items per group in OPC UA

PostgreSQL Error creating insertion cursor

pcvue_administrator — Thu, 21 Dec 2023 09:43:27 +0000

PostgreSQL Error creating insertion cursor

Anonymous 2093 — Wed, 20 Sep 2023 20:21:13 +0000

Hello! When using a PostgreSQL database in a project, the client receives the error: SGBD postgres (Name) -> trends: Ошибка создания курсора вставки (Error creating insertion cursor). Tried to enable Use Declare/Fetch (didn't help). Has anyone encountered such a problem?511

Number max of items per group in OPC UA

Giulia Magnesa — Fri, 15 Sep 2023 14:01:15 +0000

Hi all Does anyone know something about a number max of item in an opc-UA group ? A customer told me he encountered problem with a Siemens S7-1500 With one group at 1sec (5000 variables) PcVue could not refresh any variable He finally created 4 groups (300ms / 500ms / 700ms and 1100ms) and all was running perfectly. Thanks a lot Nicolas

Compatibility with WMI and PcVue

c.pinasanz — Wed, 06 Sep 2023 21:57:52 +0000

Hi, A customer needs to enable the WMI (Windows Management Instrumentation) feature on each machine where PcVue is running. PcVue 15.2 Windows 10 Pro 22H2 Windows Server 2019 Standard Do you know if it is compatible with PcVue? Any experience? Thank you!! Claudia

WHATSAPP tutorial

s.mansoor — Fri, 01 Sep 2023 19:18:49 +0000

510WhatsApp is one of the world's most popular social media messaging apps, and a popular one in India. REST Provider offers us an easy way to send messages / alarm notifications from PcVue to WhatsApp. Prerequisites: - 1. There should be continuous uninterrupted internet connection for the PcVue running PC where Whatsapp need to be configured. Basically, as whatsapp runs with Internet. 2. Please look for a legit Whatsapp API provider, so that we get proper details like "instance key"& "API key" to integrate this accordingly. Make sure that the chosen plan of that API shall have unlimited sending messages and specifications as per the requirement. 3. In this phase, we used Whatzapi API provider for testing. How to install REST ADO.NET Provider: - 1. Download the latest providerversion from FTP. 2. Unzip the file: sv-adonet-provider_REST_XXXXX.msi (XXXfor the latest version). 3. Install the file like usual.exe file. The installation is complete !! The provider is now visible in PcVue SQLConnection (Data source: Built-in providers). Steps to do on Whatzapi side: - 1. Go to https://app.whatzapi.com/auth/login.php and SIGN UP. 2. After SIGN UP, you will receive a whatsapp message with login credentials. 3. Login with the user credentials received on the whatsapp. 4. Go to Device tab, Generate QR code and scan the QR showing in the whatzapi account with your whatsapp account. 5. Then, you will see the account is connected and you can find the details like "instance key" & "API key" in the API tab in whatzapi account. --->To be continued in the attached file for reference... Regards, Mansoor

Installation tutorial

AD — Thu, 31 Aug 2023 18:28:43 +0000

PostgreSQL is "the world's most advanced open-source relational database". It's made by PostgreSQL Global Development Group. Unfortunately, PostgreSQL like some open source projects such as Maria DB does not offer a ready to use ADO.NET provider. Once the binaries are obtained it is possible to install a third party provider with the tool : "ProviderInstaller.exe". To be detected by PcVue, each ADO.NET provider must be installed in the Global Assembly Cache (GAC) of the .NET framework and referenced in the machine.config file. The tool "ProviderInstaller.exe" is there to facilitate this task. -- How to install PostgreSQL ADO.NET Provider -- Optional: Build Binaries for .NET from EDB Connectors => PostgreSQL Precompiled Binaries for .NET https://www.enterprisedb.com/software-downloads-postgres, select following version of binaries: Windows x86-32 and merge assemblies (.dll) from netstandard2.0 folder with a tool like ILMerge. 1. Download Attachment "ProviderInstaller - PostgreSQL.zip" 2. Extract "ProviderInstaller - PostgreSQL.zip" to "ProviderInstaller - PostgreSQL" 3. Open CMD prompt as Administrator 4. Change directory to be in "ProviderInstaller - PostgreSQL" directory Ex: cd "C:UsersardeDownloadsProviderInstaller - PostgreSQLProviderInstaller - PostgreSQL"
5. Run following command: ProviderInstaller.exe /install
The installation is complete !! The provider is now visible in PcVue SQL Connection (Data source : Other providers). -- Connection string -- . Connection string without password: host=127.0.0.1;username=postgres;database=MyDatabase;port=5432
. Connection string with password: host=127.0.0.1;username=postgres;password=MySecret;database=MyDatabase;port=5432
-- Sql queries -- . Create a database CREATE DATABASE MyDatabase
. Create a table CREATE TABLE MyTable (col1 INT)
. Insert a value INSERT INTO MyTable (col1) VALUES (1)
. Display table content SELECT * FROM MyTable
Found more samples here509

Mysterious logoff timeout

n.kunzer — Tue, 29 Aug 2023 22:00:22 +0000

Hello, I have the following messages in Event Viewer 2023/08/24,12:42:34.484,6,I,,19434,,1,User rights, user authentication 'userName' succeeded, bound to profile 'userProfile', cause: interactive logon 2023/08/24,17:27:45.054,6,I,,19564,userName,1,User rights, user 'userName', logout, cause: interactive logoff, timeout But, in the Profile settings, the "automatic logoff" is not Enabled !!! Is it a more 'general' auto-logoff setting somewhere? Version is 15.2.2 Nico

CoDeSys Vulnerabilities

AT — Tue, 15 Aug 2023 14:34:50 +0000

On 11th August 2023, there was a report done by Microsoft regarding the vulnerabilities present on PLCs that runs on the CoDeSys platform for programming. The vulnerabilities include the risk of Denial of Service (DoS) and Remote Code Execution (RCE). That means that the owner of the PLC can be locked out of the device and bad actors could program the PLC to perform hazardous tasks which might endanger people or certain operations. https://www.microsoft.com/en-us/security/blog/2023/08/10/multiple-high-severity-vulnerabilities-in-codesys-v3-sdk-could-lead-to-rce-or-dos/ While it does not affect PcVue, but at the same time, wouldn't this "vulnerability" be the same in PcVue as most of our configuration file, and even SCADA Basic files are exposed as plain text?