Solved

VMware converter error SQL_CANTOPEN during conversion

Posted on 2011-09-09
5
6,415 Views
Last Modified: 2012-05-12
Hi

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...
0
Comment
Question by:rjebb
  • 2
  • 2
5 Comments
 
LVL 119
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?
0
 

Author Comment

by:rjebb
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
0
 
LVL 119

Accepted Solution

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

Expert Comment

by:Luciano Patrão
ID: 36510088
Hi

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.

Jail
0
 

Author Closing Comment

by:rjebb
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.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

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.
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 install vSphere Update Manager  Console to Windows system:  Install vSphere Update Manager: Configure vSphere Update Manager plug-in in vSphere Client: Verify vSphere Update Manager settings in vSphere Client:
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…

773 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