<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic SAS ECM Attachments in SAS Programming</title>
    <link>https://communities.sas.com/t5/SAS-Programming/SAS-ECM-Attachments/m-p/692861#M211161</link>
    <description>Hi, I am using SAS ECM on Linux. Trying to update a case by adding an attachment. I am making the web service call to the ECM web service from the workspcae server, so the file is on the machine. I get the web service error below, basically stating the file is not found. I have check the file exists in the location, change the perms fo te folders to 775. The user running soap request is the owner of the file. Pleade asist. Thank you in advance.
CODE to BUILD SOAP REQUEST:

Request
CODE:

%LET ecmwsdir = %sysfunc(pathname(work));
%LET soapXMLFile = %sysfunc(pathname(work))/ECMXML_request.xml; 
filename request "%sysfunc(pathname(work))/ECMXML_request.xml"; 
filename response "%sysfunc(pathname(work))/ECMXML_response.xml"; 
%let caseid=2020-674899;

data _null_;
           file "&amp;amp;soapXMLFile";
           put '';
           put '&lt;CREATEREQUEST ecm="http://sas.com/solutions/casemgmt/webservice"&gt;';

           aa='&lt;REFERENCES&gt;&lt;CASEREFERENCE refid="MSGREF1" caseid="'||strip("&gt;&lt;/CASEREFERENCE&gt;&lt;/REFERENCES&gt;';
           put aa;
           put ' &lt;CREATE&gt;';

           put '&lt;ATTACHMENT file="/grid/fnbfraud/FNB_Fraud/SASEnterpriseCaseManagement/sasdav/subpoenas/ecmdocs/test.zip" refid="attachment1"&gt;' ;
           put '      &lt;DESCRIPTION&gt;Test attachment for subpoena case&lt;/DESCRIPTION&gt;' ;
           put '      &lt;LINKTO refid="MSGREF1"&gt;&lt;/LINKTO&gt;';
           put ' &lt;/ATTACHMENT&gt;' ;
           

           put '&lt;/CREATE&gt;';
           put '&lt;/CREATEREQUEST&gt;';
     run;

     proc soap
           in=request
           out=response
     srsurl="&amp;amp;websvrprot.://&amp;amp;websvrnm.:&amp;amp;websvrport./SASWIPSoapServices/services/ServiceRegistry"
     url="&amp;amp;websvrprot.://&amp;amp;websvrnm.:&amp;amp;websvrport./SASEntCaseManagement/service"
     soapaction="&lt;A href="http://sas.com/solutions/casemgmt/webservice/CaseManagementServiceInterface/create" target="_blank"&gt;http://sas.com/solutions/casemgmt/webservice/CaseManagementServiceInterface/create&lt;/A&gt;"
           WSSUSERNAME="aaa"
           WSSPASSWORD="fffff"
           ;
     run; 
     data _null_ ;infile response ;input ;put _infile_ ;run ;

the REQUEST XML

&lt;CREATEREQUEST ecm="http://sas.com/solutions/casemgmt/webservice" mode="reject_on_error" lockhandlingmode="update_locked_objects" countrycode="US" languagecode="en" sourcesystemcode="SASMAILICG"&gt;
&lt;REFERENCES&gt;&lt;CASEREFERENCE refid="MSGREF1" caseid="2020-123123113123" casesourcesystemcode="SASMAILICG"&gt;&lt;/CASEREFERENCE&gt;&lt;/REFERENCES&gt;
     &lt;CREATE&gt;
&lt;ATTACHMENT file="/grid/fnbfraud/FNB_Fraud/SASEnterpriseCaseManagement/sasdav/subpoenas/ecmdocs/test.zip" refid="attachment1"&gt;
           &lt;DESCRIPTION&gt;Test attachment for subpoena case&lt;/DESCRIPTION&gt;
           &lt;LINKTO refid="MSGREF1"&gt;&lt;/LINKTO&gt;
     &lt;/ATTACHMENT&gt;
&lt;/CREATE&gt;
&lt;/CREATEREQUEST&gt;

the RESPOSE XML
&lt;CREATERESPONSE ns2="http://sas.com/solutions/casemgmt/webservice" resultcode="FAILURE"&gt;&lt;CREATERESULTS&gt;&lt;CREATERESU lt="" refid="attachment1" resultcode="FAILURE"&gt;&lt;ATTACHMENTREFERENCE refid="attachment1"&gt;&lt;/ATTACHMENTREFERENCE&gt;&lt;CREATEERROR errorcode="FILE_NOT_FOUND
_EXCEPTION"&gt;&lt;MESSAGE&gt;File not found: "/grid/fnbfraud/FNB_Fraud/SASEnterpriseCaseManagement/sasdav/subpoenas/ecmdocs/test.zip"&lt;/MESSAGE&gt;&lt;/CREATEERROR&gt;&lt;/CREATERESU&gt;&lt;/CREATERESULTS&gt;&lt;/CREATERESPONSE&gt;</description>
    <pubDate>Tue, 20 Oct 2020 13:29:33 GMT</pubDate>
    <dc:creator>brendanb</dc:creator>
    <dc:date>2020-10-20T13:29:33Z</dc:date>
    <item>
      <title>SAS ECM Attachments</title>
      <link>https://communities.sas.com/t5/SAS-Programming/SAS-ECM-Attachments/m-p/692861#M211161</link>
      <description>Hi, I am using SAS ECM on Linux. Trying to update a case by adding an attachment. I am making the web service call to the ECM web service from the workspcae server, so the file is on the machine. I get the web service error below, basically stating the file is not found. I have check the file exists in the location, change the perms fo te folders to 775. The user running soap request is the owner of the file. Pleade asist. Thank you in advance.
CODE to BUILD SOAP REQUEST:

Request
CODE:

%LET ecmwsdir = %sysfunc(pathname(work));
%LET soapXMLFile = %sysfunc(pathname(work))/ECMXML_request.xml; 
filename request "%sysfunc(pathname(work))/ECMXML_request.xml"; 
filename response "%sysfunc(pathname(work))/ECMXML_response.xml"; 
%let caseid=2020-674899;

data _null_;
           file "&amp;amp;soapXMLFile";
           put '';
           put '&lt;CREATEREQUEST ecm="http://sas.com/solutions/casemgmt/webservice"&gt;';

           aa='&lt;REFERENCES&gt;&lt;CASEREFERENCE refid="MSGREF1" caseid="'||strip("&gt;&lt;/CASEREFERENCE&gt;&lt;/REFERENCES&gt;';
           put aa;
           put ' &lt;CREATE&gt;';

           put '&lt;ATTACHMENT file="/grid/fnbfraud/FNB_Fraud/SASEnterpriseCaseManagement/sasdav/subpoenas/ecmdocs/test.zip" refid="attachment1"&gt;' ;
           put '      &lt;DESCRIPTION&gt;Test attachment for subpoena case&lt;/DESCRIPTION&gt;' ;
           put '      &lt;LINKTO refid="MSGREF1"&gt;&lt;/LINKTO&gt;';
           put ' &lt;/ATTACHMENT&gt;' ;
           

           put '&lt;/CREATE&gt;';
           put '&lt;/CREATEREQUEST&gt;';
     run;

     proc soap
           in=request
           out=response
     srsurl="&amp;amp;websvrprot.://&amp;amp;websvrnm.:&amp;amp;websvrport./SASWIPSoapServices/services/ServiceRegistry"
     url="&amp;amp;websvrprot.://&amp;amp;websvrnm.:&amp;amp;websvrport./SASEntCaseManagement/service"
     soapaction="&lt;A href="http://sas.com/solutions/casemgmt/webservice/CaseManagementServiceInterface/create" target="_blank"&gt;http://sas.com/solutions/casemgmt/webservice/CaseManagementServiceInterface/create&lt;/A&gt;"
           WSSUSERNAME="aaa"
           WSSPASSWORD="fffff"
           ;
     run; 
     data _null_ ;infile response ;input ;put _infile_ ;run ;

the REQUEST XML

&lt;CREATEREQUEST ecm="http://sas.com/solutions/casemgmt/webservice" mode="reject_on_error" lockhandlingmode="update_locked_objects" countrycode="US" languagecode="en" sourcesystemcode="SASMAILICG"&gt;
&lt;REFERENCES&gt;&lt;CASEREFERENCE refid="MSGREF1" caseid="2020-123123113123" casesourcesystemcode="SASMAILICG"&gt;&lt;/CASEREFERENCE&gt;&lt;/REFERENCES&gt;
     &lt;CREATE&gt;
&lt;ATTACHMENT file="/grid/fnbfraud/FNB_Fraud/SASEnterpriseCaseManagement/sasdav/subpoenas/ecmdocs/test.zip" refid="attachment1"&gt;
           &lt;DESCRIPTION&gt;Test attachment for subpoena case&lt;/DESCRIPTION&gt;
           &lt;LINKTO refid="MSGREF1"&gt;&lt;/LINKTO&gt;
     &lt;/ATTACHMENT&gt;
&lt;/CREATE&gt;
&lt;/CREATEREQUEST&gt;

the RESPOSE XML
&lt;CREATERESPONSE ns2="http://sas.com/solutions/casemgmt/webservice" resultcode="FAILURE"&gt;&lt;CREATERESULTS&gt;&lt;CREATERESU lt="" refid="attachment1" resultcode="FAILURE"&gt;&lt;ATTACHMENTREFERENCE refid="attachment1"&gt;&lt;/ATTACHMENTREFERENCE&gt;&lt;CREATEERROR errorcode="FILE_NOT_FOUND
_EXCEPTION"&gt;&lt;MESSAGE&gt;File not found: "/grid/fnbfraud/FNB_Fraud/SASEnterpriseCaseManagement/sasdav/subpoenas/ecmdocs/test.zip"&lt;/MESSAGE&gt;&lt;/CREATEERROR&gt;&lt;/CREATERESU&gt;&lt;/CREATERESULTS&gt;&lt;/CREATERESPONSE&gt;</description>
      <pubDate>Tue, 20 Oct 2020 13:29:33 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Programming/SAS-ECM-Attachments/m-p/692861#M211161</guid>
      <dc:creator>brendanb</dc:creator>
      <dc:date>2020-10-20T13:29:33Z</dc:date>
    </item>
  </channel>
</rss>

