Error with Universe Stage
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 142
- Joined: Mon Jun 27, 2005 5:31 pm
- Location: Atlanta GA
Error with Universe Stage
Hi folks I am expiriencing the following error with Universe stage.
UniVerse_61.DSLink62: DSD.BCIOpenW call to SQLExecDirect failed.
CREATE TABLE "mapping"("maptype" CHAR(10) NOT NULL, "sApplicationName" VARCHAR(30), "sApplicationId" DECIMAL(12, 0), "sTableName" VARCHAR(30), "sTableId" DECIMAL(12, 0), "sDataElementName" VARCHAR(30), "sDataElementId" DECIMAL(12, 0), "tApplicationName" VARCHAR(30), "tApplicationId" DECIMAL(12, 0), "tTableName" VARCHAR(30), "tTableId" DECIMAL(12, 0), "tDataElementName" VARCHAR(30), "tDataElementId" DECIMAL(12, 0))
SQLSTATE=42000, DBMS.CODE=950338
[DataStage][SQL Client][UNIVERSE]DataStage/SQL: "VMW-DWETL02\\velag001" is not an SQL user.
This job is created by different user and I think he doesnt have any problems. Apparently VMW-DWETL02 is the box where DS is sitting on and velag001 is my login. Looks like a permission issue. Can any one let me know what to do.
UniVerse_61.DSLink62: DSD.BCIOpenW call to SQLExecDirect failed.
CREATE TABLE "mapping"("maptype" CHAR(10) NOT NULL, "sApplicationName" VARCHAR(30), "sApplicationId" DECIMAL(12, 0), "sTableName" VARCHAR(30), "sTableId" DECIMAL(12, 0), "sDataElementName" VARCHAR(30), "sDataElementId" DECIMAL(12, 0), "tApplicationName" VARCHAR(30), "tApplicationId" DECIMAL(12, 0), "tTableName" VARCHAR(30), "tTableId" DECIMAL(12, 0), "tDataElementName" VARCHAR(30), "tDataElementId" DECIMAL(12, 0))
SQLSTATE=42000, DBMS.CODE=950338
[DataStage][SQL Client][UNIVERSE]DataStage/SQL: "VMW-DWETL02\\velag001" is not an SQL user.
This job is created by different user and I think he doesnt have any problems. Apparently VMW-DWETL02 is the box where DS is sitting on and velag001 is my login. Looks like a permission issue. Can any one let me know what to do.
Venkat Velagapudi
-
- Premium Member
- Posts: 108
- Joined: Sat Feb 05, 2005 6:52 pm
- Location: US
-
- Premium Member
- Posts: 142
- Joined: Mon Jun 27, 2005 5:31 pm
- Location: Atlanta GA
-
- Premium Member
- Posts: 108
- Joined: Sat Feb 05, 2005 6:52 pm
- Location: US
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You may be the Administrator, but are you the DBA?
to find out.
Code: Select all
SELECT * FROM UV_USERS WHERE DBAAUTH = 'YES';
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 142
- Joined: Mon Jun 27, 2005 5:31 pm
- Location: Atlanta GA
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 142
- Joined: Mon Jun 27, 2005 5:31 pm
- Location: Atlanta GA
(C) Copyright 1985-2001 Microsoft Corp.
C:\Documents and Settings\Administrator>cd `cat \.dshome`
The system cannot find the path specified.
C:\Documents and Settings\Administrator>
C:\Documents and Settings\Administrator>cd $DSHOME
The system cannot find the path specified.
C:\Documents and Settings\Administrator>
This is what Iam getting when I am using the command prompt.
Pls let me know how to get in to DSHome.
C:\Documents and Settings\Administrator>cd `cat \.dshome`
The system cannot find the path specified.
C:\Documents and Settings\Administrator>
C:\Documents and Settings\Administrator>cd $DSHOME
The system cannot find the path specified.
C:\Documents and Settings\Administrator>
This is what Iam getting when I am using the command prompt.
Pls let me know how to get in to DSHome.
Venkat Velagapudi
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You're on Windows. Windows does not have a cat command (though there is on in MKS Toolkit, which you might have installed). DataStage on Windows does not record the installation directory in /.dshome - rather it uses a Registry entry.
Try
Try
Code: Select all
cd C:\Ascential\DataStage\Engine
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 142
- Joined: Mon Jun 27, 2005 5:31 pm
- Location: Atlanta GA
Hi I am not the DBA.
E:\Ascential\DataStage\Engine>bin\uv
DataStage Command Language 7.5
Copyright (c) 1997 - 2004 Ascential Software Corporation. All Rights Reserved
Engine logged on: Wednesday, April 19, 2006 09:45
>SELECT * FROM UV_USERS WHERE NAME='velag001';
User Name.......... velag001
DBauth Privilege... NO
Resource Privilege. YES
Author............. velag001
Own-Table Schema.. Owned Tables......
Perm-Table Schema. Permitted Tables..
When I tried to give myself DBAUTH, It gave me following message
>UPDATE UV_USERS SET DBAUTH='YES' WHERE NAME='velag001';
WRITE attempt on read-only file.
>
When I tried to give DBAUTH with the help of other guy who has DBAUTH=YES, even he got the same above message.
i.e WRITE attempt on read-only file.
Pls help me
E:\Ascential\DataStage\Engine>bin\uv
DataStage Command Language 7.5
Copyright (c) 1997 - 2004 Ascential Software Corporation. All Rights Reserved
Engine logged on: Wednesday, April 19, 2006 09:45
>SELECT * FROM UV_USERS WHERE NAME='velag001';
User Name.......... velag001
DBauth Privilege... NO
Resource Privilege. YES
Author............. velag001
Own-Table Schema.. Owned Tables......
Perm-Table Schema. Permitted Tables..
When I tried to give myself DBAUTH, It gave me following message
>UPDATE UV_USERS SET DBAUTH='YES' WHERE NAME='velag001';
WRITE attempt on read-only file.
>
When I tried to give DBAUTH with the help of other guy who has DBAUTH=YES, even he got the same above message.
i.e WRITE attempt on read-only file.
Pls help me
Venkat Velagapudi
You need to use the GRANT command to effect this. Try GRANT DBA TO velag001;
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 142
- Joined: Mon Jun 27, 2005 5:31 pm
- Location: Atlanta GA