Search not working. Phone ringing incessantly. Severity 1 and 2 tickets being raised by Service Center @ speed of light. Damn!! This Search had to fail on a Friday Night.
Phew!!! All of us ALUI/WCI/Plumtree Portal Administrators must have faced this issue one or the other time. After a recent such outage with Search I decided to write down some common remedies for Search.
As usual, I do not vouch for these, but I have seen them work in our portal environment. Please use your brains and do not just follow everything mentioned here cause I am a lazy blogger and might have missed some points.
Search Rebuild Using Search Service Manager:
Under Select Utility Choose Search Service Manager
In the Next Repair Date, Choose a date in the past. Suppose today is August 4,2010 then choose a date from last week.
This causes the Search Update Agent to perform an index repair (or, in this case, rebuild) the next time it is run. Once you have selected an older date click on Finish.
No go ahead and run the Search Update job. Normally there are 3 search update jobs. Please unscheduled the other 2 search update jobs and run just one of the jobs. You will see that the job runs in Repair Mode. Once the job completes successfully, it would have repaired your index and your problems should be resolved.
The Database Method:My boss tells me I am the most irresponsible person, when I tell him to perform this step. But let me tell you, responsible or not…..this works always….without fail. Let me explain the scenario when this works.
Suppose you have 10 folders and 100 documents in your portal and for some God forsaken reason you are seeing only 96 of those 100 documents. No matter what you do, the other 4 documents do not come up in search. Now is the time to step into the DB server and try restoring order into this portal by rectifying the issue.
Go ahead and browse through the tables of your portal and find two tables “PTSEARCHSTATUS and PTCARDSTATUS” Change the status columns of PTSEARCHSTATUS table to 1 while the PTCARDSTATUS takes a value of 4
Now go ahead and simply run your Search Update job. Voilla!!! All 100 documents will be searchable.
Oracle has started a very good thing of recording their free webinars and allowing others to go through them and even download them for later reference.
Recently they conducted a webinar on Search. Please find below the URL for your reference:
The Search Webinar can be downloaded for viewing here:
https://oracleaw.webex.com/oracleaw/lsr.php?AT=dw&SP=MC&rID=56494767&rKey=99a5997008e7d549
