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 …
AF Database Sql Error - pisquare.osisoft.com
Unexpected Server Error: 'SQL Error (9002) The transaction log for database 'tempdb' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in …
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 …
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 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. …
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 …
ADO.Net Sample code available? - AVEVA
Can you test the linked server in SQL Server Management Studios? If it does not connect, we should verify the linked server settings as well as verify a connection in the PI Server Message …
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.
PI SQL DAS gSOAP Channel HTTP Error
You mentioned you were able to login via PI OLEDB Tester using the same credentials. However, that application asks for PI Server username/pwd combos, while for PI SQL DAS, the …