OBIEE 12C + SSAS. Timeout

Question

Hi! I made subject area, based by SSAS-source (Anslysis Services 2012). In analytics, i created a analysis. Sometimes, when i run this analysis, i get error Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65PState: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)State: HY000. Code: 46169. [nQSError: 46169] An HTTP operation to timed out after 60 seconds. Operation aborted. (HY000) How fix this error? On the server (SSAS), i set up the IIS File "msmdpump.ini": SERVER_NAME 3600 20 20 50 10 There timeout is 3600 sec In repository: Connection pool (type XMLA) haven't such setting "Timeout" Where else i must change setting "Timeout"?

Frog Toad · Answer

Hi Mr Sausages > You can probably try changing to 10 or Maximum Connections in Connection Pool to 20. I checked many-many different cases - set different values to "Maximum connections" (in repository) and to "msmdpump.ini"-file. And this case too - i experimented with different values of "ConnectionPoolSize" - not helped. The only thing, early, after i get timeout-error, if i immediately run the report with timeout, i will get another error - 503: Error code: OPR4ONWY:U9IM8TAC:U9IM8TAC:OI2DL65P State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred (HY000) State: HY000. Code: 43113. [nQSError: 43113] И Message returned from OBIS. URL: http:///OLAP/msmdpump.dll. The http return status is 503. The service is unavailable. (HY000)503 I fixed 503-error in the following way - set "MaxThreadsPerClient" (from "msmdpump.ini") value less than "Maximum connections" (in repository). Ideally, when "MaxThreadsPerClient (from "msmdpump.ini)" and "Maximum connections" (in repository) are equally, this should solve problems with timeout... in my case it's not working

Mr Sausages · Answer

We tried reducing and increasing the connections, does not make any difference, quires work great on 11g.

Mr Sausages · Answer

Hi Frog,

Sorry to hear you are having as much luck with Oracle Support as we are having. Very disappoint.....

Would be handy if Oracle tested this for themselves.

We have had to role back from 12c to 11g where we have no issues. So it is a timeout they have introduced in 12c. It is not OS related.

Thank god Oracle do not make life support machines....