Where can I find the error log in Azure Synapse?

Question

One of our pipelines failed with below error code.

Mosty common explanation in online forums are this is due to data type or data size mismatch between source and target. I want to know the table this is happening...I am hoping looking at log error files will give me that information.

So where can I find detailed error log?

{ "errorCode": "ActionFailed", "message": "Activity failed because an inner activity failed; Inner activity name: SSR_INCREMENTAL_TO_DW, Error: Failure happened on 'Sink' side. ErrorCode=SqlOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=A database operation failed. Please search error to get more details.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.Data.SqlClient.SqlException,Message=PdwManagedToNativeInteropException ErrorNumber: 46724, MajorCode: 467, MinorCode: 24, Severity: 20, State: 2, Exception of type 'Microsoft.SqlServer.DataWarehouse.Tds.PdwManagedToNativeInteropException' was thrown.,Source=.Net SqlClient Data Provider,SqlErrorNumber=100000,Class=16,ErrorCode=-2146232060,State=1,Errors=[{Class=16,Number=100000,State=1,Message=PdwManagedToNativeInteropException ErrorNumber: 46724, MajorCode: 467, MinorCode: 24, Severity: 20, State: 2, Exception of type 'Microsoft.SqlServer.DataWarehouse.Tds.PdwManagedToNativeInteropException' was thrown.,},],'", "failureType": "UserError", "target": "ForEach1", "details": "" }

Answer 1

Hello,

I'd recommend take a look at your ADW column sizes as mentioned in a similar thread:

https://stackoverflow.com/questions/51656521/copy-activity-is-failing-with-the-following-error

"This error occurs when one or more columns of destination have defined size lesser than the data which you are trying to copy. Just increase the size of the columns and your ADF will run smoothly." - Saurabh Porwal

On the other hand, you can try implementing some catch logic:

Errors and Conditional execution

https://learn.microsoft.com/en-us/azure/data-factory/tutorial-pipeline-failure-error-handling

---

If this is helpful please accept answer.

Answer 2

Hi Gunawardena, Udeshka,
Thank you for your response.
To determine the table where the error occurred, you can look for more information in the error message and stack trace. The error message may contain the name of the table or the SQL statement that caused the error. You can also look for more information in the diagnostic logs for Azure Synapse Analytics, which can provide more detailed information about the error.

Reference link: https://bradleyschacht.com/log-analytics-with-azure-synapse-analytics/
I hope this suggestion helps you. Let me know if you have any further questions or concerns.