• Combine rows into comma separated values

    I have the following query: Select  erc.Value as [ZONE] ,  el.Name as [LINE] from [AFDB].[EventFrame].[EventFrame] ef   INNER JOIN [AFDB].[Asset].[Element] el ON el.ID = ef.PrimaryRefer...
    last modified by DonKiser
  • Is there any way possible to use parameters in PISysOleDB?

    Is there any way at all currently to use named or unnamed parameters through PiSysOleDB (@pwhaterer, ? - unnamed, :pwhatever)? for Data.Interpolated.StartTime and EndTime? so that I can produce an ad-hoc report on AF ...
    last modified by fisher_johnp
  • Can escape methods be used with PIOleDB and vb.net to prevent SQL injection attacks?

    Take a look at the SQL injection entry on Wikipedia, under the heading "escaping".  I'd like to avoid potential SQL injection attacks in my coding of OleDB with the PI server.  If that can be done with ...
    last modified by cjrancur
  • PI exposed as a Linked Server

    Are there any good walkthroughs of exposing PI as a Linked Server? (Too lazy & busy to have a look )   Particularly interested on example queries combining data from PI Linked Server and the host SQL Server.
    last modified by RJKSolutions
  • Problems with PI OLEDB Provider in 64 bit WinXP dev environment

    Hi   I'm trying to figure out why I get the following message when using the PI OLEDB Provider in a 64 bit Visual Studio project:   "The 'PIOLEDB.1' provider is not registered on the local machine."   I...
    Asle Frantzen
    last modified by Asle Frantzen
  • "Invalid value for registry" when opening PI OLEDB Connection

    I have the following setup:   -Win2k8 R2 (x64) -PI -PI OLEDB x86 - IIS 7.5 - .NET 4.0 / Visual Studio 2010   I have created a WCF services, which accepts requests for data input/output from PI...
    last modified by MichaelvdV@Atos
  • Inserting overflow record

    Data is updating in primary PI server (2012 version ) but not in secondary pi server for specific point source all most all tags around 300. When I have observed in logs I found below message.   Inserting overf...
    last modified by NimmaniPrasad
  • What would make RTQP queries  intermittently Time out. The first execution returns in 2 seconds the next Times out. We recently updated the Server . How Can I detect what the problem really is.

    Select top 50 * from [MASTER].[ELEMENT].[Attribute] ea INNER JOIN [MASTER].[ELEMENT].[ARCHIVE] a ON a.ATTRIBUTE= ea.ID  and ELEMENT = 'XXXXXXX'  and NAME like  '%7-7%' Where a.TIMESTAMP BETWEEN '04/...
    last modified by RandolphT
  • Error while installing PI OLEDB Enterprise 2017R2

    Hi,   I am trying to install OLEDB Enterprise 2017 R2 and I have AF 2018 SP2, but i am getting error as below. Can anyone tell tell why i am getting this AFclient version error. Regards, Ritu
    last modified by Lipi
  • PI OLEDB query for avg values

    Hello Experts,   I am having an issue with a SQL query using PI OLEDB.   I have two tags, the first one has int values and the second has a string value. The timestamps are the same for both tags.   ...
    last modified by oolabode
  • timeEq filter questionable

    Hello,   I notice that the function timeEq includes the duration of questionable values, even if we filter the questionable values in the WHERE clause.   Is there any way to make the function timeEq, ...
    created by JoaoReis
  • JDBC 2019 Invalid sub-protocol

    I am connecting to JDBC 2019 with no specified properties.   I get this warning message for PI: com.osisoft.jdbc.common.DriverImpl acceptsURL SEVERE: Invalid sub-protocol provided in jdbc:pioledb://dasName/Data...
    last modified by BrunoDevos
  • Loading data into PI Server

    I need to test real time data access from PI Server. For this I need to load data into PI Server. What tools or approaches can I use to upload data into PI Server
    last modified by jagdishaswath
  • PI SQL Custom Table Valued Function

    I'm working with some relatively discrete laboratory analysis data that is being stored in PI at the same time for multiple attributes. The current GetSampledValues only allow for iteration over time ranges with times...
    last modified by dgrigsby.fw
  • PI SQL Commander - AF Attribute - range and sampled data

    I am trying to get range for "Dust" Attribute and sampled data for "PF10" attribute for a timestep of 20s. Below snap shows archive data for both the attributes. Can anyone help me with syntex for finding range and s...
    created by JavithFareeth
  • Pivot\Transpose a View Rather Than a Data Table

    Was wondering if the Transpose function can be used to transpose a view?
    last modified by sidwahab
  • Catalog name piarchive is invalid

    Hi Friends,     I have set up a query to read the data from Pi Server into SQL Server and the query works fine. However, when I save this query as a SQL Server Integration Service Package and run the same, ...
    created by tajammul
  • PI RTQP and User Authentication

         I am having trouble configuring our RTQP server and user authentication the way i want to.  In reading through the admin guide it only provides instructions for adding a mapping/trust for the ...
    last modified by Julian.Beresford
  • Digital Tags Data showing incorrect SQL Commander

    Hello Everyone!   I have configured digital tags, which values I can see good in Archive editor but in SQL Commander it is showing incorrect please check below screenshots.   PI SQL Commander:  ...
    last modified by AKASH MISAL
  • PI SQL Commander Case format

    What is the case format in PI SQL Commander?   Thank you.
    last modified by RobertHymes