DSXchange

Making all stages to run in sequential mode (where possible) didn't help

Hi! Unfortunately inode table changes didn't help. Here's part of job log ran after DS server reconfiguration and restart. Regards Wojtask Occurred: 11:04:10 On date: 28-07-2005 Type: Fatal Event: cs}}}(0),0: Failure during execution of operator logic [api/operator_rep.C:315] Occurred: 11:04:10 On d...

Hi All! Today I got following error message: Unable to start ORCHESTRATE process on node node0 (regan): APT_PMPlayer::APT_PMPlayer: fork() failed, Not enough space [processmgr/player.C:394] df -k shows that 52% of space is avilable (for both datasets and scratch) ulimit -a shows: core file size (blo...

Thank you for help

Hi All! We currently working on a project, where we want to: 1. import/export/run jobs from unix machnie other than DS server Is this possible? 2. Is it possible without RTI run jobs from other unix machine maybe? 3. Is the only way to run jobs from other machine is to create kind of wrapper for dsj...

I discovered that on DS server there was 2 nodes (CPU's?) and total number of rows was smaller two times if I changed the apt file to use 4 CPU's numer of rows was 4 times smaller. I used Key Generator instead and everything worked fine. Thanks.

Nop, unfortunately there are no duplicates so it's not that case.
There was no PK in the B table (Load) I added on the Client_id which is unique and it was still the same

Maybe I'm wrong but I think that upsert (with insert) works that way:
if there is a record with a particular key value update it
if there is not insert a record
So if I have 6000 input records after upsert I should have 6000 in a table, right??

When I run a job it writes records to 2 Oracle tables A and B (one Upsert (update and Insert) and one Load) exactly same data. In table A I have 3000 rec written and in B 6000 (all from input) only 9 rows are written to reject table, no errors in log appear. Both A and B are empty in the beginning A...

In my case making the length column empty for all varchar fields with length greater than 254 worked :D