DSXchange

Thank you very much, I was just checking the director not manager,..

I am curious about something and I believe that there must be a way to see when the job is saved ( especially if it is saved but not compiled). when I look at the status of the jobs in director it says either compiled, not compiled, finished or aborted... what if a job is saved but not compiled righ...

is your col1 marked as a key column on your job? and is it also key on your database? if so, try to seperate inserts and updates into two links and use the same user defined queries but drop col4 for the update link

that should work

ok you need to post the error log in order for the people to help you. another thing is just being able to view data and being able to validate the job does not guarantee that the job will not abort.

One last thing, how do we/you know that the error is related with the oracle stage?

use keywords "job stats" or ETLstats

mdx is also the Microsoft's multidimensional ( cube) sql standard. I don't know if those files have mdx extension though.

did you try to pass those parameters within a single or double quote?

Yes, searh in this forum and Ray answered this questions many times

I also needed a driver in unix for excel last year and there are some drivers for that but it would cost you some money ( Data direct has one for sure) and there are also some open source drivers if you google it you will see, if you are not going to use many many times, I think it is not feasable t...

Did you save or compile the job after you run?

What's the error or warning before this error?

Mike3000 wrote:We added a [Transformer] and the error changed to :
"Attempting to Cleanup after ABORT raised in stage my_unload_to_seqOCI..Transformer_7"

videsh77 wrote:Would Iconv & Oconv work in Px? ..
Thanks in advance.

No, PX has many other functions to replace Iconv and Oconv

Hi all, ... "Fatal error:Unable to allocate communication resources" When I reset the job and rerun it ,it runs well. ... it could be anything, you should give us more details... whats database are you using? how many connections is this job trying to open? is the server/network too busy?...

Wouldnt a job write to the same sequential file twice, if there is a delay between the two write operations ? If the file is not written to in the same active stage ? As Craig said, the update/read/write operations to a sequential files are governed by the OS. if you open a sequential file for read...

If this were a server job, just use the link collector stage to let 1 or more transformer stages write to the same seq file. ... but this will not guarantee that the second link will be an append, i.e., the records from two links will be mixed. I guess same case will occur with the funnel stage in PX