How To Reset Last Modified Date On SES Incremental Crawl
Last updated on MARCH 08, 2017
Applies to:Oracle Secure Enterprise Search - Version 11.1.2 to 184.108.40.206
Information in this document applies to any platform.
In your latest release 3/29/2014, you made a mistake by setting some records with LASTMODIFIEDDATE to the future date (May 29, 2014).
As the result, all your incremental crawls since the beginning of the year , return zero record.
Fully re-crawl is not an option in this case, if you can avoid it , since it will take more than a week to fully crawl.
Is there a method to reset the "last modified date" to point to 3/29/2014 ?
11:00:11:722 INFO crawler_4 Crawler plug-in "Database Crawler Plugin" crawl starts
11:00:11:725 INFO crawler_4 Previous max. last modified date: 2014-05-29T23:59:59
11:00:11:725 INFO crawler_4 Query key only= false; SQL Statement = select * from (select * from (foo_EXT.foo_PACKAGES_ALL) mqry where LASTMODIFIEDDATE > ?) where "KEY" = ?
11:00:11:726 INFO crawler_4 No subqueries to create PreparedStatements
11:00:11:726 INFO crawler_4 Creating PreparedStatements for the subqueries
11:00:11:727 INFO crawler_4 AppJDBC crawler initialization: Connection string is
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms