Skip to content

Edge Stream analytics can't add SQL database output. #162

@Maci3jPy

Description

@Maci3jPy

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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions