Re: [python-win32] unknow solution

[Christoph J. Dorner]

Hey guys,

just one idea from a problem I had:
Not succeeding to call ACCESS via pywin32 in the same way I succeeded to
call EXCEL I learned that not all 32bit versions of Office applications
provide a suitable 64bit proxy as part of their COM interface. I do not
know which bitness your Office has but you may want to check if this is
related to your problem?

You may refer to the mailing list archive topic "Issue with PythonCOM -
Application.Run does not work for Access.Application" from Sep-Nov 2021.
Reference there is the following article:
Re: [python-win32] Makepy for Access on Win7 « python-win32 «
ActiveState List Archives


Regards
Christoph


Am 31.05.2023 um 22:44 schrieb Martín Trujillo Raddatz:

Thanks!
Finally the problem is Word app, i try repair and reinstall, din not work.
its seems that a virus may be affecting it, we are now moving the
scripts to other machine ir orden to determine if the proble is Word
or other thing.

**
*Martín Trujillo Raddatz
Puerto Montt - Chile
Teléfono: +56 9 96427814 *
**


El mar, 30 may 2023 a las 17:29, Steven Manross ()
escribió:

While I’ve done word automation in the past, is it possible that
there’s any issues with the word application installation itself? 
Or maybe you might have multiple scripts trying to open/write
files simultaneously?

As well, I might consider looking at task manager on your web
server to see if there are a lot of processes for word that might
create some sort of bottleneck, or concurrency issue.

I know when I am doing some selenium work with Google Chrome,
sometimes it leaves a rogue Chrome process running, and as a
result, the server gets bogged down and can’t do what it’s
supposed to very well because of all the chrome processes left
over from failed python script instances.

Typically the error you are seeing might point to a problem with
some variable you believe should be an expected value, but in this
case, it’s None, or another non-standard value…  Typically, I will
log that kind of data from my classic asp web pages to understand
the problem more.

In your case, I might start by writing the file name (self.ruta)
to a log file in case it’s blank, or has special characters in it
that could be causing issues.

I hope this helps.  The error messages you are seeing are quite
generic, and reference a problem with rendering the webpage and
not necessarily a python specific error.

Steven

*From:* python-win32
 *On Behalf Of
*Martín Trujillo Raddatz
*Sent:* Monday, May 29, 2023 12:05 PM
*To:* python-win32@python.org
*Subject:* [python-win32] unknow solution

i ve using the library for some time now without any trouble..
but a few days ago the script for a conversion in word from doc to
pdf respond with this error sometimes, other works fine, the error
is random, i cant figure out why occurs.

the error is:

Traceback (most recent call last):
  File

"C:\inetpub\wwwroot\ruc2docs\venv\lib\site-packages\win32com\client\dynamic.py",
line 81, in _GetGoodDispatch
    IDispatch = pythoncom.connect(IDispatch)
pywintypes.com_error: (-2147221021, 'Operación no disponible',
None, None)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\inetpub\wwwroot\ruc2docs\r2d2documento.py", line 14, in
__init__
    self.save_as_('pdf')
  File "C:\inetpub\wwwroot\ruc2docs\r2d2documento.py", line 25, in
save_as_
    word = win32.gencache.EnsureDispatch('Word.Application')
  File

"C:\inetpub\wwwroot\ruc2docs\venv\lib\site-packages\win32com\client\gencache.py",
line 524, in EnsureDispatch
    disp = win32com.client.Dispatch(prog_id)
  File

"C:\inetpub\wwwroot\ruc2docs\venv\lib\site-packages\win32com\client\__init__.py",
line 95, in Dispatch
    dispatch, userName =
dynamic._GetGoodDispatchAndUserName(dispatch,userName,clsctx)
  File

"C:\inetpub\wwwroot\ruc2docs\venv\lib\site-packages\win32com\client\dynamic.py",
line 98, in _GetGoodDispatchAndUserName
    return (_GetGoodDispatch(IDispatch, clsctx), userName)
  File

"C:\inetpub\wwwroot\ruc2docs\venv\lib\site-packages\win32com\client\dynamic.py",
line 83, in _GetGoodDispatch
    IDispatch = pythoncom.CoCreateInstance(IDispatch, None,
clsctx, pythoncom.IID_IDispatch)
pywintypes.com_error: (-2146959355, 'Error en la ejecución de
servidor', None, None)

the code to execute the conversion is:

def save_as_(self, tipo):
        import win32com.client as win32
        from win32com.client import constants
        # self.registrar_conversion()
        word = win32.gencache.EnsureDispatch('Word.Application')
  

Re: [python-win32] unknow solution

[Martín Trujillo Raddatz]

Thanks!
Finally the problem is Word app, i try repair and reinstall, din not work.
its seems that a virus may be affecting it, we are now moving the scripts
to other machine ir orden to determine if  the proble is Word or other
thing.

**


*Martín Trujillo Raddatz Puerto Montt - ChileTeléfono:
+56 9 96427814 *
**


El mar, 30 may 2023 a las 17:29, Steven Manross ()
escribió:

> While I’ve done word automation in the past, is it possible that there’s
> any issues with the word application installation itself?  Or maybe you
> might have multiple scripts trying to open/write files simultaneously?
>
>
>
> As well, I might consider looking at task manager on your web server to
> see if there are a lot of processes for word that might create some sort of
> bottleneck, or concurrency issue.
>
>
>
> I know when I am doing some selenium work with Google Chrome, sometimes it
> leaves a rogue Chrome process running, and as a result, the server gets
> bogged down and can’t do what it’s supposed to very well because of all the
> chrome processes left over from failed python script instances.
>
>
>
> Typically the error you are seeing might point to a problem with some
> variable you believe should be an expected value, but in this case, it’s
> None, or another non-standard value…  Typically, I will log that kind of
> data from my classic asp web pages to understand the problem more.
>
>
>
> In your case, I might start by writing the file name (self.ruta) to a log
> file in case it’s blank, or has special characters in it that could be
> causing issues.
>
>
>
> I hope this helps.  The error messages you are seeing are quite generic,
> and reference a problem with rendering the webpage and not necessarily a
> python specific error.
>
>
>
> Steven
>
> *From:* python-win32  *On
> Behalf Of *Martín Trujillo Raddatz
> *Sent:* Monday, May 29, 2023 12:05 PM
> *To:* python-win32@python.org
> *Subject:* [python-win32] unknow solution
>
>
>
> i ve using the library for some time now without any trouble.. but a
> few days ago the script for a conversion in word from doc to pdf
> respond with this error sometimes, other works fine, the error is random, i
> cant figure out why occurs.
>
>
>
> the error is:
>
>
>
> Traceback (most recent call last):
>   File
> "C:\inetpub\wwwroot\ruc2docs\venv\lib\site-packages\win32com\client\dynamic.py",
> line 81, in _GetGoodDispatch
> IDispatch = pythoncom.connect(IDispatch)
> pywintypes.com_error: (-2147221021, 'Operación no disponible', None, None)
>
> During handling of the above exception, another exception occurred:
>
> Traceback (most recent call last):
>   File "C:\inetpub\wwwroot\ruc2docs\r2d2documento.py", line 14, in __init__
> self.save_as_('pdf')
>   File "C:\inetpub\wwwroot\ruc2docs\r2d2documento.py", line 25, in save_as_
> word = win32.gencache.EnsureDispatch('Word.Application')
>   File
> "C:\inetpub\wwwroot\ruc2docs\venv\lib\site-packages\win32com\client\gencache.py",
> line 524, in EnsureDispatch
> disp = win32com.client.Dispatch(prog_id)
>   File
> "C:\inetpub\wwwroot\ruc2docs\venv\lib\site-packages\win32com\client\__init__.py",
> line 95, in Dispatch
> dispatch, userName =
> dynamic._GetGoodDispatchAndUserName(dispatch,userName,clsctx)
>   File
> "C:\inetpub\wwwroot\ruc2docs\venv\lib\site-packages\win32com\client\dynamic.py",
> line 98, in _GetGoodDispatchAndUserName
> return (_GetGoodDispatch(IDispatch, clsctx), userName)
>   File
> "C:\inetpub\wwwroot\ruc2docs\venv\lib\site-packages\win32com\client\dynamic.py",
> line 83, in _GetGoodDispatch
> IDispatch = pythoncom.CoCreateInstance(IDispatch, None, clsctx,
> pythoncom.IID_IDispatch)
> pywintypes.com_error: (-2146959355, 'Error en la ejecución de servidor',
> None, None)
>
>
>
> the code to execute the conversion is:
>
>
>
> def save_as_(self, tipo):
> import win32com.client as win32
> from win32com.client import constants
> # self.registrar_conversion()
> word = win32.gencache.EnsureDispatch('Word.Application')
> doc = word.Documents.Open(self.ruta, ReadOnly=True,
> AddToRecentFiles=False, Revert=True, Visible=False)
> doc.Activate()
> if tipo == 'pdf':
> word.ActiveDocument.SaveAs(self.ruta[:-4] + '.pdf',
> FileFormat=constants.wdFormatPDF)
> elif tipo == 'docx':
> word.ActiveDocument.SaveAs(self.ruta[:-4] + '.doc',
> FileFormat=constants.wdFormatXMLDocument)
> doc.Close(SaveChanges=constants.wdDoNotSaveChanges)
> word.Quit()
>
>
>
> Thank you!
>
>
>
> **
>
>
>
> *Martín Trujillo Raddatz  Puerto Montt - Chile
> Teléfono: +56 9 96427814 *
>
> **
>
___
python-win32 mailing list
python-win32@python.org
https://mail.python.org/mailman/listinfo/python-win32

Re: [python-win32] unknow solution

[Steven Manross]

While I’ve done word automation in the past, is it possible that there’s any 
issues with the word application installation itself?  Or maybe you might have 
multiple scripts trying to open/write files simultaneously?

As well, I might consider looking at task manager on your web server to see if 
there are a lot of processes for word that might create some sort of 
bottleneck, or concurrency issue.

I know when I am doing some selenium work with Google Chrome, sometimes it 
leaves a rogue Chrome process running, and as a result, the server gets bogged 
down and can’t do what it’s supposed to very well because of all the chrome 
processes left over from failed python script instances.

Typically the error you are seeing might point to a problem with some variable 
you believe should be an expected value, but in this case, it’s None, or 
another non-standard value…  Typically, I will log that kind of data from my 
classic asp web pages to understand the problem more.

In your case, I might start by writing the file name (self.ruta) to a log file 
in case it’s blank, or has special characters in it that could be causing 
issues.

I hope this helps.  The error messages you are seeing are quite generic, and 
reference a problem with rendering the webpage and not necessarily a python 
specific error.

Steven
From: python-win32  On 
Behalf Of Martín Trujillo Raddatz
Sent: Monday, May 29, 2023 12:05 PM
To: python-win32@python.org
Subject: [python-win32] unknow solution

i ve using the library for some time now without any trouble.. but a few 
days ago the script for a conversion in word from doc to pdf respond with this 
error sometimes, other works fine, the error is random, i cant figure out why 
occurs.

the error is:

Traceback (most recent call last):
  File 
"C:\inetpub\wwwroot\ruc2docs\venv\lib\site-packages\win32com\client\dynamic.py",
 line 81, in _GetGoodDispatch
IDispatch = pythoncom.connect(IDispatch)
pywintypes.com_error: (-2147221021, 'Operación no disponible', None, None)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\inetpub\wwwroot\ruc2docs\r2d2documento.py", line 14, in __init__
self.save_as_('pdf')
  File "C:\inetpub\wwwroot\ruc2docs\r2d2documento.py", line 25, in save_as_
word = win32.gencache.EnsureDispatch('Word.Application')
  File 
"C:\inetpub\wwwroot\ruc2docs\venv\lib\site-packages\win32com\client\gencache.py",
 line 524, in EnsureDispatch
disp = win32com.client.Dispatch(prog_id)
  File 
"C:\inetpub\wwwroot\ruc2docs\venv\lib\site-packages\win32com\client\__init__.py",
 line 95, in Dispatch
dispatch, userName = 
dynamic._GetGoodDispatchAndUserName(dispatch,userName,clsctx)
  File 
"C:\inetpub\wwwroot\ruc2docs\venv\lib\site-packages\win32com\client\dynamic.py",
 line 98, in _GetGoodDispatchAndUserName
return (_GetGoodDispatch(IDispatch, clsctx), userName)
  File 
"C:\inetpub\wwwroot\ruc2docs\venv\lib\site-packages\win32com\client\dynamic.py",
 line 83, in _GetGoodDispatch
IDispatch = pythoncom.CoCreateInstance(IDispatch, None, clsctx, 
pythoncom.IID_IDispatch)
pywintypes.com_error: (-2146959355, 'Error en la ejecución de servidor', None, 
None)

the code to execute the conversion is:

def save_as_(self, tipo):
import win32com.client as win32
from win32com.client import constants
# self.registrar_conversion()
word = win32.gencache.EnsureDispatch('Word.Application')
doc = word.Documents.Open(self.ruta, ReadOnly=True, 
AddToRecentFiles=False, Revert=True, Visible=False)
doc.Activate()
if tipo == 'pdf':
word.ActiveDocument.SaveAs(self.ruta[:-4] + '.pdf', 
FileFormat=constants.wdFormatPDF)
elif tipo == 'docx':
word.ActiveDocument.SaveAs(self.ruta[:-4] + '.doc', 
FileFormat=constants.wdFormatXMLDocument)
doc.Close(SaveChanges=constants.wdDoNotSaveChanges)
word.Quit()

Thank you!


Martín Trujillo Raddatz
Puerto Montt - Chile
Teléfono: +56 9 96427814

___
python-win32 mailing list
python-win32@python.org
https://mail.python.org/mailman/listinfo/python-win32