Skip to main content

Broken Dashboards and panels in a report of Logi Info

Jerry

I had a report that functioned well but crashed recently. The error messages were not helpful.

The main page displayed a dashboard with multiple panels that held data tables, but the dashboard was broken suddenly.

I discovered that when I deleted the dashboard and all panels, and I replaced them with an empty dashboard and an empty panel, the report was still broken and shown me the same error message which is showing below.

Has anyone dealt with the error before? Are there any solutions? Any that are simple and small?  

 

Source code and Error messages 

<?xml version="1.0" encoding="utf-8"?>

<Report ID="Dashboard" SavedBy="user" SavedAt="8/19/2020 10:25:10 AM" EngineVersion="12.7.367-SP7">

  <StyleSheet StyleSheet="newStyleSheet.css" />

  <ReportHeader />

  <Body>

    <Dashboard2 ID="testDash" SaveFile="@Function.AppPhysicalPath~\SavedDashboards\a.Dashboard_Default_.xml">

      <Panel Caption="panel header" ID="pnlTest1">

        <PanelContent>

          <Label Caption="test label" />

        </PanelContent>

      </Panel>

    </Dashboard2>

  </Body>

  <DefaultRequestParams Interval="0" />

  <ReportFooter />

  <ideTestParams />

</Report>

 

Logi Debugger Trace Report

There was an error while processing your request.

The error was:

There was a problem evaluating an expression. The error was: "Error: in expression ".

 

                           

Event

Event Detail

Value

Time

Debug 

Started 

2020/08/19 10:29:26.4 AM 

.000

Server 

 

 

 

 

.013

 

Product Edition 

Logi Info Studio and Server 

 

 

.025

 

Server Engine Version 

12.7.367-SP7 

 

 

.035

 

File Version Number 

12.7.367.188 

 

 

.044

 

.NET CLR Version 

4.0.30319.42000 

 

 

.054

 

Operating System Version 

Microsoft Windows NT 10.0.19041.0 

 

 

.064

 

Process Identity 

IIS APPPOOL\Logi Info .Net v4.0 

 

 

.074

 

Process Mode 

64-bit 

 

 

.085

 

Machine Name 

D-19-BPI1 

 

 

.094

 

IP Addresses 

fe80::5104:8600:6d7c:f5cd%8, 2607:0:3:26:84fb:4710:e27d:cb2, 2607:0:3:26:5104:8600:6d7c:f5cd, 172.30.6.10 

 

 

.104

Browser 

User Agent 

Mozilla/5.0 (Windows NT 6.3; Win64; x64; Trident/7.0; rv:11.0) like Gecko 

 

 

.114

Request Tokens 

 

 

 

 

.126

 

@Request.rdReport~ 

Dashboard 

 

 

.138

 

@Request.lgxPreview~ 

86262 

 

 

.150

Response Builder 

Start 

 

 

 

.160

Requested URL 

 

http://localhost/KPI/rdPage.aspx?rdReport=Dashboard&lgxPreview=86262 

 

 

.170

Application Security 

Enabled 

False 

 

 

.181

Hybrid Data Engine 

MemoryStreamLimit 

10 MB 

 

 

.191

Determine Definition 

 

 

 

 

.201

 

Requested Definition 

Dashboard 

 

 

.211

 

Read Definition from Cache 

False 

 

 

.221

Get DefaultRequestParams 

Start 

 

 

 

.231

 

Interval 

0 

 

 

.241

Get DefaultRequestParams 

Finish 

 

 

 

.251

Report Show Modes 

 

 

 

 

.262

Apply Theme 

Theme Name 

Silver 

 

 

.273

 

Applied Modifier 

Update Count: 1 

 

 

.288

 

 

View Modifier Log 

 

 

.300

 

 

View Modified Definition 

 

 

.315

Apply Theme 

Theme Name 

ProfessionalBlue 

 

 

.329

 

Applied Modifier 

Update Count: 2 

 

 

.341

 

 

View Modifier Log 

 

 

.351

 

 

View Modified Definition 

 

 

.365

Dashboard 

Generate Definition 

 

 

 

.380

Get LocalData 

Start 

localSharedFrom 

 

 

.394

Get DataLayer.DefinitionList 

ID = rdDataLayer_rdSharedFrom 

 

 

 

.406

 

Compute Data Operation Plan 

View Data Operation PlanData Operation Group 1:
- Retrieve data

Data Operation Group 2:
- ReportCenterFilter ID="rdReportCenterFilter"

Data Operation Group 3:
- CompareFilter ID="cmpIsVisual"
- CompareFilter ID="cmpNotCurrentUser"

Data Operation Group 4:
- DeDuplicateFilter

Data Operation Group 5:
- AggregateColumn ID="RowCount"

Data Operation Group 6:
- DataLayerLink ID="dlSharedFrom"
 

 

 

.418

 

Data Operation Group 1 of 6 

View Group Details (1 Items)Details for Data Operation Group 1 of 6

Load data into engine
- Running as a separate Data Operation Group since the next step requires access to the full data file.

 

 

 

.430

 

Definition List Folder 

_Reports 

 

 

.441

 

Processed Row Count 

109 

 

 

.545

 

Processed Data 

View Memory Stream Data (35,862 bytes) 

 

 

.558

 

Data Operation Group 2 of 6 

View Group Details (1 Items)Details for Data Operation Group 2 of 6

Run ReportCenterFilter(ID = rdReportCenterFilter)

 

 

 

.574

 

Rows Affected 

0 rows in output. 

 

 

.584

 

Processed Data 

View Memory Stream Data (10 bytes) 

 

 

.594

 

Data Operation Group 3 of 6 

View Group Details (2 Items)Details for Data Operation Group 3 of 6

Run CompareFilter (ID = cmpIsVisual)
- Filter Criteria: Visualization = 'True'

Run CompareFilter (ID = cmpNotCurrentUser)
- Filter Criteria: BookmarkUserName != ''

 

 

 

.605

 

Processed Row Count 

0 

 

 

.616

 

Processed Data 

View File Stream Data (53 bytes) 

 

 

.626

 

Data Operation Group 4 of 6 

View Group Details (1 Items)Details for Data Operation Group 4 of 6

Run DeDuplicateFilter(ID = DeDuplicateFilter)
- DataColumns: BookmarkUserName

 

 

 

.637

 

 

Sort the data based on BookmarkUserName. 

 

 

.648

 

 

Write sorted file 

 

 

.661

 

 

View Sorted FileStream Data (21 bytes) 

 

 

.677

 

 

Remove duplicate data. 

 

 

.689

 

Processed Row Count 

0 Checked; 0 Removed; 0 Remaining 

 

 

.699

 

Processed Data 

View Memory Stream Data (53 bytes) 

 

 

.709

 

Data Operation Group 5 of 6 

View Group Details (1 Items)Details for Data Operation Group 5 of 6

Run AggregateColumn(ID = RowCount)
- AggregateColumn: BookmarkUserName
- AggregateFunction: Count

 

 

 

.720

 

Processed Row Count 

0 

 

 

.730

 

Processed Data 

View File Stream Data (53 bytes) 

 

 

.740

 

Data Operation Group 6 of 6 

View Group Details (1 Items)Details for Data Operation Group 6 of 6

Run DataLayerLink(ID = dlSharedFrom)

 

 

 

.752

 

Processed Data 

View File Stream Data (53 bytes) 

 

 

.764

 

Finalize DataLayers 

 

 

 

.775

 

Merge Data 

Start 

 

 

.785

 

Merge Data 

Finish 

 

 

.795

 

Data Engine 

Data processing completed. 

 

 

.805

Get LocalData 

Finish 

 

 

 

.817

Dashboard2 Definition 

Generated 

View Definition 

 

 

.829

Apply Theme 

Theme Name 

Silver 

 

 

.846

 

Applied Modifier 

Update Count: 19 

 

 

.858

 

 

View Modifier Log 

 

 

.869

 

 

View Modified Definition 

 

 

.884

Apply Theme 

Theme Name 

ProfessionalBlue 

 

 

.899

 

Applied Modifier 

Update Count: 4 

 

 

.910

 

 

View Modifier Log 

 

 

.920

 

 

View Modified Definition 

 

 

.935

AnalysisFilter 

Generate Definition 

 

 

 

.956

Apply Theme 

Theme Name 

Silver 

 

 

.972

 

Applied Modifier 

Update Count: 54 

 

 

.986

 

 

View Modifier Log 

 

 

.996

 

 

View Modified Definition 

 

 

1.010

Apply Theme 

Theme Name 

ProfessionalBlue 

 

 

1.026

 

Applied Modifier 

Update Count: 10 

 

 

1.038

 

 

View Modifier Log 

 

 

1.048

 

 

View Modified Definition 

 

 

1.064

 

Generated AnalysisFilter 

View Definition 

 

 

1.086
       

                      

* Generating this debugger information increases the overall elapsed time.

 

 

Detailed Error Report

There was an error while processing your request.

Message:
There was a problem evaluating an expression.  The error was: "Error:  in expression ".

Source:
rdServer

Stack Trace:
   at rdServer.rdScriptEvaluator.Eval(String sExpression, String sErrorResult, Int32 iValueCountPassed)
   at rdServer.PageBuilder.k(XmlElement A_0)
   at rdServer.PageBuilder.ax(XmlElement& A_0)
   at rdServer.PageBuilder.bf(XmlElement& A_0)
   at rdServer.PageBuilder.ak(XmlElement A_0)
   at rdServer.PageBuilder.ax(XmlElement& A_0)
   at rdServer.PageBuilder.bf(XmlElement& A_0)
   at rdServer.PageBuilder.ak(XmlElement A_0)
   at rdServer.PageBuilder.q(XmlElement& A_0)
   at rdServer.PageBuilder.bf(XmlElement& A_0)
   at rdServer.PageBuilder.ak(XmlElement A_0)
   at rdServer.PageBuilder.s(XmlElement& A_0)
   at rdServer.PageBuilder.bf(XmlElement& A_0)
   at rdServer.PageBuilder.ak(XmlElement A_0)
   at rdServer.PageBuilder.r(XmlElement& A_0)
   at rdServer.PageBuilder.bf(XmlElement& A_0)
   at rdServer.PageBuilder.ak(XmlElement A_0)
   at rdServer.PageBuilder.q(XmlElement& A_0)
   at rdServer.PageBuilder.bf(XmlElement& A_0)
   at rdServer.PageBuilder.ak(XmlElement A_0)
   at rdServer.PageBuilder.s(XmlElement& A_0)
   at rdServer.PageBuilder.bf(XmlElement& A_0)
   at rdServer.PageBuilder.ak(XmlElement A_0)
   at rdServer.PageBuilder.r(XmlElement& A_0)
   at rdServer.PageBuilder.bf(XmlElement& A_0)
   at rdServer.PageBuilder.ak(XmlElement A_0)
   at rdServer.PageBuilder.q(XmlElement& A_0)
   at rdServer.PageBuilder.bf(XmlElement& A_0)
   at rdServer.PageBuilder.ak(XmlElement A_0)
   at rdServer.PageBuilder.s(XmlElement& A_0)
   at rdServer.PageBuilder.bf(XmlElement& A_0)
   at rdServer.PageBuilder.ak(XmlElement A_0)
   at rdServer.PageBuilder.r(XmlElement& A_0)
   at rdServer.PageBuilder.bf(XmlElement& A_0)
   at rdServer.PageBuilder.ak(XmlElement A_0)
   at rdServer.PageBuilder.ax(XmlElement& A_0)
   at rdServer.PageBuilder.bf(XmlElement& A_0)
   at rdServer.PageBuilder.ak(XmlElement A_0)
   at rdServer.PageBuilder.q(XmlElement& A_0)
   at rdServer.PageBuilder.bf(XmlElement& A_0)
   at rdServer.PageBuilder.ak(XmlElement A_0)
   at rdServer.PageBuilder.s(XmlElement& A_0)
   at rdServer.PageBuilder.bf(XmlElement& A_0)
   at rdServer.PageBuilder.ak(XmlElement A_0)
   at rdServer.PageBuilder.r(XmlElement& A_0)
   at rdServer.PageBuilder.bf(XmlElement& A_0)
   at rdServer.PageBuilder.ah(XmlElement& A_0, String A_1)
   at rdServer.PageBuilder.bf(XmlElement& A_0)
   at rdServer.PageBuilder.ak(XmlElement A_0)
   at rdServer.PageBuilder.ax(XmlElement& A_0)
   at rdServer.PageBuilder.bf(XmlElement& A_0)
   at rdServer.rdDashboard.a(XmlElement& A_0, XmlElement A_1)
   at rdServer.PageBuilder.bf(XmlElement& A_0)
   at rdServer.PageBuilder.ak(XmlElement A_0)
   at rdServer.PageBuilder.az(XmlElement& A_0)
   at rdServer.PageBuilder.bf(XmlElement& A_0)
   at rdServer.PageBuilder.ak(XmlElement A_0)
   at rdServer.PageBuilder.a6(XmlElement& A_0)
   at rdServer.PageBuilder.bf(XmlElement& A_0)
   at rdServer.PageBuilder.BuildHtml(String RequestedPage)
   at rdServer.ResponseBuilder.BuildResponse()

 

Inner error:

Message:
Error:  in expression

Source:
Microsoft.VisualBasic

Stack Trace:
Error:  in expression 
   at Microsoft.VisualBasic.CompilerServices.Symbols.Container.InvokeMethod(Method TargetProcedure, Object[] Arguments, Boolean[] CopyBack, BindingFlags Flags)
   at Microsoft.VisualBasic.CompilerServices.NewLateBinding.ObjectLateGet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack)
   at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateGet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack)
   at rdServer.rdScriptEvaluator.Eval(String sExpression, String sErrorResult, Int32 iValueCountPassed)
0

Comments

3 comments

Date Votes
  • Official comment
    Natan Cohen

    Hi Jerry,

    Thanks for posting the full debug page.  The error appears to be in our script evaluator module, and I find that these errors can occur if the script is either invalid or one operand is missing.  For example, if the evaluator tried to execute " > 5", it would throw a server error because the left operand is missing.  One trick to minimize these errors, is to always use double quotes if the operands are strings.  The empty string is never equivalent to null.  This won't work for numeric values with operators like ">" and "<", though.

    To find out which script is causing this error, please load only one panel in your dashboard and try to reproduce the error.  Then look at all the scripts you've declared in your attributes and try to find the script where one or more operands could be null.  Let me know what you find.

    Thanks,
    Natan
    Logi Support

  • Jerry

    Hi Natan,

    Thanks for the reply.

    However, I don't think the scripts are the main problem.

    I just tried on another application thinking perhaps there was a library problem, but the same thing happened! It errors as soon as you add a panel to a dashboard.

    <?xml version="1.0" encoding="utf-8"?>
    <Report ID="Menu.test" SavedBy="user" SavedAt="8/21/2020" EngineVersion="12.7.100-SP1">
      <Body>
        <Dashboard2 ID="Dashboard1" SaveFile="@Function.AppPhysicalPath~\SavedDashboards\testDashboard.xml" DashboardColumns="3" DashboardTabs="True">
          <Panel ID="pnl1" Caption="Panel 1">
            <PanelContent>
              <Label Caption="test" />
            </PanelContent>
          </Panel>
        </Dashboard2>
      </Body>
      <ideTestParams />
    </Report>
    0
  • Natan Cohen

    Hi Jerry,

    Can you test with a vanilla (blank) Report definition?  First see if you can run the definition with a Dashboard element and no panels.  Then test with a simple panel that outputs a label, like you have above.  If it throws the same error, then please attach the full debug trace.  The fact that you claim that this error is thrown on an entirely separate Logi app may indicate that there is perhaps a masked write permissions error on the dashboard save file location, or perhaps an issue with a .Net dependency library in the GAC.  

    Thanks,
    Natan
    Logi Support

    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post