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

missing cost_category for monthly cost-model derived rows

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Undefined Undefined
    • 2022Q4
    • None
    • None
    • None

      postgres=# select * from reporting_ocpusagelineitem_daily_summary WHERE cost_category_id IS NULL and namespace LIKE 'openshift-%';
      -[ RECORD 1 ]----------------------------------+-----------------------------------------------
      uuid                                           | 61464d3d-c6e2-4a93-8d37-a17b6f2d6ba9
      cluster_id                                     | test_cost_ocp_on_aws_cluster
      cluster_alias                                  | test_cost_ocp_on_aws_cluster
      data_source                                    | Pod
      namespace                                      | openshift-stage
      node                                           | ocp-nod
      resource######################################
      infrastructure_project_monthly_cost            | {"cpu": 500.0000000000, "pvc": 0, "memory": 0}
      supplementary_project_monthly_cost             | 
      monthly_cost_type                              | Node
      source_uuid                                    | 5f2661a7-c839-4181-bc99-e8eefc09ee75
      report_period_id                               | 10
      raw_currency                                   | 
      cost_category_id                               | 
      -[ RECORD 2 ]----------------------------------+-----------------------------------------------
      uuid                                           | 1160e2bd-36e9-45de-b0ee-4e15226a8090
      cluster_id                                     | test_cost_ocp_on_aws_cluster
      cluster_alias                                  | test_cost_ocp_on_aws_cluster
      data_source                                    | Pod
      namespace                                      | openshift-stage
      node                                           | ocp-nod
      #################
      infrastructure_project_monthly_cost            | {"cpu": 500.0000000000, "pvc": 0, "memory": 0}
      supplementary_project_monthly_cost             | 
      monthly_cost_type                              | Node
      source_uuid                                    | 5f2661a7-c839-4181-bc99-e8eefc09ee75
      report_period_id                               | 9
      raw_currency                                   | 
      cost_category_id                               | 
      

            myersco Cody Myers
            myersco Cody Myers
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: