OFSAA User Defined Executable Script Batch Using "Run Executable" Component Fails With 'Server command has NO parameters'
(Doc ID 1343957.1)
Last updated on AUGUST 07, 2020
Applies to:
Oracle Financial Services Analytical Applications Infrastructure - Version 7.2 and laterInformation 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 = OFSAA_BATCH2_20110726_5 ComponentId = RUN EXECUTABLE TaskId = Task1 InfoDate = 20110726 Parameters = /ftpshare/rates/Upload_rates.sh,Y,Y DataStore = OFSAA DataStoreType = EDW IPAddress =
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 = [/ftpshare/rates/Upload_rates.sh,Y,Y]
2011-07-26 | 16:45:59 | ficgen | INFO | | | [GetBatchParam] : ENTRY : parameters = /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 = /ftpshare/rates/Upload_rates.sh,Y
2011-07-26 | 16:45:59 | ficgen | INFO | | | [GetWaitParam] : ENTRY : parameters = /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 = /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 : [/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 = #/ftpshare/rates/Upload_rates.sh#
2011-07-26 | 16:45:59 | ficgen | INFO | | | [FicGenExecute] : Server processName after CheckProcessName : [/ftpshare/rates/Upload_rates.sh]
2011-07-26 | 16:45:59 | ficgen | INFO | | | [FicGenExecute] : Server local parameters /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 OFSAA
IP Address <xx.xxx.x.xx>
Executable /tpshare/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 |