SAP Knowledge Base Article - Preview

2679143 - Fiori Launchpad initial startup is very slow - SAP ASE for Business Suite

Symptom

  • SAP Fiori Launchpad takes 30+ seconds just for Fiori to start
  • It shows the message "Please Wait.." for a long time before anything changes.
  • Initial Fiori Launchpad load after running the report /UI5/APP_INDEX_CALCULATE is very slow
  • Per ST12, slow queries are the one of the following:

Program: /UIF/CL_LREP_DB_ACCESS_CDEP
Table: /UIF/LREPDEREFCD

SELECT DISTINCT  WHERE "CLIENT" = '100' AND ( ( "TROBJNAME" IN ( '+abcdgef=' , ‘fsadasdek=' ) AND "REF_TYPE" = 'UEP' AND "REF_SUBTYPE" = 'CONT' )
OR ( "TROBJNAME" IN ( '+abcdgef=' , ‘fsadasdek=') AND "REF_TYPE" = 'UI5DEP' AND "REF_SUBTYPE" = 'E' )
OR ( "TROBJNAME" IN ( '+abcdgef=' , ‘fsadasdek=') AND "REF_TYPE" = 'UI5DEP' AND "REF_SUBTYPE" = 'L' )
OR ( "TROBJNAME" IN ( '+abcdgef=' , ‘fsadasdek=') AND "REF_TYPE" = 'UI5DEP' AND "REF_SUBTYPE" = 'LY' )
OR ( "TROBJNAME" IN ( '+abcdgef=' , ‘fsadasdek=') AND "REF_TYPE" = 'UI5DEP' AND "REF_SUBTYPE" = 'MR' )
OR ( "TROBJNAME" IN ( '+abcdgef=' , ‘fsadasdek=') AND "REF_TYPE" = 'UI' AND "REF_SUBTYPE" = 'TY' )
OR ( "TROBJNAME" IN ( '+abcdgef=' , ‘fsadasdek=' ) AND "REF_TYPE" = 'EMBEDDED' AND "REF_SUBTYPE" = '' )
OR ( "TROBJNAME" IN ( '+abcdgef=' , ‘fsadasdek=') AND "REF_TYPE" = 'VERSION' AND "REF_SUBTYPE" = '' )
OR ( "TROBJNAME" IN ( '+abcdgef=' , ‘fsadasdek=') AND "REF_TYPE" = 'ORIGLAYER' AND "REF_SUBTYPE" = '' )
OR ( "TROBJNAME" IN ( '+abcdgef=' , ‘fsadasdek=') AND "REF_TYPE" = 'UI5ATTR' AND "REF_SUBTYPE" = 'APD' )
OR ( "TROBJNAME" IN ( '+abcdgef=' , ‘fsadasdek='  ) AND "REF_TYPE" = 'UI5ATTR' AND "REF_SUBTYPE" = 'APR' )
OR ( "TROBJNAME" IN ( '+abcdgef=' , ‘fsadasdek=') AND "REF_TYPE" = 'UI5ATTR' AND "REF_SUBTYPE" = 'CENT' )
OR ( "TROBJNAME" IN ( '+abcdgef=' , ‘fsadasdek=') AND "REF_TYPE" = 'UI5ATTR' AND "REF_SUBTYPE" = 'I' )
OR ( "TROBJNAME" IN ( '+abcdgef=' , ‘fsadasdek=' ' ) AND "REF_TYPE" = 'UI5ATTR' AND "REF_SUBTYPE" = 'TYE' )
OR ( "TROBJNAME" IN ( '+abcdgef=' , ‘fsadasdek=') AND "REF_TYPE" = 'UI5ATTR' AND "REF_SUBTYPE" = 'NO’)
OR ( "TROBJNAME" IN ( '+abcdgef=' , ‘fsadasdek=')  AND "REF_TYPE" = 'UI5ATTR' AND "REF_SUBTYPE" = 'BSP’)
OR ( "TROBJNAME" IN ( '+abcdgef=' , ‘fsadasdek=') AND "REF_TYPE" = 'DATASOURCE' AND "REF_SUBTYPE" = 'OA' )
OR ( "TROBJNAME" IN ( '+abcdgef=' , ‘fsadasdek=') AND "REF_TYPE" = 'DATASOURCE' AND "REF_SUBTYPE" = 'ONO'  ) )
 /* R3:/UIF/CL_LREP_DB_ACCESS_CDEP===CP:5233 T:/UIF/LREPDEREFCD M:100 */ 

SELECT DISTINCT "REF_TYPE" ,"REF_SUBTYPE" ,"NAMESPACE" ,"NAME" ,"TYPE" ,"LAYER_TYPE" ,"CREATED_AT" ,"LAST_CHANGED_AT" ,"URI" FROM "/UIF/LREPVCCD" WHERE "CLIENT" = ? AND ( "REF_TYPE" = ? OR "REF_TYPE" = ? ) AND "REF_HASH" IN ( ? , ? , ? ) AND "LAYER_TYPE" IN ( ? , ? ) AND "HIDDEN" = ? /* R3:/UIF/CL_LREP_DB_ACCESS_CDEP===CP:4918 T:/UIF/LREPVCCD M:100 */  

SELECT "REF_TYPE" ,"REF_SUBTYPE" ,"NAMESPACE" ,"NAME" ,"TYPE" ,"LAYER_TYPE" ,"CREATED_AT" ,"LAST_CHANGED_AT" ,"URI" FROM "/UIF/LREPVC" WHERE ( "REF_TYPE" = ? OR "REF_TYPE" = ? ) AND "REF_HASH" IN ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) AND "LAYER_TYPE" IN ( ? , ? , ? ) AND "HIDDEN" = ? /* R3:/UIF/CL_LREP_DB_ACCESS========CP:4879 T:/UIF/LREPVC M:330 */ /*unc. rd.*/


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite (BS)
  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite (BS)
  • SAP NetWeaver 7.5

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver 7.4

Keywords

UI5, Fiori, launchpad, startup, slow, /UIF/LREPDEREFCD, "rsdb/max_blocking_factor", "rsdb/prefer_union_all", /UI5/APP_INDEX_CALCULATE, /UIF/LREPVCCD , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.