[OPT-5247] Reports to view raw data visualized as a table generate errors when accessing the result page for more than 10000 records - camunda JIRA

Type: Bug Report
Resolution: Unresolved
Priority: L3 - Default
Fix Version/s: None
Affects Version/s: None
Component/s: backend
Labels:

PM Priority:
2
Effort:
M
Epic Link:
None

What are the steps to reproduce your problem?

Create > 10K BPMN and DMN instances in Camunda Platform.
After import is complete build Process and Decision reports on the BPMN and DMN.
Configure the reports:
1. View: Raw Data.
2. Visualization: Table.

What is the problem?

In the report builder, try to go to any page for result index > 10000, the screen shows the error:

An application error occured.
Refresh your browser or close it and sign in again.

Cannot read property 'name' of null

The browser's developer tools show the response error:

{
  "errorCode" : "elasticsearchError",
  "errorMessage" : "Elasticsearch encountered an error. If this issue persists, please contact your administrator.",
  "detailedMessage" : "Elasticsearch exception [type=search_phase_execution_exception, reason=all shards failed]",
  "reportDefinition" : null
}

After the report is created and saved, run the report then try to go to any page for result index > 10000, the screen shows the error:

This link is not valid.
Go to Home…

The browser's developer tools show the same response error code as above.
What would be the expected behavior:
Report builder and report view should work for process and decision reports to view raw data visualized as a table for result index > 10000.

This is the controller panel for Smart Panels app

Daniel Ewing created issue - 21/May/21 5:01 PM

Daniel Ewing made changes - 21/May/21 5:03 PM

Description

Original: What are the steps to reproduce your problem?
# Create > 10K BPMN and DMN instances in Camunda Platform.
# After import is complete build Process and Decision reports on the BPMN and DMN.
# Configure the reports:
## View: Raw Data.
## Visualization: Table.

What is the problem?
In the report builder, try to go to any page for result index < 10000, the screen shows the error:
{code:java}An application error occured.
Refresh your browser or close it and sign in again.

Cannot read property 'name' of null{code}
The browser's developer tools show the response error:
{code:java}{
  "errorCode" : "elasticsearchError",
  "errorMessage" : "Elasticsearch encountered an error. If this issue persists, please contact your administrator.",
  "detailedMessage" : "Elasticsearch exception [type=search_phase_execution_exception, reason=all shards failed]",
  "reportDefinition" : null
}{code}
After the report is created and saved, run the report then try to go to any page for result index < 10000, the screen shows the error:
{code:java}This link is not valid.
Go to Home…{code}
The browser's developer tools show the same response error code as above.
What would be the expected behavior:
Report builder and report view should work for process and decision reports to view raw data visualized as a table for result index > 10000.

Hints (optional):

New: h4, What are the steps to reproduce your problem?
# Create > 10K BPMN and DMN instances in Camunda Platform.
# After import is complete build Process and Decision reports on the BPMN and DMN.
# Configure the reports:
## View: Raw Data.
## Visualization: Table.

h4. What is the problem?
In the report builder, try to go to any page for result index < 10000, the screen shows the error:
{code:java}An application error occured.
Refresh your browser or close it and sign in again.

Cannot read property 'name' of null{code}
The browser's developer tools show the response error:
{code:java}{
  "errorCode" : "elasticsearchError",
  "errorMessage" : "Elasticsearch encountered an error. If this issue persists, please contact your administrator.",
  "detailedMessage" : "Elasticsearch exception [type=search_phase_execution_exception, reason=all shards failed]",
  "reportDefinition" : null
}{code}
After the report is created and saved, run the report then try to go to any page for result index < 10000, the screen shows the error:
{code:java}This link is not valid.
Go to Home…{code}
The browser's developer tools show the same response error code as above.
What would be the expected behavior:
Report builder and report view should work for process and decision reports to view raw data visualized as a table for result index > 10000.

Daniel Ewing made changes - 21/May/21 5:03 PM

Mentioned Roles

Daniel Ewing made changes - 21/May/21 5:03 PM

Mentioned Groups

Daniel Ewing made changes - 21/May/21 5:03 PM

Description

Original: h4, What are the steps to reproduce your problem?
# Create > 10K BPMN and DMN instances in Camunda Platform.
# After import is complete build Process and Decision reports on the BPMN and DMN.
# Configure the reports:
## View: Raw Data.
## Visualization: Table.

h4. What is the problem?
In the report builder, try to go to any page for result index < 10000, the screen shows the error:
{code:java}An application error occured.
Refresh your browser or close it and sign in again.

Cannot read property 'name' of null{code}
The browser's developer tools show the response error:
{code:java}{
  "errorCode" : "elasticsearchError",
  "errorMessage" : "Elasticsearch encountered an error. If this issue persists, please contact your administrator.",
  "detailedMessage" : "Elasticsearch exception [type=search_phase_execution_exception, reason=all shards failed]",
  "reportDefinition" : null
}{code}
After the report is created and saved, run the report then try to go to any page for result index < 10000, the screen shows the error:
{code:java}This link is not valid.
Go to Home…{code}
The browser's developer tools show the same response error code as above.
What would be the expected behavior:
Report builder and report view should work for process and decision reports to view raw data visualized as a table for result index > 10000.

New: h4. What are the steps to reproduce your problem?
# Create > 10K BPMN and DMN instances in Camunda Platform.
# After import is complete build Process and Decision reports on the BPMN and DMN.
# Configure the reports:
## View: Raw Data.
## Visualization: Table.

h4. What is the problem?
In the report builder, try to go to any page for result index < 10000, the screen shows the error:
{code:java}An application error occured.
Refresh your browser or close it and sign in again.

Cannot read property 'name' of null{code}
The browser's developer tools show the response error:
{code:java}{
  "errorCode" : "elasticsearchError",
  "errorMessage" : "Elasticsearch encountered an error. If this issue persists, please contact your administrator.",
  "detailedMessage" : "Elasticsearch exception [type=search_phase_execution_exception, reason=all shards failed]",
  "reportDefinition" : null
}{code}
After the report is created and saved, run the report then try to go to any page for result index < 10000, the screen shows the error:
{code:java}This link is not valid.
Go to Home…{code}
The browser's developer tools show the same response error code as above.
What would be the expected behavior:
Report builder and report view should work for process and decision reports to view raw data visualized as a table for result index > 10000.

Daniel Ewing made changes - 21/May/21 5:03 PM

Mentioned Roles

Daniel Ewing made changes - 21/May/21 5:03 PM

Mentioned Groups

Daniel Ewing made changes - 21/May/21 5:04 PM

Description

Original: h4. What are the steps to reproduce your problem?
# Create > 10K BPMN and DMN instances in Camunda Platform.
# After import is complete build Process and Decision reports on the BPMN and DMN.
# Configure the reports:
## View: Raw Data.
## Visualization: Table.

h4. What is the problem?
In the report builder, try to go to any page for result index < 10000, the screen shows the error:
{code:java}An application error occured.
Refresh your browser or close it and sign in again.

Cannot read property 'name' of null{code}
The browser's developer tools show the response error:
{code:java}{
  "errorCode" : "elasticsearchError",
  "errorMessage" : "Elasticsearch encountered an error. If this issue persists, please contact your administrator.",
  "detailedMessage" : "Elasticsearch exception [type=search_phase_execution_exception, reason=all shards failed]",
  "reportDefinition" : null
}{code}
After the report is created and saved, run the report then try to go to any page for result index < 10000, the screen shows the error:
{code:java}This link is not valid.
Go to Home…{code}
The browser's developer tools show the same response error code as above.
What would be the expected behavior:
Report builder and report view should work for process and decision reports to view raw data visualized as a table for result index > 10000.

New: h4. What are the steps to reproduce your problem?
# Create > 10K BPMN and DMN instances in Camunda Platform.
# After import is complete build Process and Decision reports on the BPMN and DMN.
# Configure the reports:
## View: Raw Data.
## Visualization: Table.

h4. What is the problem?
In the report builder, try to go to any page for result index > 10000, the screen shows the error:
{code:java}An application error occured.
Refresh your browser or close it and sign in again.

Cannot read property 'name' of null{code}
The browser's developer tools show the response error:
{code:java}{
  "errorCode" : "elasticsearchError",
  "errorMessage" : "Elasticsearch encountered an error. If this issue persists, please contact your administrator.",
  "detailedMessage" : "Elasticsearch exception [type=search_phase_execution_exception, reason=all shards failed]",
  "reportDefinition" : null
}{code}
After the report is created and saved, run the report then try to go to any page for result index > 10000, the screen shows the error:
{code:java}This link is not valid.
Go to Home…{code}
The browser's developer tools show the same response error code as above.
What would be the expected behavior:
Report builder and report view should work for process and decision reports to view raw data visualized as a table for result index > 10000.

Daniel Ewing made changes - 21/May/21 5:04 PM

Mentioned Roles

Daniel Ewing made changes - 21/May/21 5:04 PM

Mentioned Groups

Assignee:: Unassigned

Reporter:: Daniel Ewing

DRI:: Giuliano Rodrigues Lima

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Created:: 21/May/21 5:01 PM

Updated:: 27/Dec/23 2:35 PM