none
OLAP over HTTP resulting in 503 status code and connection time out RRS feed

  • General discussion

  • Hi,
    I set up my OLAP over HTTP with msmdpump.dll and set up the .ini file accordingly. The connections are fine, however on my site when i make a lot of request to the OLAP, I get a 503 HTTP status code andconnection time out in th event log. 

    I have change the #of threads on the .ini file for msmdpump.dll. Also changed the initialconnectiontimeout in sql ini file from 10 to 15.

    In my OLAP instance in sql studio, under datasources I made adjustments from forums but that did not affect. in all instances i restarted the machine.

    NOt sure where to look further and how i can diagnose what the issue is. Looking for any assistance to help me resolve my issue.
    Monday, February 2, 2015 7:35 PM

All replies

  • Hi,

    we also had some problems after we made some Stresstests on the AS with many connections.

    First we raised the Queue Length and the worker processes in the Application Pool.

    Worked, but the recommendation was  to do this at the last step.

    So we changed the following entries in the ini of the Datapump:

     <MinThreadPoolSize>60</MinThreadPoolSize>
     <MaxThreadPoolSize>200</MaxThreadPoolSize>
     <MaxThreadsPerClient>20</MaxThreadsPerClient>

    Kr Jürgen

    Tuesday, February 3, 2015 8:33 AM