AnsweredAssumed Answered

PI RDBMS - Historical Recovery from Spectrum History Scheme

Question asked by ClaudioMartinez on Oct 18, 2018

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!!!!

Outcomes