Not able to open text file

Xpert · Post by **Xpert** » Mon Feb 16, 2009 7:53 am

Hi all,

I have created a server job which has desing as below.

Seq.File -----> Transformer --------> Oracle stage

It successfully completed.

I have created a copy of the above job and the file metadata structure is same and used Parameter for Pathname and Filename.

when I check to view the data, its throwing the below error message.

"CopyOfJ_Stg_RAM_Asset..SEQ_Balance_CTL1.Src_Hash: DSD.SEQOpen Failed to open BH_RAMS_TRAILBAL_CTL.txt in directory /data/FINETL/incoming
STATUS = -1"

But when I hardcode the pathname and filename, I am able to view the data. And also when I use the previous run file, its not giving any error message.

Could anyone please help me out?

Thanks in advance.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Mon Feb 16, 2009 8:36 am

Something you might have already tried

1.) Copy one of "previous run" files as the new name and try to view
2.) When you "view data", does all required parameter prompts appear?
3.) Is there any special chars in the filename / format section?

mk_ds09 · Post by **mk_ds09** » Mon Feb 16, 2009 10:42 am

If hard coding is working and the parameters are not working means there are some issues with parameters only..

1.Check your parameters properly.
2.Check if there is any space of path name which you are passing is correct.

Hope this helps.

Xpert · Post by **Xpert** » Mon Feb 16, 2009 10:47 pm

mk_ds09 wrote:If hard coding is working and the parameters are not working means there are some issues with parameters only..

1.Check your parameters properly.
2.Check if there is any space of path name which you are passing is correct.

Hope this helps.

Parameters are correct and there is no space.

If i pass the previous run file name, its showing the data but for new file, its throwing the error message.

ray.wurlod · Post by **ray.wurlod** » Tue Feb 17, 2009 1:31 am

Disk full? File permissions? Directory permissions?
Verify parameter value (posted in "job starting" event in job log).

Xpert · Post by **Xpert** » Tue Feb 17, 2009 2:12 am

ray.wurlod wrote:Disk full? File permissions? Directory permissions?
Verify parameter value (posted in "job starting" event in job log).

Ray,

The directory and file has full rights. Disk is not full.

#$SrcPath##TPFileName#_CTL.txt

$SrcPath --> /data/FINETL/incoming/
TPFileName --> BH_RAMS_TRAILBAL

When I give the above values directly, its showing the data.

But when I use parameters, its throwing the error message.

I'm not able to understand. why its happening like this?

ray.wurlod · Post by **ray.wurlod** » Tue Feb 17, 2009 3:31 am

What happens if you use a job parameter that is NOT an environment variable?