ue_01_z0102 too slow; ctx_sync_error and Oracle Text error
- Article Type: General
- Product: Aleph
- Product Version: 18, 19, 20, 21, 22, 23
Description
In xxx01/scratch/ue_01_z0102 log file or when saving a record using util f/1/13 the following error appears:
Oracle error: ctx_sync_error
ORA-20000: Oracle Text error:
DRG-10313: logging has already been star
or
Oracle error: ctx_sync_error
ORA-20000: Oracle Text error:
DRG-11134: The file /exlibris/app/oracle
Resolution:
Problem is the xxx01 table z91 for storing ADAM index objects.
If ADAM is not in use, the z91 should be dropped in the XXX01 library using the following SQL:
s+ XXX01
drop table z91;
If you do use ADAM
1. create the table again using util a/17/2 and util a/17/3.
2. Re-run service "Update Full Text Index (manage-91)" outside your working hours
Additional Information
Related articles:
ctx_sync_error, ORA-20000 and DRG-10502
util f/1/13: Oracle error: update_cursor z91; ctx_sync_error
- Article last edited: 18-April-2016