Re: HP SHR 9.30 DB creation fails (834 Views)
Reply
Respected Contributor
dcsbeemer
Posts: 299
Registered: ‎07-19-2011
Message 1 of 8 (867 Views)
Accepted Solution

HP SHR 9.30 DB creation fails

[ Edited ]

Hi all

 

 

I'm trying to get a trial install of HP SHR 9.30 going in order to see whether the reporting capability will meet a customer's requirements for BSM OMi events.

The install itself went fine, but going through the configuration wizard and getting to step 3, it always fails when trying to create the DB.

 

I've tried following some of the troubleshooting steps, but just thought I'd ask here as well in case anyone came across this before.

 

Thanks in advance.

 

 

P.S. This thread has been moved from Application Perf Mgmt (BAC / BSM) Support and News Forum to Systems Management (OpenView-OP Mgmt) Support and News Forum. - Hp Forum Moderator

Respected Contributor
dcsbeemer
Posts: 299
Registered: ‎07-19-2011
Message 2 of 8 (847 Views)

Re: HP SHR 9.30 DB creation fails

[ Edited ]

Maybe just to ask a different question, one of my customers needs to be able to pull monthly reports on all OMi events. As far as I know, there's no way to do this in BSM, unless the report is pulled by manually exporting closed events to a CSV file (and will not be feasible).

Is installing SHR the absolute only way of being able to pull any meaningful reports on OMi events, or is there a less cumbersome solution to this?

HP Expert
PatWest
Posts: 836
Registered: ‎03-06-2008
Message 3 of 8 (835 Views)

Re: HP SHR 9.30 DB creation fails

hi,

The error may occur due to lack of permissions. Please check if you have full permissions on folder

{install-dir}:/HP-SHR/Postgres/Mgmtdata

Also, edit the pmdbconfig.cfg file and verify if the  <databaseserver> instance was created correctly.

 

If needed, correct it here.

 

Hope this helps,
PatW

HP Expert
Siggi Gladitsch
Posts: 467
Registered: ‎03-11-2010
Message 4 of 8 (834 Views)

Re: HP SHR 9.30 DB creation fails

Hi,

 

I thought you can do this via Custom Query Builder, sample type Event, but after further looking at it, it seems this is about SiteScope events only, not BSM/OMi events.

Another option would be to query the OPR database directly (I guess that's what SHR would do as well).

 

We cannot tell you anything about the table layout, but the names should be self-explaining.

 

For example,

 SELECT top 10 *FROMALL_EVENTS where state='CLOSED'order by time_created desc

would return the last / newest 10 events which have been closed.

 

Greetings

Siggi

 

HP Support

If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
Respected Contributor
dcsbeemer
Posts: 299
Registered: ‎07-19-2011
Message 5 of 8 (815 Views)

Re: HP SHR 9.30 DB creation fails

Thanks PatWest and Siggi Gladitsch.

I know OMi is understandably limited, but I can't grasp the reporting capability on it being as limited as it is.
Really hoping that the reporting around OMi is vastly improved in a future release of BSM.

Back to the issue though, I'll look into both SHR and direct DB querying further, will provide feedback as soon as we've made some progress.

Thanks again for the help so far, appreciate it.
Respected Contributor
dcsbeemer
Posts: 299
Registered: ‎07-19-2011
Message 6 of 8 (805 Views)

Re: HP SHR 9.30 DB creation fails

Hi Siggi Gladitsch

 

 

Your advice has proven extremely useful... Thanks for helping, appreciate it.

Visitor
Lion_Hsu
Posts: 1
Registered: ‎01-10-2013
Message 7 of 8 (707 Views)

Re: HP SHR 9.30 DB creation fails

Hi,

 

I had same problem about SHR9.3 management DB creation has failed, It can't resolved.

could you help me?

 

 

thanks.

Advisor
Ivan Kovac_1
Posts: 23
Registered: ‎07-14-2008
Message 8 of 8 (398 Views)

Re: HP SHR 9.30 DB creation fails

Hi,

how did you solve issue? I have the same problem.

 

Regards

Ivan

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.