We have some java code that queries PI using PI JDBC. Sometimes, it seems to return partial results?
Is it because it's timing out? I tried the same using PI SQL Commander and got the same behavior.
Could you please share more details about your issue (the query, PI JDBC/PI SQL DAS versions, any relevant log messages, screenshots of query results and actual archive data would help too)?
Thank you for getting back!
below is the query we use
SELECT i.Time, i.Value, eh.Name FROM [APS Weather].[Asset].[ElementHierarchy] eh INNER JOIN [APS Weather].[Asset].[ElementAttribute] ea ON ea.ElementID = eh.ElementID,
[APS Weather].[Data].[ft_InterpolateRange] i WHERE eh.Path = N'\Arizona\' and ea.Name = 'GHI' AND i.ElementAttributeID = ea.ID AND i.StartTime = N't-9d' AND i.EndTime = N't+2d' AND i.TimeStep = N'1h' ORDER BY eh.Name, i.Time
Below is the example of the results we get
This should return us more than 4000 rows based on the data we have. However, it sometimes returns only 300 or 400 when we run it the first time. If you run it a few times then it gives you back the whole result set. I have tried it with the application as well as SQL Commander. Both have the same behavior
PI SQL DAS Version - 1.3.3.0259
Retrieving data ...