Server Management - Systems Insight Manager
cancel
Showing results for 
Search instead for 
Did you mean: 

HP PMP unable to create PMP Database

HP PMP unable to create PMP Database

HP Performance Management Pack was unable to create the HP Performance Management database.

After custom installation the installation process hang with the
error message "HP Performance Management Pack was unable to create the HP Performance Management Pack database".
I am on a DL380G2 with 2 GB RAM an 2 x PIII 1.133Mhz.
On the System I have Windwos 2000 Server with the latest Patches and the included MSDE engine form HP SIM 4.1

Anyone knows the solution ???

Thanks.

Robert
8 REPLIES
Philip Robinson
Occasional Visitor

Re: HP PMP unable to create PMP Database

I had seen this problem multiple times while trying to install SIM 4.1 and I did the following.

1. Un install SIM, PMP and PSP.
2. Clean the registery especially for SIM and PMP also cleanup the SIM and PMP related directories under program files and the logs created under c:
3. Reboot the system.
4. Install PSP.
5. Reboot the system
6. Install SIM 4.1 from the Smart start 7.10

The installation worked but I still do not know the root cause of the above error, more so becuase the error logged in PMP log does not suggest anything more too.
Tjebbew
Advisor

Re: HP PMP unable to create PMP Database

I had the same trouble by installation the HP performance management pack.
I did not deinstallt HP-sim or the PSP. I removed evrything in the registery with "pmp" and i removed this directory "c:\Program Files\HP\Performance Management Pack 3"

Afther this i could install de PMP.

regards Tjebbe Wiersma
Tjebbe Wiersma
Remote Support Account Advocate
Hewlett-Packard Company

+31 20 5477667 / Tel
+31 651490637 / Mobile
Startbaan 16
1187XR Amstelveen
The Netherlands
intotheether
Occasional Visitor

Re: HP PMP unable to create PMP Database

Find and delete the following files on the MSSQL/MSDE server:

- PMP_V3_0.mdf
- PMP_V3_0.ldf

Regards,

Jamie.
Ole Thomsen_1
Trusted Contributor

Re: HP PMP unable to create PMP Database

Same problem.

Don't have any PMP files or registry settings on HPSIM server, and no files or databases on SQL server.

From hppmp.log:

Starting HP Performance Management Pack Installation...
Is earlier versions of PMP found? No
Is the Operating System and Service Pack Valid? Yes
Is the screen resolution valid? Yes
Is HP SIM installed? Yes
Is PMP 4.0.1 already installed? No
Successfully retrieved HP SIM installation path.
Is Disk space sufficient for PMP installation? Yes
Applying PMP schema to the database.
HP Performance Management Pack was unable to create the HP Performance Management Pack database. Aborting the installation
Failed to install PMP.


From pmpdb.log:

Setup failed in detaching the database with the below error[DBNETLIB]Invalid connection.
[DBNETLIB]ConnectionOpen (Invalid Instance()).
[DBNETLIB]ConnectionOpen (Invalid Instance()).
Setup failed in attaching the database with the below error[DBNETLIB]Invalid connection.
[DBNETLIB]ConnectionOpen (Invalid Instance()).
[DBNETLIB]ConnectionOpen (Invalid Instance()).
Error in Creating Database PMP_V3_0

Ole Thomsen

Re: HP PMP unable to create PMP Database

I'm in the same boat as Ole,

Have cleaned up anything that I found in the reg, no db files attached or otherwise to the db, when the install aborts, it cleans up after itself pretty nicely (kudos for that - but I'd rather get the stupid thing installed)

My pmpdb.log shows:

Setup failed in detaching the database with the below errorLogin failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection.
SQL Server connection.
Setup failed in attaching the database with the below errorLogin failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection.
SQL Server connection.
Error in Creating Database PMP_V3_0

Why the heck is it using a null user? It has the administrator login attached and greyed out so you can not change it? A null user will always be rejected from any SQL db unless its setup for anonymous access..which will not happen - no creates, drops or alters to anon thank you very much...

Anybody got an SQL create script for this puppy? I'll create the db myself and point pmp at it..

Just talking out loud, the docs don't seem to have any direction on a manual install, I'll keep digging around.

Regards,

M
pkrai
Trusted Contributor

Re: HP PMP unable to create PMP Database

There are 3 different types of users w.r.t. to HPSIM & PMP:

- Install user, under whose credential, HPSIM & PMP has been installed.
- Service user, under whose credential all services (SIM, SMH, PMP & PMPTools) are running.
- Database user, whose credential has been used by SIM & PMP for database connectivity.

For proper funtioning, all users must be same.

Thanks,
Pravesh
correcto
Occasional Visitor

Re: HP PMP unable to create PMP Database

I did all about pmp keys registry delete and path in c:\progr... etc. But doesn´t work

I finally open ODBC tools in administrative tools, and I checked about port used to connect to database (local or remote) 1433. This value may be took dinamically or define by you.

I uncheck the mark about dinamic and fixed this port 1433 standard, restart sim, restart sim with mxstart and mxstop and work fine.

You must be sure that this port is open in your configuration firewall...

Brule
Occasional Visitor

Re: HP PMP unable to create PMP Database

I had the same issue and this was the solution:

Re-register the dll file: sqloledb.dll

This was due to the following error:


Executing SQL Query: Select count(*) from Supported_Software
Error Number: 800a0e7a
Error Message: Unknown error 0x800A0E7A
Error Decscription: Provider cannot be found. It may not be properly installed.
Connection string: Provider=sqloledb; Data Source=66.11.145.114,1433; Initial Catalog = master; Integrated Security=SSPI;
SQL: create database PMP_V3_0