Executing Run Pipeline

You can execute a Run Pipeline from UI or using a command line utility called wfExecExternal.sh. 

From UI

To execute Run Pipeline from UI:

1.      From the Process Modeller Summary window, click  corresponding to the Run Pipeline you want to execute:

2.     Click Execute Run to execute the Run Pipeline. The Select Run Params window is displayed.

3.     Select values for the Run Parameters and click OK.

The execution of the Run Pipeline is triggered using the selected FIC MIS DATE. The RUNSKEY is generated and inserted into the “DIM_RUN” table. For the RUNSKEY generated, the corresponding user-selected parameters are inserted into the “RUN_EXE_PARAMETERS” table.

Using Command Line Utility

A command line utility ./wfExecExternal.sh is available in $FIC_DB_HOME/bin folder.

To execute Run Pipeline using command line utility

1.      Navigate to $FIC_DB_HOME/bin folder.

2.     Execute the script file using the following command:

./wfExecExternal.sh processInstanceId processId objectId objectType infodom userID segment locale 'applicationparams' 'securityparams'

§       processInstanceId - Instance Id of the Process or Run Pipeline

§       processId - Process ID of the Run Pipeline. This is a mandatory parameter.

§       objectId -Specify a unique Object ID. This is a mandatory parameter.

§       objectType - Specify the Object Type if it is defined in the aai_wf_app_definition_map table.

§       infodom - Information Domain Name

§       userID - Specify the user ID  

§       segment - Segment Name

§       locale - Locale selected. For example, en_US

§       'applicationparams'- Specify values for the Run execution parameters stored in APP_COMP_ATTR_MAP_ID within single quotes separated by comma.

§       'securityparams'- Specify any security parameters within single quotes separated by comma

For example:

./wfExecExternal.sh null 1542221676429 CECLShellLatest null OFSIFRSINFO OFSIFRSINFO AAAIUSER en_US "hierDetailsLE":[{"hierValueCode":"AU","value":"Bank of Australia","hierNodeCode":"[HLLFP029].[0].[AU]","leafCondition":"CASE WHEN DIM_ORG_STRUCTURE.f_latest_record_indicator = 'Y' THEN DIM_ORG_STRUCTURE.v_entity_code END='AU'","hierNodeDesc":"Bank of Australia"}],"CONSOTYPE":"S","hierDetailsRCY":[{"hierValueCode":"DZD","value":"Algerian Dinar","hierNodeCode":"[HLLFP026].[DZD]","leafCondition":"DIM_CURRENCY.v_iso_currency_cd = 'DZD'","hierNodeDesc":"Algerian Dinar"}],"FIC_MIS_DATE":"2019-04-19","V_RUN_MAIN_DESC":"Test"}' null