01-09-2016 01:04 AM
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";
infile U nbyte=nbyte end=done lrecl=32760;
file XMLOUT lrecl=32760;
do while (not done);
put _infile_ @;
01-11-2016 11:45 PM
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-
2- When we are running using Proc HTTP approach we are getting some Java related issues, below are the details-
01-12-2016 12:28 AM
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
-jreoptions (-Djavax.net.ssl.trustStore=full-path-to-the-trust-store -
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
-jreoptions (- Djavax.net.ssl.trustStore=C:\Documents and Settings\mydir\.keystore
01-12-2016 12:56 AM
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