Browse searches not working for newly-added Logical base

• Article Type: General
• Product: Aleph
• Product Version: 20

Description:
I have created 3 new logical bases and added new criteria to a 4th. The browsing for 3 of the logical bases is not working at all and the fourth doesn't seem to include all relevant information.

Resolution:
tab_base.eng column 8 says whether the z0102 index will be used. The entries for your bases had "Y". That means that it expects there to be z0102 records for the bases.

I suggest two things:

1. Change this col. 8 to "N" and restart the www_server. This should correct the immediate problem and let the base be used successfully. If the number of records in these bases is more 10% of the total records, then leave it like this.

2. If the number of records in one of the bases is fewer than 10% of the total, then, over the weekend or whenever you have time, change the tab_base entry back to "Y" and run p_manage_32 to regenerate the z0102 table.

Note: util h/1/10 will show you how many records are in each base.

• Article last edited: 10/8/2013