photo

Darren Dawson

shared this problem
5 months ago

Employees Involved

photo

DMT Support Team

Admin

Statistics

2
Comments
1
Views

Relates to

Share

1
votes

Error 46724

I getting this error migrating one table from SQL Server to Azure SQL Data Warehouse, all other tables were successful.

Full Error Message:

Description: Data write error

Message: PdwManagedToNativeInteropException ErrorNumber: 46724, MajorCode: 467, MinorCode: 24, Severity: 20, State: 2, Exception of type 'Microsoft.SqlServer.DataWarehouse.Tds.PdwManagedToNativeInteropException' was thrown.

19000000 row(s) are successfully migrated.

1000000 row(s) are failed to migrate.

Processed 20000000 row(s) out of total 150633468.

Please advise how to resolve.

Add Comment

Comments (2)

photo Employee
1

Hello Darren,

To investigate your issue we need additional information. Could you provide us source and target tables structure (columns and their type) and columns mapping (if they have different names)? We are going to fill up tables with various data (including boundary values) and try to reproduce and fix issue on our side.

photo Employee
1

If it is convenient, you can get support by e-mail at product-support@dbbest.com.

Leave Comment

photo

Attach files...

The file must be a jpg, gif, png, bmp, ico, pdf, doc, rtf, txt, zip or rar no more than 2M