SAP Knowledge Base Article - Public

3096839 - Analysis Office is hanging when trying to reconnect to BW system


Analysis Office is freezing/hanging when trying to reconnect to BW system.

The trace of AO (see SAP note 2129389) ends with following entries when AO hangs:
Run cancelable action Executing server function "RSAO_GET_REENTRY_TICKET"
Waiting for tasks
+++ Execute function in new task - task id <XYZ>

The task <XYZ> never ends and the expected entry below is not found in trace:
+++ Execution of function finished - task id <XYZ>


SAP BusinessObjects Analysis, edition for Microsoft Office


Change the setting PreferDirectAssertionTickets to FALSE (uncheck it). The setting is available in AO 2.8 SP11 via Excel File > Analysis > Customize Analysis > Technical Configuration.

If using AO 2.8 SP10, it is necessary to add the setting manually in the configuration file %programdata%\SAP\Cof\Ao_app.config by adding the entry below under <configSections>: 
<section name="PreferDirectAssertionTickets" type="Boolean" configurationLevel="PerMachine" />

Then add the following entry before last line </configuration>:
<PreferDirectAssertionTickets value="False" /> 

Refer to SAP note 2083067.

See Also

3051114 - When closing Excel the process hangs


freeze, freezing, freezes, hangs, hang, hanging , KBA , BI-RA-AO-XLA , Excel Addin , Problem


SAP Analysis for Microsoft Office all versions