AnsweredAssumed Answered

RDBMS Interface writes zero values when there is no data from Select query

Question asked by Piotr_Stach on Mar 31, 2017
Latest reply on Apr 6, 2017 by Piotr_Stach

Hi,

When there is no data from Select query the interface writes zero values with actual time stamp to pi tags.

Log:

Fri Mar 31 14:48:43 2017 [DEB-3]: P1=TS : 31-Mar-2017 14:33:44.260
Fri Mar 31 14:48:43 2017 [DEB-3]: P2=TS : 31-Mar-2017 14:33:44.260
Fri Mar 31 14:48:43 2017 [DEB-3]: P3=TS : 31-Mar-2017 14:33:44.260
Fri Mar 31 14:48:43 2017 [DEB-3]: P4=TS : 31-Mar-2017 14:33:44.260
Fri Mar 31 14:48:43 2017 [DEB-3]: P5=TS : 31-Mar-2017 14:33:44.260
Fri Mar 31 14:48:43 2017 [DEB-3]: P6=TS : 31-Mar-2017 14:33:44.260
Fri Mar 31 14:48:43 2017 [DEB-3]: P7=TS : 31-Mar-2017 14:33:44.260
Fri Mar 31 14:48:43 2017 [DEB-3]: P8=TS : 31-Mar-2017 14:33:44.260
Fri Mar 31 14:48:43 2017 [DEB-3]: P9=TS : 31-Mar-2017 14:33:44.260
Fri Mar 31 14:48:43 2017 [DEB-4]: Point - 1WPPW-7134-TEMP : 
timestamp=31-Mar-17 14:48:43.244; drval=0.000000e+000; ival=0; istat=0.
Fri Mar 31 14:48:43 2017 [DEB-4]: Point - 1WPPW-7134-TEMP : 
timestamp=31-Mar-17 14:48:43.244; drval=0.000000e+000; ival=0; istat=0.
Fri Mar 31 14:48:43 2017 [DEB-5]: uni_dsil [exit]>



 

Between 14:33:44 and 14:48:43.244 there is no data in source database so why value 0 is written to pi tag with timestamp 14:48:43.244 ? What's interesting it is written two times!

 

Capture.PNG

 

Thanks in advance, Peter.

Outcomes