SOLVED

Dedicated sql pool error log files

Copper Contributor

One of my pipelined failed with following error.

 

Most online forums suggest this is due to a data type or data size mismatched between source and target.

 

My question is how do I find more details on which table/column in sql pool is causing this?

 

Pipeline loads many tables and error copied below doesn't specify the table/column causing the failure  

 

 

 

{ "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": "" }

6 Replies
did you check the output ? also do you log the errors? if you log the errors, you will find the file number of the log error on the output

@AstridMalanka - Thank you for your response.

 

Where can I find error log files?

if you connected it, probably on the storage you chose under a container called probably errorlogging.

in order to enable the error logging you got to the setting (on the copy for example), and fill up the enable logging on the setting tab.

Thank you again. I am going to see if we have any error logging enabled.
kindly share if there are any documentation about enabling error logging,
best response confirmed by udeshka23 (Copper Contributor)
Thank you. Appreciate a lot!
1 best response

Accepted Solutions