Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,374 questions
ADF stored procedure glitch when ran via trigger
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(230.39999999999998, 23%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENK%3C/text%3E%3C/svg%3E)
NIKHIL KUMAR
126
Reputation points
I have a database stored procedure with one of below code snippets in it. Now problem is when I call this stored procedure via ADF pipeline stored procedure activity.
The Database SP is working as expected when ADF pipeline is ran in debug mode or SP is ran directly via SSMS, but moment I run my ADF pipeline via trigger this code snippets within SP is not working. What could be possible reasons ?
Update a
SET a.columnB = b.columnB
From tableA a
Inner join table B b
On a.columnA = b.columnA
Azure Synapse Analytics
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,624 questions
{count} votes
-
Nandan Hegde 36,146 Reputation points MVP Volunteer Moderator2023-09-28T02:48:55.09+00:00 Can you please share the error message which you are receiving in trigger mode?
-
NIKHIL KUMAR 126 Reputation points
2023-09-28T04:39:29.79+00:00 @Nandan Hegde There are no error messages pipeline gets executed with success but update query is not updating the records
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 61%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
phemanth 15,755 Reputation points Microsoft External Staff Moderator2023-09-28T10:23:24.5866667+00:00 Thanks for approaching Microsoft Q&A
try checking the trigger configuration. and the pipeline activity settings and confirm with us.
- Check the permissions of the user running the ADF pipeline and ensure that they have the necessary permissions to execute the stored procedure.
- Check the input parameters of the stored procedure and ensure that they are being passed correctly.
- Check the logs of the ADF pipeline to see if there are any error messages or warnings related to the stored procedure activity.
- Try running the stored procedure with a simple query to see if it executes successfully. If it does, gradually add complexity to the query to see where it fails.
provide some screenshots if possible!
-
phemanth 15,755 Reputation points Microsoft External Staff Moderator
2023-09-29T09:31:03.0066667+00:00 @NIKHIL KUMAR We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
-
phemanth 15,755 Reputation points Microsoft External Staff Moderator
2023-09-30T08:19:15.6466667+00:00 @NIKHIL KUMAR checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Sign in to comment
Sign in to answer