CODEWITHSUNDEEP
azure-data-factory
Geekn
Geekn

Reputation: 2882

How to debug DataFlow exception

I am receiving the following error condition in an Azure Data Factory data flow that looks like the picture below.

enter image description here

{"message":"DSL stream  has parsing errors\nLine 11 Position 207: token recognition error at: '\\n'. Details:DSL stream  has parsing errors\nLine 11 Position 207: token recognition error at: '\\n'","failureType":"UserError","target":"df_ReplicaSync","errorCode":"DFExecutorUserError"}

How does one debug this? It has no reference to any activity, operation, or parameter? I tried looking at the line in the JSON code for each activity in the data flow but no help.

UPDATE:

There was a line feed in the expression builder window where you build the T-SQL. It will not complain about it but it will add a new line character that will cause this issue at runtime.

enter image description here

enter image description here

When viewing the script as Mark suggested

enter image description here

Upvotes: 2

Views: 4459

Answers (1)

Mark Kromer MSFT
Mark Kromer MSFT

Reputation: 3838

DSL is referring to the data flow script (https://learn.microsoft.com/en-us/azure/data-factory/data-flow-script) that is behind the map. You can see it by clicking on the Script button on the top right. If you click on it for your data flow, you can find the location of the error via Line 11, Pos 207.

Upvotes: 2

Related Questions