Index template creation

Elastic Stack Elasticsearch
1

during the template creation based on the json data , i am facing the issues for the data, even i have defined the nested type. please suggest .

"type": "illegal_argument_exception",
    "reason": "composable template [data_center-test] template after composition is invalid",
    "caused_by": {
      "type": "illegal_argument_exception",
      "reason": "invalid composite mappings for [data_center-test]",
      "caused_by": {
        "type": "mapper_parsing_exception",
        "reason": "Failed to parse mapping: Mapping definition for [data] has unsupported parameters:  [timeScale : {type=text, fields={keyword={ignore_above=256, type=keyword}}}]",
        "caused_by": {
          "type": "mapper_parsing_exception",
          "reason": "Mapping definition for [data] has unsupported parameters:  [timeScale : {type=text, fields={keyword={ignore_above=256, type=keyword}}}]"
2

It looks like you are using a composite template. Check what is problem there, name, structure etc.

3

Hello, you need to share the template you are trying to load, it is pretty hard to suggest anything without seeing what you are trying to do.

4

here is my template sample

{
    "index_patterns" : [
      "data_center-*"
    ],
    "template": {
      "settings" : {
        "number_of_shards" : "1"
      },
      "mappings" : {
        "properties" : {
          "path" : {
            "type" : "keyword"
          },
          "metadata" : {
            "properties" : {
              "hostname" : {
                "type" : "keyword"
              },
              "application" : {
                "type" : "keyword"
              },
              "method" : {
                "properties" : {
                  "fn" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "params" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  }
                }
              },
              "timestamp_log" : {
                "type" : "text"
              },
              "timezone" : {
                "type" : "keyword"
              },
              "hostname_formatted" : {
                "type" : "keyword"
              },
              "status_at" : {
                "type" : "text"
              },
              "status" : {
                "type" : "keyword"
              },
              "country" : {
                "type" : "keyword"
              },
              "dcId" : {
                "type" : "keyword"
              },
              "dcId2" : {
                "type" : "keyword"
              }
            }
          },
          "@timestamp" : {
            "type" : "date"
          },
          "@timestamp_log" : {
            "type" : "date"
          },
          "@timestamp_bucket" : {
            "type" : "date"
          },
          "@timestamp_post" : {
            "type" : "date"
          },
          "raw" : {
            "dynamic" : "true",
            "properties" : { }
          },
          "source" : {
            "type" : "keyword"
          },
          "alarm_name" : {
            "type" : "keyword"
          },
          "alarm_status" : {
            "type" : "keyword"
          },
          "alarm_type" : {
            "type" : "keyword"
          },
          "asset_classification" : {
            "type" : "keyword"
          },
          "ddid" : {
            "type" : "long"
          },
          "ddidArr" : {
            "type" : "long"
          },
          "time_stamp" : {
            "type" : "keyword"
          },
          "data" : {
            "type" : "nested",
            "properties" : {
              "data" : {
                "type" : "nested",
                "properties" : {
                  "amps" : {
                    "type" : "float"
                  },
                  "soldAmps" : {
                    "type" : "long"
                  },
                  "peakKvaLastSevenDaysContractualKva" : {
                    "type" : "long"
                  },
                  "percentageKva" : {
                    "type" : "float"
                  },
                  "peakKvaLastSevenDays" : {
                    "type" : "float"
                  },
                  "redundant" : {
                    "type" : "nested",
                    "properties" : {
                      "amps" : {
                        "type" : "float"
                      },
                      "accountNo" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },
                      "soldAmps" : {
                        "type" : "long"
                      },
                      "peakKvaLastSevenDaysContractualKva" : {
                        "type" : "long"
                      },
                      "percentageKva" : {
                        "type" : "float"
                      },
                      "peakKvaLastSevenDays" : {
                        "type" : "float"
                      },
                      "cage" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },
                      "readingTime" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },
                      "soldKva" : {
                        "type" : "float"
                      },
                      "zone" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },
                      "levelType" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },
                      "kva" : {
                        "type" : "float"
                      },
                      "lastUpdatedTime" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },
                      "levelValue" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },
                      "timestamp" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },
                      "cabinetRating" : {
                        "type" : "float"
                      },
                      "comparisonData" : {
                        "properties" : {
                          "yesterday" : {
                            "type" : "float"
                          },
                          "datapoint" : {
                            "type" : "text",
                            "fields" : {
                              "keyword" : {
                                "ignore_above" : 256,
                                "type" : "keyword"
                              }
                            }
                          },
                          "lastweek" : {
                            "type" : "float"
                          },
                          "lastmonth" : {
                            "type" : "float"
                          },
                          "lastquarter" : {
                            "type" : "float"
                          }
                        }
                      },
                      "contractualKva" : {
                        "type" : "long"
                      },
                      "kw" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },
                      "customerName" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },
                      "redundantKva" : {
                        "type" : "float"
                      },
                      "primaryKva" : {
                        "type" : "float"
                      },
                      "peakKvaLastSevenDaysPercentage" : {
                        "type" : "float"
                      },
                      "sensor" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },
                      "cabinet" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },                   
                      "circuitNo" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },
                      "ibx" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },
                      "powerFactor" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      }
                    }
                  },
                  "humidityUom" : {
                    "type" : "text"                   
                  },
                  "cage" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "readingTime" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "soldKva" : {
                    "type" : "float"
                  },
                  "zone" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "levelType" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "accountNo" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "kva" : {
                    "type" : "float"
                  },
                  "temperature" : {
                    "type" : "float"
                  },
                  "humidity" : {
                    "type" : "float"
                  },
                  "lastUpdatedTime" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "levelValue" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "timestamp" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "cabinetRating" : {
                    "type" : "float"
                  },
                  "comparisonData" : {
                    "properties" : {
                      "yesterday" : {
                        "type" : "float"
                      },
                      "datapoint" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },
                      "lastweek" : {
                        "type" : "float"
                      },
                      "lastmonth" : {
                        "type" : "float"
                      },
                      "lastquarter" : {
                        "type" : "float"
                      }
                    }
                  },
                  "temperatureUom" : {
                    "type" : "text"
                  },
                  "sensorName" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "contractualKva" : {
                    "type" : "long"
                  },
                  "kw" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "customerName" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "redundantKva" : {
                    "type" : "float"
                  },
                  "primaryKva" : {
                    "type" : "float"
                  },
                  "peakKvaLastSevenDaysPercentage" : {
                    "type" : "float"
                  },
                  "sensor" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "cabinet" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "ibx" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "primary" : {
                    "type" : "nested",
                    "properties" : {
                      "amps" : {
                        "type" : "float"
                      },
                      "accountNo" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },
                      "soldAmps" : {
                        "type" : "long"
                      },
                      "peakKvaLastSevenDaysContractualKva" : {
                        "type" : "long"
                      },
                      "percentageKva" : {
                        "type" : "float"
                      },
                      "peakKvaLastSevenDays" : {
                        "type" : "float"
                      },
                      "cage" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },
                      "readingTime" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },
                      "soldKva" : {
                        "type" : "float"
                      },
                      "zone" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },
                      "levelType" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },
                      "kva" : {
                        "type" : "float"
                      },
                      "lastUpdatedTime" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },
                      "levelValue" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },
                      "timestamp" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },
                      "cabinetRating" : {
                        "type" : "float"
                      },
                      "comparisonData" : {
                        "properties" : {
                          "yesterday" : {
                            "type" : "float"
                          },
                          "datapoint" : {
                            "type" : "text",
                            "fields" : {
                              "keyword" : {
                                "ignore_above" : 256,
                                "type" : "keyword"
                              }
                            }
                          },
                          "lastweek" : {
                            "type" : "float"
                          },
                          "lastmonth" : {
                            "type" : "float"
                          },
                          "lastquarter" : {
                            "type" : "float"
                          }
                        }
                      },
                      "contractualKva" : {
                        "type" : "long"
                      },
                      "kw" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },
                      "customerName" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },
                      "redundantKva" : {
                        "type" : "float"
                      },
                      "primaryKva" : {
                        "type" : "float"
                      },
                      "peakKvaLastSevenDaysPercentage" : {
                        "type" : "float"
                      },
                      "sensor" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },
                      "cabinet" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },                   
                      "circuitNo" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },
                      "ibx" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },
                      "powerFactor" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      }
                    }
                  },
                  "powerFactor" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "InBkr_Status" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "LossOfPower" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "InBkr_Trip" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "Outgoing_Bkr_OFF" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "deviceName" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "id" : {
                    "type" : "long"
                  },
                  "PUE" : {
                    "type" : "float"
                  },
                  "SATemp" : {
                    "type" : "float"
                  },
                  "SATempUom" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "SAHumi" : {
                    "type" : "float"
                  },
                  "SAHumiUom" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "fanSpeed" : {
                    "type" : "float"
                  },
                  "fanSpeedUom" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "runStatus" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  }
                },
                "timeScale" : {
                  "type" : "text",
                  "fields" : {
                    "keyword" : {
                      "ignore_above" : 256,
                      "type" : "keyword"
                    }
                  }
                }
              },
              "ibx" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "status" : {
                    "type" : "boolean"
                  }
                }
              }
            }
          }
        }
      }
    }
}
5

I suggest that you double check your template, I copied it and just pasting on an code editor it already shows that some curly brackets are not closing correctly.

6

it seems that i was not able to copy paste the complete template , attaching the same again.

{
    "index_patterns" : [
      "data_center-*"
    ],
    "template": {
      "settings" : {
        "number_of_shards" : "1"
      },
      "mappings" : {
        "properties" : {
          "path" : {
            "type" : "keyword"
          },
          "metadata" : {
            "properties" : {
              "hostname" : {
                "type" : "keyword"
              },
              "application" : {
                "type" : "keyword"
              },
              "method" : {
                "properties" : {
                  "fn" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "params" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  }
                }
              },
              "timestamp_log" : {
                "type" : "text"
              },
              "timezone" : {
                "type" : "keyword"
              },
              "hostname_formatted" : {
                "type" : "keyword"
              },
              "status_at" : {
                "type" : "text"
              },
              "status" : {
                "type" : "keyword"
              },
              "country" : {
                "type" : "keyword"
              },
              "dcId" : {
                "type" : "keyword"
              },
              "dcId2" : {
                "type" : "keyword"
              }
            }
          },
          "@timestamp" : {
            "type" : "date"
          },
          "@timestamp_log" : {
            "type" : "date"
          },
          "@timestamp_bucket" : {
            "type" : "date"
          },
          "@timestamp_post" : {
            "type" : "date"
          },
          "raw" : {
            "dynamic" : "true",
            "properties" : { }
          },
          "source" : {
            "type" : "keyword"
          },
          "alarm_name" : {
            "type" : "keyword"
          },
          "alarm_status" : {
            "type" : "keyword"
          },
          "alarm_type" : {
            "type" : "keyword"
          },
          "asset_classification" : {
            "type" : "keyword"
          },
          "ddid" : {
            "type" : "long"
          },
          "ddidArr" : {
            "type" : "long"
          },
          "time_stamp" : {
            "type" : "keyword"
          },
          "data" : {
            "type" : "nested",
            "properties" : {
              "data" : {
                "type" : "nested",
                "properties" : {
                  "amps" : {
                    "type" : "float"
                  },
                  "soldAmps" : {
                    "type" : "long"
                  },
                  "peakKvaLastSevenDaysContractualKva" : {
                    "type" : "long"
                  },
                  "percentageKva" : {
                    "type" : "float"
                  },
                  "peakKvaLastSevenDays" : {
                    "type" : "float"
                  },
                  "redundant" : {
                    "type" : "nested",
                    "properties" : {
                      "amps" : {
                        "type" : "float"
                      },
                      "accountNo" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },
                      "soldAmps" : {
                        "type" : "long"
                      },
                      "peakKvaLastSevenDaysContractualKva" : {
                        "type" : "long"
                      },
                      "percentageKva" : {
                        "type" : "float"
                      },
                      "peakKvaLastSevenDays" : {
                        "type" : "float"
                      },
                      "cage" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },
                      "readingTime" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },
                      "soldKva" : {
                        "type" : "float"
                      },
                      "zone" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },
                      "levelType" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },
                      "kva" : {
                        "type" : "float"
                      },
                      "lastUpdatedTime" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },
                      "levelValue" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },
                      "timestamp" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },
                      "cabinetRating" : {
                        "type" : "float"
                      },
                      "comparisonData" : {
                        "properties" : {
                          "yesterday" : {
                            "type" : "float"
                          },
                          "datapoint" : {
                            "type" : "text",
                            "fields" : {
                              "keyword" : {
                                "ignore_above" : 256,
                                "type" : "keyword"
                              }
                            }
                          },
                          "lastweek" : {
                            "type" : "float"
                          },
                          "lastmonth" : {
                            "type" : "float"
                          },
                          "lastquarter" : {
                            "type" : "float"
                          }
                        }
                      },
                      "contractualKva" : {
                        "type" : "long"
                      },
                      "kw" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },
                      "customerName" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },
                      "redundantKva" : {
                        "type" : "float"
                      },
                      "primaryKva" : {
                        "type" : "float"
                      },
                      "peakKvaLastSevenDaysPercentage" : {
                        "type" : "float"
                      },
                      "sensor" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },
                      "cabinet" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },                   
                      "circuitNo" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },
                      "ibx" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },
                      "powerFactor" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      }
                    }
                  },
                  "humidityUom" : {
                    "type" : "text"                   
                  },
                  "cage" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "readingTime" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "soldKva" : {
                    "type" : "float"
                  },
                  "zone" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "levelType" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "accountNo" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "kva" : {
                    "type" : "float"
                  },
                  "temperature" : {
                    "type" : "float"
                  },
                  "humidity" : {
                    "type" : "float"
                  },
                  "lastUpdatedTime" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "levelValue" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "timestamp" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "cabinetRating" : {
                    "type" : "float"
                  },
                  "comparisonData" : {
                    "properties" : {
                      "yesterday" : {
                        "type" : "float"
                      },
                      "datapoint" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },
                      "lastweek" : {
                        "type" : "float"
                      },
                      "lastmonth" : {
                        "type" : "float"
                      },
                      "lastquarter" : {
                        "type" : "float"
                      }
                    }
                  },
                  "temperatureUom" : {
                    "type" : "text"
                  },
                  "sensorName" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "contractualKva" : {
                    "type" : "long"
                  },
                  "kw" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "customerName" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "redundantKva" : {
                    "type" : "float"
                  },
                  "primaryKva" : {
                    "type" : "float"
                  },
                  "peakKvaLastSevenDaysPercentage" : {
                    "type" : "float"
                  },
                  "sensor" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "cabinet" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "ibx" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "primary" : {
                    "type" : "nested",
                    "properties" : {
                      "amps" : {
                        "type" : "float"
                      },
                      "accountNo" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },
                      "soldAmps" : {
                        "type" : "long"
                      },
                      "peakKvaLastSevenDaysContractualKva" : {
                        "type" : "long"
                      },
                      "percentageKva" : {
                        "type" : "float"
                      },
                      "peakKvaLastSevenDays" : {
                        "type" : "float"
                      },
                      "cage" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },
                      "readingTime" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },
                      "soldKva" : {
                        "type" : "float"
                      },
                      "zone" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },
                      "levelType" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },
                      "kva" : {
                        "type" : "float"
                      },
                      "lastUpdatedTime" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },
                      "levelValue" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },
                      "timestamp" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },
                      "cabinetRating" : {
                        "type" : "float"
                      },
                      "comparisonData" : {
                        "properties" : {
                          "yesterday" : {
                            "type" : "float"
                          },
                          "datapoint" : {
                            "type" : "text",
                            "fields" : {
                              "keyword" : {
                                "ignore_above" : 256,
                                "type" : "keyword"
                              }
                            }
                          },
                          "lastweek" : {
                            "type" : "float"
                          },
                          "lastmonth" : {
                            "type" : "float"
                          },
                          "lastquarter" : {
                            "type" : "float"
                          }
                        }
                      },
                  "runStatus" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  }
                },
                "timeScale" : {
                  "type" : "text"
                   }
                }
              },
              "children" : {
                "type" : "nested",
                "properties" : {
                  "children" : {
                    "type" : "nested",
                    "properties" : {
                      "children" : {
                        "type" : "nested",
                        "properties" : {
                          "levelType" : {
                            "type" : "text",
                            "fields" : {
                              "keyword" : {
                                "ignore_above" : 256,
                                "type" : "keyword"
                              }
                            }
                          },
                          "label" : {
                            "type" : "text",
                            "fields" : {
                              "keyword" : {
                                "ignore_above" : 256,
                                "type" : "keyword"
                              }
                            }
                          },
                          "levelValue" : {
                            "type" : "text",
                            "fields" : {
                              "keyword" : {
                                "ignore_above" : 256,
                                "type" : "keyword"
                              }
                            }
                          }
                        }
                      },
                      "levelType" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },
                      "label" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      },
                      "levelValue" : {
                        "type" : "text",
                        "fields" : {
                          "keyword" : {
                            "ignore_above" : 256,
                            "type" : "keyword"
                          }
                        }
                      }
                    }
                  },
                  "levelType" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "label" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "levelValue" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  }
                }
              },
              "levelType" : {
                "type" : "text",
                "fields" : {
                  "keyword" : {
                    "ignore_above" : 256,
                    "type" : "keyword"
                  }
                }
              },
              "label" : {
                "type" : "text",
                "fields" : {
                  "keyword" : {
                    "ignore_above" : 256,
                    "type" : "keyword"
                  }
                }
              },
              "totalCount" : {
                "type" : "long"
              },
              "levelValue" : {
                "type" : "text",
                "fields" : {
                  "keyword" : {
                    "ignore_above" : 256,
                    "type" : "keyword"
                  }
                }
              },
              "alarms" : {
                "properties" : {
                  "severity" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "tagId" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "tagDisplayName" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "customerassets" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "assetClassification" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "timeProcessed" : {
                    "type" : "long"
                  },
                  "ack" : {
                    "type" : "boolean"
                  },
                  "conditionName" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "assetType" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "assetId" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "accountNo" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "customerId" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "timeNormalProcessed" : {
                    "type" : "long"
                  },
                  "timeTrigerred" : {
                    "type" : "long"
                  },
                  "ibx" : {
                    "type" : "text",
                    "fields" : {
                      "keyword" : {
                        "ignore_above" : 256,
                        "type" : "keyword"
                      }
                    }
                  },
                  "status" : {
                    "type" : "boolean"
                  }
                }
              }
            }
          }
        }
      }
}
7

Did you double check every mapping? The error you shared could happen if the json of your mapping is not correct, you need to check every mapping to see if all opening and closing curly brackets are ok.

This second template you shared also shows that are some errors, but it is almost 1000 lines and I can't check each one, you will need to do that.

Use an editor that will color every bracket pair to help find what is wrong.

8

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.