Related Tips & Info
Wikis - Page

List docs successfully ingested into CP MetaStore

Jean-Michel Guiral
 
1 Likes

You may, sometimes, want to be sure about the number of documents that have been scanned and recorded in the metadata database (MetaStore).

First, you will need the ID of the repository concerned. Run the following SQL script (with SQL Server Management Studio for example).

image1.png

Identify the repository in the list, for example number 3 here and run the following script.

image-2.png

We have now the list of documents recorded in the database. At the bottom right, Management Studio gives you the row count, here 6541 rows.

image-3.png

Labels:

How To-Best Practice
Comment List

  • When the Metastore is showing an initial count of the files in the repo correctly, then a rescan occurs, and the count only grows rather than shrinks with the items that were removed/added - outside of the repository - which log would reflect the errors that seem to be occurring in the update of the Metastore DB?  The sync and ingest metastore logs all seem to know and reflect what should happen - but the repository always continues to be incorrect. The files that were removed at the source remain in the Repository.

Related
Recommended

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Cookies Preferences
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.