Spreadsheet Fails to Load in New Excel-Entity Mapping Screen - Not Memory Related

Last updated on MARCH 14, 2018

Applies to:

Symptoms

In Oracle Financial Services Analytical Applications (OFSAA), when you try to create an Excel-Entity Mapping, the screen where Excel spreadsheet data should appear never loads and remains empty.  You go to Excel Upload > Excel-Entity Mappings and click on the "Add" button.  You enter a Mapping name and Description and then select an Excel file.  When you click on the "Arrow" button, nothing happens.  The data from the Excel spreadsheet never loads.

If using Tomcat, the following error appears in the Tomcat server's catalina.out file:

DEBUG - Returning ssh-rsa
INFO - Verifying server1,xx.x.xx.xxx host key
DEBUG - Fingerprint: 2048: 4c 47 30 4 2 c3 17 46 43 3a 2f b6 99 65 a6 db
The host server1,xx.x.xx.xxx is currently unknown to the system
The host key fingerprint is: 2048: 4c 47 30 4 2 c3 17 46 43 3a 2f b6 99 65 a6 db
Do you want to allow this host key? [Yes|No|Always]: java.lang.NullPointerException
     at com.sshtools.j2ssh.transport.ConsoleKnownHostsKeyVerification.getResponse(Unknown Source)
     at com.sshtools.j2ssh.transport.ConsoleKnownHostsKeyVerification.onUnknownHost(Unknown Source)
     at com.sshtools.j2ssh.transport.AbstractKnownHostsKeyVerification.verifyHost(Unknown Source)
     at com.sshtools.j2ssh.transport.TransportProtocolClient.verifyHostKey(Unknown Source)
     at com.sshtools.j2ssh.transport.TransportProtocolClient.performKeyExchange(Unknown Source)
     at com.sshtools.j2ssh.transport.TransportProtocolCommon.beginKeyExchange(Unknown Source)
     at com.sshtools.j2ssh.transport.TransportProtocolCommon.onMsgKexInit(Unknown Source)
     at com.sshtools.j2ssh.transport.TransportProtocolCommon.startBinaryPacketProtocol(Unknown Source)
     at com.sshtools.j2ssh.transport.TransportProtocolCommon.run(Unknown Source)
at java.lang.Thread.run(Thread.java:736)
INFO - The host key was not accepted
INFO - Sending SSH_MSG_DISCONNECT
INFO - Sending SSH_MSG_NEWKEYS
ERROR - The Transport Protocol thread failed

If using Weblogic, the error is slightly different:

DEBUG - Returning ssh-rsa
INFO - Verifying server1,xx.x.xx.xxx host key
DEBUG - Fingerprint: 2048: a0 d5 62 9d 8 cc f9 d b2 74 3c 7a 70 8 1b 4e
The host server1,xx.x.xx.xxx is currently unknown to the system
The host key fingerprint is: 2048: a0 d5 62 9d 8 cc f9 d b2 74 3c 7a 70 8 1b 4e
Do you want to allow this host key? [Yes|No|Always]: java.io.IOException: Bad file descriptor

Steps to Reproduce:

1. Go to Unified Metadata Manager
2. Go to Data Entry Forms and Queries > Excel Upload 
3. Go to Excel-Entity Mappings and click on the Add button
4. Enter a Mapping Name, Description, and select an Excel spreadsheet to load
5. Click on the Arrow button

Nothing happens.

Cause