Skip to main content
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Indexing_and_Hotswapping failed

    • Article Type: General
    • Product: Primo
    • Product Version: 2

    At times the cause for indexing stopping is when a large frbrmrg record is created (>15MB).

    If an OutOfSpace problem is encountered during indexing in v2, you can run an SQL query to check if this is the reason:
    select recordid from p_pnx where length(string_clob) > 1000000;

    This defect is being handled by development.

    To run indexing successfully we advise the following workaround:

    1) When running indexing, when there is already an existing index, enter the following commands:
    Update p_pnx set secontrol=3, updated_date = ' <Future date>' where length(string_clob) > 1000000;
    Future date should be about current date + 1 year ahead. For instance:
    Update p_pnx set secontrol=3, updated_date = '20-AUG-10' where length(string_clob) > 1000000;

    When running index from scratch:
    Update p_pnx set secontrol=-1 where length(string_clob) > 1000000;

    2) execute index

    • Article last edited: 10/8/2013
    • Was this article helpful?