DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
admin
Site Admin



Joined: 12 Jan 2003
Posts: 8720

Points: 10

Post Posted: Wed Feb 18, 2004 4:01 pm Reply with quote    Back to top    

I am getting an error and don't know how to research it. What is status=13, when opening flat files?
Deptree..siDeptree.lin: DSD.SEQOpen Failed to open baseroll.csv in directory \\Phl-file-04\Is\MES-QDW
STATUS = 13.

I can open this file using MS/Explorer, but I cannot view the file from Designer/Job stage/view function and the job gets this same error when executing.
I was OK this morning at 12:20 am, but I am stopped cold now.

Daniel A. Sutton Associate Technical Fellow, Boeing Navigator
Hierarchical Databases, Data Warehouse, and Migration Control Group

To be in a dialogue, we must listen from where the other person speaks.
Otherwise, we only have two monologues

Boeing Philadelphia IS/Data Management
610-591-7124 610-591-7524(fax) 800-946-4646 pwd 1499533(beeper)

email: daniel.a.sutton@boeing.com

Regular Mail Address:
Boeing
PO Box 16858 MS-P29-29
Philadelphia PA 19142-0858



_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users

_________________
PLEASE READ
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
admin
Site Admin



Joined: 12 Jan 2003
Posts: 8720

Points: 10

Post Posted: Wed Feb 18, 2004 9:47 pm Reply with quote    Back to top    

Sorry, don't know what status=13 means. But, you are
accessing the file via a UNC path, so that leads me to
several suggestions to try. If you "see" the file in
Explorer, is that from your client machine or from the
Server? Because, it's what the server can see, not
your client, that counts. Have you copied the file or
a sample locally to the server and tried a view data
from there? Can you see other files on
\\Phl-file-04\xxx? Could you have either a login
rights, permissions, or path issue coming from the DS
server?

Good luck!
-Ken


--- "Sutton, Daniel A"
wrote:
> I am getting an error and don't know how to research
> it. What is status=13, when opening flat files?
> Deptree..siDeptree.lin: DSD.SEQOpen Failed to open
> baseroll.csv in directory \\Phl-file-04\Is\MES-QDW
> STATUS = 13.
>
> I can open this file using MS/Explorer, but I cannot
> view the file from Designer/Job stage/view function
> and the job gets this same error when executing.
> I was OK this morning at 12:20 am, but I am stopped
> cold now.
>
> Daniel A. Sutton Associate Technical Fellow, Boeing
> Navigator
> Hierarchical Databases, Data Warehouse, and
> Migration Control Group
>
> To be in a dialogue, we must listen from where the
> other person speaks.
> Otherwise, we only have two monologues
>
> Boeing Philadelphia IS/Data Management
> 610-591-7124 610-591-7524(fax) 800-946-4646
> pwd 1499533(beeper)
>
> email: daniel.a.sutton@boeing.com
>
> Regular Mail Address:
> Boeing
> PO Box 16858 MS-P29-29
> Philadelphia PA 19142-0858
>
>
>
> _______________________________________________
> datastage-users mailing list
> datastage-users@oliver.com
>
http://www.oliver.com/mailman/listinfo/datastage-users


__________________________________
Do you Yahoo!?
Yahoo! Mail SpamGuard - Read only the mail you want.
http://antispam.yahoo.com/tools
_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users

_________________
PLEASE READ
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Rate this response:  
Not yet rated
admin
Site Admin



Joined: 12 Jan 2003
Posts: 8720

Points: 10

Post Posted: Wed Feb 18, 2004 10:33 pm Reply with quote    Back to top    

Depending on what is getting passed back to you by DataStage:

DOS Error Code 13 (hex): Attempt to write on a write-protected disk
DOS Error Code 13 (dec): Invalid Data
Windows Error 13: Permission Denied
UNIX Error 13: Permission Denied

Don't know if this all helps. I'm assuming DataStage running under Windows
can have some of the same issues as it does under UNIX - just because "you"
have permissions to see something doesn't mean your jobs do - even when they
are running under "your" userid.

-craig

-----Original Message-----
From: datastage-users-bounces@oliver.com
[mailto:datastage-users-bounces@oliver.com] On Behalf Of Kenneth Bland
Sent: Wednesday, February 18, 2004 8:48 PM
To: DataStage Users Discussion List
Subject: Re: DSD.SEQOpen Failed to open


Sorry, don't know what status=13 means. But, you are
accessing the file via a UNC path, so that leads me to
several suggestions to try. If you "see" the file in
Explorer, is that from your client machine or from the
Server? Because, it's what the server can see, not
your client, that counts. Have you copied the file or
a sample locally to the server and tried a view data
from there? Can you see other files on
\\Phl-file-04\xxx? Could you have either a login
rights, permissions, or path issue coming from the DS
server?

Good luck!
-Ken


--- "Sutton, Daniel A"
wrote:
> I am getting an error and don't know how to research
> it. What is status=13, when opening flat files?
> Deptree..siDeptree.lin: DSD.SEQOpen Failed to open
> baseroll.csv in directory \\Phl-file-04\Is\MES-QDW
> STATUS = 13.
>
> I can open this file using MS/Explorer, but I cannot
> view the file from Designer/Job stage/view function
> and the job gets this same error when executing.
> I was OK this morning at 12:20 am, but I am stopped
> cold now.
>
> Daniel A. Sutton Associate Technical Fellow, Boeing
> Navigator
> Hierarchical Databases, Data Warehouse, and
> Migration Control Group
>
> To be in a dialogue, we must listen from where the
> other person speaks.
> Otherwise, we only have two monologues
>
> Boeing Philadelphia IS/Data Management
> 610-591-7124 610-591-7524(fax) 800-946-4646
> pwd 1499533(beeper)
>
> email: daniel.a.sutton@boeing.com
>
> Regular Mail Address:
> Boeing
> PO Box 16858 MS-P29-29
> Philadelphia PA 19142-0858


_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users

_________________
PLEASE READ
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Rate this response:  
Not yet rated
admin
Site Admin



Joined: 12 Jan 2003
Posts: 8720

Points: 10

Post Posted: Thu Feb 19, 2004 7:31 am Reply with quote    Back to top    

Hi Daniel,

What are you logging on to the DataStage Designer or Director as?

What we found was if we chose Omit, then we don't get the needed authentication to work on files via a UNC path. So we do the following:

1. When we logon to a DataStage (Director, Designer, etc.) we always use a username of: Domain\MyUserid (where the domain may or may not be needed depending on your setup).
2. We set up a userid (we called it "Datastage") and in the Administrator under the Schedule tab for the project, we used this "Datastage" userid in "User name for scheduled jobs."
3. In the UNC directory we give our userids plus the DataStage userid the needed permissions.

With this setup, when we run a job it uses the permissions of the Domain\MyUserid that we signed on to the DataStage GUI with. When we schedule a job, it uses the permissions of the "DataStage" userid we setup.

I hope this helps you,

Scott

--- "Sutton, Daniel A"
wrote:
> I am getting an error and don't know how to research
> it. What is status=13, when opening flat files?
> Deptree..siDeptree.lin: DSD.SEQOpen Failed to open
> baseroll.csv in directory \\Phl-file-04\Is\MES-QDW
> STATUS = 13.
>
> I can open this file using MS/Explorer, but I cannot
> view the file from Designer/Job stage/view function
> and the job gets this same error when executing.
> I was OK this morning at 12:20 am, but I am stopped
> cold now.


_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users

_________________
PLEASE READ
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Rate this response:  
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours