Re: HTTPPOSTCLOBVERBOSE - invoking a HTTPS web service

FYI, invoking a SSL connection wasn't working because of PTF issue.
It seems to be working the other I've tried it.

I still need to find out from our IBM i guy who maintains the server,
what's changed.

On 8 August 2016 at 14:12, Bradley Stone <bvstone@xxxxxxxxx> wrote:

If it's having issues with HTTPS it could be the port doesn't automatically
default to 443 on the request or the Certificate Authorities used by the
HTTPS site aren't in your *SYSTEM store and it doesn't "trust" the
certificates in use. Although the error is quite obtuse as to the actual
problem.

Have you looked into using a different product for making HTTP/HTTPS
requests that have better support? Our GETURI software (
http://www.bvstools.com/geturi.html) which has both command and ILE
interfaces or Scott's HTTPAPI (https://www.scottklement.com/httpapi/)
would
probably let you get a lot further in less time.

Brad
www.bvstools.com

On Mon, Aug 8, 2016 at 2:29 AM, Eric <send2et@xxxxxxxxx> wrote:

Sorry for the late reply.

Okay thanks. I will do that.
I posted it in developerworks at first but Jon Paris asked me to post it

in

midrange.com, mentioning that midrange.com has a lot of experts around

to

help. :-)

On 28 July 2016 at 13:37, CRPence <crpbottle@xxxxxxxxx> wrote:

On 25-Jul-2016 08:10 -0500, Eric wrote:

I tried running this SQL

SELECT *
FROM TABLE( SYSTOOLS.HTTPPOSTCLOBVERBOSE
( 'https://httpbin.org/post'
, ''
, 'testing'
)
) AS X

... which sends a web service to https but there is an issue.

This is from the job log.

Message ID: CPF503E
Date sent: 16/07/25 Time sent: 14:06:59
Message: User-defined function error on member QSQPTABL.
Cause: An error occurred while invoking user-defined
function HTTPPOSTCLOBVERBOSE in library SYSTOOLS. The error occurred
while invoking the associated external program or service program
B2RESTUDF: in library SYSTOOLS.D, program entry point or external
name com.ibm.db2.rest.DB2UDFWrapper.httpPostClobVerbose, specific
name HTTPPOSTCLOBVERBOSENONXML. The error occurred on member QSQPTABL
file QSQPTABL in library QSYS2. The error code is 1. The error codes
and their meanings follow:
1 -- The external program or service program returned
SQLSTATE 38000. The text message returned from the program is:
SYSTOOLS.HTTPPOSTCLOBVERBOSE HTTPPOSTCLOBVERBOSENONXML
ãjava.lang.ArrayIn

[changed my mind; sending this from my drafts]

The above information for ErrCde1 was truncated; presumably:
SYSTOOLS.HTTPPOSTCLOBVERBOSE HTTPPOSTCLOBVERBOSENONXML ã
java.lang.ArrayIndexOutOfBoundsException: Array index out of range:

64 .

Note: the replacement data for the qualified service program name is
corrupted; clearly a defect: "program B2RESTUDF: in library SYSTOOLS.D"
presumably should have been diagnosed as "program DB2RESTUDF in library
SYSTOOLS".

If I change it to use http, it is fine.

Any ideas?

Consider posting on midrange-l instead.? [further comment here was
placed instead, in my other recent reply to this thread]

FWiW: if making multiple postings across fora for a specific issue,
probably worthwhile to include a link to those other topic threads [or

at

least maintain the same visible nym as text within the postings] when
posting to an additional forum, so a reader can know, rather than

merely

presume, that the discussions are duplicates; for reference to an
apparently duplicate topic on another forum:
Forum Directory ->‎ Information Management ->‎ Forum: DB2 for i ->‎
Topic: HTTPPOSTCLOBVERBOSE SSL issue
Authored by etan84 19-July-2016
[https://www.ibm.com/developerworks/community/forums/html/
topic?id=fac6d4cd-8e0e-4e73-b22b-f8ae59ba1607&ps=25]


--
Regards, Chuck

--
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400)

mailing

list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.

--
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing
list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.

--
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing
list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.