Azure IoT Hub
An Azure service that enables bidirectional communication between internet of things (IoT) devices and applications.
1,138 questions
Connecting Streamanalytics to IoTHub
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 81%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGQ%3C/text%3E%3C/svg%3E)
Georgios - QU
0
Reputation points
Hi all,
We're facing the issue that since 2 days ag
We're getting the problem that
"Stream Analytics job has validation errors: Unable to connect to IoT Hub using connection string. Please make sure you have configured the IoT Hub input correctly. Input was selected from IoT Hub from subscription".
Confusing is the fact that everything worked fine until 2 days ago. The issue started with the point that our Watermark delay went to 48 hours.
Thank you for your support.
Georgios
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 74%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
AshokPeddakotla-MSFT 28,751 Reputation points2023-06-20T02:22:56.3833333+00:00 Georgios - QU Greetings & Welcome to Microsoft Q&A forum!
"Stream Analytics job has validation errors: Unable to connect to IoT Hub using connection string. Please make sure you have configured the IoT Hub input correctly. Input was selected from IoT Hub from subscription"
I understand that it was working fine earlier.
Can you confirm what exactly is changed when you say, "The issue started with the point that our Watermark delay went to 48 hours." ?
Did you change any configuration or Keys? Make sure you are using latest key.
Can you try by selecting Provide IoT Hub settings manually and enter required details?
-
Georgios - QU 0 Reputation points
2023-06-20T08:21:13.71+00:00 On Thursday we were migrated to the new DigiCert C2 Global C2. Systems showed normal behavior on Thursday and Friday without any issues. The 2 systems create about 10.000 messages per day with operating times from 6:30 to 21:30.
The issue started on Friday 01:10 a.m. with the continuous increase of the watermark delay from 10 seconds to about 50 hours.
Yesterday we switched off the stream analytics job. Restarting has not been not successful.
We followed your suggestion unfortunately without success. We also tried to regenerate the Primary Key and obtained the following response:
Unable to build a valid connection string with the given parameters. Error message: A duplicate property 'SharedAccessKeyName' was found in the Service Bus connection string.Later we made a roll-back of the certificate to Baltimore root, also without success.
Some boundary information:
The devices generating the data of running correctly. We could also see the increasing number of messages in the IoT Hub Overview. Both devices are Raspberry Pi 4B.
Also we have a number of other systems using different IoT hubs and different stream analytics that show no issues. -
AshokPeddakotla-MSFT 28,751 Reputation points
2023-06-20T09:41:41.7633333+00:00 Georgios - QU Thanks for sharing the additional information.
For a deeper investigation and immediate assistance on this issue, please file a support request @ https://aka.ms/azsupt? If you do not have access to a support plan, let us know.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 15%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKG%3C/text%3E%3C/svg%3E)
Keith Graham 0 Reputation points2024-05-16T07:00:47.45+00:00 I am having in a similar issue.
I can connect the OUTput to a postgress DB and table fine but the Input from IotHub throws an error that it can not use a connection string check your IoTHub settings (see below).
I have tried using iothubowner and also the Service and it makes no difference.
I have removed IPfiltering for not Default no difference.
I have used the $Default and a new connection group - no difference.They whole point it that these service's should be EASY to connect and use and it fills in the defaults - which it does.
What am I doing wrong ??
Thanks,
KeithUnable to connect to IoT Hub 'iam-iothub' using connection string. Please make sure you have configured the IoT Hub input correctly. Exception details Microsoft.Azure.Amqp.AmqpException: Unauthorized access at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at Microsoft.Azure.Amqp.AsyncResult.EndTAsyncResult at Microsoft.Azure.Amqp.AmqpObject.OpenAsyncResult.End(IAsyncResult result) at Microsoft.Azure.Amqp.AmqpObject.EndOpen(IAsyncResult result) at System.Threading.Tasks.TaskFactory
1.FromAsyncCoreLogic(IAsyncResult iar, Func2 endFunction, Action1 endAction, Task1 promise, Boolean requiresSynchronization) --
Sign in to comment