Indexing_and_Hotswapping failed

Last updated
Save as PDF
Share
1. Share
2. Tweet
3. Share

Article Type: General
Product: Primo
Product Version: 2

Description:
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;

Resolution:
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