We are experiencing an issue with our PI Interface for RDBMS via ODBC where unexpected data entries are being recorded in the PI System. Specifically, data with timestamps beyond the latest entries available in the SQL database are appearing in the PI System (The PI data is being recorded at every scan class 1 minute interval but The source data from SQL has a time interval of 15 minutes.)
Details of the SQL Database Retrieval and Tag Configuration
1. SQL Database Retrieval:
The data retrieval from the SQL database is performed using RxC (row by column) distribution with aliases. The columns used include PI_TIMESTAMP, PI_TAGNAME1, PI_VALUE1, etc., following the manual under the section "Update points from more rows and columns (RxC row by column distribution using aliases) with SELECT list columns renamed."
2.Tag Configuration:
- ExDesc: P1=TS /ALIAS=32622711_v_w
- InstrumentTag: query.sql
- Location1: 1
- Location2: 1
- Location3: -2
- Location4: 4 ( f = 00:01:00)
3. Location5 Configuration Attempts:
Various settings for Location5, ranging from -1 to 4, have been tested, but the results remain the same.
RDBMS interface bat file
sql file (query.sql)
PI Data
The data at timestamps 14:15, 14:30, 14:45, and 15:00 are correct. Any other timestamps are unexpected
Message log
The highlighted portion of the log image shows entries that are unexpected.
Thank you for your support!