Skip to Content
0
Former Member
Apr 09, 2014 at 03:55 PM

Batch job failing at workflow

217 Views

Hi all,

one of our batch job is failing daily at a specific work flow. Below is the job log

WORKFLOW: Work flow <WF> is started.

PRINTFN: Select LAST_EXECUTION_DATE From ETL_Status Where Job_Name = 'JOB' and WF_Name = 'WF' and DF_Name =DF'

PRINTFN: Update ETL_Status Set Start_Date = getdate(), Status = 'Running' Where Job_Name = 'JOB' and WF_Name = 'WF'

and DF_Name = 'DF'

PRINTFN: $l_last_xuc_date

PRINTFN: 2013.03.24 01:08:45

PRINTFN: Update ETL_Status Set Start_Date = getdate(), Status = 'Running' Where Job_Name = 'JOB' and WF_Name = WF' and DF_Name = DF'

PRINTFN: Workflow Name:WF

PRINTFN: 17.03.2013

PRINTFN: 2013.03.23 00:00:00

DATAFLOW: Process to execute data flow <DF> is started.

DATAFLOW: Data flow <DF> is started.

DATAFLOW: Cache statistics determined that data flow <DF> uses <0> caches with a total size of <0> bytes. This is less than(or

equal to) the virtual memory <159776590> bytes available for caches. Statistics is switching the cache type to IN MEMORY.

DATAFLOW: Data flow <DF> using IN MEMORY Cache.

After this the job is failed. all help is appreciated