Open nitamanna18 opened 1 month ago
@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.
Related Slack thread: https://cross-mediaworkspace.slack.com/archives/C0312M4HE3F/p1726668994171129
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
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.