Model Upload Fails Without Error in Model Upload Log When Executing Database Scripts

(Doc ID 2350849.1)

Last updated on JANUARY 19, 2018

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.5.1.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)

Symptoms

On OFSAAI 7.3.5.1.0, when attempting to run model upload, it appears the model upload is successful, but fails during ftp as the model upload log file ends abruptly without completion:

Start Firing with index script ....file name :XIE3CONSOLIDATED_DETAIL_TEMPLA_FSI_O_CONS_DETAIL_TEMPLATE.sql
INDEX XIE3CONSOLIDATED_DETAIL_TEMPLA_FSI_O_CONS_DETAIL_TEMPLATE created successfully

Start Firing with index script ....file name :XIE3FSI_O_CONSOLIDATED_MASTER_FSI_O_CONSOLIDATED_MASTER.sql
INDEX XIE3FSI_O_CONSOLIDATED_MASTER_FSI_O_CONSOLIDATED_MASTER created successfully

Start Firing with index script ....file name :XIE3RESULT_MASTER_FSI_O_RESULT_MASTER.sql
INDEX XIE3RESULT_MASTER_FSI_O_RESULT_MASTER created successfully
----------------------------------------------

The following error is found in the nohup.out of the $FIC_APP_HOME/common/FICServer/bin directory:

ERROR

Drop ....XIE3RESULT_MASTER_FSI_O_RESULT_MASTER.sql
The host ofsaa,10.11.22.333 is currently unknown to the system
The host key fingerprint is: 2048: a2 0 1a b0 54 66 d1 33 f2 bb 99 65 10 1a 5a 11
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)


Server is updated since last working model upload to close ftp port 21. Only sftp port is now open.

The issue can be reproduced at will with the following steps:
1. Run model upload.
2. Check errors in nohup.out

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms