Well, you might have encountered this weird issue
status code:400, com.microsoft.dataflow.broker.invalidoperationexception DSL complication failed – DSL stream has parsing errors excepting decimal_literal,hex_literal,oct_literal,binary_literal,max_int,min_int,max_long,parameters,functions,stores,inputs,output,constants,open_interpolate
while using Azure data factory, Data flow components. Then we will try to help you to fix this error with a simple technique. Obviously this error message doesn’t help at all like many other error messages. Lot of jargons but not a simple message that can help.
When I got this issue I searched over google and other forums for hours to find something on this issue but couldn’t get any information.
So coming back to solution, you have faced this issue in Source activity in Data flows when trying Data preview. Source activity contain few things to suspect on, but query section is the main one. If you clearly see the error message last before line, you can see Line 5 Position 20
this type of error we majorly see in SQL server when we have an issue in the SQL query. But query will execute without any errors if you execute it normally with database management systems on Source system. That is where it is very frustrating to debug this error.
If your query in multi line like below
You can convert multi line to a single line query as below.
It should fix you are error.
© 2023, Datalieve . All rights reserved.
Leave a Reply