hamzaqk wrote:Would be a good idea if you could post the whole log then ?
p.s i think you might want to double check the values you are specifying for the enterprise stage. and what is pname ??
I have no idea what pname is. I havent specified it anywhere I dont know where its picking that from.
The log's below:
DataStage Report - Summary Log for job: TB_BAYE_PARTICIPATION_LOAD
Produced on: 01/04/2008 11:33:46
Project: HRBIS Host system: 11.154.64.86
Items: 1 - 11
Sorted on: Date Sorter
Occurred: 06:52:17 On date: 01/04/2008 Type: Control
Event: Starting Job TB_BAYE_PARTICIPATION_LOAD. (...)
Occurred: 06:52:17 On date: 01/04/2008 Type: Info
Event: Environment variable settings: (...)
Occurred: 06:52:17 On date: 01/04/2008 Type: Info
Event: Parallel job initiated
Occurred: 06:52:17 On date: 01/04/2008 Type: Info
Event: Parallel job default NLS map UTF-8, default locale OFF
Occurred: 06:52:17 On date: 01/04/2008 Type: Info
Event: main_program: Ascential DataStage(tm) Enterprise Edition 7.5.1A (...)
Occurred: 06:52:18 On date: 01/04/2008 Type: Info
Event: main_program: The open files limit is 100; raising to 65536.
Occurred: 06:52:18 On date: 01/04/2008 Type: Info
Event: main_program: orchgeneral: loaded (...)
Occurred: 06:52:18 On date: 01/04/2008 Type: Info
Event: main_program: APT configuration file: /opt/Ascential/Ascential/DataStage/Configurations/hrmis1node.apt (...)
Occurred: 06:52:18 On date: 01/04/2008 Type: Warning
Event: main_program: Warning: the value of the PWD environment variable (/opt/Ascential/Ascential/DataStage/DSEngine) does not appear to be a synonym for the current working directory (/opt/Ascential/Ascenti (...)
Occurred: 06:52:19 On date: 01/04/2008 Type: Fatal
Event: main_program: Fatal Error: No match for pname: db_cs, which: 0
Occurred: 06:52:24 On date: 01/04/2008 Type: Control
Event: Job TB_BAYE_PARTICIPATION_LOAD aborted.
End of report.