AzureMLException: Error in Streaming from Input Data Sources

Question

An AzureMLException is encountered with the message "Error Code: ScriptExecution.StreamAccess.Unexpected Native Error: error in streaming from input data sources" when using the 'Apply SQL Transformation' component in the Azure ML designer during model scoring and training. This was working previously. Also created a basic flow in designer with minimum dataset and a basic select statement in the SQL transformation, same error is encountered.

The error details are as follows:

AzureMLException: Message: Error Code: ScriptExecution.StreamAccess.Unexpected Native Error: error in streaming from input data sources StreamError(Unknown("Dataflow at inmemory://dataflow/a9827b8da4d93cdfae79983b16412044 is not valid.", Some(DataflowInvalid("inmemory://dataflow/a9827b8da4d93cdfae79983b16412044", VisitError(ExecutionError(ArgumentError(InvalidArgument { argument: "writer", expected: "preppy|delimited|parquet", actual: "dfd" }))))))) => Dataflow at inmemory://dataflow/a9827b8da4d93cdfae79983b16412044 is not valid. Unknown("Dataflow at inmemory://dataflow/a9827b8da4d93cdfae79983b16412044 is not valid.", Some(DataflowInvalid("inmemory://dataflow/a9827b8da4d93cdfae79983b16412044", VisitError(ExecutionError(ArgumentError(InvalidArgument { argument: "writer", expected: "preppy|delimited|parquet", actual: "dfd" })))))) => Dataflow at inmemory://dataflow/a9827b8da4d93cdfae79983b16412044 is not valid. DataflowInvalid("inmemory://dataflow/a9827b8da4d93cdfae79983b16412044", VisitError(ExecutionError(ArgumentError(InvalidArgument { argument: "writer", expected: "preppy|delimited|parquet", actual: "dfd" })))) Error Message: Got unexpected error: Dataflow at inmemory://dataflow/a9827b8da4d93cdfae79983b16412044 is not valid.. DataflowInvalid("inmemory://dataflow/a9827b8da4d93cdfae79983b16412044", VisitError(ExecutionError(ArgumentError(InvalidArgument { argument: "writer", expected: "preppy|delimited|parquet", actual: "dfd" }))))| session_id=e2d026ac-7e1f-46ab-a813-87371a12999a InnerException None ErrorResponse { "error": { "message": "\nError Code: ScriptExecution.StreamAccess.Unexpected\nNative Error: error in streaming from input data sources\n\tStreamError(Unknown(\"Dataflow at inmemory://dataflow/a9827b8da4d93cdfae79983b16412044 is not valid.\", Some(DataflowInvalid(\"inmemory://dataflow/a9827b8da4d93cdfae79983b16412044\", VisitError(ExecutionError(ArgumentError(InvalidArgument { argument: \"writer\", expected: \"preppy|delimited|parquet\", actual: \"dfd\" })))))))\n=> Dataflow at inmemory://dataflow/a9827b8da4d93cdfae79983b16412044 is not valid.\n\tUnknown(\"Dataflow at inmemory://dataflow/a9827b8da4d93cdfae79983b16412044 is not valid.\", Some(DataflowInvalid(\"inmemory://dataflow/a9827b8da4d93cdfae79983b16412044\", VisitError(ExecutionError(ArgumentError(InvalidArgument { argument: \"writer\", expected: \"preppy|delimited|parquet\", actual: \"dfd\" }))))))\n=> Dataflow at inmemory://dataflow/a9827b8da4d93cdfae79983b16412044 is not valid.\n\tDataflowInvalid(\"inmemory://dataflow/a9827b8da4d93cdfae79983b16412044\", VisitError(ExecutionError(ArgumentError(InvalidArgument { argument: \"writer\"

Answer 1

serErrorException: Message: Error Code: ScriptExecution.StreamAccess.Unexpected Native Error: error in streaming from input data sources StreamError(Unknown("Dataflow at inmemory://dataflow/5167460359bc9052dc2971be19c173c4 is not valid.", Some(DataflowInvalid("inmemory://dataflow/5167460359bc9052dc2971be19c173c4",

I kept running into the same issue for the past week @kothapally Snigdha do you have any update on solutions?