Schedule Search Index - Discrepancy between total documents processed vs total documents indexed
PeopleTools 8.60.13
OpenSearch v 2.3.0
Hello, I built a connected query that returns 393 rows of data in my database when executing the SQL on PL/SQL. When I schedule the search index and run it, the PTSF_GENFEED program is only indexing 392 documents according to the process monitor message log. I thought that I had all of my search attributes mapped correctly, so I wasn't expecting to be one row short when building the search index. The drilling URL I have set up in the query also references the correct number of fields.
Does anyone know an effective way for how I can view a list of all of the documents that were indexed so that I can compare between my query results and the documents that were indexed? Essentially, I'm trying to find the one row of data that is missing so I can determine what I need to do in terms of troubleshooting such as as map another search attribute. I am trying to avoid manually scraping through all of the hits returned for my index pattern in the Discover page on OpenSearch and cross referencing my query results. Any help