Need help to access a secure URL to get the data into mainframe dataset

Reply
New Contributor
Posts: 3

Need help to access a secure URL to get the data into mainframe dataset

Hi Team,

 

One of our job used to access the XML file in URL and get the content from the URL into mainframe datasets for further processing Using "FILENAME URL " access method.

Few days back the URL was changed to secure URL i.e. from HTTP to HTTPS. After the URL was changed the SAS code is getting error out with error as "Missing CA trust list."

We did researched and got the CA trust list certificates installed in to the mainframe, but after that when ever we are running the job its abending with error message displayed as spaces. Its not getting the data retrieved into mainframe.

Below are the log details for the same-

%let U=https (link to the file);
/* DOWNLOAD - FileName URL */
filename U url "&U" recfm=s debug encoding="utf-8";
data _null_;
NBYTE=1;
infile U nbyte=nbyte end=done lrecl=32760;
file XMLOUT lrecl=32760;
do while (not done);
input;
put _infile_ @;
end;
stop;
run;

ERROR: .

 

 

Super User
Posts: 9,671

Re: Need help to access a secure URL to get the data into mainframe dataset

Maybe you should check  PROC HTTP .

New Contributor
Posts: 3

Re: Need help to access a secure URL to get the data into mainframe dataset

Hi Keshan,

 

We already tried the same, but earlier there was an issue with the certificates but now when we have certificates installed below issues are coming-

1- When running the job with existing method, i.e. filename URL access method, some unknown error is coming for which there is no message being displayed in the SAS log.

Below is the message being displayed-

 ERROR: .

 

2- When we are running using Proc HTTP approach we are getting some Java related issues, below are the details-

 

Error-
ERROR: The Java proxy is not responding.     
ERROR: The Java proxy cannot allocate memory.
ERROR: JVM failed to start. 
 
Could you please suggest something.
Super User
Posts: 9,671

Re: Need help to access a secure URL to get the data into mainframe dataset

I would check SAS documentation firstly. The following is the expert I picked up . If it is still not working I would contact sas support or searching error information at support.sas.com

 

Making PROC HTTP Calls by Using the HTTPS Protocol 

In order to make PROC HTTP calls by using the HTTPS protocol, you must configure
trust source that contains the certificate of the service to be trusted. This trust source
and its password must be provided for the SAS session by setting Java system options
using jreoptions. You can provide this information on the SAS command line or in a
SAS configuration file. Use the following syntax. Be sure to enter the following entry on
one line:
-jreoptions (-Djavax.net.ssl.trustStore=full-path-to-the-trust-store -
Djavax.net.ssl.trustStorePassword=trustStorePassword)
The following example shows how to use the entry on the SAS command line. This
example uses the Windows operating environment. Be sure to enter the following entry
on one line:
"C:\Program Files\SAS\SASFoundation\9.2\sas.exe" -CONFIG
"C:\Program Files\SAS\SASFoundation\9.2\nls\en\SASV9.CFG"
-jreoptions (- Djavax.net.ssl.trustStore=C:\Documents and Settings\mydir\.keystore
-Djavax.net.ssl.trustStorePassword=trustpassword)

New Contributor
Posts: 3

Re: Need help to access a secure URL to get the data into mainframe dataset

Will trust source will be the location which will have the certificates ?

If so, we ran our job pointing the PDS which contains certifcates in mainframe, but after also the same issue exists

Occasional Contributor
Posts: 8

Re: Need help to access a secure URL to get the data into mainframe dataset

Hi Jugal,

 

Were you able to solve this scenario ? 

Ask a Question
Discussion stats
  • 5 replies
  • 572 views
  • 0 likes
  • 3 in conversation