# Dasboard BAQ server Cache?

**URL:** <https://www.epiusers.help/t/dasboard-baq-server-cache/54267>\
**Category:** Epicor ERP 10\
**Tags:** baq, dashboard, e10\
**Created:** [April 3, 2019, 3:35pm UTC](https://www.epiusers.help/t/dasboard-baq-server-cache/54267 "2019-04-03T15:35:38Z")\
**Posts on this page:** 13\
**Page:** 1

<div class="post-metadata">

**Author:** ![knash](https://www.epiusers.help/user_avatar/www.epiusers.help/knash/32/74179_2.png) [@knash](https://www.epiusers.help/u/knash)\
**Post date:** [April 3, 2019, 3:35pm UTC](https://www.epiusers.help/t/dasboard-baq-server-cache/54267/1 "2019-04-03T15:35:38Z")

</div>

What would cause the return object in a Dashboard to return an incomplete object?

We have a BAQ that works in the BAQ editor.

It sometimes works in dashboard.

Here is what I mean.

I ran this in the dashboard yesterday and got 9 records returned.

 ![pic2](https://epiusers.help/uploads/default/original/2X/3/32ffb129344c344781ec328538dca92a4f61bb2f.png)

I ran this in the BAQ editor and all records were returned.  
 ![Capture2](https://epiusers.help/uploads/default/original/2X/9/9c06975c92dba0ab105291e518d3327e8b72ccbb.jpeg)

I ran this in the dashboard today and got all expected records.

 ![Capture](https://epiusers.help/uploads/default/original/2X/6/60278ef44c5aeb909df98a8d1fa72745381e040a.jpeg)

Seems like something on the server side is causing the return object to be cut off and something that happens over night “fixes” the issue.

Anyone seen this? Any ideas on how to fix this with out having to wait for the issue to clear itself on it own.

Thanks,

---

<div class="post-metadata">

**Author:** ![ckrusen](https://www.epiusers.help/user_avatar/www.epiusers.help/ckrusen/32/50584_2.png) [@ckrusen](https://www.epiusers.help/u/ckrusen)\
**Post date:** [April 3, 2019, 6:07pm UTC](https://www.epiusers.help/t/dasboard-baq-server-cache/54267/2 "2019-04-03T18:07:36Z")

</div>

That’s an awful lot of criteria fields above the `One Level BOM` grid. You sure that there are no filters or other restrictions on the dashboard?

Does running a trace enable you to see the actual request the dashboard makes?

---

<div class="post-metadata">

**Author:** ![knash](https://www.epiusers.help/user_avatar/www.epiusers.help/knash/32/74179_2.png) [@knash](https://www.epiusers.help/u/knash)\
**Post date:** [April 3, 2019, 6:16pm UTC](https://www.epiusers.help/t/dasboard-baq-server-cache/54267/3 "2019-04-03T18:16:07Z")

</div>

Those aren’t criteria fields.

The only parameters are part and rev.

The request is the BAQ, with results, unless there is something I am missing.

---

<div class="post-metadata">

**Author:** ![Banderson](https://www.epiusers.help/user_avatar/www.epiusers.help/banderson/32/50875_2.png) [@Banderson](https://www.epiusers.help/u/Banderson)\
**Post date:** [April 3, 2019, 6:17pm UTC](https://www.epiusers.help/t/dasboard-baq-server-cache/54267/4 "2019-04-03T18:17:52Z")

</div>

Do you have any calculated fields that might change based on date? divide by 0 can do funky things.

**edit** never mind, that would affect the BAQ too.

---

<div class="post-metadata">

**Author:** ![ckrusen](https://www.epiusers.help/user_avatar/www.epiusers.help/ckrusen/32/50584_2.png) [@ckrusen](https://www.epiusers.help/u/ckrusen)\
**Post date:** [April 3, 2019, 6:21pm UTC](https://www.epiusers.help/t/dasboard-baq-server-cache/54267/5 "2019-04-03T18:21:17Z")

</div>

I assume you have Parameters in the BAQ? How else would it limit the results to the 66 you expected.

And since “overnight” tends to fix it, is there any date time fields used for filtering, and a time zone difference matters sometimes, but not others?

17:00 PST is 21:00 EST - both with the same date. But both are 01:00 UTC, and the next day.

While the next morning, 8:00 PST is 12:00 EDT and 16:00 UTC - All have the same date.

---

<div class="post-metadata">

**Author:** ![knash](https://www.epiusers.help/user_avatar/www.epiusers.help/knash/32/74179_2.png) [@knash](https://www.epiusers.help/u/knash)\
**Post date:** [April 3, 2019, 6:33pm UTC](https://www.epiusers.help/t/dasboard-baq-server-cache/54267/6 "2019-04-03T18:33:38Z")

</div>

no date filter. good idea.

Crazy thing is that the BAQ worked, but the dashboard didn’t. Debugging in visual studio showed the results off the wire were incomplete.

I was wondering if there was something in IIS that was causing the result set to be different when called via a Dashboard vs the BAQ Editor.

That might help me find where the issue is.

---

<div class="post-metadata">

**Author:** ![ckrusen](https://www.epiusers.help/user_avatar/www.epiusers.help/ckrusen/32/50584_2.png) [@ckrusen](https://www.epiusers.help/u/ckrusen)\
**Post date:** [April 3, 2019, 6:38pm UTC](https://www.epiusers.help/t/dasboard-baq-server-cache/54267/7 "2019-04-03T18:38:11Z")

</div>

Is it a deployed dashboard? If so, maybe try re-deploying it.

Also, try the gold old clear client cache.

One last thing, I had deployed a dashboard once, and it created a new file with a suffix after the name. Something like `Ice.UI.App.CK_ShippingSchedule_1.dll` when it should have been  
`Ice.UI.App.CK_ShippingSchedule.dll`

So obviously the dashboard wasn’t actually running the updated version.

---

<div class="post-metadata">

**Author:** ![knash](https://www.epiusers.help/user_avatar/www.epiusers.help/knash/32/74179_2.png) [@knash](https://www.epiusers.help/u/knash)\
**Post date:** [April 3, 2019, 6:47pm UTC](https://www.epiusers.help/t/dasboard-baq-server-cache/54267/8 "2019-04-03T18:47:28Z")

</div>

All good points. I should have wrote this earlier.

Steps I took Yesterday Afternoon:  
All the time I was using VS to debug and watch the results coming from the adapter call.

Opened the customization and resaved it.  
Tried and it didn’t work (bad results)

Cleared Client Cache  
Tried and it didn’t work (bad results)

Changed the dynamic code to use a different named adapter.  
Tried and it didn’t work (bad results)

Tried on a different machine as a different user  
Tried and it didn’t work (bad results)

Changed the BAQ (added a column) and saved it  
Tried and it didn’t work (bad results)

Cleared Client Cache  
Tried and it didn’t work (bad results)

Hit my head against screen and said I will deal with this tomorrow.

Came in today  
Got my Diet Dew.  
Opened the form and everything worked.

---

<div class="post-metadata">

**Author:** ![Banderson](https://www.epiusers.help/user_avatar/www.epiusers.help/banderson/32/50875_2.png) [@Banderson](https://www.epiusers.help/u/Banderson)\
**Post date:** [April 3, 2019, 6:48pm UTC](https://www.epiusers.help/t/dasboard-baq-server-cache/54267/9 "2019-04-03T18:48:11Z")

</div>

It was totally the dew

---

<div class="post-metadata">

**Author:** ![ckrusen](https://www.epiusers.help/user_avatar/www.epiusers.help/ckrusen/32/50584_2.png) [@ckrusen](https://www.epiusers.help/u/ckrusen)\
**Post date:** [April 3, 2019, 6:50pm UTC](https://www.epiusers.help/t/dasboard-baq-server-cache/54267/10 "2019-04-03T18:50:48Z")

</div>

`*` **diet** dew

---

<div class="post-metadata">

**Author:** ![knash](https://www.epiusers.help/user_avatar/www.epiusers.help/knash/32/74179_2.png) [@knash](https://www.epiusers.help/u/knash)\
**Post date:** [April 3, 2019, 6:52pm UTC](https://www.epiusers.help/t/dasboard-baq-server-cache/54267/11 "2019-04-03T18:52:44Z")

</div>

Here is the btnClick Code

```
private void btnOneLevel_Click(object sender, System.EventArgs args)
{
	// **Place Event Handling Code Here**
			
	spNotifyUsers.Status = ( Ice.Lib.Framework.StatusTypes )3;
	spNotifyUsers.EnabledCaption = "Retrieving FIRST Level of the BOM";
	spNotifyUsers.Refresh( );

		
	DynamicQueryAdapter dqaBOMShort = new DynamicQueryAdapter(oTrans);
	dqaBOMShort.BOConnect();

	QueryExecutionDataSet qedsBOMShort = new QueryExecutionDataSet();

	qedsBOMShort.ExecutionParameter.Clear();
	qedsBOMShort.ExecutionParameter.AddExecutionParameterRow("ParentPartNum",txtPartNum.Text,"nvarchar", false, Guid.NewGuid(),"A");
	qedsBOMShort.ExecutionParameter.AddExecutionParameterRow("ParentPartRev",cboRevisions.Text,"nvarchar",false, Guid.NewGuid(),"A");
	
	dqaBOMShort.ExecuteByID("ETK-BOMShort", qedsBOMShort);
	DataTable results = dqaBOMShort.QueryResults.Tables["Results"];
	
	grdBOMShort.DataSource = results;

	grdBOMShort.DisplayLayout.Bands[0].Columns["PartMtl_MtlSeq"].SortIndicator = Infragistics.Win.UltraWinGrid.SortIndicator.Ascending;

	spNotifyUsers.Status = ( Ice.Lib.Framework.StatusTypes )0;
	spNotifyUsers.EnabledCaption = "";
	spNotifyUsers.Refresh( );

}
```

---

<div class="post-metadata">

**Author:** ![knash](https://www.epiusers.help/user_avatar/www.epiusers.help/knash/32/74179_2.png) [@knash](https://www.epiusers.help/u/knash)\
**Post date:** [April 3, 2019, 7:06pm UTC](https://www.epiusers.help/t/dasboard-baq-server-cache/54267/12 "2019-04-03T19:06:28Z")

</div>

crazy thing is I know which places have dew in Vegas. I have my morning walks already planned, as not every hotel is Pepsi friendly.

---

<div class="post-metadata">

**Author:** ![Banderson](https://www.epiusers.help/user_avatar/www.epiusers.help/banderson/32/50875_2.png) [@Banderson](https://www.epiusers.help/u/Banderson)\
**Post date:** [April 3, 2019, 7:18pm UTC](https://www.epiusers.help/t/dasboard-baq-server-cache/54267/13 "2019-04-03T19:18:34Z")

</div>

A little off subject, why don’t you just use the stock grid that comes in with a dashboard? Do you have to parameterize this query?