How to fix We cannot connect to Event Hub partition [0] because the maximum number of allowed receivers per partition in a consumer group has been reached
We cannot connect to Event Hub partition [0] because the maximum number of allowed receivers per partition in a consumer group has been reached. Ensure that other Stream Analytics jobs or Service Bus Explorer are not using the same consumer group. The…
![](https://techprofile.blob.core.windows.net/images/xa5h60Ksy0O79EPsi4I_eQ.png?8DAD44)
I am trying to configure cosmos db output in stream analytics job, getting error as This subpartitioned container has more than 1 partition key path please use `PartitionKeyPaths`, But there is no option to configure path in output settings
I am trying to configure cosmos db output in stream analytics job, getting error as This subpartitioned container has more than 1 partition key path please use PartitionKeyPaths, But there is no option to configure path in output settings. How this can…
Debugging Data Loss in Stream Analytics to Event Hubs
A stream analytics job has been set up to transfer data from a blob storage account to Event Hubs and subsequently into a Kusto database. There is an observed data loss of 10% compared to the original blob storage account. What methods are available to…
Stopping Stream Analytics Job
Hello, I just want to ask if stopping Stream Analytics Job also means it will stop incurring cost? or it needs to be deleted? Thank you.
Cannot start stream analytics job in Vnet (cannot acquire managed identity)
Hello, I have set up an Azure Stream Analytics job that is injected into a virtual network (VNet). The job is connected to the following resources, all of which are linked to the VNet via private endpoints: Storage Account: I authenticate using the…
Stream Analytics job does not stream the data to the database
I have a Python script that sends data to the IoT Hub using MQTT. A message routing configuration is set up to route the data to a Blob storage, and this part is working as expected—I can see the data in the storage. My next goal is to route the data to…
Adjusting Lateness Tolerance in Azure Stream Analytics
A query is being run using Azure Stream Analytics to send data binned by hour into an event hub, which subsequently sends it into a Kusto database. However, there appears to be an issue, as approximately 1,000 messages are missed each day. The logs…
Debugging Data Loss in Stream Analytics to Event Hubs and ADF
My goal is to stream telemetry data from blob storage files into a Azure Data Factory database. I have set up a stream analytics job that takes data from blob storage, bins it by hour, and then passes it through an event hub with two partitions in order…
Stream RealTime data from an On Prem Microsoft Server to a Azure Data Lake.
There is a need for Real Time data to be collected from a On Prem SQL Server. This means ADF is not suitable because it only does batch. Azure Streaming Analytics only connects to Azure SQL Server and not on prem. Has anybody else encountered this and…
![](https://techprofile.blob.core.windows.net/images/xa5h60Ksy0O79EPsi4I_eQ.png?8DAD44)
How to configure late arrival policy to handle events that arrive later than configured tolerance window
I want to configure a late arrival policy and increase the tolerance of my Stream Analytics. While I can see documentation explaining late arrival policies…
duplicate key value violates unique constraint
Hi, I'm experiencing this issue from time to time when inserting values into a PostgreSQL database as output from the stream analytic, every 15 minutes Here the detailed version of it: First Occurred: 1/7/2025 8:09:22 PM UTC | Resource Name:…
How to enable Stream Analytics Job in EAST US 2 EUAP and CENTRAL US EUAP canary regions?
We couldn't create Stream Analytics Jobs in our EUAP Canary Production Subscriptions on East US 2 EUAP and Central US EUAP. Could you help allow EUAP on these subscriptions or tell me which TSG or doc I should follow? Error:…
Stream Analytics: Referring an input from blob storage in JOIN resulted "The join predicate is not time bounded. JOIN operation between data streams requires specifying max time distances between matching events. Please add DATEDIFF to the JOIN"
Hello, I'm trying to refer a blob storage input config in our query window to determine the threshold value of the event value. But while joining the 2 tables resulting in below error: The join predicate is not time bounded. JOIN operation between data…
Azure Stream Analytics Job Produces No Output Despite Successful Query Tests and No Runtime Error
Hello, I am encountering an issue with my Azure Stream Analytics job. The job runs without any errors in the monitoring metrics, and when I test the queries individually using the query editor, they produce the expected results. However, the job does not…
Azure Function cannot process data streaming at 10 Hz
Hi I have the following architecture I am using the Azure Function to be able to save data in CosmosDB for Mongo since this is not supported by the Azure Streaming Analytics API and we need to use MongoDB. All is working but when I test with…
What are the feature supported by IoT Edge jobs for Stream Analytics
I want to write UDF for IoT Edge Stream Analytics, but seems it does not support by IoT Edge job of stream analytics. Can someone confirm, below limitations are still valid for IoT Edge jobs of stream analytics ? Found from this old link.
What factors affect the CPU utilization of Stream Analytics jobs?
I have two Stream Analytics jobs with the same configuration. One processes approximately 500k input events daily, while the other processes only 10k. However, the job that processes 10k input events daily consistently has a CPU utilization of 80%, an…
Azure Stream Analytics Job to save data to CosmosDB for Mongo
Hi I am creating an IoT solution I have connected the Azure Stream Analytics job with CosmosDB NoSQL and it si working fine, but I would like to connect to the CosmosDB for Mongo since we are used to work with Mongo DB. More over The CosmosDB is…
When will the Kafka as an input source for Azure Stream Analytics become general available
Kafka as an input source for Azure Stream Analytics is now almost in public preview for one year. I wonder when it becomes GA. Thanks See https://learn.microsoft.com/en-us/azure/stream-analytics/stream-analytics-define-kafka-input
Where is the difference between "Real-Time-Intelligence" in Fabric and "Azure Stream Analytics"?
HI, https://learn.microsoft.com/en-us/fabric/get-started/microsoft-fabric-overview has as components (a.o.) Real-Time Intelligence and some Synapse-Services. But in https://learn.microsoft.com/en-us/fabric/real-time-intelligence/overview Stream Analytics…