Executing Word Macros from WebSphere/Tomcat running as NT Services


Updated 2015.07.31: corrected and added System32 vs SysWOW64 details.

If macros do not execute when running from the RPE Web Services or Rational DOORS Next Generation that is most likely caused by Word automation not functioning properly. If you check the RPE/RDNG log files you may observe error an entry like this one: Error loading document. Error: 424 – Object required

A solution that worked for us in many cases is to create a “Desktop” folder under  C:\Windows\System32\config\systemprofile or C:\Windows\SysWOW64\config\systemprofile. Create the folder, restart the application server and verify if the problem is resolved.

What folder to use

  1. for 32 bit Windows it’s only C:\Windows\System32\config\systemprofile
  2. for 64 bit Windows
    1. if Word is 64 bit you need to use C:\Windows\System32\config\systemprofile
    2. if Word is 32 bit you need to use C:\Windows\SysWOW64\config\systemprofile

Please note that Microsoft does not officially support Word automation from NT Services so there is no guarantee that this solution will always work.

systemprofile_desktop

More information is available in the RPE Infocenter here: http://www-01.ibm.com/support/knowledgecenter/SS6RHZ_1.2.0/com.ibm.rational.pe.troubleshooting.doc/topics/t_macro_execution.html

NOTE: if you type C:\Windows\SysWOW64\config\systemprofile or C:\Windows\System32\config\systemprofile in the Windows Explorer address bar you might receive an error from Windows that the path does not exist. You need to start the navigation from the System32/SysWOW64 folder and confirm your administrator access when prompted.

Advertisements

Author: Dragos Cojocari

Architect for Rational Publishing Engine

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s