VMware converter error SQL_CANTOPEN during conversion

Posted on 2011-09-09
Last Modified: 2012-05-12

After yersterdays success converting one old Win2k Professional machine to a VMware Workstation VM using Standalone Converter 4.0.1, I am now trying to do my remaining machine, which I naively thought would be easy.

Following bestway's general advice I have turned off the AV software and used msconfig to disable as many non-essential services as I dare.

There are no databases or other server processes running on the box, mostly just files and a few old apps we need to keep alive.

When I did the conversion the first time it stopped at about 85% and popped up a dialog box saying that I needed to increase the size of the registry database. I could also see the task had failed with the error

FAILED: A general system error occurred: SQL_CANTOPEN: unable to open database file

(Note: I have no SQL databases on either the source PC or the PC on which the VM is being generated)

I have now rerun the process and it now gets to 98% (during "Applying reconfigurations") but it still comes up with this error.

Anyone got any ideas what might be causing this? If anyone can suggest the easiest way to upload all the diagnostics logs I'll do it, but I just tried and it complained about one of the files in the zip having a gz extension...
Question by:Richard Jebb
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
LVL 121
ID: 36509760
Are you applying any configuration changes in the job, e.g. decreasing or increasing size of partitions etc

this usually happens at the end of the job (98%).

Are the disks full on the Source?

Author Comment

by:Richard Jebb
ID: 36509773
Not intentionally. I have checked the "apply reconfigurations" option in the final step of the converter wizard simply because it said if I don't the new VM may not start, but the only change I've made is to ask it to increase the memory size. I've left the disks alone.

The disks are quite full though,

C: has 605MB of 7.98GB free
D: has 327MB of 10.6GB free
LVL 121

Accepted Solution

Andrew Hancock (VMware vExpert / EE MVE^2) earned 250 total points
ID: 36509821
try a straight P2V with no changes, just accept the defaults
LVL 23

Expert Comment

by:Luciano Patrão
ID: 36510088

That's a very generic error. Most of the times just start again and then will work.

But go with the hanccocka solution above. Do not change anything and try again.

Also try to use IPs not dns names.


Author Closing Comment

by:Richard Jebb
ID: 36510355
OK, that did it

I first deleted a bunch of crud off the D drive that I had planned to clear out after the P2V, then uninstalled various applications that won't be needed off the C drive.

This gave me about 1.5GB free on both drives

Then I did a P2V just accepting the defaults all the way through and the conversion has completed successfully. I'm just installing VMware tools in the VM now so I can get the graphics sorted out.

Featured Post

Schedule a Tour of the ATEN booth at InfoComm 2017

Tour the ATEN booth to see the the Latest Addition to the Modular Matrix Switch Series, New 4K HDMI Over IP Extender and more! Enter ATEN's Ultimate Giveaway Sweepstakes for a chance to win one of several great prizes, including an ATEN US7220 2-Port Thunderbolt 2 Sharing Switch!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, I show you step by step with screenshots to assist you - HOW TO: Deploy and Install the VMware vCenter Server Appliance 6.5 (VCSA 6.5), with some helpful tips along the way.
Giving access to ESXi shell console is always an issue for IT departments to other Teams, or Projects. We need to find a way so that teams can use ESXTOP for their POCs, or tests without giving them the access to ESXi host shell console with a root …
Teach the user how to install ESXi 5.5 and configure the management network System Requirements: ESXi Installation:  Management Network Configuration: Management Network Testing:
Teach the user how to use configure the vCenter Server storage filters Open vSphere Web Client:  Navigate to vCenter Server Advanced Settings: Add the four vCenter Server storage filters: Review the advanced settings: Modify the values of the four v…

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question