main_program: Fatal Error: No match for pname: db_cs, which:

hema177 · Post by **hema177** » Mon Mar 31, 2008 11:07 pm

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

hamzaqk · Post by **hamzaqk** » Mon Mar 31, 2008 11:12 pm

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?

hema177 · Post by **hema177** » Mon Mar 31, 2008 11:32 pm

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'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 · Post by **hamzaqk** » Mon Mar 31, 2008 11:41 pm

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 ??

hema177 · Post by **hema177** » Tue Apr 01, 2008 12:23 am

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.

hamzaqk · Post by **hamzaqk** » Tue Apr 01, 2008 1:10 am

you might want to check what is causing the warning and value of that enviroment variable. PWD i think would have do something with the password for connecting to oracle ?

ray.wurlod · Post by **ray.wurlod** » Tue Apr 01, 2008 1:12 am

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?

hamzaqk · Post by **hamzaqk** » Tue Apr 01, 2008 1:27 am

thanks for clearing that one up. i was'nt sure on that