User configuration issue : Sql error number: 50000. : ADF

Question

User configuration issue : Sql error number: 50000. : ADF

Nithin kv 6

We are getting below error on ADF stored procedure activity, some times it's getting failed with below error and it will get succeed after re-try and it's impacting the overall performance.
Error code
2402
Failure type
User configuration issue
Details
Execution fail against sql server. Please contact SQL Server team if you need further support. Sql error number: 50000. Error Message: Parse error at line: 2, column: 772: Incorrect syntax near 'NULL'.

HimanshuSinha-msft 19,486 Reputation points Microsoft Employee Moderator

2023-01-06T23:19:48.847+00:00
Hello @Nithin kv ,
Thanks for the question and using MS Q&A platform.
As we understand the ask here is how to get rid of Sql error number: 50000 , please do let us know if its not accurate.
Let me start withe that the error which you are seeing is from SQL and not from ADF , ADF is just catching the exception from SQL and showing here .
The error id : 500000 is the default when you raiseerror .

I will suggest you to look into the procedure . Since it self heals may be its related to some data .

Please do let me if you have any queries.
Thanks
Himanshu

Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how

Want a reminder to come back and check responses? Here is how to subscribe to a notification

If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators
HimanshuSinha-msft 19,486 Reputation points Microsoft Employee Moderator

2023-01-19T20:12:02.77+00:00

Hello @Nithin kv ,
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 back with the more details and we will try to help . Thanks Himanshu

Your answer

HimanshuSinha-msft 19,486 Reputation points Microsoft Employee Moderator

2023-01-06T23:19:48.847+00:00

Hello @Nithin kv ,
Thanks for the question and using MS Q&A platform.
As we understand the ask here is how to get rid of Sql error number: 50000 , please do let us know if its not accurate.
Let me start withe that the error which you are seeing is from SQL and not from ADF , ADF is just catching the exception from SQL and showing here .
The error id : 500000 is the default when you raiseerror .

I will suggest you to look into the procedure . Since it self heals may be its related to some data .

Please do let me if you have any queries.
Thanks
Himanshu

Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how

Want a reminder to come back and check responses? Here is how to subscribe to a notification

If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators
HimanshuSinha-msft 19,486 Reputation points Microsoft Employee Moderator

2023-01-19T20:12:02.77+00:00

Hello @Nithin kv ,
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 back with the more details and we will try to help . Thanks Himanshu

Share via

User configuration issue : Sql error number: 50000. : ADF

Your answer