DSR.ADMIN: Error creating DR elements, Error was -1

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
vipson
Premium Member
Premium Member
Posts: 52
Joined: Thu Jan 03, 2008 10:31 pm

DSR.ADMIN: Error creating DR elements, Error was -1

Post by vipson »

I am running DS 8.0.1 FP1a on Solaris.
I am trying to create a project named TCL_US and I am getting error:
DSR.ADMIN: Error creating DR elements, Error was -1

I tried creating projects namd "TCLUS", "Test001", "TEST2" etc.
All of these projects were created without any issue.

I have created projects like TOT_US in past..

On Unix, space wise; I have lots of space available.
I am checking with my DBA to find out if the repository has any issue with space; which I doubt is the problem. Because I am able to create projects with other names..

I have opened up case with IBM..and waiting for their answer..

Any suggestion/idea?

Also,
I have Test environment where I was able to create the "TCL_US" project. Test environment is also on Solaris DS 8.0.1 FP1a.
deanwalker
Participant
Posts: 82
Joined: Tue Jan 22, 2008 10:37 am
Location: UK

Post by deanwalker »

DataStage failed to create all the required project records in XMETA, you will not be able to create a project with this name until these are removed.
If you can live with another project name, then that is a workaround.
You will need help from support to remove the existing items if you require to use that project name.
vipson
Premium Member
Premium Member
Posts: 52
Joined: Thu Jan 03, 2008 10:31 pm

Post by vipson »

Well,
I ended up working with IBM and they gave me partial solution.
With my DBA knowledge I was able to figure out the rest..

Basically it is a three step process. You run a shell script, you run some DS command and than you clean up the xmeta tables...
roblew
Charter Member
Charter Member
Posts: 123
Joined: Mon Mar 27, 2006 7:32 pm
Location: San Ramon

Post by roblew »

I have run into a similar issue. I have ample space (db and os). I just want to figure out how to delete any references to this project.

vipson, do you have a case number I can reference?
sjfearnside
Premium Member
Premium Member
Posts: 278
Joined: Wed Oct 03, 2007 8:45 am

Post by sjfearnside »

I had a similiar problem in Feb 08. The case # was 712398
roblew
Charter Member
Charter Member
Posts: 123
Joined: Mon Mar 27, 2006 7:32 pm
Location: San Ramon

Post by roblew »

Thanks. I opened a case with IBM and got the details. Here it is for anyone who's interested:
You will need to do the following to delete the project:

Delete the project from UV Account
1. Check that the project folder no longer exist in the projects folder. If it still exist, please
delete the project folder completely.
2. telnet to the UV or go to command line in Administrator
3. Run the command, LIST UV.ACCOUNT projectname
4. If you can see the project, run the command,
DELETE UV.ACCOUNT projectname
5. Now you need to fix the schema. Run the command,
LIST UV_SCHEMA
6. If you see the project, run the command,
VERIFY.SQL SCHEMA project FIX
7. Check that you cannot see the project anymore,
run the command LIST UV_SCHEMA again

Delete the project from Repository:
The attached zip file contains the DStageWrapper.sh script can be use as
outlined below to check for the bad project and then delete it.
Depending on your install location you may have to modify the script to
point to the right locations.

The command to list the project

DStageWrapper.sh -query "select x.Name,x.HostName from x in
DataStageX::DSProject"
will list all of the projects in the repository

The command to delete the project
DStageWrapper.sh -deleteproject <hostname> <projectname>
Here are the contents of the DStageWrapper.sh shell script:

Code: Select all

# Script to run dstage_wrapper.jar command line

. `cat /.dshome`/dsenv 
NODE_DIR=${ASBHOME}
CLASSPATH="${NODE_DIR}/conf:${NODE_DIR}/lib/java/ACS_client.jar:${NODE_DIR}/lib/java/ACS_common.jar:${NODE_DIR}/lib/java/ASB_utils.jar:${NODE_DIR}/lib/java/ASB_util_client.jar:${NODE_DIR}/lib/java/WASClient.jar:${NODE_DIR}/lib/java/dstage_wrapper.jar:${NODE_DIR}/lib/java/dstage_wrapper.jar"
exec "${NODE_DIR}/apps/jre/bin/java" "-Djava.security.auth.login.config=${NODE_DIR}/conf/auth.conf" "-Dcom.ibm.CORBA.ConfigURL=file:${NODE_DIR}/conf/sas.client.props" -Djava.util.logging.manager=com.ibm.ws.bootstrap.WsLogManager -Djava.util.logging.configureByServer=true  -classpath "$CLASSPATH" com.ascential.dstage.proxies.Loader "$@"
boxtoby
Premium Member
Premium Member
Posts: 138
Joined: Mon Mar 13, 2006 5:11 pm
Location: UK

Post by boxtoby »

Thanks for the info guys, just hit the same problem myself!

Unfortunately I can't quite understand the command:

DStageWrapper.sh -query "select x.Name,x.HostName from x in
DataStageX::DSProject"

what does the "x" stand for?

and what is DataStageX::DSProject?


Thanks for any assistance.

Bob.
Bob Oxtoby
roblew
Charter Member
Charter Member
Posts: 123
Joined: Mon Mar 27, 2006 7:32 pm
Location: San Ramon

Post by roblew »

boxtoby wrote:Unfortunately I can't quite understand the command:

DStageWrapper.sh -query "select x.Name,x.HostName from x in
DataStageX::DSProject"

what does the "x" stand for?

and what is DataStageX::DSProject?
you know what... I think you just enter the commands as-is. I don't remember changing anything. I'll try to find my logs from when I ran it. I don't think it should do any harm by just running that, since it just queries the repository and gives you a result set (it won't delete anything at that point). The next step actually does the delete, which you will have to replace the things in brackets:

The command to delete the project
DStageWrapper.sh -deleteproject <hostname> <projectname>
Post Reply