Uploaded image for project: 'Cost Management'
  1. Cost Management
  2. COST-3098

OCI storage report endpoint returns incorrect data when group_by is applied

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Normal Normal
    • 2022Q4
    • None
    • API

      1. When we apply group_by[region|instance-types|product_service] to OCI storage endpoint, the total cost exceeds the total cost of storage endpoint without group_by

      It seems that also non-storage services are included in the storage report.

      2. Additionally, if we combine group_by[instance_type] with filter[limit]=some_number - we get no data back

       

      Steps to reproduce #1:

      1. ingest OCI data - wait 2 mins to make sure ingestion is complete and prevent caching issues
      2. hit http://localhost:8000/api/cost-management/v1/reports/oci/storage/
        we see the total cost of 49.8432 (not sure if this value is correct, but it could be)
      {"meta": 
          {
              "count": 10,
              "check_tags": false,
              "filter":{
                  "time_scope_value": "-10",
                  "time_scope_units": "day",
                  "resolution": "daily"
              }
              ,"group_by": {},
              "order_by": {},
              "total": {
                  "sup_credit": 0.0,
                  "usage": {
                      "value": 0.04121333,
                      "units": "GB_MS"
                  },
              },
              "infrastructure":{...},
              "supplementary": {...},
              "cost": {
                  ....
                  "total": {
                      "value": 49.8432,
                      "units": "USD"
                  }
              }
          }

      3. add group_by[product_service]=* to the request:

      http://localhost:8000/api/cost-management/v1/reports/oci/storage/?group_by%5Bproduct_service%5D=*

      we see the total of 200.2128, i.e, higher than without group_by (unexpected)

      "meta": {
              "count": 10,
              "limit": 10001,
              "check_tags": false,
              "group_by": {
                  "product_service": [
                      "*"
                  ]
              },
              "filter": {
                  "time_scope_value": "-10",
                  "time_scope_units": "day",
                  "resolution": "daily"
              },
              "order_by": {},
              "total": {
                  "sup_credit": 0.0,
                  "usage": {
                      "value": 0.102197144,
                      "units": "BYTES"
                  },
                  "infrastructure": {...},
                  "supplementary": {...},
                  "cost": {
                      ...
                      "total": {
                          "value": 200.2128,
                          "units": "USD"
                      }
                  }
              }
          }, 

      You may also notice that the report contains not only "BLOCK_STORAGE", but also "COMPUTE",  "NETWORK" services (unexpected)

       

      Note that the same applies to group_by[region] and group_by[instance-types]

       

      Steps to reproduce #2:

      hit http://localhost:8000/api/cost-management/v1/reports/oci/storage/?group_by%5Binstance_type%5D=*&filter%5Blimit%5D=4

      no data are returned -  this is unexpected providing that we actually have some storage instance-types - we can check that once #1 is fixed. If no data are returned from http://localhost:8000/api/cost-management/v1/reports/oci/storage/?group_by%5Binstance_type%5D=* then we are good

            rh-ee-dnakabaa David Nakabaale
            rhn-support-esebesto Eva Šebestová
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: