Incremental scan fails with exit code 1 while consuming scan reconciliation database

Problem

Incremental scan for shares fails with Exit Code 1

Error Message

commd0.0.log:2017-09-26 22:01:55 WARNING: #{22} [Scanner$ScannerThread.scanJob] Scanner for share [MSU ID] failed with exit code: 1 (incremental:true)ext#_msu###.rlog2017-09-22 22:02:42 ERROR: V-378-1310-5264: #{3444} [db_prep: 274] db|Failed|db_prep|sqlite3_prepare_v2|sql=SELECT id, pathname, type, timestamp FROM ipath WHERE id>:id LIMIT :max_rows|sqliterr=1.
2017-09-22 22:02:42 WARNING: V-378-1310-5026: #{3444} [__db_traverse_close: 193] db|Warning|db_traverse_close|prepare is null.
2017-09-22 22:02:42 INFO: V-378-1310-5029: #{3444} [__db_traverse_close: 230] db|Success|db_traverse_close.
2017-09-22 22:02:42 INFO: V-378-1310-5689: #{3444} [reh_verbose: 59] veh|Success|RemoveVectoredExceptionHandler|returncode=1.

Cause

A database query is incorrectly calling for the timestamp field, which does not exist in the path reconciliation database.

Solution

Please apply Data Insight 6.1 HF1 which can be downloaded from SORT at the following location:

DataInsight6.1HF1