Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.

Im trying to call a webservice with PUT over https, but i get an error that i do not understand. The call works with Postman.

Could not execute statement.

HTTP request failed. Status code '<none>'

SQLCODE=-983, ODBC 3 State="HY000"

Line 1, column 1

Procedure is

ALTER FUNCTION "DBA"."OpenURLPUT"( in u text ) 
returns xml
url '!u' 
type 'HTTP:PUT:text/plain'
certificate 'file=C:\\Database\\certificates\\cert.crt'

cert.crt is certificate of the domain i am calling

asked 03 Apr '17, 06:25

Audun's gravatar image

Audun
156101117
accept rate: 0%

edited 03 Apr '17, 06:28


The error message that you are receiving indicates that there was a problem communicating with the remote server: either sending the request or no response was received back. You may be able to get more information if you turned on http client logging using

call sa_server_option( 'WebClientLogFile', 'provide-a-file-name.txt' );
call sa_server_option( 'WebClientLogging', 'ON' );

If you do not specify the WebClientLogFile then the output will go to the server console log. See WebClientLogging for more information.

HTH

permanent link

answered 03 Apr '17, 08:44

Mark%20Culp's gravatar image

Mark Culp
25.0k10142298
accept rate: 41%

Thank you, this helps. I get [connid = 364, Error: socket closed by peer] [connid = 364, socket closed]

both for GET and PUT so it looks like it is certificate error

(03 Apr '17, 09:19) Audun
Replies hidden
1

If you can update your comment with the results/findings, I will appreciate this.

Thanks

(04 Apr '17, 05:45) Vlad
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×33

question asked: 03 Apr '17, 06:25

question was seen: 1,620 times

last updated: 04 Apr '17, 05:45