Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.

Reply
ramankr48
Helper I
Helper I

Getting error or issue while updating the column in log table in datawarehouse

Hi Team,

 

I have deigned a pipeline where iam running store procedure then updating the pipeline status into the table using script activity, but it's not changing, I have tried different method, check below the sc

 

In this method script activity throwing error saying {Incorrect syntax near '='.}

Screenshot 2025-04-17 194412.pngScreenshot 2025-04-17 194445.png

also tried with this method, creating a parameter at scrpt level


Screenshot 2025-04-17 194504.pngScreenshot 2025-04-17 194516.png

but status is same as default not changing even when sp getting successfully executed

1 ACCEPTED SOLUTION
v-sathmakuri
Community Support
Community Support

Hi @ramankr48 ,

 

Thank you for reaching out to Microsoft Fabric Community.

 

please use the below script in the expression builder to update the Pipeline_Metadata_Log table with success status for the current run id.

 

@{concat('UPDATE Pipeline_Metadata_Log SET Status = ''Success'' WHERE PipelineRunId= ''', pipeline().RunId, '''')}

 

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

 

Thank you!!

View solution in original post

5 REPLIES 5
v-sathmakuri
Community Support
Community Support

Hi @ramankr48 ,

 

Thank you for reaching out to Microsoft Fabric Community.

 

please use the below script in the expression builder to update the Pipeline_Metadata_Log table with success status for the current run id.

 

@{concat('UPDATE Pipeline_Metadata_Log SET Status = ''Success'' WHERE PipelineRunId= ''', pipeline().RunId, '''')}

 

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

 

Thank you!!

Hi @v-sathmakuri 

the solution you provided it worked, but the same update statement I have tried in adf it worked there but it's not working in fabric,
1. what is the reason??

2. so do we need to pass the sql statements in script like this always 

This can be done without the concat as well as stated below wherein replace == with =




----------------------------------------------------------------------------------------------
Nandan Hegde (MSFT Data MVP)
LinkedIn Profile : www.linkedin.com/in/nandan-hegde-4a195a66
GitHUB Profile : https://github.com/NandanHegde15
Twitter Profile : @nandan_hegde15
MSFT MVP Profile : https://mvp.microsoft.com/en-US/MVP/profile/8977819f-95fb-ed11-8f6d-000d3a560942
Topmate : https://topmate.io/nandan_hegde
Blog :https://datasharkx.wordpress.com
NandanHegde
Super User
Super User

you need to update the script activity and use a single = rather than ==

where pipelinerunid = 




----------------------------------------------------------------------------------------------
Nandan Hegde (MSFT Data MVP)
LinkedIn Profile : www.linkedin.com/in/nandan-hegde-4a195a66
GitHUB Profile : https://github.com/NandanHegde15
Twitter Profile : @nandan_hegde15
MSFT MVP Profile : https://mvp.microsoft.com/en-US/MVP/profile/8977819f-95fb-ed11-8f6d-000d3a560942
Topmate : https://topmate.io/nandan_hegde
Blog :https://datasharkx.wordpress.com

I had tried this earlier also, it was not working, gave some error

Helpful resources

Announcements
FBCApril_Carousel

Fabric Monthly Update - April 2025

Check out the April 2025 Fabric update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors