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.

3051114 - When closing Excel the process hangs

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