DSXchange

Thank you all. We're looking in to the user/sessions/connections limitations with our Oracle connectivity now. One would think we'd have a job failure, rather than a hang though. We're also looking into the deadlock possibility, but again I'd think that we'd receive an error there and a failure. Non...

My fault. We are using an Oracle connector stage. Here's an example of what we see in the logs: Orc_insert_update_table: The connector connected to Oracle server TARGET1A. Orc_insert_update_table: Connector code revision: 263892_0223017 Orc_insert_update_table: The connector will run in parallel on ...

We're having intermittent job hanging running 11.5.0.2, updating tables against Oracle 11g targets on a client database. We run hundreds of jobs per day that perform various table updates. Each day, we can have between zero and 4 jobs hang at various times. The only common theme appears to be that w...

Thank you for your advice. We did that, and it worked - however, as we are not able to map the output for the link and the table we are referencing has different column names than the input from reject, we had to manually edit the SQL. I'd prefer not to have to do that for each job we create. Are th...

We have searched, and been unable to find a thread referencing this. We have two links out of transforms, going to a lookup. We specify a key column, and if that key matches in the lookup, we want to drop the record, and only send through rows that do not match. We have tried changing the parameters...