My Oracle Support Banner

Model Upload Fails Without Error in Model Upload Log When Executing Database Scripts (Doc ID 2350849.1)

Last updated on JUNE 09, 2021

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 <hostname>,<IP> is currently unknown to the system
The host key fingerprint is: <key fingerprint>
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

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
Cause
Solution
References


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