SAP Knowledge Base Article - Public

3296912 - AO Workbook with transient query pointing to wrong system

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

Product

SAP Analysis for Microsoft Office all versions