SAP Knowledge Base Article - Preview

2567129 - Accessing BPC folders slow in EPM add-in

Symptom

In EPM add-in, when clicking on "Open Server", it can take very long before the selection box appears

On one click, it can be instant and then within the same session, clicking can take 10+ seconds

p1.jpg

In the EPM perf logs, you will see the same call with different response times

2017-10-03 17:44:28,800|DEBUG|Performance|?.?|OSSADMIN|||||1|Remote call [https://bpc.sap.com/sap/bpc/files?method=list] start#
2017-10-03 17:44:28,844|DEBUG|Performance|?.?|OSSADMIN|||||1|Remote call [https://bpc.sap.com/sap/bpc/files?method=list] end, duration = 0.043 s#
..
2017-10-03 17:45:07,348|DEBUG|Performance|?.?|OSSADMIN|||||1|Remote call [https://bpc.sap.com/sap/bpc/files?method=list] start#
2017-10-03 17:45:16,441|DEBUG|Performance|?.?|OSSADMIN|||||1|Remote call [https://bpc.sap.com/sap/bpc/files?method=list] end, duration = 12.093 s#

In traces, you see slow SQL selects on table "UJF_DOCTREE"

SELECT WHERE "MANDT" = ? AND "APPSET" = ? AND "PARENTDOC" = ? ORDER BY "MANDT" , "DOCNAME"


Read more...

Environment

Business Planning and Consolidation NW 10.x

Product

SAP Business Planning and Consolidation 10.1, version for SAP NetWeaver ; SAP Business Planning and Consolidation, version for SAP BW/4HANA all versions

Keywords

UJF_DOCTREE, buffer   , KBA , bpc-nw , EPM-BPC-NW-INF-FS , File Service , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.