DSXchange

My problem got resolved after changing all my columns to same data type and length for pivot stage.

Not sure whether this is correct solution but it worked for me.

DSguru2B wrote:Dump the hashed file into a text file and pivot that. See if the error persists. ...

i have tried this option too..but got
Arithmetic overflow
|-100|

Reset the aborted job and let us know the contents of the "From previous run..." log message if it shows up. ... Resetting Job pivotjob. Resetting stage pivotjob..Transformer_117. pivotjob..ValidateFile.ValidateFile: Write link private caching enabled, cache size (128MB) pivotjob..Hashed_...

hi, I have a server job which has [hash]-->[transformer]--->[pivot]--->[file] The job is aborting with DataStage Job 1898 Phantom 6648 Access violation. Attempting to Cleanup after ABORT was raised in stage testjob..Pivot_145 DataStage Phantom Aborting with @ABORT.CODE = 3 There are no other message...

Hi, I have a situation where i have to query a table and look for a column.It is 'A' then proceed to another job. I have to keep running the job until the column value is 'A'. Another process outside of etl updates this table.. Now how can i run the job every 5 min to check the value for "A&quo...

ArndW wrote:If you execute the exact same SELECT statement from your favorite DB access tool, how long does that take? Odds are high that this lengthy period isn't related to DS but to the database. ...

Hi ArndW,

It is taking 4 min on data base side.Okay looks like it is data base problem and not DS.

Thanks!

Hi, We have server job which is reading from Oracle 10g and doing a join with hash file and writing to hash file. The job is taking more than 5 min to start reading rows from oracle. The job waits for 5 min and then starts reading and rows/sec is also small.We have 10 milion records and this job is ...

To start execution of the script sequencer is taking nearly 20 min after completing previous stage.

The script is adding a trailer at the end of the file created by the job. The execution of the script is completed in 2 min .But the time taken to start next stage is again nearly 20 min by sequencer.

Thanks!

I will give a try.

Hi, I have a sequencer which calls couple of parallel jobs along with execute command stages. The problem is the job is getting finished in couple of minutes but the sequencer is taking more than 10-30 min to execute next stage. I have a script in after job routine..thought problem with the script a...

HI, I have an unix script to call sequencer. It runs fine when called from command prompt.We have MKSTool kit. It is giving error when run through tiwoli. 'G]A4' is not recognized as an internal or external command, operable program or batch file. ']D4FOnlyFeature' is not recognized as an internal o...

Ray,

This also happened when i was the only one running jobs and no one else.

There is no error while opening the designer or compiling jobs but it will take longer time.

Correct metadata and domain layers were installed on the same server as our engine .

There is no error while opening the designer or compiling jobs but it will take longer time.

Correct metadata and domain layers were installed on the same server as our engine .

Others are not able to open desinger or run,compile jobs