ADF Pipeline is failing randomly - The service has encountered an error processing your request. Please try again. Error code 9001.

Question

ADF Pipeline is failing randomly with below error:

peration on target xxxxxx failed: {"StatusCode":"DFExecutorUserError","Message":"Job failed due to reason: at Sink 'xxxx': shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerException: The service has encountered an error processing your request. Please try again. Error code 9001.","Details":"shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerException: The service has encountered an error processing your request. Please try again. Error code 9001.\n\tat shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262)\n\tat shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1632)\n\tat shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatementBatch(SQLServerStatement.java:944)\n\tat shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerStatement.access$200(SQLServerStatement.java:51)\n\tat shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtBatchExecCmd.doExecute(SQLServerStatement.java:905)\n\tat shaded.msdataflow.com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7418)\n\tat shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:3272)\n\tat shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServer"}

Need urgent assistance to fix the issue.

Answer 1

Hello @Twisha Mistry ,
Thanks for the question and using MS Q&A platform.
As we understand the ask here is how to get rid of the random error called out above , please do let us know if its not accurate.
Since its random , it will need more investigation as the failure is not consistent .
But If possible I think you can set th eretry option and let the application recover itself .

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