
General Notice: BOB is going to retire...please see details here. General Notice: No events within the next 45 days. |
Author |
Message |
DaveO Senior Member


Joined: 28 Apr 2005
              Posts: 75 Location: North West, UK

|
Posted: 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


Joined: 29 Aug 2002
                 Posts: 6629 Location: Connecticut, USA

|
Posted: 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


Joined: 20 Jun 2002
                
*2 Posts: 17346 Location: *** BEEP ...Dreaming of Africa... leave No message ; ) BEEP ***

|
Posted: 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


Joined: 29 Aug 2002
                 Posts: 6629 Location: Connecticut, USA

|
Posted: 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


Joined: 20 Jun 2002
                
*2 Posts: 17346 Location: *** BEEP ...Dreaming of Africa... leave No message ; ) BEEP ***

|
Posted: 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 |
|
 |
|
|