Capacity Planner Error

[ErikSteffens]

When doing a inventory of performance scan i get the following error in Capacity Planner:

05/08/2008 10:54:43:2:5832: Performance: SysPerfComplete for 2386 with a status of 0.

05/08/2008 10:54:43:1:4424: Module = vcpSysPerf Function = OpenDatabase (C:\Program Files\VMware\VMware Capacity Planner\AOGCapPlan.mdb) Source = Microsoft JET Database Engine Error = Unspecified error(-2147467259:0:5000000)

05/08/2008 10:54:43:1:5844: Module = vcpSysPerf Function = OpenDatabase (C:\Program Files\VMware\VMware Capacity Planner\AOGCapPlan.mdb) Source = Microsoft JET Database Engine Error = Unspecified error(-2147467259:0:5000000)

05/08/2008 10:54:43:3:264: PerfSummary.Modify: Updating Record (4529) in database

05/08/2008 10:54:43:2:5832: Performance: SysPerfComplete Number of running threads = 6.

05/08/2008 10:54:43:0:4812: OpenDatabase: All attempts to open a database, failed. This problem may be due to high activity by the collector. Reduce the number of systems collected at the same time if this is the case.

05/08/2008 10:54:43:3:264: PerfSummary.Modify: Updating Record (4530) in database

Can someone tell me what is wrong and how do i correct it??

[admin · Accepted solution]

I have suffered this a few times, what I had to do was create a new Database, basically I stopped the service then deleted the mdb & ldb files in the CP directory, rebooted and then when back into CP (a start over I'm afriad), this seemed to happen on a particular site due to the CP being attached to the Network using a 100mb NIC. Once I had reset the Database and changed to 1GB it was OK.

[admin]

One thing you might try is to compact your database before you delete everything and start over. You can compact the database from the admin menu on the Data Collector.

[admin]

I have had mixed results doing a compact as it just seems to compact the corruption !

[ErikSteffens]

I created a new database, but i still get these errors.

Any other suggestions??

[admin]

Hi Eric,

What version of MDAC do you have installed on your system?

[ErikSteffens]

It's a Windows 2003 Server with standard MDAC.

This morning I had no more errors. I cleaned up the database one more time. Change the number of collected machines to 10 and everything went fine.

Thnx.

[badazws6]

I had this problem and ran a compact and it completely wiped out all my systems and data... Beware!