BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: Upcoming Events: PGHBOUG: Nov 1.

[BI 4.x] Server Issue


 
Search this topic... | Search XI Server Discussion... | Search Box
Register or Login to Post    Forum Index -> Server Administration, Installation, Upgrades -> XI Server Discussion  Previous TopicPrint TopicNext Topic
Author Message
DaveO
Senior Member
Senior Member



Joined: 28 Apr 2005

Posts: 75
Location: North West, UK


flag
PostPosted: Thu Nov 15, 2018 5:39 am 
Post subject: Server Issue

Hi everyone.

We have a bit of a major issue with some reports that are querying a multi source universe since we upgraded to SAP BI4.2 SP6. The issue we're experiencing is an extremely long delay between clicking on refresh to seeing the prompt window opening when we run the reports through the browser in either HTML or Java (IE or Chrome). However, when the reports are opened and refreshed through Rich Client they run without any problems.

Because of the difference between browser and Rich Client, I'm guessing the issue is with the way the servers have been set up however, I don't know for sure what servers are being used between the refresh and opening of the prompt window when running the report from the server through a browser and which ones are being used when running the report locally through Rich Client.

Could anyone advise or has anyone experienced similar issues?

Thanks in advance.

D.
Back to top
joepeters
Forum Fanatic
Forum Fanatic



Joined: 29 Aug 2002

Posts: 6606
Location: Connecticut, USA


flag
PostPosted: Mon Nov 19, 2018 12:28 pm 
Post subject: Re: Server Issue

I don't have an answer for you, but the DataFederation server is used to process all queries for multi-source universes. You can also use the Data Federation Administration Tool to get historical stats on all queries generated.

Joe
Back to top
Andreas
Forum Advocate
Forum Advocate



Joined: 20 Jun 2002

medal_silver.gif*2medal_gold.gif
Posts: 17344
Location: *** BEEP ...Dreaming of Africa... leave No message ; ) BEEP ***


flag
PostPosted: Mon Nov 26, 2018 9:56 am 
Post subject: Re: Server Issue

Please, which patch are you running? Patch 3 for 4.2 SP6? or?
_________________
Follow me on Twitter
Reading "The Design Of Everyday Things" by Don Norman
Focusing on Data Visualization, Design Thinking, SAP DesignStudio + scripting, SAP BI 4.x platform & architecture, SAP connectivity, Data Modeling, and SAP HANA Certified Associate
Back to top
joepeters
Forum Fanatic
Forum Fanatic



Joined: 29 Aug 2002

Posts: 6606
Location: Connecticut, USA


flag
PostPosted: Mon Nov 26, 2018 9:58 am 
Post subject: Re: Server Issue

We're on BI4.2 SP06 Patch 100.
Back to top
Andreas
Forum Advocate
Forum Advocate



Joined: 20 Jun 2002

medal_silver.gif*2medal_gold.gif
Posts: 17344
Location: *** BEEP ...Dreaming of Africa... leave No message ; ) BEEP ***


flag
PostPosted: Tue Nov 27, 2018 12:48 am 
Post subject: Re: Server Issue

Might wanna try patch 3, we had issues w/ OLAP BW Based universes, which would trigger a memory leak in the Webi PROC Server, which in turn would go into recycle mode and get stuck there.
_________________
Follow me on Twitter
Reading "The Design Of Everyday Things" by Don Norman
Focusing on Data Visualization, Design Thinking, SAP DesignStudio + scripting, SAP BI 4.x platform & architecture, SAP connectivity, Data Modeling, and SAP HANA Certified Associate
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Server Administration, Installation, Upgrades -> XI Server Discussion  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0275 seconds using 17 queries. (SQL 0.0028 Parse 0.0009 Other 0.0238)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo