CTI generation has stopped

Question

My server is currently in a state where events are coming into the system but they are not being consumed. There do not appear to be any CTIs produced for any of the queries. The CTIs appear to be going into the Input Adapter however the CleanseInput shows no CTIs.

Any idea what could be causing this? All queries appear to still be in a Running state and not suspended. The memory consumption is sitting at 30%, so not unreasonably high. 

Answer 1

What are your AdvanceTimeSettings? Or are you enqueuing the CTIs directly from the input adapter without specifying any AdvanceTimeSettings?

---

DevBiker (aka J Sawyer)
Microsoft MVP - Sql Server (StreamInsight)

---

---

If I answered your question, please mark as answer.
If my post was helpful, please mark as helpful.

Answer 2

The CTIs are being enqueued directly from the input adapter, but has been modeled to be StrictlyIncreasing.

Answer 3

If you are enqueuing your CTIs in the input adapter, you should be specifying the advance time generation settings when creating the stream. Remove that and see how things go.

---

DevBiker (aka J Sawyer)
Microsoft MVP - Sql Server (StreamInsight)

---

---

If I answered your question, please mark as answer.
If my post was helpful, please mark as helpful.

Answer 4

Sorry, I just wanted to be clear. Did you mean I shouldn't be specifying the Advance Time Generation Settings, if I am enqueuing the CTIs. I am still specifying them, but you are saying I should not be?

Thank you for the clarification.

 

Answer 5

Correct. You should do one or the other, not both.

IIRC, the AdvanceTimeGenerationSettings will override your enqueued CTIs.

---

DevBiker (aka J Sawyer)
Microsoft MVP - Sql Server (StreamInsight)

---

---

If I answered your question, please mark as answer.
If my post was helpful, please mark as helpful.