Hi All,
To my utter surpise,
We have created data set file in one job and some times there are zero records in this for particular day run.
While reading the same data set file from another job with zero records our jobs are failing with below error.
Error executing View Data command:
##E TFDR 000001 15:02:58(014) </udd002/DSExtras/DataSets/Brac_Except2006-12-19.ds> Data set initialization for "/udd002/DSExtras/DataSets/Brac_Except2006-12-19.ds": This input-file data set does not exist: /udd002/DSExtras/DataSets/Brac_Except2006-12-19.ds.
##I TFCN 000001 15:02:58(000) <main_program>
Ascential DataStage(tm) Enterprise Edition 7.5.1A
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved
##I TUTL 000031 15:02:58(001) <main_program> The open files limit is 2000; raising to 2147483647.
##I TOSH 000002 15:02:58(002) <main_program> orchgeneral: loaded
##I TOSH 000002 15:02:58(003) <main_program> orchsort: loaded
##I TOSH 000002 15:02:58(004) <main_program> orchstats: loaded
##I TFSC 000001 15:02:58(005) <main_program> APT configuration file: /apps/Ascential/DataStage/Configurations/default.apt
##W TCOS 000049 15:02:58(006) <main_program> Parameter specified but not used in flow: DataSets
##W TCOS 000049 15:02:58(007) <main_program> Parameter specified but not used in flow: LoadFiles
##W TCOS 000049 15:02:58(008) <main_program> Parameter specified but not used in flow: CurrentDate
##W TCOS 000049 15:02:58(009) <main_program> Parameter specified but not used in flow: SeqFiles
##W TCOS 000049 15:02:58(010) <main_program> Parameter specified but not used in flow: PreviousDate
##W TCOS 000049 15:02:58(011) <main_program> Parameter specified but not used in flow: FileName
##W TCOS 000049 15:02:58(012) <main_program> Parameter specified but not used in flow: FileSets
##W TCOS 000049 15:02:58(013) <main_program> Parameter specified but not used in flow: DSProjectMapName
>##E TFDR 000001 15:02:58(014) </udd002/DSExtras/DataSets/Brac_Except2006-12-19.ds> Data set initialization for "/udd002/DSExtras/DataSets/Brac_Except2006-12-19.ds": This input-file data set does not exist: /udd002/DSExtras/DataSets/Brac_Except2006-12-19.ds.
>##E TCOS 000029 15:02:58(015) <main_program> Creation of a step finished with status = FAILED.
>
shall appreciate your response.
thanks
Not able to read Data set file with zero records
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 108
- Joined: Wed Jul 28, 2004 7:15 am
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
Check whether this file "/udd002/DSExtras/DataSets/Brac_Except2006-12-19.ds" physically exists on the server. If it does exist then try to open it using the Data Set Management utility in the DataStage Manager. If not, then you need to check the code which is creating this data set.
I haven't failed, I've found 10,000 ways that don't work.
Thomas Alva Edison(1847-1931)
Thomas Alva Edison(1847-1931)