BO XI 4.0 is slow, very slow

[Former Member]

Hi,

We had some weeks ago BO XI 3.1 with some reports, everything was good.

We have created a new environment, with :

- Windows 2008 R2 64 bits standard with 4 CPU and 20Giga of RAM

- SQL 2008 R2 64 bits standard

- BO XI 4.0 SP3 64 bits

We have migrated the report to the new server, and now it’s take a long time to have the report
(1 minute versus 15 seconds). Same problem with all report.

Could you please help us to troubleshoot?

Thanks  a lot in advance

[Former Member]

If you still have both 3.1 and 4.0 environments, it worth looking at the SQL query for a report and compare between the environments.

[IngoH]

Hello Marc,

is the report in BI4 still using the XI 3.1 Universe ?

Ingo

[Former Member]

Hi,

Thanks for the feedback.

Everthing was migrated on XI 4 to the new server

[former_member188911]

Try to open the documents, refresh, save and then check the response times again.

You can also try to get some end to end traces to see where time is consumed

instructions here http://scn.sap.com/community/bi-platform/remote-supportability/blog/2012/11/06/how-to-generate-and-c...

[Former Member]

Hi Simone,

Thanks a lot for the information.

We have made the steps, but not possible for us to understand why it's take so much time 😞

You can find attached the file filtered with the transaction id, perhaps can you have a look?

Thanks a lot in advance for your time and experience 😉

test.glf.zip

[former_member188911]

Have you split the APS?

Is this a physical box or virtualized?

thanks

SC

[Former Member]

Yes, the APS is splited

This is a virtualized server (with CPU and RAM reserved for it)

FYI : the wiReporter server take only 25% of CPU, never more

[Former Member]

Hi Simone

Do you have please some time to analyse the file posted?

The only process running is WIReportServer (it take all ressources of one cpu). except the CPU no other ressources are used.

Is it possible to use multi processor for one WIReportServer.exe?

Thanks in advance for you help

[Henry_Banks]

Hi,

It sounds like you're hitting a problem.. testing a single webi reports should not occupy 1 entire cpu (25% of a quad core)

I can't recommend 'vanilla' FP03 (SP03) - that was a pre-release "ramp up" version, and went "generally available" on SP04 actually. This was ~ 12 months ago.

Since then, we only have SP05 and SP06 that are now actively maintained, so all the latest code/bug fixes are in the later Patch5.x or Patch6.x

I would recommend that you move to a later SP + Patch level and retest - at least that way, when you contact Support, it will make for a more meaningful interaction.

Regards,

H

[Former Member]

Hi Henry,

In fact we already have the SP6 😞

It's strange because the same report in BO XI 3 take just 15 seconds and 50seconds on the BO XI 4 infrastructure.

Do you know how we can troubleshoot?

Thanks

[Former Member]

Hi Marc,

Could you also check the working of the reports in the client tools rather than web interface?  - like Interactive Analysis or Webi Rich Client...

Also if feasible can we create a test report which might be similar to the one which are tested and monitor the processing of it?   - this can guide us if the issue is only with migrated reports or new reports as well..

thanks,

Arun