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 connection with the …
Can the PI AF SQL database be put on an existing SQL database server
Reply Roger Palmen (Partner) 10 years ago That's probably somewhat hidden in terminology: A SQLserver database is like a car, consisting of an engine and multiple seats. The engine is the …
Cannot insert the value NULL into column 'SecurityDescriptor', table ...
Sep 12, 2018 · Can you confirm this by running the following sql statement directly on the PIFD sql database? select name from dbo.afelementtemplate where fksecurityid is null If so, you can try to fix …
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 then use an …
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 element so that …
Creating Data in PI System. - AVEVA
14 years ago Aymen GHARBI Hi guys, I have an SQL database that contains historical data, can I export data from SQL database and import it to PI server ?? If you mean exporting the SQL …
Sign In - AVEVA
What is your Single Sign-On (SSO) account? An SSO account provides the login credentials you’ll need to engage with all digital communities, including: Learning (for training) PI Square (for peer and …
What and where is the table #tblElementHierarchy2
There is an intensive query on our SQL database that is blocking all access on the SQL server and AF databases, it is an insert into a table named "#tblElementHierarchy2".
Linked Server Query Timeout Not Working and Optimization of Snap …
2) Based on the question above the offended query is below, this query takes about 8 minutes to run in Sql Commander (the tool that comes with PI, so is probably not really a linked server performance …
OSI PI Moved to 64 Bit Windows but still running as 32 Bit - AVEVA
Once the services are stopped, rename the directory which the PI Server is installed on, so something similar to /PI-old. Once you have done that, do a complete re-installation of the 64 bit pi server, and …