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.
DSR.ADMIN: Error creating DR elements, Error was -1
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 82
- Joined: Tue Jan 22, 2008 10:37 am
- Location: UK
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.
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.
-
- Premium Member
- Posts: 278
- Joined: Wed Oct 03, 2007 8:45 am
Thanks. I opened a case with IBM and got the details. Here it is for anyone who's interested:
Here are the contents of the DStageWrapper.sh shell script: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>
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 "$@"
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.
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
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: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?
The command to delete the project
DStageWrapper.sh -deleteproject <hostname> <projectname>