Symptom
A workbook has been transported that contains transient queries from source system A to target system B.
When opening the AO workbook from the system B, AO logon screen pops up pointing to logon on to system A.
Environment
SAP Analysis for Microsoft Office
Reproducing the Issue
Open AO workbook from Netweaver system or from Fiori Launchpad.
Cause
Due to backend system behavior change, transient queries are not avaialbe in the backend table RSAOOBJXREF and always point to the source system A.
In the AO_Trace_XXXXX.glf, you can find the following entries:
******************
DS_1 | 2CXXXXXXXXXXXX
#
XX:XX:XX.XXX |VERBOSE|Con |CrTlogoTransportHelper.GetDsToBeTransported |VSTA_Main | TLOGO: Content of RSAOOBJXREF table:
<empty>
******************
Resolution
AO Client has been adapted to new backend behavior in AO 2.8 SP17 with the new setting UsePlatformAsDefaultTransportTarget default set to True as described in note:
3287311 - Transient Queries are pointing to the origin System after Transport
Please apply AO 2.8 SP17 (or higher) to resolve this issue.
Keywords
transport, logon, source system, target system, UsePlatformAsDefaultTransportTarget, RSAOOBJXREF, transient queries, 2C, cds , KBA , BI-RA-AO-XLA , Excel Addin , BI-RA-AO-BIP , AO Precalculation, Scheduling and AO InfoOb... , Problem
SAP Knowledge Base Article - Public