Dashboard Stopped Working

Yahoo Archive
1
Good thing to know.

Thanks, Brenda.

Joe

On Thu, May 14, 2015 at 12:48 PM, brenda mohr brenda@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p>

With the help of Sergio P and his awesome helpers, we just fixed and deployed this dashboard without error. It seems filters on both the query and the grid don’t play well together. So we removed the grid filters and now all is well. And it’s actually faster! Why it stopped working out of the blue is still a mystery.

Â

Â

Brenda

Â

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, May 14, 2015 11:49 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Dashboard Stopped Working

Â

Â

So there could be a couple of solutions to this....I have found E10 to be a bit sensitive around bit fields (i.e. checkboxes).

Â

The first thing to try is to make the criteria OrderDtl_OpenLine = true



If that doesn't solve it then you could try OrderDtl_OpenLine = 1



Let me know how you get on

 

</div>
 


<div style="color:#fff;min-height:0;"></div>

2

Yep, out of the blue, my dashboard started throwing the error below.  Any ideas?

 

1.        This was a working dashboard heavily used since E9 – Over a year now in E10.  (E10.0.700.2)

2.       No I didn’t change it.

3.       Yes it works in test

4.       Yes, I re-imported it (and the BAQs) and it does not work in live

5.       Yes it works for Epicor support

6.       Yes I recreated it from scratch

7.       No it still doesn’t work.

8.       No the network guys didn’t change anything

9.       No they didn’t do anything in live they didn’t do in test first

 

What I read is that one of my filters (the one below I think) is not happy in LIVE.  I have re-written this filter 8,352 different ways, (OK maybe just 10ish) but still the same error.   I’m thinking something internal changed, but as this is not my forte, I am not sure which rabbit trail to follow.

 

OrderDtl_OpenLine = TRUE

 

Application Error

10.     

11.     

12.    Error Detail

13.    ============

14.    Message: DB_JRES_OrderDtl-Order Detail: View Filter exception.   View Filter not applied.  A DataColumn has been dropped from BAQ results table.

15.    Inner Exception Message: Cannot perform '=' operation on System.Boolean and System.String.

16.    Program:

17.    Method:

18.     

19.     

20.    Inner Exception

21.    ===============

22.    Cannot perform '=' operation on System.Boolean and System.String.

23.     

24.    Inner Stack Trace

25.    =================

26.       at System.Data.BinaryNode.BinaryCompare(Object vLeft, Object vRight, StorageType resultType, Int32 op, CompareInfo comparer)

27.       at System.Data.BinaryNode.EvalBinaryOp(Int32 op, ExpressionNode left, ExpressionNode right, DataRow row, DataRowVersion version, Int32[] recordNos)

28.       at System.Data.BinaryNode.Eval(DataRow row, DataRowVersion version)

29.       at System.Data.BinaryNode.Eval(ExpressionNode expr, DataRow row, DataRowVersion version, Int32[] recordNos)

30.       at System.Data.BinaryNode.EvalBinaryOp(Int32 op, ExpressionNode left, ExpressionNode right, DataRow row, DataRowVersion version, Int32[] recordNos)

31.       at System.Data.BinaryNode.Eval(DataRow row, DataRowVersion version)

32.       at System.Data.BinaryNode.Eval(ExpressionNode expr, DataRow row, DataRowVersion version, Int32[] recordNos)

33.       at System.Data.BinaryNode.EvalBinaryOp(Int32 op, ExpressionNode left, ExpressionNode right, DataRow row, DataRowVersion version, Int32[] recordNos)

34.       at System.Data.BinaryNode.Eval(DataRow row, DataRowVersion version)

35.       at System.Data.DataExpression.Invoke(DataRow row, DataRowVersion version)

36.       at System.Data.Index.AcceptRecord(Int32 record, IFilter filter)

37.       at System.Data.Index.InitRecords(IFilter filter)

38.       at System.Data.Index..ctor(DataTable table, IndexField[] indexFields, Comparison`1 comparison, DataViewRowState recordStates, IFilter rowFilter)

39.       at System.Data.DataTable.GetIndex(IndexField[] indexDesc, DataViewRowState recordStates, IFilter rowFilter)

40.       at System.Data.DataView.UpdateIndex(Boolean force, Boolean fireEvent)

41.       at System.Data.DataView.UpdateIndex(Boolean force)

42.       at System.Data.DataView.SetIndex2(String newSort, DataViewRowState newRowStates, IFilter newRowFilter, Boolean fireEvent)

43.       at System.Data.DataView.SetIndex(String newSort, DataViewRowState newRowStates, IFilter newRowFilter)

44.       at System.Data.DataView.set_RowFilter(String value)

45.      at Ice.UI.Dashboard.DashboardView.ApplyViewFilter(IPublisher pub, PublishEventArgs args)

 

 

Brenda

 

3
So there could be a couple of solutions to this....I have found E10 to be a bit sensitive around bit fields (i.e. checkboxes).

The first thing to try is to make the criteria OrderDtl_OpenLine = true

If that doesn't solve it then you could try OrderDtl_OpenLine = 1

Let me know how you get on
 
4

With the help of Sergio P and his awesome helpers, we just fixed and deployed this dashboard without error.  It seems filters on both the query and the grid don’t play well together.  So we removed the grid filters and now all is well.  And it’s actually faster! Why it stopped working out of the blue is still a mystery.

 

 

Brenda

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, May 14, 2015 11:49 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Dashboard Stopped Working

 

 

So there could be a couple of solutions to this....I have found E10 to be a bit sensitive around bit fields (i.e. checkboxes).

 

The first thing to try is to make the criteria OrderDtl_OpenLine = true



If that doesn't solve it then you could try OrderDtl_OpenLine = 1



Let me know how you get on

 

5
Thanks a lot Brenda I am glad everything is working now for you. 
 
Kind Regards,
Sergio P. 
CTO, Sr. Partner

Mayan Technologies USA, Inc.
(858) 900.1555
sprieto@...




On Thursday, May 14, 2015 12:48 PM, "brenda mohr brenda@... [vantage]" <vantage@yahoogroups.com> wrote:


  
<div id="ygrps-yiv-1444138506yiv3329736621ygrp-text">
  
  
  <div>
With the help of Sergio P and his awesome helpers, we just fixed and deployed this dashboard without error.  It seems filters on both the query and the grid don’t play well together.  So we removed the grid filters and now all is well.  And it’s actually faster! Why it stopped working out of the blue is still a mystery.
 
 
Brenda
 
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, May 14, 2015 11:49 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Dashboard Stopped Working
 
 
So there could be a couple of solutions to this....I have found E10 to be a bit sensitive around bit fields (i.e. checkboxes).
 
The first thing to try is to make the criteria OrderDtl_OpenLine = true


If that doesn't solve it then you could try OrderDtl_OpenLine = 1


Let me know how you get on
 
</div>
 


<div class="ygrps-yiv-1444138506yiv3329736621yqt6776445724" id="ygrps-yiv-1444138506yiv3329736621yqt21662"><div style="color:#fff;height:0;"></div></div>
#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 #ygrps-yiv-1444138506yiv3329736621 -- #ygrps-yiv-1444138506yiv3329736621ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 #ygrps-yiv-1444138506yiv3329736621ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 #ygrps-yiv-1444138506yiv3329736621ygrp-mkp #ygrps-yiv-1444138506yiv3329736621hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 #ygrps-yiv-1444138506yiv3329736621ygrp-mkp #ygrps-yiv-1444138506yiv3329736621ads {
margin-bottom:10px;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 #ygrps-yiv-1444138506yiv3329736621ygrp-mkp .ygrps-yiv-1444138506yiv3329736621ad {
padding:0 0;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 #ygrps-yiv-1444138506yiv3329736621ygrp-mkp .ygrps-yiv-1444138506yiv3329736621ad p {
margin:0;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 #ygrps-yiv-1444138506yiv3329736621ygrp-mkp .ygrps-yiv-1444138506yiv3329736621ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 #ygrps-yiv-1444138506yiv3329736621ygrp-sponsor #ygrps-yiv-1444138506yiv3329736621ygrp-lc {
font-family:Arial;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 #ygrps-yiv-1444138506yiv3329736621ygrp-sponsor #ygrps-yiv-1444138506yiv3329736621ygrp-lc #ygrps-yiv-1444138506yiv3329736621hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 #ygrps-yiv-1444138506yiv3329736621ygrp-sponsor #ygrps-yiv-1444138506yiv3329736621ygrp-lc .ygrps-yiv-1444138506yiv3329736621ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 #ygrps-yiv-1444138506yiv3329736621actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 #ygrps-yiv-1444138506yiv3329736621activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 #ygrps-yiv-1444138506yiv3329736621activity span {
font-weight:700;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 #ygrps-yiv-1444138506yiv3329736621activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 #ygrps-yiv-1444138506yiv3329736621activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 #ygrps-yiv-1444138506yiv3329736621activity span span {
color:#ff7900;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 #ygrps-yiv-1444138506yiv3329736621activity span .ygrps-yiv-1444138506yiv3329736621underline {
text-decoration:underline;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 .ygrps-yiv-1444138506yiv3329736621attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 .ygrps-yiv-1444138506yiv3329736621attach div a {
text-decoration:none;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 .ygrps-yiv-1444138506yiv3329736621attach img {
border:none;padding-right:5px;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 .ygrps-yiv-1444138506yiv3329736621attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 .ygrps-yiv-1444138506yiv3329736621attach label a {
text-decoration:none;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 .ygrps-yiv-1444138506yiv3329736621bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 .ygrps-yiv-1444138506yiv3329736621bold a {
text-decoration:none;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 dd.ygrps-yiv-1444138506yiv3329736621last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 dd.ygrps-yiv-1444138506yiv3329736621last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 dd.ygrps-yiv-1444138506yiv3329736621last p span.ygrps-yiv-1444138506yiv3329736621yshortcuts {
margin-right:0;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 div.ygrps-yiv-1444138506yiv3329736621attach-table div div a {
text-decoration:none;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 div.ygrps-yiv-1444138506yiv3329736621attach-table {
width:400px;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 div.ygrps-yiv-1444138506yiv3329736621file-title a, #ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 div.ygrps-yiv-1444138506yiv3329736621file-title a:active, #ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 div.ygrps-yiv-1444138506yiv3329736621file-title a:hover, #ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 div.ygrps-yiv-1444138506yiv3329736621file-title a:visited {
text-decoration:none;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 div.ygrps-yiv-1444138506yiv3329736621photo-title a, #ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 div.ygrps-yiv-1444138506yiv3329736621photo-title a:active, #ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 div.ygrps-yiv-1444138506yiv3329736621photo-title a:hover, #ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 div.ygrps-yiv-1444138506yiv3329736621photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 div#ygrps-yiv-1444138506yiv3329736621ygrp-mlmsg #ygrps-yiv-1444138506yiv3329736621ygrp-msg p a span.ygrps-yiv-1444138506yiv3329736621yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 .ygrps-yiv-1444138506yiv3329736621green {
color:#628c2a;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 .ygrps-yiv-1444138506yiv3329736621MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 o {
font-size:0;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 #ygrps-yiv-1444138506yiv3329736621photos div {
float:left;width:72px;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 #ygrps-yiv-1444138506yiv3329736621photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 #ygrps-yiv-1444138506yiv3329736621photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 #ygrps-yiv-1444138506yiv3329736621reco-category {
font-size:77%;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 #ygrps-yiv-1444138506yiv3329736621reco-desc {
font-size:77%;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 .ygrps-yiv-1444138506yiv3329736621replbq {
margin:4px;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 #ygrps-yiv-1444138506yiv3329736621ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 #ygrps-yiv-1444138506yiv3329736621ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 #ygrps-yiv-1444138506yiv3329736621ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 #ygrps-yiv-1444138506yiv3329736621ygrp-mlmsg select, #ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 input, #ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 #ygrps-yiv-1444138506yiv3329736621ygrp-mlmsg pre, #ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 code {
font:115% monospace;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 #ygrps-yiv-1444138506yiv3329736621ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 #ygrps-yiv-1444138506yiv3329736621ygrp-mlmsg #ygrps-yiv-1444138506yiv3329736621logo {
padding-bottom:10px;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 #ygrps-yiv-1444138506yiv3329736621ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 #ygrps-yiv-1444138506yiv3329736621ygrp-msg p#ygrps-yiv-1444138506yiv3329736621attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 #ygrps-yiv-1444138506yiv3329736621ygrp-reco #ygrps-yiv-1444138506yiv3329736621reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 #ygrps-yiv-1444138506yiv3329736621ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 #ygrps-yiv-1444138506yiv3329736621ygrp-sponsor #ygrps-yiv-1444138506yiv3329736621ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 #ygrps-yiv-1444138506yiv3329736621ygrp-sponsor #ygrps-yiv-1444138506yiv3329736621ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 #ygrps-yiv-1444138506yiv3329736621ygrp-sponsor #ygrps-yiv-1444138506yiv3329736621ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 #ygrps-yiv-1444138506yiv3329736621ygrp-text {
font-family:Georgia;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 #ygrps-yiv-1444138506yiv3329736621ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 #ygrps-yiv-1444138506yiv3329736621ygrp-text tt {
font-size:120%;}

#ygrps-yiv-1444138506 #ygrps-yiv-1444138506yiv3329736621 #ygrps-yiv-1444138506yiv3329736621ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-1444138506