'Step Failure' & 'taskStatus - in isRunnableChildPresent : 1' Running Custom Post Load Transformation in Batch (Doc ID 1673348.1)

Last updated on MARCH 06, 2017

Applies to:

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

Symptoms

In Oracle Financial Services Analytical Applications (OFSAA), you cannot execute a custom Post Load Transformation using a Batch.  You can run the function included in the Post Load Transformation successfully in SQL*Plus on the server.  But when you run it in Operations > Batch Execution, the Batch ends in a status of Failed. The following error is in the "RunProc" Batch log file from $FIC_DB_HOME/log/date:

Log Message here 1: Tue May 13 19:31:08 2014||INFO||After Calling execProc
Log Message here 1: Tue May 13 19:31:08 2014||SEVERE||Stored procedure execution failed

The following messages are in the "DT" Batch log file from $FIC_DB_HOME/log/date:

Log Message here 1: Tue May 13 19:31:08 2014||INFO||exit status : 1
Log Message here 1: Tue May 13 19:31:08 2014||INFO||Step Failure -- <transformation name>_1
Log Message here 1: Tue May 13 19:31:08 2014||INFO||taskStatus - in isRunnableChildPresent : 1
Log Message here 1: Tue May 13 19:31:08 2014||INFO||All the steps/jobs have been executed
Log Message here 1: Tue May 13 19:31:08 2014||INFO||Jobs over.

This error prevents you from running the custom Post Load Transformations from a 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