-
Notifications
You must be signed in to change notification settings - Fork 930
Description
Hi,
there is an issue in the Stream Analytics Edge job. After adding SQL database as an output in the job. You can't deploy it to Edge.
Steps to reproduce:
- Add SQL database table to an Stream Analytics Edge job
- Reference it in the query
- Add the job to the edge deployment manifest, either through Azure portal or VSC.
Here is the issue that occurs during adding the SA edge job with a SQL database in the VSC extension:
Parse Stream Analytics jobs info failed: 500 - "{\"status\":\"Failed\",\"edgePackageUrl\":null,\"error\":{\"code\":\"InternalServerError\",\"message\":\"Error in line 1 position 330. 'Element' 'MaxBatchCount' from namespace 'http://schemas.datacontract.org/2004/07/Microsoft.Streaming.ObjectModel.Logical' is not expected. Expecting element 'OutputBatchMaxWaitDurationTicks | OutputBatchMinRows | RendezvousSettings | SupportsExactlyOnceDelivery | ConnectionString'.\",\"details\":null},\"manifest\":null}"
And this issue shows then I add id as a module in Azure porta:
Error in line 1 position 330. 'Element' 'MaxBatchCount' from namespace 'http://schemas.datacontract.org/2004/07/Microsoft.Streaming.ObjectModel.Logical' is not expected. Expecting element 'OutputBatchMaxWaitDurationTicks | OutputBatchMinRows | RendezvousSettings | SupportsExactlyOnceDelivery | ConnectionString'. [SessionID: c3d54b3c2f624deca62a294d0521c039]
Also you can't test the output since, it gets in the loop and never end. I tested it with Edge supported SQL server authentication.