How To Reset Last Modified Date On SES Incremental Crawl (Doc ID 1664612.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Secure Enterprise Search - Version 11.1.2 to 11.1.2.2
Information in this document applies to any platform.

Goal

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 ?

jdbc:oracle:thin:@ldap://hostname:port/foo,cn=oraclecontext,dc=yourdb, user: mysesuser
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

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms