OFSAA 8.0.7: “[20355] Mapping Template Not Found” Error in Excel-Entity Mapping Screen. Object Migration Fails With “com.jcraft.jsch.JSchException: Auth Cancel” Exception (Doc ID 2867492.1)

Last updated on SEPTEMBER 21, 2023

Applies to:

Symptoms

On OFSAAI 8.0.7 version, for Excel Upload, when attempting to access the Excel-Entity Mapping screen, the following message appears:

ERROR

[20355] Mapping Template Not Found

There are no mapping definitions listed on the screen.

In Excel Upload, when trying to load data from a selected spreadsheet, a spinning hourglass appears.

Additionally, the following error exists in the both the web server RevAppserver.log and <weblogic_domain>.log:

[28-02-22 14:39:20,626 GMT PM] [ERROR] [WEB] [REVELEUS] [NA] [SFTPUTIL] Exception while downloading file : /<ftpshare>/STAGE/ExcelUpload/<Information_Domain_Name>/<mapping_name>.xml
[28-02-22 14:39:20,628 GMT PM] [ERROR] [WEB] [REVELEUS] [NA] [SFTPUTIL] Exception
org.apache.commons.vfs2.FileSystemException: Could not connect to SFTP server at "sftp://<OFSAA_user>@<ip_address>/".
at org.apache.commons.vfs2.provider.sftp.SftpFileProvider.doCreateFileSystem(SftpFileProvider.java:107)
at org.apache.commons.vfs2.provider.AbstractOriginatingFileProvider.getFileSystem(AbstractOriginatingFileProvider.java:103)
at org.apache.commons.vfs2.provider.AbstractOriginatingFileProvider.findFile(AbstractOriginatingFileProvider.java:81)
at org.apache.commons.vfs2.provider.AbstractOriginatingFileProvider.findFile(AbstractOriginatingFileProvider.java:65)
at org.apache.commons.vfs2.impl.DefaultFileSystemManager.resolveFile(DefaultFileSystemManager.java:693)
at org.apache.commons.vfs2.impl.DefaultFileSystemManager.resolveFile(DefaultFileSystemManager.java:621)
at com.iflex.fic.util.ftpService.SFTPUtil.downloadFile(SFTPUtil.java:622)
at com.iflex.fic.util.ftpService.SFTPUtil.downloadFile(SFTPUtil.java:635)
at com.iflex.fic.util.ftpService.SFTPUtil.downloadFile(SFTPUtil.java:635)
.
.
.
  at com.iflex.fic.util.ftpService.fileTranferer.getFileFromRemoteServer(fileTranferer.java:651)
at com.iflex.fic.util.ftpService.fileTranferer.getFileFromRemoteServer(fileTranferer.java:563)
at com.iflex.fic.etl.excelUpload.ClsUCntETLExcelLoadingOne.getExcelMapping(ClsUCntETLExcelLoadingOne.java:1605)
at jsp_servlet._excelupload.__filehandler._jspService(__filehandler.java:242)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:35).
.
.
.
Caused by: org.apache.commons.vfs2.FileSystemException: Could not connect to SFTP server at "<ip_address>".
at org.apache.commons.vfs2.provider.sftp.SftpClientFactory.createConnection(SftpClientFactory.java:230)
at org.apache.commons.vfs2.provider.sftp.SftpFileProvider.doCreateFileSystem(SftpFileProvider.java:96)
... 75 more
Caused by: com.jcraft.jsch.JSchException: Auth cancel
at com.jcraft.jsch.Session.connect(Session.java:518)
at com.jcraft.jsch.Session.connect(Session.java:183)
at org.apache.commons.vfs2.provider.sftp.SftpClientFactory.createConnection(SftpClientFactory.java:226)
... 76 more

Environment is using Private Key Authentication to allow webserver to connect to the application server.

In "Configure Web Server" screen, "Public key authentication" is being used (web_server_info contains data for AUTHTYPE as PUBLICKEYAUTH and PRIVATEKEYPATH).

STEPS TO REPRODUCE

The issue can be reproduced at will with the following steps:
1. Go to Common Object Maintenance
2. Go to Data Entry Forms and Queries > Excel Upload (Atomic)
3. Go to Excel-Entity Mappings

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.