Azure data factory data processing pipeline error

Question

Azure data factory data processing pipeline error

durbslaw 1

I have a required that imports files from Oracle and bulk inserts it into SQL Azure, I have created and tested the data collection pipeline, I have configure a SQL agent to populate the Azure table with the Oracle extract, how when debugging the data processing pipeline I get the error that the agent cannot be found, I have checked the configuration table and found the entry for the agent, when I manually pass the agent name and a GUID to the stored procedure the pipeline is trying to run I don't get errors.

Error code
2402
Failure type
User configuration issue
Details
Execution fail against sql server. Sql error number: 50000. Error Message: <PROC Name="yyyy-AUDIT-ZZZZ.execution.spRunSQLAgentJob" Start="14:36:45:647">
<Params>@Job _name=CMS_12345545_PP_EMP_csv_CMS_Raw_Case_Emp @adfrunid=88191520-3BA8-447D-B5C8-5DEC0CE1FD70</Params>
<Context>Start Agent Job</Context>
<Error Num="14262" Sev="16" State="1" Time="14:36:45:660" >
<MSG>The specified @Job _name ('CMS_Raw_Case_Emp') does not exist.</MSG>
</Error>
</PROC>

Thanks and regards,

Bhargava-MSFT 31,361 Reputation points Microsoft Employee Moderator

2022-07-29T19:31:02.677+00:00

Hello @durbslaw ,

Thanks for the question and using MS Q&A platform.

Can you please help me understand your issue? You have an Azure data factory pipeline that imports files from Oracle into SQL azure.

and your pipeline failed and getting the error message, agent job cannot be found. Are you using any copy activity or stored proc to import files? and how do you reference the SQL agent job in the pipeline? are you using any Azure run books here? or any SSIS packages?

Please provide us with more details to help you unblock here.
Bhargava-MSFT 31,361 Reputation points Microsoft Employee Moderator

2022-08-02T21:21:41.92+00:00

Hello @durbslaw ,
I am just checking in to see if you have any updates here.
Bhargava-MSFT 31,361 Reputation points Microsoft Employee Moderator

2022-08-04T20:08:50.867+00:00

Hello @durbslaw ,
I am just checking in to see if you have any updates here.