OFSAA User Defined Executable Script Batch Using "Run Executable" Component Fails With 'Server command has NO parameters'

Last updated on JULY 05, 2017

Applies to:

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