VMware converter error SQL_CANTOPEN during conversion

Posted on 2011-09-09
Medium Priority
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 122
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 122

Accepted Solution

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

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Last article we focus in how to VMware: How to create and use VMs TAGs – Part 1 so before follow this article and perform the next tasks, you should read the first article how to create the TAG before using them in Veeam Backup Jobs.
In this article, I will show you HOW TO: Perform a Physical to Virtual (P2V) Conversion the easy way from a computer backup (image).
Teach the user how to delpoy the vCenter Server Appliance and how to configure its network settings Deploy OVF: Open VM console and configure networking:
Teach the user how to install ESXi 5.5 and configure the management network System Requirements: ESXi Installation:  Management Network Configuration: Management Network Testing:
Suggested Courses

770 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