Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
Maci3jPy opened this issue Apr 17, 2023 · 0 comments
Open

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

Maci3jPy opened this issue Apr 17, 2023 · 0 comments

Comments

@Maci3jPy
Copy link

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant