[BI 4.x] Server Issue

DaveO · 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.

joepeters · 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

Andreas · 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?

joepeters · Posted: Mon Nov 26, 2018 9:58 am Post subject: Re: Server Issue

We're on BI4.2 SP06 Patch 100.

Andreas · 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.