<div><span style="color:rgb(34,34,34);font-size:13px;font-family:arial,sans-serif">I know about sql and mdx log, but I would actually like to get the current state of Mondrian i.e. which queries / mdx statements / tasks are currently in execution.</span></div>
<div><span style="color:rgb(34,34,34);font-size:13px;font-family:arial,sans-serif"><br></span></div><div><span style="color:rgb(34,34,34);font-size:13px;font-family:arial,sans-serif">To better understand my problem, I often get the following error:</span></div>
<div><span style="color:rgb(34,34,34);font-size:13px;font-family:arial,sans-serif"><br></span></div><div><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">Mondrian Error:The number of </span><span class="il" style="background-color:rgb(255,255,204);color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px">concurrent</span><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)"> </span><span class="il" style="background-color:rgb(255,255,204);color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px">MDX</span><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)"> statements which can be processed simultaneously by this Mondrian server instance has been reached. Set 'mondrian.rolap.</span><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">maxQueryThreads' to change the current limit.</span></div>
<div><br></div><div><font color="#222222" face="arial, sans-serif">All the consequential mdx queries after that error fails to execute (even if I wait for 300s). I suspect that there are MDX queries which fail to finish and I would like to see which.</font></div>
<span style="font-size:13px;color:rgb(34,34,34);font-family:arial,sans-serif"><div><br></div><div>Best,</div><div>Domen</div><div><br></div>Date: Fri, 8 Mar 2013 13:10:01 -0600</span><br style="font-size:13px;color:rgb(34,34,34);font-family:arial,sans-serif">
<span style="font-size:13px;color:rgb(34,34,34);font-family:arial,sans-serif">From: Matt Campbell <</span><a href="mailto:mcampbell@pentaho.com" target="_blank" style="font-size:13px;color:rgb(17,85,204);font-family:arial,sans-serif">mcampbell@pentaho.com</a><span style="font-size:13px;color:rgb(34,34,34);font-family:arial,sans-serif">></span><br style="font-size:13px;color:rgb(34,34,34);font-family:arial,sans-serif">
<span style="font-size:13px;color:rgb(34,34,34);font-family:arial,sans-serif">Subject: Re: [Mondrian] retrieve currently executing sql queries</span><br style="font-size:13px;color:rgb(34,34,34);font-family:arial,sans-serif">
<span style="font-size:13px;color:rgb(34,34,34);font-family:arial,sans-serif">To: Mondrian developer mailing list <</span><a href="mailto:mondrian@pentaho.org" target="_blank" style="font-size:13px;color:rgb(17,85,204);font-family:arial,sans-serif">mondrian@pentaho.org</a><span style="font-size:13px;color:rgb(34,34,34);font-family:arial,sans-serif">></span><br style="font-size:13px;color:rgb(34,34,34);font-family:arial,sans-serif">
<span style="font-size:13px;color:rgb(34,34,34);font-family:arial,sans-serif">Message-ID:</span><br style="font-size:13px;color:rgb(34,34,34);font-family:arial,sans-serif"><span style="font-size:13px;color:rgb(34,34,34);font-family:arial,sans-serif"> <</span><a href="mailto:60DAC7BD8D63084E8252254DF3F1102009B4206981@MBX36.exg5.exghost.com" target="_blank" style="font-size:13px;color:rgb(17,85,204);font-family:arial,sans-serif">60DAC7BD8D63084E8252254DF3F1102009B4206981@MBX36.exg5.exghost.com</a><span style="font-size:13px;color:rgb(34,34,34);font-family:arial,sans-serif">></span><br style="font-size:13px;color:rgb(34,34,34);font-family:arial,sans-serif">
<span style="font-size:13px;color:rgb(34,34,34);font-family:arial,sans-serif">Content-Type: text/plain; charset="us-ascii"</span><br style="font-size:13px;color:rgb(34,34,34);font-family:arial,sans-serif"><br style="font-size:13px;color:rgb(34,34,34);font-family:arial,sans-serif">
<span style="font-size:13px;color:rgb(34,34,34);font-family:arial,sans-serif">A simple option is to turn on DEBUG logging in your log4j.xml. Setting both mondrian.sql and mondrian.mdx to DEBUG is often useful.</span><br style="font-size:13px;color:rgb(34,34,34);font-family:arial,sans-serif">
<br style="font-size:13px;color:rgb(34,34,34);font-family:arial,sans-serif"><span style="font-size:13px;color:rgb(34,34,34);font-family:arial,sans-serif"> <category name="mondrian.sql"></span><br style="font-size:13px;color:rgb(34,34,34);font-family:arial,sans-serif">
<span style="font-size:13px;color:rgb(34,34,34);font-family:arial,sans-serif"> <priority value="DEBUG"/></span><br style="font-size:13px;color:rgb(34,34,34);font-family:arial,sans-serif"><span style="font-size:13px;color:rgb(34,34,34);font-family:arial,sans-serif"> <appender-ref ref="SQLLOG"/></span><br style="font-size:13px;color:rgb(34,34,34);font-family:arial,sans-serif">
<span style="font-size:13px;color:rgb(34,34,34);font-family:arial,sans-serif"> </category></span><br style="font-size:13px;color:rgb(34,34,34);font-family:arial,sans-serif"><br style="font-size:13px;color:rgb(34,34,34);font-family:arial,sans-serif">
<span style="font-size:13px;color:rgb(34,34,34);font-family:arial,sans-serif"> <category name="mondrian.mdx"></span><br style="font-size:13px;color:rgb(34,34,34);font-family:arial,sans-serif"><span style="font-size:13px;color:rgb(34,34,34);font-family:arial,sans-serif"> <priority value="DEBUG"/></span><br style="font-size:13px;color:rgb(34,34,34);font-family:arial,sans-serif">
<span style="font-size:13px;color:rgb(34,34,34);font-family:arial,sans-serif"> <appender-ref ref="MDXLOG"/></span><br style="font-size:13px;color:rgb(34,34,34);font-family:arial,sans-serif"><span style="font-size:13px;color:rgb(34,34,34);font-family:arial,sans-serif"> </category></span>