Optimize doesn't show metrics for a multi data source report when one report has no data

[engineering-issue-sync-app[bot]]

Engineering DRI: @matthewBearCamunda

Describe the bug

When a process report contains a process that does not have any data in it, the report fails to show any data

Expected behaviour

Optimize should be able to handle multi-process reports where one process does not have any data

To Reproduce

• Create a process
• Deploy and run it a couple of times
• Create another process
• Deploy it. Do not run this second process
• In Optimize, go to Collections and create a new Process Report
• Add the two processes you created. One process that has been run, and another that has not
• Create and save.
• Look at the raw data section, its empty

Notes

• Backport fix to 3.13
• There are messages in the log when trying to look at the failing report

09:28:39.870 [qtp620688706-190] INFO  o.c.o.s.d.e.r.c.e.ReportCmdExecutionPlan - Could not evaluate report because at least one required instance index [process-instance-invoice, process-instance-process_1uqyi3o] does not exist. Retrying with index multi alias
09:28:39.883 [qtp620688706-190] INFO  o.c.o.s.d.e.r.c.e.ReportCmdExecutionPlan - Could not evaluate report. Returning empty result instead

• A similar issue was worked on in the past. It has the same steps to reproduce as this ticket. https://jira.camunda.com/browse/OPT-6463
  • The support ticket has history of the old issue as well: https://jira.camunda.com/browse/SUPPORT-18311
  • The code that outputs the above message was part of the changeset for OPT-6463

Environment observed:

• Optimize mode(s): C7
• Optimize version(s): 3.13, master
• Database(s) (Elasticsearch/OpenSearch): ES

Links

• https://jira.camunda.com/browse/SUPPORT-18311

Breakdown

### Pull Requests
- [ ] https://github.com/camunda/camunda-optimize/pull/13843
- [ ] https://github.com/camunda/camunda-optimize/pull/13868
- [ ] https://github.com/camunda/camunda-optimize/pull/13867
- [ ] https://github.com/camunda/camunda-optimize/pull/13866
- [ ] https://github.com/camunda/camunda-optimize/pull/13861

Bug Lifecycle

For managing the issue lifecycle, please use the workflow commands. You can see the available commands by writing /help as a comment on this issue.

QA Verification

Is this bug reproducible?

• [x] Yes. If so:
  • [x] The bug description is clear
  • [x] The steps to reproduce are clear
  • [x] The environments observed are correct and complete
• [ ] No

Review

Review Resources

• Feature PR: {Link to PR targeting the main branch}
• Preview environments: {Link(s) to preview environments}

Engineering Review

• [x] All code targeting the main branch has been reviewed by at least one Engineer
• [x] The PR targeting the main branch has been approved by the reviewing Engineer
• [x] If the API has changed, the API documentation is updated
• [x] All other PRs (docs, controller etc.) in the breakdown have been approved

QA Review

• [x] The change is implemented as described on all target environments/versions/modes
• [x] The documentation changes are as expected

Completion

• [x] All Review stages are successfully completed
• [x] All associated PRs are merged to the main branch(es) and maintenance branches
• [x] The correct version labels are applied to the issue

^{:robot: This issue is automatically synced from: source}