We've been seeing some inconsistent behavior with the use of httpPostClob yesterday and today. We have one main program which does all of the SOAP calls with the code below:
This program has been called thousands of times and now we're having issues the past two days. We had system maintenance over the weekend that wasn't supposed to effect our partition at all, but I'll have to get on the phone with those guys.
We wondered if it might have something to do with user profile differences. I have *SECOFR and *AUDIT authorities and the call is successful for me. A fellow program is setup with *PGMR and no *AUDIT and the call is failing.
When I make the call from Run SQL Script here is the Verbose output:
My job log shows:
Java Virtual Machine is IBM Technology for Java. PID(3853)
JVM properties were loaded from a properties file.
Open attributes not valid in a multithreaded job.
Error(s) occurred during running of QsnInzSsnD API.
Open attributes not valid in a multithreaded job.
Error(s) occurred during running of _________ API.
Error(s) occurred during running of QsnCrtEnv API.
Open attributes not valid in a multithreaded job.
Error(s) occurred during running of _________ API.
I'm just noticing the missing name of the API.
User-defined function error on member SYSDUMMY1.
Java interpreter startup or communication failed for reason code 1.
Thanks.
Mike
Code:
exec sql select systools.httpPostClob( :url, :header, cast(:requestData as clob(20k) ccsid 1208)) into :returnData from sysibm.sysdummy1 ;
We wondered if it might have something to do with user profile differences. I have *SECOFR and *AUDIT authorities and the call is successful for me. A fellow program is setup with *PGMR and no *AUDIT and the call is failing.
When I make the call from Run SQL Script here is the Verbose output:
Code:
<?xml version="1.0" encoding="UTF-8" ?> <httpHeader responseCode="500"> <responseMessage>Internal Server Error</responseMessage> <header name="X-Frame-Options" value="DENY"/> <header name="HTTP_RESPONSE_CODE" value="HTTP/1.1 500 Internal Server Error"/> <header name="Strict-Transport-Security" value="max-age=31536000"/> <header name="Server" value="Apache-Coyote/1.1"/> <header name="X-OPNET-Transaction-Trace" value="a2_fccd538d-b777-4553-bac4-0dfe6e2a7408"/> <header name="X-Content-Type-Options" value="nosniff"/> <header name="X-Cnection" value="close"/> <header name="Content-Length" value="773"/> <header name="X-XSS-Protection" value="1; mode=block"/> <header name="Date" value="Wed, 22 Jan 2020 15:31:29 GMT"/> <header name="Content-Type" value="text/xml"/> <header name="v-c-response-time" value="1579707089"/> </httpHeader>
My job log shows:
Java Virtual Machine is IBM Technology for Java. PID(3853)
JVM properties were loaded from a properties file.
Open attributes not valid in a multithreaded job.
Error(s) occurred during running of QsnInzSsnD API.
Open attributes not valid in a multithreaded job.
Error(s) occurred during running of _________ API.
Error(s) occurred during running of QsnCrtEnv API.
Open attributes not valid in a multithreaded job.
Error(s) occurred during running of _________ API.
I'm just noticing the missing name of the API.
User-defined function error on member SYSDUMMY1.
Code:
Additional Message Information Message ID . . . . . . : CPF503E Severity . . . . . . . : 30 Message type . . . . . : Sender copy Date sent . . . . . . : 01/22/20 Time sent . . . . . . : 10:49:25 Message . . . . : User-defined function error on member SYSDUMMY1. Cause . . . . . : An error occurred while invoking user-defined function HTTPPOSTCLOB 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.httpPostClob, specific name HTTPP00013. The error occurred on member SYSDUMMY1 file SYSDUMMY1 in library SYSIBM. The error code is 1. The error codes and their meanings follow: 1 -- The external program or service program returned SQLSTATE 58004. The text message returned from the program is: ██ . 2 -- The external program failed before it completed. 3 -- The database timed out waiting for the program to return. The timeout
Java interpreter startup or communication failed for reason code 1.
Code:
Additional Message Information Message ID . . . . . . : SQL4301 Severity . . . . . . . : 30 Message type . . . . . : Diagnostic Date sent . . . . . . : 01/22/20 Time sent . . . . . . : 10:49:25 Message . . . . : Java interpreter startup or communication failed for reason code 1. Cause . . . . . : An error occurred while attempting to start or communicate with a Java interpreter. The reason codes and their meanings follow: 1 -- Java environment variables or Java database configuration parameters are invalid. 2 -- A Java Native Interface call to the Java interpreter failed. 4 -- The Java interpreter has terminated itself and cannot be restarted. Recovery . . . : Ensure that Java environment variables or Java database configuration parameters are valid. Ensure that a Java method called by the Java interpreter does not use System.out. Ensure that internal DB2 classes (com.ibm.db2) are not overridden by user classes.
Thanks.
Mike
Comment