[Intermittent Issue ] gRPC 225 error: INVALID_ARGUMENT INVALID_ARGUMENT: Reach-and-frequency metrics can only be computed on union-only set expressions.

[nitamanna18]

Describe the bug
When we are sending request to Adaptor to create Report, for following Reporting Sets and Metric calculations we are receiving Error gRPC 225 error: INVALID_ARGUMENT INVALID_ARGUMENT: Reach-and-frequency metrics can only be computed on union-only set expressions for the first time and when we resubmit the exact same request, it is creating Reports as expected.

Payload to Adaptor:
parent: "measurementConsumers/fLhOpt2Z4x8"report_id: "d960202392e1417f9776d73c44dfdb31"report { reporting_metric_entries { key: "measurementConsumers/fLhOpt2Z4x8/reportingSets/d86790bc4fababd29fcaaa50c555" value { metric_calculation_specs: "measurementConsumers/fLhOpt2Z4x8/metricCalculationSpecs/aa9d9ca424a82bae8700a7bae34" metric_calculation_specs: "measurementConsumers/fLhOpt2Z4x8/metricCalculationSpecs/b12e0aa05a8b4837840f3ec020556f1b" } } reporting_metric_entries { key: "measurementConsumers/fLhOpt2Z4x8/reportingSets/f56a60436604fc7ab0c72e6771e95cd" value { metric_calculation_specs: "measurementConsumers/fLhOpt2Z4x8/metricCalculationSpecs/aa9d9ca424a82bae8700a7bae34" metric_calculation_specs: "measurementConsumers/fLhOpt2Z4x8/metricCalculationSpecs/b12e0aa05a8b4837840f3ec020556f1b" } } reporting_metric_entries { key: "measurementConsumers/fLhOpt2Z4x8/reportingSets/e8ecc495bb334b508dc5113f8fd6b7d4" value { metric_calculation_specs: "measurementConsumers/fLhOpt2Z4x8/metricCalculationSpecs/aa9d9ca424a82bae8700a7bae34" metric_calculation_specs: "measurementConsumers/fLhOpt2Z4x8/metricCalculationSpecs/b12e0aa05a8b4837840f3ec020556f1b" } } reporting_metric_entries { key: "measurementConsumers/fLhOpt2Z4x8/reportingSets/ced0dc4160ea45ff9c54002cdc2c2137" value { metric_calculation_specs: "measurementConsumers/fLhOpt2Z4x8/metricCalculationSpecs/aa9d9ca424a82bae8700a7bae34" metric_calculation_specs: "measurementConsumers/fLhOpt2Z4x8/metricCalculationSpecs/b12e0aa05a8b4837840f3ec020556f1b" } } reporting_metric_entries { key: "measurementConsumers/fLhOpt2Z4x8/reportingSets/bf87e7399af4f59a402c9e7101ae0fd" value { metric_calculation_specs: "measurementConsumers/fLhOpt2Z4x8/metricCalculationSpecs/aa9d9ca424a82bae8700a7bae34" metric_calculation_specs: "measurementConsumers/fLhOpt2Z4x8/metricCalculationSpecs/b12e0aa05a8b4837840f3ec020556f1b" } } reporting_metric_entries { key: "measurementConsumers/fLhOpt2Z4x8/reportingSets/f7c106f9628452f8e97c7757121ff1b" value { metric_calculation_specs: "measurementConsumers/fLhOpt2Z4x8/metricCalculationSpecs/aa9d9ca424a82bae8700a7bae34" metric_calculation_specs: "measurementConsumers/fLhOpt2Z4x8/metricCalculationSpecs/b12e0aa05a8b4837840f3ec020556f1b" } } reporting_metric_entries { key: "measurementConsumers/fLhOpt2Z4x8/reportingSets/c746b226c444a78bdfacde129998c61" value { metric_calculation_specs: "measurementConsumers/fLhOpt2Z4x8/metricCalculationSpecs/aa9d9ca424a82bae8700a7bae34" metric_calculation_specs: "measurementConsumers/fLhOpt2Z4x8/metricCalculationSpecs/b12e0aa05a8b4837840f3ec020556f1b" } } reporting_metric_entries { key: "measurementConsumers/fLhOpt2Z4x8/reportingSets/d43e2f4cdb405bbf94fbc14bfced77" value { metric_calculation_specs: "measurementConsumers/fLhOpt2Z4x8/metricCalculationSpecs/eb82c0e27a4f12bc07db309a7f05d1" } } reporting_metric_entries { key: "measurementConsumers/fLhOpt2Z4x8/reportingSets/cd7a294265a148e58c29bc5ad08c7020" value { metric_calculation_specs: "measurementConsumers/fLhOpt2Z4x8/metricCalculationSpecs/eb82c0e27a4f12bc07db309a7f05d1" } } reporting_metric_entries { key: "measurementConsumers/fLhOpt2Z4x8/reportingSets/d4ffeb84b4046b2a362742b718217" value { metric_calculation_specs: "measurementConsumers/fLhOpt2Z4x8/metricCalculationSpecs/eb82c0e27a4f12bc07db309a7f05d1" } } reporting_metric_entries { key: "measurementConsumers/fLhOpt2Z4x8/reportingSets/fde6a92bdbe94482b35af6bc882c60cc" value { metric_calculation_specs: "measurementConsumers/fLhOpt2Z4x8/metricCalculationSpecs/eb82c0e27a4f12bc07db309a7f05d1" } } reporting_metric_entries { key: "measurementConsumers/fLhOpt2Z4x8/reportingSets/c1a5f47db34d0dad55638f00e9c251" value { metric_calculation_specs: "measurementConsumers/fLhOpt2Z4x8/metricCalculationSpecs/eb82c0e27a4f12bc07db309a7f05d1" } } tags { key: "brands" value: "'Call Connect' 'Call Connect' 'Laundry Genie' 'LaundryGenie'" } tags { key: "campaign_name" value: "CG_029309-034" } tags { key: "end_date" value: "2024-01-08T10:00:00Z" } tags { key: "filter_display_viewability_mrc" value: "display.viewable_50_percent_plus" } tags { key: "filter_video_viewability_mrc" value: "video.viewable_100_percent" } tags { key: "media_types" value: "DISPLAY OTHER VIDEO" } tags { key: "report_name" value: "Automation_TestReport_Cross_MediaType_Display_Video_Other94028994309608" } tags { key: "start_date" value: "2024-01-01T00:00:00Z" } tags { key: "target" value: "'dataProviders/GYPvFN2Z4Ug' 'dataProviders/SVf4UiJmHl4' 'dataProviders/c4gsYiJmHo4'" } reporting_interval { report_start { year: 2024 month: 1 day: 1 utc_offset { } } report_end { year: 2024 month: 1 day: 8 } }}request_id: "d960202392e1417f9776d73c44dfdb31""timestamp: "2024-09-11T15:02:26.298Z"

Error in Reporting Server Log:

Error in Logs: [DefaultDispatcher-worker-1] gRPC 225 error: INVALID_ARGUMENT INVALID_ARGUMENT: Reach-and-frequency metrics can only be computed on union-only set expressions. io.grpc.StatusException: INVALID_ARGUMENT: Reach-and-frequency metrics can only be computed on union-only set expressions.

"[DefaultDispatcher-worker-4] gRPC 226 error: INVALID_ARGUMENT Reach-and-frequency metrics can only be computed on union-only set expressions."

Steps to reproduce

1. The issue is intermittent.
2. Submit Create Report Request to Adaptor
3. Error occurs only first time
4. Try submitting the same Report second time
5. Reports created successfully

Component(s) affected
Reporting Server

Version
Halo v.0.5.8

Environment
Origin DEV & TST Environment

Additional context
We have checked all the Reporting Set for the above Report and there is no Reach and Frequency metrics added to non union Reporting Set.

[SanjayVas]

@tristanvuong2021 can you take a look? Report creation logic should all be deterministic, so it's especially concerning when this is happening intermittently. I'm wondering if something is order-dependent.

[SanjayVas]

Related Slack thread: https://cross-mediaworkspace.slack.com/archives/C0312M4HE3F/p1726668994171129