Hi,
Can anyone shed some light on this error?
main_program: Fatal Error: No match for pname: db_cs, which: 0
I'm trying to run a very simple job to read from a file and insert into an oracle table when it aborts.
Thanks in advance
H
main_program: Fatal Error: No match for pname: db_cs, which:
Moderators: chulett, rschirm, roy
I'm getting this error in the Director, I am able to view the data in the file from datastage and i'm not using any parameters. Its a job selecting two fields from a seq file, pushing them through to a transformer for handling nulls and trimming and the output is inserted into an oracle table using the oracle enterprise stage.hamzaqk wrote:Can you shed a bit more light on where are you getting this error ? are you being able to view the file properly ? Are you using parameters?
I have no idea what pname is. I havent specified it anywhere I dont know where its picking that from.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 ??
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
PWD has nothing to do with passwords. It serves the function "print working directory"; it contains the pathname of the working directory.
Is the job using a Sequential File stage to read the source file? How are you attempting to "select two fields" from the file?
Is the job using a Sequential File stage to read the source file? How are you attempting to "select two fields" from the file?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.