Technote (FAQ)


How do I identify Indexing errors in Atlas database?


Sometimes encrypted and password protected documents cause document indexing errors


  1. Login to Atlas database as PSSAPL user
  2. Run select * from ctx_user_index_errors;
  3. Copy the value in the ERR_TEXTKEY Field
  4. Run select * from documentlibrary where rowid='<value from Step 3> ';
  5. This will list the document which has the indexing error