SAP Knowledge Base Article - Preview

2858935 - Opening a Webi report is intermittently very slow

Symptom

  • Intermittently reports load slowly
  • The load time was ~5 minutes in this case, on approximately 1 in 10 of the attempts to open the report
  • In an end to end trace, these functions are the delay:
2019 09 17 10:59:14:718|RepositoryProxy_SessionRegistry:initBICommentaryService: 2:30.503
2019 09 17 10:59:24:717|dgDocument:ProcessCommentCommands: 2:40.504
  • Additionally, you will intermittently see errors in the logs following these attempted queries: 
2019 09 16 09:29:58.962|arralistVal:[0, LIUjasjMerbSk_2lP0] query:SELECT CommentID,DocId,CommentText,UserCuid,UserName,LastModifiedUserCuid,LastModifiedUserName,
CreationTimeStamp,LastModifiedTimestamp,LogicalReportId,ContextCommon,AppName,AppContext,AppDatapath,OptionKey1,OptionKey2,OptionKey3,OptionKey4,Hidden  
FROM COMMENTARY_MASTER where Hidden=? AND DocId= ? ORDER BY  CreationTimeStamp ASC
 
2019 09 16 09:30:11.103|EnterpriseSession: dispose(): aps=HOSTNAME:6400,cluster=@CLUSTERNAME,userInfo=(UserInfo: username=GenericUser,userID=9991111,userDesc=,auth=secWinAD),
uri=osca:iiop://HOSTNAME:6400;SI_SESSIONID=PLACEHOLDERSTRING,SI_TENANT_ID=0


Read more...

Environment

  • SAP BusinessObjects Business Intelligence Platform 4.2
  • Web Intelligence HTML interface
  • Commentary Database is not set to use Audit Database

Product

SAP BusinessObjects Business Intelligence platform 4.2

Keywords

KBA , BI-RA-WBI , Web Intelligence , 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.