OFSAA Batch Logs Not Visible From UI "org.apache.commons.vfs2.FileSystemException: Could not copy "sftp://:" Errors
(Doc ID 3061049.1)
Last updated on DECEMBER 03, 2024
Applies to:
Oracle Financial Services Analytical Applications Infrastructure - Version 8.1.2 and laterInformation in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI / AAI)
User Interface (UI)
Symptoms
On AAI 8.1.2 Batch logs are not visible on the OFSAA front end. The below error is reported in the RevAppserver.log:
ERROR
/ofsaa_home/ftpshare//logs/20241115/OFSAAEPM/LOAD DATA/LOAD DATA_OFSAAEPM_FCT_COMMON_ACCT_SUMMARY_20241115_2_Task1_REVLOADER.log
[19-11-24 10:53:25,196 GMT AM] [ERROR] [WEB] [REVELEUS] [NA] [SFTPUTIL] Exception
org.apache.commons.vfs2.FileSystemException: Could not copy "sftp://:***@/ofsaa_home/ftpshare/logs/20241115/OFSAAEPM/LOAD DATA/LOAD DATA_OFSAAEPM_FCT_COMMON_ACCT_SUMMARY_20241115_2_Task1_REVLOADER.log" to "file:///ofsaa_home/ftpshare/LOAD DATA_OFSAAEPM_FCT_COMMON_ACCT_SUMMARY_20241115_2_Task1_REVLOADER.log".
[FILETRANSFER] Protocol is SFTP only
Have confirmed that using manual sftp to APP server, able to download the log file to the web server and vice versa:
<sftp UNIX user>@<IP ADDRESS APP SERVER>'s password:
Connected to <IP ADDRESS APP SERVER>
sftp> ls
sftp> get "LOAD DATA_OFSAAEPM_FCT_COMMON_ACCT_SUMMARY_20241115_1_Task1_REVLOADER.log"
Fetching /ofsaa_home/ftpshare/logs/20241115/OFSAAEPM/LOAD DATA/LOAD DATA_OFSAAEPM_FCT_COMMON_ACCT_SUMMARY_20241115_1_Task1_REVLOADER.log to LOAD DATA_OFSAAEPM_FCT_COMMON_ACCT_SUMMARY_20241115_1_Task1_REVLOADER.log
/ofsaa_home/ftpshare/logs/20241115/OFSAAEPM/LOAD DATA/LOAD DATA_OFSAAEPM_FCT_COMMON_ACCT_SUMMARY_20241115_1_Task1_REVL 100% 1326 1.6MB/s 00:00
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |