DSXchange

Is there a question here anywhere?

Dude, that is totally uncool. You edited your original post to not only change the subject but to also to replace the original question with a completely different one, such that our first two replies now make zero sense.

Nex time, just move on and start a new post.

Wow... paragraphs would be nice. I've attached a couple of extra carriage returns for use in your next post.

Is this 'process' a job? A typical 'hang' in situations like this can occur if the job tries to attach to itself, any chance that is happening?

You're asking here for help writing a C program to read a flat file? There are more appropriate places out there for this kind of question, seeing as how this really isn't a DataStage question or problem, but perhaps someone may take pity on you and throw you a bone. Best to find a forum/resource de...

In other words, how you've defined the file contents in the stage (your metadata) doesn't match reality, what's actually in the file. You need to correct that.

More than what?

But it does now because you did what? Please post the exact resolution in order to help future searchers. Thanks!

Images cannot be "attached" here. Rather you need to upload them somewhere else and then link them to a post here using the [img] or "image tags". Lots of sites available to do free file sharing / hosting, if you feel the need to show us your screenshots. Can't tell from what you...

It's an "informational" message only and should occur in conjunction with the "real" problem, which should have also been reported.

Some examples of troubleshooting it: http://www.dba-oracle.com/t_ora_12537_tns_error.htm

You might also consider running DSJobReport 'after job' and processing its output for auditing purposes.

Is this the first time you are attempting to compile a PX job with a Transformer stage in it? Or you've done that before and there's something wrong with this particular job?

Isn't there some sort of odd MI bug that enabling auto-purge of the logs creates that people have reported? What happens if you disable auto-purge for this job?

Even if you managed to set an environment variable in one job, it wouldn't still be there for any others, being local in scope. What about using USERSTATUS as the mechanism?

We are on Data Stage Server version 7.5x2 on AIX 5.2 ML08 Sorry, but you aren't. The "7.5x2" version was special and only produced for Windows servers. Did you mean "7.5.2" instead? If you Reset the aborted job, does a new "From previous run..." entry get added to the ...

Are you certain you've got a valid / working stored procedure? Tested it outside of DataStage?