systools httpPostClob SQLCOD -4301

[B.Hauser]

Have you also tried to use the newer http_post function in the QSYS2 library?

https://www.ibm.com/docs/en/i/7.5?topic=functions-http-post

[mjhaston]

B.Hauser - Unfortunately I don't have those newer functions available. We're on 7.3, but I guess we need some PTFs?

Scott Klement - I switched over from httpPostClob to using your http_req. We'll see how it goes.

Thank you both.

[mjhaston]

Scott Klement - I put a debug statement in and see one of my labels failed and returned what's below. It's odd because 10 labels before and 10 after printed fine.


HTTPAPI Ver 1.39 released 2018-03-09
NTLM Ver 1.4.0 released 2014-12-22
OS/400 Ver V7R3M0

http_persist_open(): entered
http_long_ParseURL(): entered
DNS resolver retrans: 2
DNS resolver retry : 3
DNS resolver options: x'00000136'
DNS default domain: MYCOMPANY.COM
DNS server found: 1.1.1.1
DNS server found: 8.8.8.8
SetError() #2: Host name look up failed.
http_close(): entered

[Scott Klement]

"Host name lookup failed" is very different from "connection refused".

It is attempting to perform a DNS lookup on the host name you listed in the URL, and that is failing. The fact that you received that as well as a "connection refused" makes me wonder if there is something flaky about your network. I've seen stuff like this with bad cables, bad network cards, bad routers, etc. As they wear out, they can reach a point where data gets lost or corrupted sporadically.

[mjhaston]

To make it even more odd... I'm using an IP address, so it really shouldn't be doing a lookup? Right?

I'm going to set a longer timeout on the http_req call and in my script on the PC and see if that helps anything.

[Scott Klement]

Correct, it wouldn't do a DNS lookup if you're using an IP address. I don't see how adjusting the timeout would help.