Azure / Azure/azure-stream-analytics

Edge Stream analytics can't add SQL database output.

Open
#162 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
C#
Stars
229
Forks
920
PR merge metrics
No merged PRs in 30d

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:
1. Add SQL database table to an Stream Analytics Edge job
2. Reference it in the query
3. 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.

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.