DSD.SEQOpen Failed to open

Archive of postings to DataStageUsers@Oliver.com. This forum intended only as a reference and cannot be posted to.

Moderators: chulett, rschirm

Locked
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

DSD.SEQOpen Failed to open

Post by admin »

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
<b>PLEASE READ</b>
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
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

DSD.SEQOpen Failed to open

Post by admin »

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
<b>PLEASE READ</b>
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
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

DSD.SEQOpen Failed to open

Post by admin »

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
<b>PLEASE READ</b>
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
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

DSD.SEQOpen Failed to open

Post by admin »

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
<b>PLEASE READ</b>
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.
Locked