July 28, 2022 at 1:34 pm
Hi,
I have a requirement to import data from Oracle to Azure in a ADF pipeline, I configured and tested the Data Collection aspects as well as as file-watcher and SQL agent, when I test the data processing aspect I get the error.
Error code2402
Failure typeUser configuration issue
DetailsExecution fail against sql server. Sql error number: 50000. Error Message: <PROC Name="SDB-MTP-AUDIT-ZAN.execution.spRunSQLAgentJob" Start="14:36:45:647"> <Params>@job_name=CMS_stamtptapsbizan_PM_EMP_csv_SDB_MTP_TBI_PM_STG_ZAN_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_stamtptapsbizan_PM_EMP_csv_SDB_MTP_TBI_PM_STG_ZAN_CMS_Raw_Case_Emp') does not exist.</MSG> </Error> </PROC>
I have checked the configuration tables and ensured the agent name is present, further more when I pass variables to the stored procedure the pipeline is trying to run there is no error.
Thanks and regards,
July 29, 2022 at 2:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
February 8, 2023 at 3:03 am
Hmm, small world 😛
I assume you already resolved this Lawson.
For the rest looking for a solution to this error.
You can try the following:
Check your SSIS Execution reports for the error code '14262'. The package above is either executed in a SSIS package or in a SP.
If you have a config table where you store all details for stored procedures and parameters to pass when calling a SP. You can ensure that the details in that table and the parameters passed in the pipeline correspond.
This example is however difficult to resolve without more context.
Usually when you get a 50000 SQL Server Error, it relates to user setups.
Hope this helps 😉
Regards
Leo
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply