DSXchange

I have found that when using tables in a PX job you need to set certain table settings. For example in Oracle you might want to check both initrans 4 pctfree 15.

ALTER TABLE [tablename] initrans 4 pctfree 15;

The message your are getting "unable to insert row" is generic and will not give you the exact reason. Do the following Try inserting the row into the table using SQL Plus or Toad and see if error occurs. If this is sucessful then have your DBA look at tablespaces and other database reason...

I am using Enterprise 8.0 and comparing the error message of a server job vs a Px job in 8.0. Let me re-phrase, server jobs in 8.0 give detailed logging information that include the exact oracle error and even the data it was processing. Px error logs only inlcude a generic error message, not that a...

Our company just upgraded from 7 to 8 and I was wondering why the error messages in the logs files in director do not show the exact oracle messages as it did using 7.x. Example, I am getting the following error Unable to insert a record into the table. Howewer, no oracle error is being displayed in...