0 Replies Latest reply on Oct 18, 2018 7:22 PM by ClaudioMartinez

    PI RDBMS - Historical Recovery from Spectrum History Scheme

    ClaudioMartinez

      Hi Colleagues,

        I'm having some problems with PI RDBMS Instance execution to recovery Data from Historical Scheme of Spectrum (ORACLE). It doesnt work as well as know it.

       

      I prepare *.bat file with parameters to do historical recovery:

      --------------------------------------------------------------------------------------------------------------------------

      "E:\Program Files\PIPC\Interfaces\RDBMSPI_DIG\RDBMSPI.exe" 1 /DEB=4 ^

      /DSN=SPECHIS2PI ^

      /ExecDirect ^

      /Output="E:\Program Files\PIPC\Interfaces\RDBMSPI_DIG\Log\pirdbms.out" ^

      /SQL="E:\Program Files\PIPC\Interfaces\RDBMSPI_DIG\SQL" ^

      /User_ODBC=scada2sstt ^

      /pass_odbc=scada2ssttpro ^

      /UTC ^

      /PS=SPECTRUM2 ^

      /ID=2 ^

      /host=10.10.60.40:5450 ^

      /lb  ^

      /f=1  ^

      /RECOVERY=TS ^

      /RECOVERY_STEP=1d ^

      /RECOVERY_TIME="13-Aug-18,17-Oct-18" ^

      /pisdk=1

      --------------------------------------------------------------------------------------------------------------------------

       

      So I'd set *.sql file to this need:

      --------------------------------------------------------------------------------------------------------------------------

      SELECT TIMESTAMP AS PI_TIMESTAMP, VALUE AS PI_VALUE, 0 AS PI_ANNOTATION FROM V_DIGITALHIST WHERE TIMESTAMP > ? AND TIMESTAMP <= ? AND VALUENAME = ? ORDER BY TIMESTAMP ASC; P1=TS P2=TE

      --------------------------------------------------------------------------------------------------------------------------

      And I set Point configuration fields how I did in past successful opportunity

       

            

      Select Tagexdescinstrumenttagpointtypelocation1location2location3location4location5
      xCALLA.60.L6031.DESC2P1=TS P2=TE P3=AT.TAGSQL_to_PI_DI.sqldigital21001
      xCALLA.60.L6040.DESC1P1=TS P2=TE P3=AT.TAGSQL_to_PI_DI.sqldigital21001
      xCALLA.220.L2716.DESC1P1=TS P2=TE P3=AT.TAGSQL_to_PI_DI.sqldigital21001
      xCALLA.60.TRG3.INTP1=TS P2=TE P3=AT.TAGSQL_to_PI_DI.sqldigital21001
      xCALLA.220.L2008.DESC1P1=TS P2=TE P3=AT.TAGSQL_to_PI_DI.sqldigital21001

       

      And I dont know , why it didn't work ....

       

      somebody can help me with some lights!!!!