When the Live ETL process in SAS Infrastructure for Risk Management fails, the output log file, which is named last_live_etl.error.txt, can contain this message:
java.lang.RuntimeException: Failed to copy one or more files from Input area
Here is a full example of the failure message:
LiveETL Summary for Input Area /local/install/Config/Lev1/AppData/SASIRM/pa/fas/fa.sasdemo/input_area ***
Removing old LiveETL status files in Input Areas.
Files will be loaded to the Federated Area:
/local/install/Config/Lev1/AppData/SASIRM/pa/fas/fa.sasdemo/landing_area/myfile.txt
The following job flow instances became out of date after loading the new data:
Keys: []
Copying data from IAs to FAs ...
LiveETL failed for Input Area /local/install/Config/Lev1/AppData/SASIRM/pa/fas/fa.sasdemo/input_area with the following exception: java.lang.RuntimeException: Failed to copy one or more files from Input area /local/install/Config/Lev1/AppData/SASIRM/pa/
at com.sas.solutions.risk.irm.server.liveetl.LiveEtlService.doLiveEtlForOneIA(LiveEtlService.java:341)
at com.sas.solutions.risk.irm.server.liveetl.LiveEtlService.doLiveEtl(LiveEtlService.java:195)
at com.sas.solutions.risk.irm.server.liveetl.LiveEtlTriggerMonitor$1.run(LiveEtlTriggerMonitor.java:156)
This message is most likely caused by a permissions issue in the landing area, such as when a user makes a change to one or more files in the landing area. Files in the landing area should appear as follows:
-rw-rw-r-- 1 sas sas 196608 Jun 15 2020 rollover_scheme.sas7bdat
The files in the landing area should all be owned by the same account (often sas) with 664 permissions. If any files are owned by another user, change them to match both according to owner and permissions mode.