Azure data factory web variable

Question

Hi all,

I am trying to send an email body from variable but i got this error below.

{"error":{"code":"NoResponse","message":"The server did not receive a response from an upstream server. Request tracking id '08585100121591438405849018936CU00'."}}

Variable is below.

{
	"name": "ExecutionLog",
	"value": "{\"message\":\"{\\\"StatusCode\\\":\\\"DFExecutorUserError\\\",\\\"Message\\\":\\\"Job failed due to reason: at Sink \\\"CDCcBranches\\\": Cannot find the object \\\\\\\"c_branches\\\\\\\" because it does not exist or you do not have permissions.\\\",\\\"Details\\\":\\\"shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object \\\\\\\"c_branches\\\\\\\" because it does not exist or you do not have permissions.\\\\n\\\\tat shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:265)\\\\n\\\\tat shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1673)\\\\n\\\\tat shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:907)\\\\n\\\\tat shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:802)\\\\n\\\\tat shaded.msdataflow.com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7627)\\\\n\\\\tat shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:3912)\\\\n\\\\tat shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:268)\\\\n\\\\tat shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerStatemen\\\"}\",\"failureType\":\"UserError\",\"target\":\"CDC_c_branches\"}"
}

Can you please tell me what is wrong.

Thanks

Answer 1

The error message you are encountering indicates an issue with the SQL Server object "c_branches". There are two probable causes for this error:

• The specified object "c_branches" may not exist in the database you are targeting. Ensure that the object (likely a table or a view) exists in the specified database and that you're connecting to the correct database.
• The user that you are connecting with may not have the necessary permissions to access or manipulate the "c_branches" object. Check the permissions for the user associated with the connection and make sure that they have the appropriate rights.

Try to check if the object "c_branches" actually exists in your database. Run a query to see if you can retrieve information about it, or check directly within your SQL Server Management Studio or other database tools.

Also, verify that the user you're connecting with has the necessary permissions to access the "c_branches" object. If not, you may need to grant the necessary permissions.