# No results found for View transaction in Discover

**URL:** https://discuss.elastic.co/t/no-results-found-for-view-transaction-in-discover/148740
**Category:** APM
**Created:** [September 16, 2018, 11:54am UTC](https://discuss.elastic.co/t/no-results-found-for-view-transaction-in-discover/148740 "2018-09-16T11:54:33Z")
**Posts on this page:** 18
**Page:** 1

<div class="post-metadata">

### Author: ![rcoundon](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rcoundon/32/30010_2.png) [@rcoundon](https://discuss.elastic.co/u/rcoundon)
#### Post date: [September 16, 2018, 11:54am UTC](https://discuss.elastic.co/t/no-results-found-for-view-transaction-in-discover/148740/1 "2018-09-16T11:54:33Z")

</div>

If I load a transaction in APM and then select to View Transaction in Discover, no results are returned.

The IDs are copied over to the search bar successfully:

`processor.event:transaction AND transaction.id:b2355f9f-f8ef-45e7-9d44-a24218e0b09b`

but there are no results returned. Is there anything special I need to do to enable this feature?

---

<div class="post-metadata">

### Author: ![axw](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/axw/32/28197_2.png) [@axw](https://discuss.elastic.co/u/axw)
#### Post date: [September 17, 2018, 1:25am UTC](https://discuss.elastic.co/t/no-results-found-for-view-transaction-in-discover/148740/2 "2018-09-17T01:25:07Z")

</div>

Hello, and thanks for trying out Elastic APM!

How recent is the transaction? What is the time range set to (top-right corner of Kibana)? It may be that the UI is not setting the time range appropriately for older transactions. It should just work, but it's possible that the time range isn't being properly set by the APM UI.

---

<div class="post-metadata">

### Author: ![rcoundon](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rcoundon/32/30010_2.png) [@rcoundon](https://discuss.elastic.co/u/rcoundon)
#### Post date: [September 17, 2018, 6:32am UTC](https://discuss.elastic.co/t/no-results-found-for-view-transaction-in-discover/148740/3 "2018-09-17T06:32:44Z")

</div>

Thanks for getting back to me.

You're right, the time range doesn't get carried through to Discover, nor does the index. Setting the index to apm\* (Kibana has two index patterns of apm\* after loading them through the GUI) and a matching time range does show the transaction.

---

<div class="post-metadata">

### Author: ![felixbarny](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/felixbarny/32/27341_2.png) [@felixbarny](https://discuss.elastic.co/u/felixbarny)
#### Post date: [September 17, 2018, 7:05am UTC](https://discuss.elastic.co/t/no-results-found-for-view-transaction-in-discover/148740/4 "2018-09-17T07:05:09Z")

</div>

> [@rcoundon](#):
>
> Kibana has two index patterns of apm\* after loading them through the GUI

That sounds a bit strange. Could you post screenshots how they are set up? Which one works and which one does not?

---

<div class="post-metadata">

### Author: ![rcoundon](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rcoundon/32/30010_2.png) [@rcoundon](https://discuss.elastic.co/u/rcoundon)
#### Post date: [September 17, 2018, 7:36am UTC](https://discuss.elastic.co/t/no-results-found-for-view-transaction-in-discover/148740/5 "2018-09-17T07:36:49Z")

</div>

Hi - they both return data but they are slightly different - one has @timestamp formatted as Date and one doesn't:

 ![Apm1](https://us1.discourse-cdn.com/elastic/original/3X/f/2/f2bc6dcb6a871c0a88863c9376b1815abfb3c87b.png) ![Apm2](https://us1.discourse-cdn.com/elastic/original/3X/0/4/0400e8faf617c9df1a8f399a2a26f2f7e2886329.png)

---

<div class="post-metadata">

### Author: ![rcoundon](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rcoundon/32/30010_2.png) [@rcoundon](https://discuss.elastic.co/u/rcoundon)
#### Post date: [September 17, 2018, 7:43am UTC](https://discuss.elastic.co/t/no-results-found-for-view-transaction-in-discover/148740/6 "2018-09-17T07:43:25Z")

</div>

I've just refreshed the field list for each and now I'm getting the message:

`There's no APM index pattern available. To use the Query bar, please choose to import the APM index pattern in the [Setup Instructions.]`

From another thread in here I'd previously set this value in the kibana.yml

`apm_oss.indexPattern: 'apm*'`

which caused that message to go away, but now it's back and that line is still in kibana.yml

---

<div class="post-metadata">

### Author: ![makwarth](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/makwarth/32/27639_2.png) [@makwarth](https://discuss.elastic.co/u/makwarth)
#### Post date: [September 17, 2018, 8:37am UTC](https://discuss.elastic.co/t/no-results-found-for-view-transaction-in-discover/148740/7 "2018-09-17T08:37:22Z")

</div>

Hi @rcoundon,

it sounds like the APM UI is still looking for the `apm-*` index pattern (with `-`), which is the default. Did you restart Kibana after updating kibana.yml with `apm_oss.indexPattern: 'apm*'`?

Did you import the index pattern via the APM setup started instructions screen, or via the Index management UI?

best,  
Rasmus

---

<div class="post-metadata">

### Author: ![rcoundon](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rcoundon/32/30010_2.png) [@rcoundon](https://discuss.elastic.co/u/rcoundon)
#### Post date: [September 17, 2018, 1:02pm UTC](https://discuss.elastic.co/t/no-results-found-for-view-transaction-in-discover/148740/8 "2018-09-17T13:02:57Z")

</div>

Hi - Yes, it was restarted - I used the set instructions screen. I've tried restarting again but still see the same message.

---

<div class="post-metadata">

### Author: ![sqren](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sqren/32/26110_2.png) [@sqren](https://discuss.elastic.co/u/sqren)
#### Post date: [September 17, 2018, 1:34pm UTC](https://discuss.elastic.co/t/no-results-found-for-view-transaction-in-discover/148740/9 "2018-09-17T13:34:48Z")

</div>

Hi rcoundon,

To shed some more light on your current APM index patterns, can you please run the following in Kibana Dev Tools, and paste the output here (baring sensitive data if any):

```auto
GET .kibana/_search
{
  "size": 10,
  "_source": ["type", "updated_at", "index-pattern.title"], 
  "query": {
    "prefix" : { "index-pattern.title" : "apm" }
  }
}

```

If you import the index patterns via the APM getting started instructions screen, you should receive a warning about overwriting objects. Do you get that? Also, if you don't mind overwriting your APM dashboards and visualisations, please proceed and overwrite them.  
I expect this will fix the error with missing index patterns.  
Let me know if it doesn't.

---

<div class="post-metadata">

### Author: ![rcoundon](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rcoundon/32/30010_2.png) [@rcoundon](https://discuss.elastic.co/u/rcoundon)
#### Post date: [September 17, 2018, 1:54pm UTC](https://discuss.elastic.co/t/no-results-found-for-view-transaction-in-discover/148740/10 "2018-09-17T13:54:00Z")

</div>

Yes - I've already tried reloading and accepting the overwrite but the message persists. I have a dashboard that contains some APM objects, should I go and delete that and try again?

---

<div class="post-metadata">

### Author: ![sqren](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sqren/32/26110_2.png) [@sqren](https://discuss.elastic.co/u/sqren)
#### Post date: [September 17, 2018, 2:39pm UTC](https://discuss.elastic.co/t/no-results-found-for-view-transaction-in-discover/148740/11 "2018-09-17T14:39:23Z")

</div>

Yes, you could try deleting the APM objects (visualisations and dashboards), and the APM index patterns via /app/kibana#/management/kibana/indices.

Now you should no longer get an error, when you import the objects via Getting Started instructions (/app/kibana#/home/tutorial/apm).

I'm still interested to see the output of the above query.

---

<div class="post-metadata">

### Author: ![rcoundon](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rcoundon/32/30010_2.png) [@rcoundon](https://discuss.elastic.co/u/rcoundon)
#### Post date: [September 17, 2018, 5:59pm UTC](https://discuss.elastic.co/t/no-results-found-for-view-transaction-in-discover/148740/12 "2018-09-17T17:59:04Z")

</div>

> [@sqren](#):
>
> GET .kibana/\_search { "size": 10, "\_source": ["type", "updated\_at", "index-pattern.title"], "query": { "prefix" : { "index-pattern.title" : "apm" } } }

Apologies - missed your request for the query output.

```
 {
  "took": 1,
  "timed_out": false,
  "_shards": {
    "total": 1,
    "successful": 1,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": 2,
    "max_score": 1,
    "hits": [
      {
        "_index": ".kibana",
        "_type": "doc",
        "_id": "index-pattern:apm-*",
        "_score": 1,
        "_source": {
          "index-pattern": {
            "title": "apm*"
          },
          "updated_at": "2018-09-17T07:36:59.321Z",
          "type": "index-pattern"
        }
      },
      {
        "_index": ".kibana",
        "_type": "doc",
        "_id": "index-pattern:bec35920-64e2-11e8-a49b-cf834cb72410",
        "_score": 1,
        "_source": {
          "index-pattern": {
            "title": "apm*"
          },
          "updated_at": "2018-09-17T07:37:06.312Z",
          "type": "index-pattern"
        }
      }
    ]
  }
}

```

---

<div class="post-metadata">

### Author: ![rcoundon](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rcoundon/32/30010_2.png) [@rcoundon](https://discuss.elastic.co/u/rcoundon)
#### Post date: [September 17, 2018, 6:03pm UTC](https://discuss.elastic.co/t/no-results-found-for-view-transaction-in-discover/148740/13 "2018-09-17T18:03:51Z")

</div>

I've now deleted and reloaded the Kibana APM objects. I still get the message on the APM screen that there's no APM index pattern however I do only have one index pattern listed. The result of that query is now:

```
{
  "took": 5,
  "timed_out": false,
  "_shards": {
    "total": 1,
    "successful": 1,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": 1,
    "max_score": 1,
    "hits": [
      {
        "_index": ".kibana",
        "_type": "doc",
        "_id": "index-pattern:apm-*",
        "_score": 1,
        "_source": {
          "index-pattern": {
            "title": "apm*"
          },
          "updated_at": "2018-09-17T18:01:34.456Z",
          "type": "index-pattern"
        }
      }
    ]
  }
}
```

---

<div class="post-metadata">

### Author: ![sqren](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sqren/32/26110_2.png) [@sqren](https://discuss.elastic.co/u/sqren)
#### Post date: [September 17, 2018, 7:44pm UTC](https://discuss.elastic.co/t/no-results-found-for-view-transaction-in-discover/148740/14 "2018-09-17T19:44:50Z")

</div>

Thanks for posting the query result. Very useful.

Now I'm interested in knowing whether Kibana is correctly picking up your changes to kibana.yml. There is no direct way to figure this out, so it'll be slightly messy. I hope you'll indulge me 🙂

After opening the APM tab in Kibana, please click "View source" in your browser and search for "apmIndexPattern" - it should be hiding inside a blob of urlencoded data. I'm interested in the first 60ish characters after `apmIndexPattern` like:

"apmIndexPattern&quot;:&quot;apm\*&quot;,&quot"

---

<div class="post-metadata">

### Author: ![rcoundon](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rcoundon/32/30010_2.png) [@rcoundon](https://discuss.elastic.co/u/rcoundon)
#### Post date: [September 17, 2018, 7:54pm UTC](https://discuss.elastic.co/t/no-results-found-for-view-transaction-in-discover/148740/15 "2018-09-17T19:54:14Z")

</div>

Happy to help! I've removed the IP address, hopefully this gives you what you need

`apmIndexPattern&amp;quot;:&amp;quot;apm*&amp;quot;,&amp;quot;isCloudEnabled&amp;quot;:false,&amp;quot;elasticsearchUrl&amp;quot;:&amp;quot;http://[REDACTED]:9200&amp;quot;,&amp;quot;esRequestTimeout&amp;quot;:30000,&amp;quot;esShardTimeout&amp;quot;:30000,&amp;quot;esApiVersion&amp;quot;:&amp;quot;master&amp;quot;,&amp;quot;esDataIsTribe&amp;quot;:false,&amp;quot;kbnIndex&amp;quot;:&amp;quot;.kibana&amp;quot;,&amp;quot;kbnBaseUrl&amp;quot;:&amp;quot;/app/kibana&amp;quot;,&amp;quot;vegaConfig&amp;quot;:`

---

<div class="post-metadata">

### Author: ![sqren](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sqren/32/26110_2.png) [@sqren](https://discuss.elastic.co/u/sqren)
#### Post date: [September 19, 2018, 8:45am UTC](https://discuss.elastic.co/t/no-results-found-for-view-transaction-in-discover/148740/16 "2018-09-19T08:45:27Z")

</div>

Hi rcoundon,

From the encoded blob, I can see that your config change works, and `apm*` is the index pattern title we are looking for. I can also see that you index pattern is correctly created with a title of `apm*`. Therefore it should work as expected.

Since you are still seeing an error message, there must be an error elsewhere, and I'll have to spent some more time looking into this before I can give you a good answer. I don't have a timeline right now for when that'll be.

---

<div class="post-metadata">

### Author: ![rcoundon](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rcoundon/32/30010_2.png) [@rcoundon](https://discuss.elastic.co/u/rcoundon)
#### Post date: [September 19, 2018, 8:58am UTC](https://discuss.elastic.co/t/no-results-found-for-view-transaction-in-discover/148740/17 "2018-09-19T08:58:03Z")

</div>

Hi - no problem, let me know if you need anything more from me to assist.

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [October 10, 2018, 4:58am UTC](https://discuss.elastic.co/t/no-results-found-for-view-transaction-in-discover/148740/18 "2018-10-10T04:58:09Z")

</div>

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