Sunday, February 26, 2017

Can Endeca Partial Indexing be performed after inventory or direct SQL update?

Behaviour As per default behavior of ATG Endeca integration, Endeca Partial indexing does not update index with inventory update. ATG driv... thumbnail 1 summary
Behaviour
As per default behavior of ATG Endeca integration, Endeca Partial indexing does not update index with inventory update. ATG driven partial index looks for IncrementalItemQueueRepository and this repository does not get updated during direct SQL update or inventory update.

Solution
Endeca Partial Indexing triggered from ATG layer look for srch_update_queue table to fetch the product/sku id to apply for partial update. 

Write a job/code to insert the sku/product id to srch_update_queue table with proper status so partial process can pick it up. Invalidate the IncrementalItemQueueRepository cache and run the partial indexing from dyn/admin. This will identify the updated data and update back to Endeca MDEX engine.




From Author

Was this post resolve the solution you are looking for? what do you think about this solution?Provide your comments

1 comment

  1. I have tried entering the following record in the srch_update_queue table and invalidated IncrementalItemQueueRepository cache
    REPOSITORY_ID:prod10006
    CONFIG_REPO_ID:100002
    GENERATION:1000
    ITEM_DESC_NAME:product
    CHANGE_TYPE:0
    SUB_DESC_NAME:product

    Partial Index is not getting invoked automatically, so I tried invoking manually but it did not pick up this record.

    Kindly suggest.

    ReplyDelete

Text Widget