DSXchange

Not all that rare, I've seen it before.

Want to share some details as to exactly what you are doing - file type, anything funky? Are you using the Filter option of the stage?

So... in other words... you have no issue?

And yet you've marked your post as having a Windows server installation.

Are you looking for something other than the dsjob command? If so - details man, details.

Hopefully, they 'found' it by searching the forums. I had the issue awhile back and helped someone else figure out an approach when they wanted to leave the XML option checked and still do command line exports. They ended up scripting a registry hack that 'unchecked the option' first in the export ...

Huh... interesting. Tanks.

Stick around, we "see" it all the time here...

"Suggest method A"

"Client has forbidden method A"

"How about method B then?

"Sorry, not allowed"

"How about you whack Client upside the head for us?"

True... but who drags stages from there?

mram33 wrote:3. Add ORACLE_HOME/bin to your PATH and ORACLE_HOME/lib to your LIBPATH, LD_LIBRARY_PATH, or SHLIB_PATH.

Sometime after editing dsenv in this step, did you stop and restart DataStage?

However, having just tried it in version 7.5.1 the 'Server' transformer is greyed out in the palette of a Parallel job. Server Transformer stage != PX BASIC Transformer stage. Two different things. Problem is all three use the exact same icon on the palette from what I recall. And you have to speci...

As noted, this isn't a Complex Flat File... it's a report. Roll your own.

it pops up a window and says "The project99.dsx file already exists. Do u want to replace it?". Actually before running the command there was no file with name project99.dsx in the scratch directory. Known 'bug' or issue with it where it wants to delete a non-existent export file. Your last manual ...

If you really want a DTD, use something like XML Spy to create one.

What's different about the data in the 'other scenarios' when it fails compared to when it succeeds? What is going on in-and-around line 139 in the code that it points to in the message? Do you know where to find JOB.82185807.DT.1407164135.TRANS3 for job number 319? You should... I Dont know where ...

Load_Fact_PTD_YTD_Variance_Qty_VAS..Passthru16: |Load_Fact_PTD_YTD_Variance_Qty_VAS..Hash_VAS_SC16.ToHashVASSC16: DSD.UVOpen Unable to open file '/etlstg/DATA_FILES/HASH_FILES/HASH_MOB_VAS_SC1'.| I am getting the above log when i reset after it gets aborted Means nothing. This is a typical 'post ab...

Have you tried searching the forum? Asked and answered many (many) times.