Does Not apply to:
BigPicture
WhatIf
64-bit Excel, or 32-bit Excel 2010 or 2007

Running DTS In Process/out of Process

Background:

@RISK and the other DTS add-ins are 32-bit code, and each product has a bridge to 64-bit Excel.

Those bridges are called:

• RiskOutOfProcessServer7.exe
• EvolverOutOfProcessServer7.exe
• NeuralToolsOutOfProcessServer7.exe
• PrecisionTreeOutOfProcessServer7.exe
• StatToolsOutOfProcessServer7.exe

"Running out of process" means that it doesn't run directly as part of 64-bit Excel's process, but routes communications with Excel through the bridge.  Running out of process does NOT mean it's running out of memory.

 

When you're interfacing 32-bit code with 64-bit code, "running out of process" is normal. 

In DTS 7.5.1 and earlier releases, @RISK and the other tools alway ran out of process.

Starting with 7.5.2, when running with 32-bit Excel, the tools listed above now run in process by default. This removes a layer of code and is intended to provide better performance and stability.

If your simulations involve Microsoft Project, you'll notice a very significant speedup from running @RISK 7.6 in process.

If you are running into issues with @RISK running in process (such as flashing windows or windows not appearing at all), you can set DTS software to run out of process.

Setting DTS to Run Out of Process

NOTE: These settings are recorded in the current user's profile. If people log in to this computer under different Windows usernames, the others will continue running in process unless they also follow one of these two methods.

Method A:

1. Launch the software, and get into Utilities » Application Settings.
2. In the Advanced section at the end of Application Settings, change Operating Mode to out-of-process, and click OK.

TIP: If you have the DecisionTools Suite, and some tools are working, change this setting in one of the working tools, and it will offer to change it in the others, working and non-working. Remember to close Excel before re-testing the tool that has the issue.

Method B:

If you can't launch the software, or the Application Settings dialog won't come up, you can use the attached OutOfProcess Registry file.

1. Close all open instances of Excel and Project.
2. Download the attached OutOfProcess file.
3. Change the extension from TXT to REG.
   1. If you can't see the .TXT extension, see Making File Extensions Visible
4. Double-click the REG file.

The REG file will set Registry keys for the five products listed above.

If you don't have the DecisionTools Suite but only one or more individual products, the extra keys will do no harm.

Setting DTS Back to Run In Process

In Utilities » Application Settings » Advanced, set Operating Mode to in-process, or use the attached InProcess file.

Possible issues running In Process:

Excel Seems to Freeze When Deleting Correlation Matrix

"Microsoft Excel is waiting for another application" (with MPP files)

 

Attachments:
KB1613_OutOfProcess_DecisionToolsSuite.txt
KB1613_InProcess_DecisionToolsSuite.txt