• devdata.osisoft.com Certificate is expired.

    devdata.osisoft.com Certificate is expired. Gregor Beck could maybe check ?   ps i created also a ticket - 00785081  
    last modified by WolfgangPurrer
  • Connecting Processbook VBA with SQL server

    Hi All,   It is possible to use Processbook(VBA) to connect to get data from SQL Server and display in Textbox of Processbook.   If yes, any example to assist me. 
    last modified by Tigerhoe
  • PI OLEDB regarding

    PI OLEDB   We are still using PI-OLEDB-Enterprise_2012_.exe. With reference to upgrading Windows to 2012 in our company, was trying to download PI-OLEDB-Enterprise 2017 but it  shows as   ...
    last modified by Maitreyi
  • AFSDK afDB.FindChangedItems(AFIdentity.EventFrame, false, 1000, dbCookie, out dbNextCookie); is not working

    Hello, I am facing strange issue on AFSDK method "FindChangedItems" for finding changed EventFrames. This function is working perfect one AF Server, but it is not working on other AFServer. Let me explain you in de...
    last modified by SunilGajjarH
  • PI JDBC query: get archived values for a time frame, outside bounds

    Hello, I'm using PI SDL DAS with OLEDB Ent 2019 (we don't have AF 2018+ so I am unable to use RTQP as this time). What I'm trying to do is query archived values of attributes of a unit during the duration of an EF.&#...
    last modified by narburgh
  • Batch Requests process in pi web api using nodejs

    Hi  Could you please help  me on how to work with batch requests in pi web api using nodejs to access multiple requests in single http request    Thanks  Tarak
    last modified by Tarak128
  • PI Web API vs PI JDBC

    Which PI technology is better to develop java client ? We heard that PI web API would be bit slower than PI JDBC. The solution should support on windows and  Linux operating systems. 
    last modified by dreampangari
  • RTQP

    I 'm trying to create a new RTQP with PI SQL Commander Lite to retrieve data, but show this error.
    last modified by BiancaMuniz
  • PIDatalink function PITimeFilterVal

    Hi Community, I would to know if there is an equivalent function for the PITimeFilterVal(PIDatalink)   for pioledb tables. declare @s_Expression varchar(MAX) declare @s_StartTime datetime2 declare ...
    last modified by Alexis
  • Data reading performance

    Hi,   Does anyone have info on the difference in performance of reading data from the PI Server between OLDB client, OLEDB client or directly through the SDK?   Thanks!
    last modified by talh
  • Values are showing up in the "Status Column" while retrieving data from PI OLEDB

    Hi All, I am observing a weird problem while retrieving data of a PE tag from PI server using PI OLEDB (MMC & SQL Commander), the values of tag are showing up in the "Status Column" and I observed this only for f...
    last modified by vashavijay
  • How to change PI AF retrieval mode with SQL to get previous compressed time value?

    In this video I see mention of a retrieval mode http://www.youtube.com/watch?v=L43IPKXVopI.   What SQL query can I use to change the retrieval mode?   I want to get the previous compressed tag t...
    last modified by imqs
  • SQL statements in database reference

    I have two tables on a sql server. I would like to get the last name of an individual in the personnel table. The id of the person is located in another table  as "operatorId". I have both tables linked as tables...
    last modified by ByronCoughlin
  • Creating a Trend from a Data Set/SQL Database Information

    Good morning PI users!   I've recently been trying to include more and more information from our SQL database into our Process displays (i.e. fault summation and current active step).  However, I'm at an...
    last modified by PeteHerz
  • Newest record in table

    In AF linked a table that contains a field when the record was created. The join statement when I created the link returns one record. How can I pull out the oaId from the table using DR. Can't figure a where clause t...
    last modified by ByronCoughlin
  • Unable to update specific events in picomp2

    Hi all,   I need to update values of historical events in picomp2, using JDBC.   For some events it is possible, however for others, JDBC fails to update them, and 'false' below means no record was u...
    last modified by AhmedAshour
  • Need to know the configuration for communication to PI database

    Hi,   I am new to PI server.I am developed the java application to communication with PI database through the PI RDBS & PI JDBC interfaces in same machine.   My requirement is each system to inte...
    last modified by VigneshKarthik
  • Is it possible to write the data in PI database using PI JDBC

    Hi,   Please help.Is it possible to write the data in PI database using PI JDBC?.I am able to read the data by using PI jdbc.But I don't know how to push the data in PI database.   Please share some ...
    last modified by VigneshKarthik
  • How to write the DML commands into PI database?

    Hi,   I have one requirement states that the lighting subsystem will have the temperature,luminous etc as a parameters to be stored in PI database as well there can be multiple subsystems also.   Is ...
    last modified by VigneshKarthik
  • JDBC: PreparedStatement paremeters do not work

    Hi all,   In JDBC using paramters in PreparedStatement, the result is different from using normal SQL.   For these two cases:     @Test     public void test1() throws ...
    last modified by AhmedAshour