# No doc count in destination index of transform

**URL:** <https://discuss.elastic.co/t/no-doc-count-in-destination-index-of-transform/373284>\
**Category:** Kibana\
**Tags:** transforms\
**Created:** [January 16, 2025, 2:54pm UTC](https://discuss.elastic.co/t/no-doc-count-in-destination-index-of-transform/373284 "2025-01-16T14:54:21Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![sintim](https://avatars.discourse-cdn.com/v4/letter/s/9f8e36/32.png) [@sintim](https://discuss.elastic.co/u/sintim)\
**Post date:** [January 16, 2025, 2:54pm UTC](https://discuss.elastic.co/t/no-doc-count-in-destination-index-of-transform/373284/1 "2025-01-16T14:54:21Z")

</div>

I created a transform on ELK and it is up and HEALTHY but till now there's still no documents in the destination index for a data view. It's been about 6 hours. Is that supposed to be normal? or if not how can I check if there is a problem?

Thank you.

---

<div class="post-metadata">

**Author:** ![Patrick\_Whelan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/patrick_whelan/32/135049_2.png) [@Patrick\_Whelan](https://discuss.elastic.co/u/Patrick_Whelan)\
**Post date:** [January 17, 2025, 2:05am UTC](https://discuss.elastic.co/t/no-doc-count-in-destination-index-of-transform/373284/2 "2025-01-17T02:05:58Z")

</div>

What does the transform's stats show? `checkpoint` should progress incrementally beyond 0 each time the transform searches the source index and writes to the destination index. `trigger_count` increasing each time the transform is scheduled, regardless of whether there is data to process or not. `search*` stats are how many documents it is finding, and `documents*` is how many documents are being written.

- [Get transform statistics API | Elasticsearch Guide [8.17] | Elastic](https://www.elastic.co/guide/en/elasticsearch/reference/current/get-transform-stats.html)
- or under the `Details` and `Stats` tabs on the `Stack Management` -\> `Transforms` page in Kibana

There's also the `_preview` API to check what the search results would be from the source index, which would help verify if the transform is finding data and just not writing it for some reason:

- [Preview transform API | Elasticsearch Guide [8.17] | Elastic](https://www.elastic.co/guide/en/elasticsearch/reference/current/preview-transform.html)
- `Preview` tab on the `Stack Management` -\> `Transforms` page in Kibana

---

<div class="post-metadata">

**Author:** ![sintim](https://avatars.discourse-cdn.com/v4/letter/s/9f8e36/32.png) [@sintim](https://discuss.elastic.co/u/sintim)\
**Post date:** [January 17, 2025, 8:56am UTC](https://discuss.elastic.co/t/no-doc-count-in-destination-index-of-transform/373284/3 "2025-01-17T08:56:43Z")

</div>

The transform stats API shows

{ "count" : 0  
"transforms":   
}

Also, as at now the transform health status is seen as degraded.

---

<div class="post-metadata">

**Author:** ![Patrick\_Whelan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/patrick_whelan/32/135049_2.png) [@Patrick\_Whelan](https://discuss.elastic.co/u/Patrick_Whelan)\
**Post date:** [January 17, 2025, 2:00pm UTC](https://discuss.elastic.co/t/no-doc-count-in-destination-index-of-transform/373284/4 "2025-01-17T14:00:27Z")

</div>

What are you using to determine the health of the transform, is it Kibana? There should be a "reason" on the health tab for why it is degraded, and there is a messages tab when the transform auditor logs events, both may help explain what is going on? If nothing stands out there, maybe check the ES logs for WARN/ERROR from the transform id?
