SAP Knowledge Base Article - Preview

2567129 - Slow access to Business Planning and Consolidation (BPC) folders from 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, the same call with different response times appear:

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#

  • The trace shows low SQL selects on table "UJF_DOCTREE"

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

 



Read more...

Environment

  • SAP Business Planning and Consolidation, version for SAP NetWeaver 10.x
  • SAP Business Planning and Consolidation, version for SAP BW/4HANA 11.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


slow access, EPM add in, BPC folders, buffering issue, SQL selects, UJF_DOCTREE, performance logs, Open Server, selection box delay, Business Planning and Consolidation, NW, File Service, SE13, buffering not allowed , KBA , 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 for Me (Login required).

Search for additional results

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