Estou com problemas para carregar uma tabala no meu (Pool de SQL - Antigo Data Warehouse)

Question

Estou com problemas para carregar uma tabala no meu (Pool de SQL - Antigo Data Warehouse)

Ítalo Gomes 40

Estou utilizando um consulta SQL para carregar uma tabela no meu Data Warehouse e esta dando falha. Segue abaixo o erro que aparece.

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.,},],'

Bhargava-MSFT 31,226 Reputation points Microsoft Employee

2023-12-11T21:18:17.01+00:00

Hello Ítalo Gomes,

I am checking to see if you had a chance to look into my earlier response.
Ítalo Gomes 40 Reputation points

2023-12-12T14:54:32.8333333+00:00

Muito obrigado pela ajuda

]
Bhargava-MSFT 31,226 Reputation points Microsoft Employee

2023-12-16T00:11:18.3466667+00:00

Thank you, Ítalo Gomes

If you don't have any further questions, please consider accepting the answer by hitting the Accept answer and up-vote as it helps the community look for answers to similar questions.

1 answer

Your answer

Bhargava-MSFT 31,226 Reputation points Microsoft Employee

2023-12-11T21:18:17.01+00:00

Hello Ítalo Gomes,

I am checking to see if you had a chance to look into my earlier response.
Ítalo Gomes 40 Reputation points

2023-12-12T14:54:32.8333333+00:00

Muito obrigado pela ajuda

]
Bhargava-MSFT 31,226 Reputation points Microsoft Employee

2023-12-16T00:11:18.3466667+00:00

Thank you, Ítalo Gomes

If you don't have any further questions, please consider accepting the answer by hitting the Accept answer and up-vote as it helps the community look for answers to similar questions.

Answer 1

Bhargava-MSFT 31,226 Microsoft Employee

Hello Ítalo Gomes,

Welcome to the Microsoft Q&A forum.

It seems like the issue with the SQL query or the data warehouse.

Can you please review the SQL query and ensure that it is correct and properly formatted. You may also need to check the configuration of the Data Warehouse and ensure that it is set up correctly. Additionally, you can try the following steps:

Check the credentials used to connect to the Data Warehouse and ensure that they are correct.
Check the firewall settings for the Data Warehouse and ensure that they allow connections from the IP address of the ADF integration runtime.
Check the network connectivity between the ADF integration runtime and the Data Warehouse.

Can you try running the SQL query directly in the Data Warehouse to see if it produces any errors or issues.

Bhargava-MSFT 31,226 Reputation points Microsoft Employee

2023-12-12T15:08:02.25+00:00

Thank you, Ítalo Gomes

If you don't have any further questions, please consider accepting the answer by hitting the Accept answer and up-vote as it helps the community look for answers to similar questions.

Share via

Estou com problemas para carregar uma tabala no meu (Pool de SQL - Antigo Data Warehouse)

1 answer

Your answer