Page 1 of 1

Error When Creating Project?

Posted: Tue Jun 30, 2009 5:22 am
by laknar
ERROR: DSR.ADMIN: Error creating a schema

Status code = -135 DSJE_ADDPROJECTFAILED

Posted: Tue Jun 30, 2009 5:23 am
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

Posted: Tue Jun 30, 2009 5:47 am
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?

Posted: Tue Jun 30, 2009 5:47 am
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

Posted: Tue Jun 30, 2009 5:49 am
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.

Posted: Tue Jun 30, 2009 6:37 am
by laknar
Check Datastage is setup correctly in Project UV
(Subroutine Failed to Complete Successfully(30107))


the above error

Posted: Tue Jun 30, 2009 6:42 am
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?

Posted: Tue Jun 30, 2009 8:57 am
by laknar
At the end ADD Project process using Datastage adminstrator Client.

Posted: Wed Jul 01, 2009 1:45 am
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.

Posted: Wed Jul 01, 2009 9:06 pm
by laknar
Datastage user has write permission in the project directory.

Posted: Thu Jul 02, 2009 1:54 am
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?