Error When Creating Project?

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
laknar
Participant
Posts: 162
Joined: Thu Apr 26, 2007 5:59 am
Location: Chennai

Error When Creating Project?

Post by laknar »

ERROR: DSR.ADMIN: Error creating a schema

Status code = -135 DSJE_ADDPROJECTFAILED
miwinter
Participant
Posts: 396
Joined: Thu Jun 22, 2006 7:00 am
Location: England, UK

Post by miwinter »

If I were you and wanting a reply... I'd add proper detail to your post about what you were doing, where, when, how etc... put the error in context and it will aid no end
Mark Winter
<i>Nothing appeases a troubled mind more than <b>good</b> music</i>
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

I prefer my error message, "##W IIS-DSEE-TBLD-00000 13:46:07(005) <main_program> Error when checking composite operator: Output from subprocess: /usr/vacpp/bin/xlC_r: 1501-228 input file /home/dsrun/PXFunctionTest/BadParams.o not found
". Want to trade? :roll:


Seriously, though. There have been several posts recently describing issues with project creation and UV_SCHEMA errors. Are you involved in any of those projects?
laknar
Participant
Posts: 162
Joined: Thu Apr 26, 2007 5:59 am
Location: Chennai

Post by laknar »

executing the below command in datastage server as dsadm user.

dsadmin -createproject test -location /usr/datastage/test

below error occur.


ERROR: DSR.ADMIN: Error creating a schema

Status code = -135 DSJE_ADDPROJECTFAILED
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Can you create a project as "dsadm" from the DataStage admin client? If not, then it is almost certainly access rights issues, either in the repository or on the datastage server.
laknar
Participant
Posts: 162
Joined: Thu Apr 26, 2007 5:59 am
Location: Chennai

Post by laknar »

Check Datastage is setup correctly in Project UV
(Subroutine Failed to Complete Successfully(30107))


the above error
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

While I like brevity, I think you might be overdoing it here. I'm not sure where that error message was generated - was it from the ADMIN tool? If so, did you get when entering the tool or when trying to add a project?
laknar
Participant
Posts: 162
Joined: Thu Apr 26, 2007 5:59 am
Location: Chennai

Post by laknar »

At the end ADD Project process using Datastage adminstrator Client.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

login to UNIX as your datastage user, then go to the path where you'd like to install the project and try "touch testfile" to see if you have sufficient access rights to create the directory.
laknar
Participant
Posts: 162
Joined: Thu Apr 26, 2007 5:59 am
Location: Chennai

Post by laknar »

Datastage user has write permission in the project directory.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Does the same error occur if you try to add project "TestProj" in "/tmp" (a new project name and a location where everyone can write)? Could it be that you don't have access to the UV_SCHEMA hashed file or that it is broken? Do you know how to enter TCL?
Post Reply