How to fix this Issue. ?

Question

How to fix this Issue. ?

Ayub shaik 36

UserErrorOdbcOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ERROR [HY000] [Microsoft][ServiceNow] (20) Error while attempting to use REST API: No error,Source=Microsoft.DataTransfer.ClientLibrary.Odbc.OdbcConnector,''Type=System.Data.Odbc.OdbcException,Message=ERROR [HY000] [Microsoft][ServiceNow] (20) Error while attempting to use REST API: No error,Source=ServiceNowODBCPlugin_sb64.dll,'

KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2023-04-20T06:13:45.2066667+00:00

@Ayub shaik

Welcome to Microsoft Q&A forum and thanks for posting your query.

To better assist on this issue, could you please share few additional details about what you are trying to implement and at what step you have noticed above error? Is it while testing the linked service connection? or while running the pipeline? What is the linked service being used?

Thanks
TraceyB 5 Reputation points

2023-04-20T12:37:52.25+00:00

We are having the same issue ERROR [HY000] [Microsoft][ServiceNow] (20) Error while attempting to use REST API: Couldn't resolve proxy name
Danish, M 0 Reputation points

2023-04-20T20:26:26.01+00:00

I'm having the same issue. It occurs when I set up ServiceNow as a linked service and try to test the connection before applying the settings.
Sushmita Gaur 5 Reputation points

2023-04-24T14:55:37.9466667+00:00

Hi I am facing same issue, while try to setup ServiceNow connection. The connection was working fine more than 3 months but started to fail since yesterday. All the Production jobs are stuck Microsoft should provide ASAP solution to this.

There is a linked service(Servicenow source) which is consumed by ADF pipeline and the job was working fine since 3 months but I observed a failure today morning execution on further investigation found that we get attached error. I tried to reproduce the error by providing the Endpoint, Username and password but it failed again. Can you please look into this ASAP.
Please revert if have any further questions.
RevelinoB 3,675 Reputation points

2023-04-24T15:06:39.6866667+00:00

Hi, This error message indicates that there was an issue with using the REST API to connect to the ServiceNow data source through the ODBC connector. The error code "ERROR [HY000] [Microsoft][ServiceNow] (20)" suggests that there was a problem with the ServiceNow ODBC plugin or driver, and that the error was not specifically identified by the plugin or driver. The error message also includes the type of exception that occurred, as well as the source of the error in the Microsoft DataTransfer library.
Linda Jackson 1 Reputation point

2023-04-24T20:19:47.2833333+00:00

Similar error as many others have commented and exact error as the commenter using ADF which does not explicitly reference ODBC. All of our credentials work fine in Postman to pull the request. Thank you.
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2023-04-24T22:10:42.73+00:00

Hi All,
Sorry for the inconvenience because of this issue. I have reached out to internal team to check if there is any ongoing issue with this connector and will get back to you as soon as I have a response from the team.

In case if this is impacting production applications, I recommend filing a support ticket. We appreciate your patience.

Thank you
Himanshu Patel 0 Reputation points

2023-04-25T11:15:24.4966667+00:00

This started working automatically. We saw the same issue since yesterday.

@KranthiPakala-MSFT: Was anything fixed internally?
Linda Jackson 1 Reputation point

2023-04-25T13:23:24.0433333+00:00

A "me too" on the working again. This morning our ADF job completed without errors. Individually testing the connection from the linked service works again, too. So it does not seem like a fluke, thanks.

1 answer

Your answer

KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2023-04-20T06:13:45.2066667+00:00

@Ayub shaik

Welcome to Microsoft Q&A forum and thanks for posting your query.

To better assist on this issue, could you please share few additional details about what you are trying to implement and at what step you have noticed above error? Is it while testing the linked service connection? or while running the pipeline? What is the linked service being used?

Thanks
TraceyB 5 Reputation points

2023-04-20T12:37:52.25+00:00

We are having the same issue ERROR [HY000] [Microsoft][ServiceNow] (20) Error while attempting to use REST API: Couldn't resolve proxy name
Danish, M 0 Reputation points

2023-04-20T20:26:26.01+00:00

I'm having the same issue. It occurs when I set up ServiceNow as a linked service and try to test the connection before applying the settings.
Sushmita Gaur 5 Reputation points

2023-04-24T14:55:37.9466667+00:00

Hi I am facing same issue, while try to setup ServiceNow connection. The connection was working fine more than 3 months but started to fail since yesterday. All the Production jobs are stuck Microsoft should provide ASAP solution to this.

There is a linked service(Servicenow source) which is consumed by ADF pipeline and the job was working fine since 3 months but I observed a failure today morning execution on further investigation found that we get attached error. I tried to reproduce the error by providing the Endpoint, Username and password but it failed again. Can you please look into this ASAP.
Please revert if have any further questions.
RevelinoB 3,675 Reputation points

2023-04-24T15:06:39.6866667+00:00

Hi, This error message indicates that there was an issue with using the REST API to connect to the ServiceNow data source through the ODBC connector. The error code "ERROR [HY000] [Microsoft][ServiceNow] (20)" suggests that there was a problem with the ServiceNow ODBC plugin or driver, and that the error was not specifically identified by the plugin or driver. The error message also includes the type of exception that occurred, as well as the source of the error in the Microsoft DataTransfer library.
Linda Jackson 1 Reputation point

2023-04-24T20:19:47.2833333+00:00

Similar error as many others have commented and exact error as the commenter using ADF which does not explicitly reference ODBC. All of our credentials work fine in Postman to pull the request. Thank you.
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2023-04-24T22:10:42.73+00:00

Hi All,
Sorry for the inconvenience because of this issue. I have reached out to internal team to check if there is any ongoing issue with this connector and will get back to you as soon as I have a response from the team.

In case if this is impacting production applications, I recommend filing a support ticket. We appreciate your patience.

Thank you
Himanshu Patel 0 Reputation points

2023-04-25T11:15:24.4966667+00:00

This started working automatically. We saw the same issue since yesterday.

@KranthiPakala-MSFT: Was anything fixed internally?
Linda Jackson 1 Reputation point

2023-04-25T13:23:24.0433333+00:00

A "me too" on the working again. This morning our ADF job completed without errors. Individually testing the connection from the linked service works again, too. So it does not seem like a fluke, thanks.

Answer 1

Hello All, After multiple users reported this issue, I have notified the respective product owners with the issue details and they took this on priority and identified that there was regression which resulted in this and have fixed it internally so that the issue should be automatically fixed for end users.
Hope all the jobs are running fine now. If you still notice any issues, please let us know, so that I can involve the respective teams to further troubleshoot them.

Thank you and appreciate much for reporting this to us.

Share via

How to fix this Issue. ?

1 answer

Your answer