<div dir="ltr">I had an issue importing VMs from an export domain I was trying out.  The template would fail to copy over, and be stuck in a &quot;paused&quot; state where I could not delete or modify the VM.  I was able to fix this by dropping into the SQL database and running:<div><br></div><div><span id="gmail-docs-internal-guid-0507a4ce-0254-0412-4ecc-779a1831dc2c"><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><b>psql engine -c &quot;SELECT vm_guid, vm_name from vm_static WHERE vm_name = &#39;<u>VM_Name_Here</u>&#39;;&quot;</b></span></p><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><br></span></p><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><span id="gmail-docs-internal-guid-0507a4ce-0254-9342-1168-2272c51d18f2"><span style="font-size:11pt;background-color:transparent;vertical-align:baseline"><b>psql engine -c &quot;update vm_dynamic SET status=0 where vm_guid=&#39;<u>LongStringFromFirstCommand</u>;&quot;</b></span></span><br></span></p><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><span><span style="font-size:11pt;background-color:transparent;vertical-align:baseline"><br></span></span></span></p><p style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><font color="#000000" face="Arial"><span style="font-size:14.6667px;white-space:pre-wrap">This was able to set the status to a state where I could delete the VM, but now I still see the &quot;import&quot; task in the task log.</span></font></p><p style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><font color="#000000" face="Arial"><span style="font-size:14.6667px;white-space:pre-wrap"><br></span></font></p><p style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><font color="#000000" face="Arial"><span style="font-size:14.6667px;white-space:pre-wrap">I did some more database diving and found that if i ran:</span></font></p><p style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span id="gmail-docs-internal-guid-0507a4ce-0255-9bde-2496-6e456623cb85"></span></p><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:10.5pt;font-family:Arial;color:rgb(51,51,51);background-color:rgb(255,255,255);font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;vertical-align:baseline;white-space:pre-wrap"><b style="">SELECT * FROM audit_log WHERE vm_name = &#39;<u>VM_Template_Name_Here</u>&#39;;</b></span></p><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:10.5pt;font-family:Arial;color:rgb(51,51,51);background-color:rgb(255,255,255);font-weight:400;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap"><br></span></p><p style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:10.5pt;font-family:Arial;color:rgb(51,51,51);background-color:rgb(255,255,255);font-weight:400;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap">These entries seem to correspond with the audit entries.  Can I simply delete these entries from &quot;audit_log&quot;?  Or would this cause problems?</span></p><p style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:10.5pt;font-family:Arial;color:rgb(51,51,51);background-color:rgb(255,255,255);font-weight:400;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap"><br></span></p><p style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:10.5pt;font-family:Arial;color:rgb(51,51,51);background-color:rgb(255,255,255);font-weight:400;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap">Or perhaps, to be safe, I should just see if I can set them to &quot;Completed&quot;</span></p><p style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:10.5pt;font-family:Arial;color:rgb(51,51,51);background-color:rgb(255,255,255);font-weight:400;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap"><br></span></p><p style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:10.5pt;font-family:Arial;color:rgb(51,51,51);background-color:rgb(255,255,255);font-weight:400;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap">As always, thanks!</span></p><div><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><br></span></div></span></div></div>