• I am trying in MS-SQL to write: SELECT [tag],[time],[value],[status] ,[timestep]  FROM [PI].[piarchive]..[piinterp2] Where tag = 'sinusoid' and [time] between '*-1h' and '*'and [timestep] = '30m' GO

    I am trying in MS-SQL to write:   SELECT [tag],[time],[value],[status] ,[timestep]   FROM [PI].[piarchive]..[piinterp2] Where tag = 'sinusoid' and [time] between '*-1h' and '*'and [timestep] = '3...
    BjaNyg
    last modified by BjaNyg
  • query to contextualize EFs AND archived attribute values

    Hello, I'm new to the SQL family of products and was hoping someone could help me create a query that will: 1. gather EF data: get start and end times, durations, parent EFs and any EF attributes + values (we have a...
    narburgh
    last modified by narburgh
  • Link to download PI JDBC Driver setup kit

    Hello, do you know where I can download PI JDBC Driver setup kit?  The OSIsoft Tech Support Downloads page (https://techsupport.osisoft.com/Downloads/All-Downloads/) does not seem to have it.  Thank you.
    MINHTRAM
    last modified by MINHTRAM
  • We have installed RQTP Data Engine and I can query through SQL Client to get values from AF database.  How do I use PI SQL Client to query tags that are not in the AF but are solely in the Data Archive?

    So we are new to PI.  We have installed RQTP Data Engine and I can query through SQL Client to get values from AF database.  How do I use PI SQL Client to query tags that are not in the AF but are solely in ...
    SharZ
    last modified by SharZ
  • PI JDBC connection error

    Hi Everyone,   We have been using PI JDBC to retrieve data from PI AF via DAS into R. Everything is working great until one of the function's table in an AF database becomes invalid (e.g. due to amendment/remova...
    kuehcj
    last modified by kuehcj
  • Execution timed out with piinterp table

    Hi,        I always report errors when inquiring with ODBC  "select * FROM piarchive..piinterp WHERE tag='xxx' and time between '2019-09-06' and  '2019-09-09' "  Or&...
    sharon.meng
    last modified by sharon.meng
  • PI SQL Commander Query

    To get all milliseconds interval data from query. For eg: I want to fetch data of time '2018-07-26 07:15:00.543' But when i try to execute query :   SELECT tag, time, DIGSTRING(CAST(status AS Int32)) digsta...
    Bhavesh_22
    last modified by Bhavesh_22
  • Extract data from PI System Management Tools(Archive Editor)

    Hi Everyone,   I really need help! I am very new to this and spent very long time with no success yet. I need to retrieve data from the archive editor in the PI System Management Tools. I want to be able to upd...
    ziadelghoul
    last modified by ziadelghoul
  • PI OLEDB Select question

    Hello,  I'm trying to do what Ithought was a simple query but I've already spent way to much time trying to get it to work. I feel like I'm just running into a syntax problem and am hoping to get some help with ...
    DaveThompson
    last modified by DaveThompson
  • Data INSERT not persisting after restart.

    We have a day and a half gap for 2800 tags. I was asked to read the data from PHD and write to PI. I am using a Python script to get the data for each tag (iterate through list of tags) then write it to PI. The data w...
    Etienne
    last modified by Etienne
  • How to get previous value for AF attributes?

    Hi, I need help to find a way to efficiently get the last value of a two AF attributes (PI tags) before a given point in time, i.e. I want to get the PrevVal for a set of AF Attributes   The constraints are I...
    wilsona
    last modified by wilsona
  • PI Data link Calculated Max Value Ignore Dates

    Hi I am using PI Datalink with “Calculated Data in max mode” and have it set up as follows    Data Item = ‘Tag name’ Start Time = today End time = -1year Mode = Max   ...
    AndrewCamuso
    last modified by AndrewCamuso
  • where can i download software and interfaces from? where is the download area of the customer portal? please make it easier to find

    Im not sure if its because osisoft have changed their landing page, but i cannot find the customer portal log in url . Can someone please post a link thank you
    ctgarvey2
    last modified by ctgarvey2
  • PI JDBC Driver Java compatibility

    Hi,  Do there exist some kind of overview on which versions of PI JDBC Driver is compatible with which version of Java (Java 8, Java 11 etc)?  Thanks, Erik  pi jdbc driver java
    hodneeri
    last modified by hodneeri
  • How to extract 1-minute average once per hour?

    Hello,   I am having trouble trying to figure out how to get one-minute average values once an hour. Specifically I'm hoping to extract a one minute average from 18 after the top of the hour each hour (at 09:18, ...
    rfmii
    last modified by rfmii
  • How to consume Event Frames from AF DB using PI SQL Commander?

    Hi PI Friends.   I have a question. How I can to generate a SQL query in order to consume the data of event frames directly from AF database? I need event frames name, startime, endtime, duration, and the rest o...
    ccastro
    last modified by ccastro
  • NEED INSTALL KIT OF PI OLEDB ENTERPRISE 2017 R2

    Hello Everyone!   I need to install PI OLEDB ENTERPRISE 2017 R2, I have search in product list but I couldn't see install KIT separately, also this is not included in AF service 2017 R2 update, please check...
    AKASH MISAL
    last modified by AKASH MISAL
  • I need to copy all values from one tag to another backup tag. What is the best way ?

    I'm using pi sql commander but I'm not sure if this is the best solution. But I'm having timeout issues because of the large amount of records Here is an sample query I'm using in Pi SQL Commander. It is an insert wi...
    Dante_QP
    last modified by Dante_QP
  • Linked Server Connection Failing

    Hi   I have a Linked Server built in SQL Server, which I am using to run queries on piarchive, however the connection fails intermittently with the error:   "OLE DB provider "PIOLEDB" for linked server "WI...
    Derek_Aherne
    last modified by Derek_Aherne
  • OLE DB provider "PIOLEDB" for linked server  returned message "Timeout has expired.".

    We have had this job running for over two years now but suddenly I am getting this error and job is failing.   OLE DB provider "PIOLEDB" for linked server "xxxxx" returned message "Timeout has expired.". Msg 732...
    ArchNandakumar
    last modified by ArchNandakumar