DSXchange

Just for grins, I tried one last thing but it falls squarely into what I would call a "cheese" solution. I added a Sort stage before the child OE stage in such a way as to delay their arrival until after the parents are home. And that works. Sure. I still need to run on one node, etc etc e...

For the record, I've officially thrown in the towel on this. Nothing I can think of - including running on a single node and setting the commit row interval to 1 - makes this work. Nothing. :( Keep in mind this is a 7.5.2 install on Linux with Oracle 10g, no idea if 8.x or other changes would make t...

Let's start back at the beginning. What compiler make and model does the documentation say is supported on AIX? We've seen that 'supported' tends to mean 'only ones that work' for PX.

Wow... take all this with a grain of salt. What I thought was working reliably is just more reliable but does not work 100% of the time. Going to keep experimenting to see what else it takes, suspect I may need to knock it down to running on one node but even that may not be the ultimate answer sinc...

The third one... as long as you've fully pathed the name of the sql file.

And you got that after putting what exactly in the 'User-defined sql' tab? The error message has the answer to your 'how' question, btw.

Funny. I made the previous post after having built a small test job to load 10 records into related work tables and then running it once. That was the only time it ran without issue. :lol: As I manipulated the data, or truncated the tables for a reload, the parent table would load fine but various (...

"Not working" how?

As noted, this should be feasible to do in one job as long as you order the links properly to support the RI. It's one place where you seem to have less control over how it all works in a PX job over Server, in Server you can use a single DB stage to keep it all in one transaction and even use 'tran...

As far as I know, the information in the job logs are sourced from the &PH& entries, not linked to them. Meaning they existed at one time but are not necessarily still there, especially if you have any kind of automatic pruning going on. Can you not get whatever it is you need from the log e...

This might help: viewtopic.php?t=127425

'A specific user' as in one user that is not 'dsadm'? Or under their logged in user? Something else entirely? :? I know this is a "credentials" issue, default versus mapped or some such but don't know enough about 8.x to answer the question, unfortunately. But answering the first question ...

So... have you tried grep'ing through the contents of the project's &PH& directory for the job number in question?

Problem is, that's a 7.x solution for an 8.x problem. With the XMETA repository, I'd imagine you'd need to run some sort of equivalent DML there nowadays. However, not sure if anyone has figured out or posted what that would be yet.

True!