Failed Reads query

The Failed Reads query returns the file name of any import files that have failed to process fully.

select fiMain.uncfilename, t.ExpectedReadings, t.ImportedReadings from FileInventory fiMain

join (select fiXML.FileID, sum(fiXML.NumVRead+fiXML.NumERead+fiXML.NumNRead) as ExpectedReadings, tmp.NumReads as ImportedReadings

from FileInventorySegment fiXML

join (select fisWB.ParentFileID, sum(fisWB.NumVRead+fisWB.NumERead+fisWB.NumNRead) as NumReads

from FileInventorySegment fisWB

join FileInventory fiWB on (fiWB.fileid = fisWB.fileid) where fisWB.fileid in (

select parentfileid

from FileInventorySegment fis

join FileInventory fi on (fi.fileid = fis.fileid) where fi.filetype = 2

and fi.filestate > 0

)

and fiWB.endtime is not null group by fisWB.Parentfileid) tmp

on (tmp.Parentfileid = fiXML.FileID) group by fiXML.FileID, tmp.NumReads

having sum(fiXML.NumVRead+fiXML.NumERead+fiXML.NumNRead) != tmp.NumReads) t on (t.FileID = fiMain.FileID)

and fiMain.endtime is null;

Related topics:

• FileInventory table

• Interpreting ARI file types and states

• Import Statistics query

• Reads Processed query

• Reading table