Sequential file stage error

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
chandu123
Premium Member
Premium Member
Posts: 40
Joined: Mon Sep 12, 2016 1:26 pm

Sequential file stage error

Post by chandu123 »

I am getting this error while trying read files from a network location in sequential file stage. I am not able to figure out if this issue is related to the credential mappings and engine credential setup for dsadm or if the issue with access to files? Please advise.

Filename: `ls -name Historical Volumes*.csv #FilePath#`
Method: File pattern

Error:
Unable to open &COMO&: Permission denied.
Unable to open &HOLD&: Permission denied.

On a side note, how can we see the code written behind the scene for Sequential file stage?
HB
UCDI
Premium Member
Premium Member
Posts: 383
Joined: Mon Mar 21, 2016 2:00 pm

Post by UCDI »

the datastage login to the unix box is not allowed to open the file in question.

if you have a home or other folder that you can test with, just set that folder to full permissions (chmod 777 or winscp can do it) and try to write your file there. If that works, you need to get your sysadmin to grant access to the files to the datastage tools.

If it does not work, you may have some other weird issue.
SURA
Premium Member
Premium Member
Posts: 1229
Joined: Sat Jul 14, 2007 5:16 am
Location: Sydney

Re: Sequential file stage error

Post by SURA »

chandu123 wrote:Filename: `ls -name Historical Volumes*.csv #FilePath#`
Method: File pattern
Is it the same issue you have raised before?

By looking your command i doubt it may not work.
Thanks
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.
chandu123
Premium Member
Premium Member
Posts: 40
Joined: Mon Sep 12, 2016 1:26 pm

Post by chandu123 »

yes it is the same issue. I tried to achieve it in a different way and got different error. Now I have logged ticket with the support. Will update the outcome here!
HB
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Re: Sequential file stage error

Post by ray.wurlod »

chandu123 wrote:On a side note, how can we see the code written behind the scene for Sequential file stage?
No.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply