Page 1 of 1

sybase EE abort

Posted: Sat Aug 01, 2009 6:23 am
by yulangok
hi, how are you every one?
I develop a job which is extracting data from sybase database by sybase EE. I have two login users, and both of them can login in throgh sybase client. When I run the job, it finishes successfully using one user but abortes using another user. The messiage is "The parallel job encounter failed(code 255)". Can any boy give me advace? It is best you can tell me the requirement for using sybase EE.
Best regard!

Posted: Sat Aug 01, 2009 6:50 am
by ArndW
There will be more error message that are more helpful than the one you posted. Do you mean a different DataStage userid or a different Database userid?

Posted: Sat Aug 01, 2009 8:05 am
by yulangok
To ArndW :
Sir, in fact , there is no more helpful massage reported. I mean I use a different Database userid. And I judge that probably becase the difference privilege between the two Database userid, but I don't know the specificful requirement of a Database userid to use sybase EE.

Posted: Sat Aug 01, 2009 8:36 am
by ArndW
The userid question must be answered by your Sybase admin, most likely the GRANTs are insufficient. DataStage has no requirements - just that the ID you specify has sufficient access to perform the action required.