We are using BO4.0, for developing dashboards using Dashboard Design & BIWS as data connection. I created the BIWS, able to publish them succesfullly and used as data connection (Query As A Web Service) in Dashboard Design (xcelsius).
When am trying to preview, am recieving an error as "The maximum connection limit has been reached (RWI 00000)". Immediately our development server is going down with this error. When we are looking into the server... the sessions for data connections which are opening are double i.e. (a) Query As A Web Service (b) Web service. (for example if BIWS connections are 10 then total 20 sessions (10- QAAWS & 10-BIWS) are opening up) and not sure why this is making our connection limit has reached.
Could anyone please help us.
a) the solution for Maximum connection limit has reached
b) Two sessions BIWS & QAAWS are opening up, even though used BIWS.