<html><head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-text-html" lang="x-unicode">
<br>
We've had an issue for quite awhile where some small set of tests
fail infrequently with the error "Query required more than 12
iterations". I think I now have a general idea of what's going
on, and thought I'd describe what I've seen in case others have
insight.
<br>
<br>
In some tests (e.g. FunctionTest.testLastPeriods()) a cell request
is made for [1998].[Q1]. The cache at this point contains the
following two segments:<br>
<blockquote><small>Axes:[ <br>
{time_by_day.the_year=('1998')}</small><br>
<small> {time_by_day.quarter=(*)}</small><br>
<small>
{time_by_day.month_of_year=('2','3','4','5','6','7')}]</small><br>
<br>
<small>Axes:[</small> <small><br>
{time_by_day.the_year=(*)}</small><br>
<small> {time_by_day.quarter=(*)}</small><br>
<small>
{time_by_day.month_of_year=('1','8','9','10','11','12')}]</small><br>
</blockquote>
<br>
Which get rolled up to <br>
<blockquote><small>Axes:[<br>
{time_by_day.the_year=)}</small><br>
<small> {time_by_day.quarter=(*)}]</small><br>
</blockquote>
<br>
Note that the_year=<blank>, which occurs when the values
list is non-null but empty. Because the_year has an empty values
list, the cell request for [1998].[Q1] cannot be answered, and we
repeat the cycle, again rolling up the same 2 segments.<br>
<br>
I believe the rolled up segment in this case should be constrained
by '1998'. Does that sound right?<br>
<br>
<br>
</div>
</body>
</html>