PMP Setup and Installation Guide v5.5

Troubleshooting 47
Database
The following table displays issues and solutions that can be associated with the PMP database.
Table 9 Database components
Issue Occurs when Solution
When generating reports or
deleting logged files, the
following error message
appears:
[Microsoft][ODBC SQL
Server Driver][SQL
Server] Cannot open
database requested in
login ‘PMP_V3_0.’
Login fails.
PMP is logging data, and the
hard drive is out of space.
NOTE: You must be logged on as an administrator or a member
of the administrators group.
1 If no partition is available, insert another hard drive and
create a new partition the using Disk Management utility.
(Refer to the Microsoft Windows Help entry about
“Partition” for more information.)
2 Stop the ProLiant Performance Analyzer service using the
Services tool, accessed from Administrative Tools in
Windows 2000, Windows XP, and Windows 2003, or
from the Control Panel in Windows NT.
3 Select Start>Programs>Microsoft SQL Server. Click Query
Analyzer to open a Query Analyzer page.
4 Enter the login name and password.
5 Enter the following queries and click Run:
Use Master
Go
Sp_detach_db ‘PMP_V3_0’
6 Copy SQL Default directory\data\PMP_V3_0’.mdf to the
new partition.
7 Copy SQL Default directory\data\PMP_V3_0_log.LDF to
the new partition.
8 Attach to the SQL server by using the following query
statements in SQL Query Analyzer:
Sp_attach_db @dbname = N’ PMP_V3_0’
@filename1=N’New Partition drive
letter\PMP_V3_0.LDF’,
@filename2=N’New Partition drive
letter\PMP_V3_0_log.LDF’
9 Restart PMP using the Services tool, accessed from
Administrative Tools in Windows 2000, Windows XP, and
Windows 2003.
PMP installation fails with a
message stating that the PMP
database could not be
created.
The <SQL directory>\
<MSDE directory>\
Data folder might have .mdf
and .ldf files present. This
situation occurs when a
database has been
uninstalled.
NOTE: Uninstalling the
database software does not
remove the user-created .mdf
and .ldf files.
Manually delete the PMP .mdf and .ldf files in the
<SQL directory>\<MSDE directory>\Data folder before
installing the database software again.
PMP status might be
inconsistent with the mode of
operation or some other
unexpected behavior might
occur.
When SQL server restarts. Restart PMP.
No disk space is available
to log PMP data in the
SQL/Microsoft Date Engine
(MSDE) database, and SQL
events are generated in the
event log.
This condition occurs with
MSDE where a maximum
database size limitation of 2
GB exists. PMP logs more
information than previous
versions of PMP.
Do not use MSDE to log PMP data.