Highlighted
Micro Focus Expert
Micro Focus Expert
342 views

(OBR) Support Tip: Admin UI collection status appears to be incorrect - why?

You may have noticed that after installing OBR and correctly configuring the topology and data sources that the Admin UI shows the collection status as failed when in fact it was successful. Here is an explanation as to how the Admin UI status is updated which hopefully explains why it may appear incorrect.

The OBR Admin UI obtains the collection status from the Postgres 'dwabc' database - this database is not immediately updated after collection occurs, instead the HPE_PMDB_Platform_Collection service maintains the status of collection from topology and data sources in memory and once per hour (by default at x:55) writes the status to CSV files in {PMDB_HOME}/config/ds. These files are then consumed by the Orchestration stream step Download_Last_poll_Datasource from the platform stream PMDB_Platform@platform_poller_ds_process (see below).

LastPoll.pngOBR PMDB_Platform@platform_poller_ds_process stream
Until this stream step has completed the information shown in the Admin UI related to collection will not necessarily be up to date.

The stream step consumes the CSV file [poller name]_0_all_0_run_time.csv  from the {PMDB_HOME}/config/ds directory and updates the Postgres database with the data within.

Example CSV:

HOSTNAME,COLLECTION_STATUS,CONNECTION_STATUS,LAST_RUN_TIME,TYPE,RUN_DATE
BRA13PTR43.ACME.ORG,0,1,1527749160000,PA,05/31/2018 07:46:00
BRA23PTR29.ACME.ORG,0,1,1527749160000,PA,05/31/2018 07:46:00
bra13ptr48.acme.org,0,1,1527748560000,GENERIC_DB_COLLECTOR,05/31/2018 07:36:00
bra23ptr47.acme.org,0,1,1527748560000,CMDB,05/31/2018 07:36:00

This same file exists on remote collectors also and is 'downloaded' for processing on the OBR server.

In the CSV, the 'COLLECTION_STATUS' reflects 0 (zero) when the last collection was SUCCESSFUL, for 'CONNECTION_STATUS' - this must reflect 1 (one) when the last connection test succeeded.

Again this CSV is only updated once per hour but you can use it to check the status of the collections in the event that the platform stream has yet to consume it.

So if the Admin UI is not updating you need to check:

1. Is the *_all_0_run_time.csv in {PMDB_HOME}/config/ds being updated correctly at five to the hour?
2. Are the platform streams running properly

If the status in the CSV shows connection failed then you will need to check the related log file to determine the reason.

The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.