BPC Optimization Server Time Out error message

[Former Member]

We’re using BPC 7.5 MS and on patch level 111.02

There’s two front-end servers and one back-end.

When completing a full optimization with compression on an application we immediately get the optimization popup screen with no processing information only a “Server Time Out” error message.

Optimization was taking a long to time run and sometimes timed out.  To try and resolve this issue we have just updated indexes and statistics and during our test in production we now receive the “Server Time Out” error message immediately. However, the records from tbl.Factwb and tbl.Fac2 did move to the tbl.Fact.

Our development environment test ran fine.

Any suggestions?

Thanks.

[former_member186498 · Accepted solution]

Hi Michael,

please look in the logs maybe you will found more informations regarding the timeout and eventually share it.

There are several notes about a timeout in 10 version,

1394533 - 'Server Time Out' error when performing Modify Application, Full Process of a dimension, o...this is related with NLB

but it could be also related with the web.config 1628908 - How to fix Optimize with compress time-out failure

or if you reach the max number of connection

1635749 - Error Message: Timeout expired. The timeout period elapsed prior to obtaining a connection...

Regards

     Roberto

[Former Member · Accepted solution]

Thanks Roberto.

It seems to have resolved itself but I'll speak with our IT department about looking into some of these settings.

Michael