My Oracle Support Banner

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

Last updated on SEPTEMBER 06, 2018

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

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.