OFSAA User Defined Executable Script Batch Using "Run Executable" Component Fails With 'Server command has NO parameters' (Doc ID 1343957.1)

Last updated on JULY 05, 2017

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

On Oracle Financial Services Analytical Applications Infrastructure (OFSAAI), when attempting to run a batch using the Run Executable task component for a script with sqlldr executable, the following error occurs:

ERROR
2011-07-26 | 16:45:59 | ficgen | INFO | | | [FicGenImpl : Constructor] : Creating FIC GENERIC server
2011-07-26 | 16:45:59 | ficgen | INFO | | | [FicGenImpl::FicGen] : Entry... BatchId = OFSAADEV_BATCH2_20110726_5 ComponentId = RUN EXECUTABLE TaskId = Task1 InfoDate = 20110726 Parameters = /ofsa_infra/ftpshare/rates/Upload_rates.sh,Y,Y DataStore = OFSAADEV DataStoreType = EDW IPAddress = 10.64.5.33
2011-07-26 | 16:45:59 | ficgen | INFO | | | In FicGenExecute method of FicGeneric server
2011-07-26 | 16:45:59 | ficgen | INFO | | | [FicGenExecute] : Input Parameters = [/ofsa_infra/ftpshare/rates/Upload_rates.sh,Y,Y]
2011-07-26 | 16:45:59 | ficgen | INFO | | | [GetBatchParam] : ENTRY : parameters = /ofsa_infra/ftpshare/rates/Upload_rates.sh,Y,Y
2011-07-26 | 16:45:59 | ficgen | INFO | | | [GetBatchParam] : temp_parameters[44] = ,
2011-07-26 | 16:45:59 | ficgen | INFO | | | [GetBatchParam] : EXIT : parameters = /ofsa_infra/ftpshare/rates/Upload_rates.sh,Y
2011-07-26 | 16:45:59 | ficgen | INFO | | | [GetWaitParam] : ENTRY : parameters = /ofsa_infra/ftpshare/rates/Upload_rates.sh,Y
2011-07-26 | 16:45:59 | ficgen | INFO | | | [GetWaitParam] : temp_parameters[42] = ,
2011-07-26 | 16:45:59 | ficgen | INFO | | | [GetWaitParam] : EXIT : parameters = /ofsa_infra/ftpshare/rates/Upload_rates.sh
2011-07-26 | 16:45:59 | ficgen | INFO | | | [FicGenExecute] : WAIT_OPT = Y BPARAM_OPT = Y
2011-07-26 | 16:45:59 | ficgen | INFO | | | [FicGenExecute] : Server processName : [/ofsa_infra/ftpshare/rates/Upload_rates.sh]
2011-07-26 | 16:45:59 | ficgen | INFO | | | [CheckProcessName] : Entry
2011-07-26 | 16:45:59 | ficgen | INFO | | | [CheckProcessName] : Exit 1 : PROC_NAME = #/ofsa_infra/ftpshare/rates/Upload_rates.sh#
2011-07-26 | 16:45:59 | ficgen | INFO | | | [FicGenExecute] : Server processName after CheckProcessName : [/ofsa_infra/ftpshare/rates/Upload_rates.sh]
2011-07-26 | 16:45:59 | ficgen | INFO | | | [FicGenExecute] : Server local parameters /ofsa_infra/ftpshare/rates/Upload_rates.sh
2011-07-26 | 16:45:59 | ficgen | SEVERE | | | [FicGenExecute] : Server command has NO parameters
2011-07-26 | 16:45:59 | ficgen | INFO | | | [FicGenExecute] : FICGENERIC.MSG_0009
2011-07-26 | 16:45:59 | ficgen | SEVERE | | | [FicGenExecute] : FAILED CommandReturnValue = -1
2011-07-26 | 16:45:59 | ficgen | INFO | | | [FicGenImpl::FicGen] : FicGenExecute Complete
2011-07-26 | 16:45:59 | ficgen | INFO | | | [IccUpdateStatus] : Entry
2011-07-26 | 16:45:59 | ficgen | INFO | | | [IccUpdateStatus] : LOG_OPT = 0
2011-07-26 | 16:45:59 | ficgen | INFO | | | [IccUpdateStatus] : LOG_MSG = FicGeneric Terminated normally. Exit code = 127
2011-07-26 | 16:45:59 | ficgen | INFO | | | [IccUpdateStatus] : server update status = F
2011-07-26 | 16:45:59 | ficgen | INFO | | | [ICC_UPDATE] : Before ICC Update call
2011-07-26 | 16:45:59 | ficgen | SEVERE | | | [ICC_UPDATE] : ICC UPDATE FAILED ...

The issue can be reproduced at will with the following steps:
1. Create a new batch with the following 'Run Executable' task:

Property Value
Datastore Type EDW
Datastore Name OFSAADEV
IP Address 10.123.4.55
Executable /ofsa-infra/ftpshare/rates/Upload_rates.sh
Wait Y
Batch Parameter Y

2. Run the batch

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