lucene-general mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Shalin Shekhar Mangar <shalinman...@gmail.com>
Subject Re: DIH Delta Import not working
Date Fri, 30 Sep 2011 09:27:38 GMT
Do you have a uniqueKey configured in your schema.xml ? Is the unique key's
value the same in record1 old and new value?

On Thu, Sep 29, 2011 at 2:17 AM, surinekkalapu <surinekkalapu@yahoo.com>wrote:

> Hi,
>  We are using sole 3.4.0. Full import was working very fine except it is
> taking too long for indexing. As we have time contraint we want to do delta
> indexing instead of full import everytime.
> Below is the scenario.
>  1. Did a full import. Indexing successful and able to see the records from
> solr admin tool.
>  2. Update record1 in the database table and did a delta import.
>       a. Logs shows delta import successfull and index now shows both
> record1 old value and record1 new value.
>  Note: I was expecting only the new value for record1 but for some reason
> old values in the index are getting removed.
>  3. Now updated record2 in the database table and did a delta import again.
>       a. Logs shows delta import successfull and index now shows
>                record1 old value (record1 new value is more displayed),
>                record2 old value and record2 new value.
>  Note: I was expecting only the new values for record1 and record2.
>
>  If anyone encounter similar scenario, please can you help me resolving
> this issue? Am i missing something in the configuration?!!
>
> Below is the snippet from database-config.xml showing my queries.
> -----------------
> <document name="documents">
> <entity name="document" pk="ID"
>      query="SELECT ID, TITLE, rownum + 50000 UKNUMGEN FROM DOCUMENTS WHERE
> DOC_TYPE != 'E' AND CURRENT_STATUS = 'In Review'"
>      deltaImportQuery="SELECT ID, TITLE, rownum + 50000 UKNUMGEN FROM
> DOCUMENTS
>  WHERE DOC_TYPE != 'E' AND CURRENT_STATUS = 'In Review' AND ID =
> '${dataimporter.delta.ID}'"
>      deltaQuery="SELECT ID FROM DOCUMENTS WHERE last_change_date IS NOT
> NULL and (last_change_date > to_date('${dataimporter.last_index_time}',
> 'yyyy-mm-dd hh24:mi:ss'))"
> >
> <field column="DOC_ID" name="ID"/>
> <field column="DOCUMENT_NUMBER" name="DocumentNumber"/>
> <field column="TITLE" name="DocumentTitle"/>
> <field column="UKNUMGEN" name="UKNUMGEN"/>
> </entity>
> </document>
> ------------------------------------
>
>
>
> --
> View this message in context:
> http://lucene.472066.n3.nabble.com/DIH-Delta-Import-not-working-tp3377360p3377360.html
> Sent from the Lucene - General mailing list archive at Nabble.com.
>



-- 
Regards,
Shalin Shekhar Mangar.

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message