IBM Identifying Indexing errors in Atlas database - United States  TECHNOTE (FAQ)

QUESTION
 How do I identify Indexing errors in Atlas database? 

CAUSE
Sometimes encrypted and password protected documents cause document indexing errors

ANSWER
 

 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
How do I identify Indexing errors in Atlas database? How do I identify Indexing errors in Atlas database? 
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