<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<div class="moz-cite-prefix">On 2023-05-22 11:05 a.m., Pranav S
Pawar wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CABQoSP2rX3mUhiGQNMSY_swau6amawsb2OEbzZviYvNnmuqOpg@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">Hello Team,
<div><br>
</div>
<div>My code was working fine from one week in jupyter notebook.</div>
<div>Today i just did a kernel restart in jupyter notebook and
my code stopped working.</div>
<div><br>
</div>
<div>Not sure what happened after restart. Tried all options but
not able to resolve.</div>
<div>So through to get help from here.</div>
<div><br>
</div>
<div>Basically i am trying to get erwin api through =>
win32com.client.Dispatch("erwin9.SCAPI")
</div>
</div>
</blockquote>
<p>Again, this sounds like an issue with erwin, not python/pywin32.</p>
<p>Cheers,</p>
<p>Mark<br>
</p>
<p><br>
</p>
<blockquote type="cite"
cite="mid:CABQoSP2rX3mUhiGQNMSY_swau6amawsb2OEbzZviYvNnmuqOpg@mail.gmail.com">
<div dir="ltr">
<div><br>
</div>
<div>but getting error.</div>
<div><br>
</div>
<div>Giving Code as well as error below.</div>
<div>Please advise what corrective action should be taken.</div>
<div>I have tried to upgrade pywin32 module but still same
error.</div>
<div><br>
</div>
<div><b>Code:</b></div>
<div>import win32com.client<br>
erwin = win32com.client.Dispatch("erwin9.SCAPI")<br>
print('Connected')<br>
</div>
<div><br>
</div>
<div><b>Error:</b></div>
<div><br>
</div>
<div>
<pre
style="box-sizing:border-box;overflow:auto;font-size:14px;padding:1px 0px;margin-top:0px;margin-bottom:0px;line-height:inherit;color:rgb(0,0,0);word-break:break-all;border:0px;border-radius:0px;white-space:pre-wrap;vertical-align:baseline"><span
class="gmail-ansi-red-intense-fg gmail-ansi-bold"
style="box-sizing:border-box;color:rgb(178,43,49);font-weight:bold">com_error</span> Traceback (most recent call last)
File <span class="gmail-ansi-green-intense-fg gmail-ansi-bold"
style="box-sizing:border-box;color:rgb(0,116,39);font-weight:bold">C:\Python310\lib\site-packages\win32com\client\dynamic.py:84</span>, in <span
class="gmail-ansi-cyan-fg"
style="box-sizing:border-box;color:rgb(96,198,200)">_GetGoodDispatch</span><span
class="gmail-ansi-blue-intense-fg gmail-ansi-bold"
style="box-sizing:border-box;color:rgb(0,101,202);font-weight:bold">(IDispatch, clsctx)</span>
<span class="gmail-ansi-green-fg"
style="box-sizing:border-box;color:rgb(0,162,80)"> 83</span> <span
class="gmail-ansi-bold"
style="box-sizing:border-box;font-weight:bold;color:rgb(0,135,0)">try</span>:
<span class="gmail-ansi-green-intense-fg gmail-ansi-bold"
style="box-sizing:border-box;color:rgb(0,116,39);font-weight:bold">---> 84</span> IDispatch <span
style="box-sizing:border-box;color:rgb(98,98,98)">=</span> <span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43)">pythoncom</span><span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43);color:rgb(98,98,98)">.</span><span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43)">connect</span><span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43)">(</span><span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43)">IDispatch</span><span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43)">)</span>
<span class="gmail-ansi-green-fg"
style="box-sizing:border-box;color:rgb(0,162,80)"> 85</span> <span
class="gmail-ansi-bold"
style="box-sizing:border-box;font-weight:bold;color:rgb(0,135,0)">except</span> pythoncom<span
style="box-sizing:border-box;color:rgb(98,98,98)">.</span>ole_error:
<span class="gmail-ansi-red-intense-fg gmail-ansi-bold"
style="box-sizing:border-box;color:rgb(178,43,49);font-weight:bold">com_error</span>: (-2147221021, 'Operation unavailable', None, None)
During handling of the above exception, another exception occurred:
<span class="gmail-ansi-red-intense-fg gmail-ansi-bold"
style="box-sizing:border-box;color:rgb(178,43,49);font-weight:bold">com_error</span> Traceback (most recent call last)
Input <span class="gmail-ansi-green-intense-fg gmail-ansi-bold"
style="box-sizing:border-box;color:rgb(0,116,39);font-weight:bold">In [17]</span>, in <span
class="gmail-ansi-cyan-fg"
style="box-sizing:border-box;color:rgb(96,198,200)"><cell line: 3></span><span
class="gmail-ansi-blue-intense-fg gmail-ansi-bold"
style="box-sizing:border-box;color:rgb(0,101,202);font-weight:bold">()</span>
<span class="gmail-ansi-green-fg"
style="box-sizing:border-box;color:rgb(0,162,80)"> 1</span> <span
class="gmail-ansi-bold"
style="box-sizing:border-box;font-weight:bold;color:rgb(0,135,0)">import</span> <span
class="gmail-ansi-bold"
style="box-sizing:border-box;font-weight:bold;color:rgb(0,0,255)">win32com</span><span
class="gmail-ansi-bold"
style="box-sizing:border-box;font-weight:bold;color:rgb(0,0,255)">.</span><span
class="gmail-ansi-bold"
style="box-sizing:border-box;font-weight:bold;color:rgb(0,0,255)">client</span>
<span class="gmail-ansi-green-intense-fg gmail-ansi-bold"
style="box-sizing:border-box;color:rgb(0,116,39);font-weight:bold">----> 3</span> erwin <span
style="box-sizing:border-box;color:rgb(98,98,98)">=</span> <span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43)">win32com</span><span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43);color:rgb(98,98,98)">.</span><span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43)">client</span><span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43);color:rgb(98,98,98)">.</span><span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43)">Dispatch</span><span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43)">(</span><span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43);color:rgb(175,0,0)">"</span><span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43);color:rgb(175,0,0)">erwin9.SCAPI</span><span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43);color:rgb(175,0,0)">"</span><span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43)">)</span>
<span class="gmail-ansi-green-fg"
style="box-sizing:border-box;color:rgb(0,162,80)"> 5</span> <span
style="box-sizing:border-box;color:rgb(0,135,0)">print</span>(<span
style="box-sizing:border-box;color:rgb(175,0,0)">'</span><span
style="box-sizing:border-box;color:rgb(175,0,0)">Connected</span><span
style="box-sizing:border-box;color:rgb(175,0,0)">'</span>)
File <span class="gmail-ansi-green-intense-fg gmail-ansi-bold"
style="box-sizing:border-box;color:rgb(0,116,39);font-weight:bold">C:\Python310\lib\site-packages\win32com\client\__init__.py:118</span>, in <span
class="gmail-ansi-cyan-fg"
style="box-sizing:border-box;color:rgb(96,198,200)">Dispatch</span><span
class="gmail-ansi-blue-intense-fg gmail-ansi-bold"
style="box-sizing:border-box;color:rgb(0,101,202);font-weight:bold">(dispatch, userName, resultCLSID, typeinfo, UnicodeToString, clsctx)</span>
<span class="gmail-ansi-green-fg"
style="box-sizing:border-box;color:rgb(0,162,80)"> 116</span> <span
style="box-sizing:border-box;color:rgb(175,0,0)">"""Creates a Dispatch based COM object."""</span>
<span class="gmail-ansi-green-fg"
style="box-sizing:border-box;color:rgb(0,162,80)"> 117</span> <span
class="gmail-ansi-bold"
style="box-sizing:border-box;font-weight:bold;color:rgb(0,135,0)">assert</span> UnicodeToString <span
class="gmail-ansi-bold"
style="box-sizing:border-box;font-weight:bold;color:rgb(175,0,255)">is</span> <span
class="gmail-ansi-bold"
style="box-sizing:border-box;font-weight:bold;color:rgb(0,135,0)">None</span>, <span
style="box-sizing:border-box;color:rgb(175,0,0)">"</span><span
style="box-sizing:border-box;color:rgb(175,0,0)">this is deprecated and will go away</span><span
style="box-sizing:border-box;color:rgb(175,0,0)">"</span>
<span class="gmail-ansi-green-intense-fg gmail-ansi-bold"
style="box-sizing:border-box;color:rgb(0,116,39);font-weight:bold">--> 118</span> dispatch, userName <span
style="box-sizing:border-box;color:rgb(98,98,98)">=</span> <span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43)">dynamic</span><span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43);color:rgb(98,98,98)">.</span><span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43)">_GetGoodDispatchAndUserName</span><span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43)">(</span><span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43)">dispatch</span><span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43)">,</span><span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43)"> </span><span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43)">userName</span><span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43)">,</span><span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43)"> </span><span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43)">clsctx</span><span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43)">)</span>
<span class="gmail-ansi-green-fg"
style="box-sizing:border-box;color:rgb(0,162,80)"> 119</span> <span
class="gmail-ansi-bold"
style="box-sizing:border-box;font-weight:bold;color:rgb(0,135,0)">return</span> __WrapDispatch(dispatch, userName, resultCLSID, typeinfo, clsctx<span
style="box-sizing:border-box;color:rgb(98,98,98)">=</span>clsctx)
File <span class="gmail-ansi-green-intense-fg gmail-ansi-bold"
style="box-sizing:border-box;color:rgb(0,116,39);font-weight:bold">C:\Python310\lib\site-packages\win32com\client\dynamic.py:104</span>, in <span
class="gmail-ansi-cyan-fg"
style="box-sizing:border-box;color:rgb(96,198,200)">_GetGoodDispatchAndUserName</span><span
class="gmail-ansi-blue-intense-fg gmail-ansi-bold"
style="box-sizing:border-box;color:rgb(0,101,202);font-weight:bold">(IDispatch, userName, clsctx)</span>
<span class="gmail-ansi-green-fg"
style="box-sizing:border-box;color:rgb(0,162,80)"> 101</span> <span
style="box-sizing:border-box;color:rgb(95,135,135)">## ??? else userName remains None ???</span>
<span class="gmail-ansi-green-fg"
style="box-sizing:border-box;color:rgb(0,162,80)"> 102</span> <span
class="gmail-ansi-bold"
style="box-sizing:border-box;font-weight:bold;color:rgb(0,135,0)">else</span>:
<span class="gmail-ansi-green-fg"
style="box-sizing:border-box;color:rgb(0,162,80)"> 103</span> userName <span
style="box-sizing:border-box;color:rgb(98,98,98)">=</span> <span
style="box-sizing:border-box;color:rgb(0,135,0)">str</span>(userName)
<span class="gmail-ansi-green-intense-fg gmail-ansi-bold"
style="box-sizing:border-box;color:rgb(0,116,39);font-weight:bold">--> 104</span> <span
class="gmail-ansi-bold"
style="box-sizing:border-box;font-weight:bold;color:rgb(0,135,0)">return</span> (<span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43)">_GetGoodDispatch</span><span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43)">(</span><span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43)">IDispatch</span><span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43)">,</span><span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43)"> </span><span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43)">clsctx</span><span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43)">)</span>, userName)
File <span class="gmail-ansi-green-intense-fg gmail-ansi-bold"
style="box-sizing:border-box;color:rgb(0,116,39);font-weight:bold">C:\Python310\lib\site-packages\win32com\client\dynamic.py:86</span>, in <span
class="gmail-ansi-cyan-fg"
style="box-sizing:border-box;color:rgb(96,198,200)">_GetGoodDispatch</span><span
class="gmail-ansi-blue-intense-fg gmail-ansi-bold"
style="box-sizing:border-box;color:rgb(0,101,202);font-weight:bold">(IDispatch, clsctx)</span>
<span class="gmail-ansi-green-fg"
style="box-sizing:border-box;color:rgb(0,162,80)"> 84</span> IDispatch <span
style="box-sizing:border-box;color:rgb(98,98,98)">=</span> pythoncom<span
style="box-sizing:border-box;color:rgb(98,98,98)">.</span>connect(IDispatch)
<span class="gmail-ansi-green-fg"
style="box-sizing:border-box;color:rgb(0,162,80)"> 85</span> <span
class="gmail-ansi-bold"
style="box-sizing:border-box;font-weight:bold;color:rgb(0,135,0)">except</span> pythoncom<span
style="box-sizing:border-box;color:rgb(98,98,98)">.</span>ole_error:
<span class="gmail-ansi-green-intense-fg gmail-ansi-bold"
style="box-sizing:border-box;color:rgb(0,116,39);font-weight:bold">---> 86</span> IDispatch <span
style="box-sizing:border-box;color:rgb(98,98,98)">=</span> <span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43)">pythoncom</span><span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43);color:rgb(98,98,98)">.</span><span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43)">CoCreateInstance</span><span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43)">(</span>
<span class="gmail-ansi-green-fg"
style="box-sizing:border-box;color:rgb(0,162,80)"> 87</span> <span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43)"> </span><span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43)">IDispatch</span><span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43)">,</span><span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43)"> </span><span
class="gmail-ansi-yellow-bg gmail-ansi-bold"
style="box-sizing:border-box;background-color:rgb(221,182,43);font-weight:bold;color:rgb(0,135,0)">None</span><span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43)">,</span><span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43)"> </span><span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43)">clsctx</span><span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43)">,</span><span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43)"> </span><span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43)">pythoncom</span><span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43);color:rgb(98,98,98)">.</span><span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43)">IID_IDispatch</span>
<span class="gmail-ansi-green-fg"
style="box-sizing:border-box;color:rgb(0,162,80)"> 88</span> <span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43)"> </span><span
class="gmail-ansi-yellow-bg"
style="box-sizing:border-box;background-color:rgb(221,182,43)">)</span>
<span class="gmail-ansi-green-fg"
style="box-sizing:border-box;color:rgb(0,162,80)"> 89</span> <span
class="gmail-ansi-bold"
style="box-sizing:border-box;font-weight:bold;color:rgb(0,135,0)">else</span>:
<span class="gmail-ansi-green-fg"
style="box-sizing:border-box;color:rgb(0,162,80)"> 90</span> <span
style="box-sizing:border-box;color:rgb(95,135,135)"># may already be a wrapped class.</span>
<span class="gmail-ansi-green-fg"
style="box-sizing:border-box;color:rgb(0,162,80)"> 91</span> IDispatch <span
style="box-sizing:border-box;color:rgb(98,98,98)">=</span> <span
style="box-sizing:border-box;color:rgb(0,135,0)">getattr</span>(IDispatch, <span
style="box-sizing:border-box;color:rgb(175,0,0)">"</span><span
style="box-sizing:border-box;color:rgb(175,0,0)">_oleobj_</span><span
style="box-sizing:border-box;color:rgb(175,0,0)">"</span>, IDispatch)
<span class="gmail-ansi-red-intense-fg gmail-ansi-bold"
style="box-sizing:border-box;color:rgb(178,43,49);font-weight:bold">com_error</span>: (-2147418113, 'Catastrophic failure', None, None)</pre>
</div>
<div><br>
</div>
<div>Thanks & Best Regards,</div>
<div><br>
</div>
<div>Pranav</div>
</div>
</blockquote>
</body>
</html>