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

ReportSummaryUpdaterCloudError - index too large reporting_ocpallcostlineitem_daily_summary_p

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Normal Normal
    • January 2024, 2024Q1
    • None
    • None
    • None
    • False
    • None
    • False

      index row size 6520 exceeds btree version 4 maximum 2704 for index "reporting_ocpallcostlineitem_daily_summary_p_202_namespace_idx9"
      DETAIL:  Index row references tuple (117222,5) in relation "reporting_ocpallcostlineitem_daily_summary_p_2023_12".
      HINT:  Values larger than 1/3 of a buffer page cannot be indexed.
      Consider a function index of an MD5 hash of the value, or use full text indexing. 

              mskarbek Michael Skarbek
              mskarbek Michael Skarbek
              Pedro Lopez Perez Pedro Lopez Perez
              Votes:
              0 Vote for this issue
              Watchers:
              17 Start watching this issue

                Created:
                Updated:
                Resolved: