Logging Details of ADF Dataflow pipeline error message

Patil Rajas 40

Hello,

As part of logging status of each pipeline run, I need to save :

User's image

My pipeline have below actities:

1.lookup

2.ForEach : (pipeline->script for logging)

All I am trying is saving status and error details part in SQL table with insert in script.

I tried using string(@{activity('MergeFlow1').error.message}

but this is giving me entire error code as below: User's image

Since above test have some words in codes, its giving me error.

Any help will be much appreciate.

Regards,

PR

Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2024-03-06T21:33:33.8233333+00:00

Hello Patil Rajas, Welcome to the Microsoft Q&A forun.

from the error message, it seems that there is a syntax error in your SQL query, as it mentions that there is an unexpected "Status code" and an unexpected '}' in your query.

In your original query, the JSON string is enclosed within double quotes, which may cause issues if the string contains any double quotes or special characters. Can you enclose the JSON string within single quotes and see if it resolves the error? Ex: '{''statuscode'': xxx}'
Patil Rajas 40 Reputation points

2024-03-07T09:15:42.4666667+00:00

Hello BhargavaGunnam-MSFT,

I tried adding double quotes but its giving error as Double quoted string is not allowed(19)

Also, with this, I get whole message, but I want to save only details part of it in my table.

Your answer