PI AF Audit Trail - pisquare.osisoft.com
The audit trail information should be stored in tables in your PI AF database, so they will move with your SQL database. Look up "SQL Server change data capture". I believe the audit trail …
How To Retrieve Min, Max, Avg using PI Web API? - AVEVA
Adding Coresight Database Backup to AF (PIFD) Database Backup SQL Server Job Salutations. I am hosting Coresight and AF on the same W2K12R2 server using SQL Server 2014 Standard …
Connecting PI Processbook with SQL Server Automatically - AVEVA
How are you connecting to SQL Server from the ProcessBook display? Are you using ADODB objects? I believe the ProcessBook display should rely on single sign-on via a trusted …
Unexpected Server Error: 'SQL Error (209) Ambiguous column …
It is learnt that user restored the old AF SQL database (AF Server 2012) to their new AF Server machine (AF Server 2014 R2). Since the database schema is different between the two AF …
PI Vision 2017 Upgrade Results in 401 - Not Authorized - AVEVA
Jun 2, 2017 · My Server is 2012 R2. It is running SQL Server 2014 Standard Edition and hosts the Asset Framework Server (2016 R2) Database also. The upgrade completed successfully. …
Write to SQL server using OleDb based upon selected row in SQL …
A SQL database contains lab data that will be sent to PI. I have worked out how to sent the data to PI. Now, after the data has been sent to PI, I want to doublecheck that it is there in PI, and …
PI AF, CLR and SQL servers in enterprises - AVEVA
A couple of DBAs like to review all of the AF SQL logic, which is several MB of SQL. Some DBAs refuse modifications to master or msdb or model database. (AF 2.2 does not modify these …
PI Notification to test SQL connectivity as data source - AVEVA
From the SQL server in AF server, I am able to see database table from the SQL data source. How do I map a tag from the SQL data source based on the result of a query to a PI tag or AF …
Trying to create AF systems behind load balancer, but must …
We're attempting to set up two AF systems behind a network load balancer. However, we must manually create the database as there is an existing PIFD database on this SQL Server instance.
PI SDK Buffering without live connection - AVEVA
A persist string must be created from an initial connection to the Server before disconnection. I have not tried to restore a persist string without a connection, but suspect it will not work.