Storage Essentials Practitioners Forum
cancel

(SOM) Support Tip: SOM with OBR 10.01 command "somdatatransfercertconfig.ovpl -shrdbconfig" fails

Highlighted
Mark_Butler
HPE Expert

(SOM) Support Tip: SOM with OBR 10.01 command "somdatatransfercertconfig.ovpl -shrdbconfig" fails

Hello SOM Community,

Here's some information that will help you if you have OBR 10.01 installed prior to performing the Post-Installation Steps for OBR.

When attempting to configure Storage Operations Manager (SOM) to obtain Dashboard Analytics from Operations Bridge Reporter (OBR), using the somdatatransfercertconfig.ovpl -shrdbconfig command an error is encountered.

Steps to reproduce the error and issue.

Install OBR 10.00 and the OBR 10.01 Patch. After that, do all of the OBR post-install configurations. and then try to run the somdatatransfercertconfig.ovpl -shrdbconfig command.

C:\Program Files (x86)\HP\HP BTO Software\bin>somdatatransfercertconfig.ovpl -shrdbconfig <IP Address> 5433 verticadba <passwd>

Configuring the SHR Database details...
   SHR Database Server : <IP Address>
   SHR Database Port   : 5433
   SHR Username       : verticadba
   SHR Password       : <passwd>

args : 15.218.122.43 5433 verticadba <passwd>
Oct 04, 2016 11:10:03 AM com.hp.se.disco.common.analytics.CreateSHRDbConfig writeToConfigFile
INFO: SHR DB configuration written to C:\ProgramData\HP\HP BTO Software\se\conf\sdkConfig.cfg
Successfully created the SHR db configuration
Oct 04, 2016 11:10:03 AM com.hp.se.disco.common.analytics.CreateSHRDbConfig main
INFO: Successfully created the SHR db configuration
Oct 04, 2016 11:10:04 AM com.hp.se.disco.common.analytics.SHRSDK executeQuery
WARNING: Exception on query execution: [Vertica][VJDBC](4566) ERROR: Relation "md_fact_table" does not exist
Oct 04, 2016 11:10:04 AM com.hp.se.disco.common.analytics.SHRSDK executeQuery
WARNING: Submitted query: select count(*) from md_fact_table
Failed while testing the connection to the SHR DB!!!
Oct 04, 2016 11:10:04 AM com.hp.se.disco.common.analytics.CreateSHRDbConfig main
WARNING: Failed while testing the connection to the SHR DB!!!

With the installation of the OBR 10.01 Patch, the Post-Installation steps for the Vertica Database configuration are different.  One significant change is that there is a Vertica User (verticausr) specified as well as the Vertica Administrator (verticadba) during the Vertica Database configuration step.  The Vertica User, created during the OBR Post-Installation steps needs to be used instead of the Vertica Administrator with the somdatatransfercertconfig.ovpl -shrdbconfig command.

Please refer to the following knowledge document for more information and details.

KM02624620 - Storage Operations Manager command "somdatatransfercertconfig.ovpl -shrdbconfig" fails with "ERROR: Relation "md_fact_table" does not exist".
https://softwaresupport.hpe.com/km/KM02624620

I hope that this information is helpful.

Good Luck with your SOM environments.

Regards,

Mark

 

---
Mark Butler
HPE SW Support Engineer
https://softwaresupport.hpe.com/