DSXchange

Those records are not getting rejected through Oracle Enterprise stage but causing the job to fail.

The specific error that I am getting is:

ORA-12899: value too large for column

Tell us what you mean by needing to "suppress" multi-byte characters. I am trying to load around 200 million records to Oracle db, but some records seem to contain multi byte characters due to which Oracle load is failing. I don't want the job to abend, instead I want to capture all those...

How about Len(StringToRaw(InLink.TheString)) ? This I can't even get to compile. Depending on the output data type it either complains about an "Invalid conversion requested from a string to a raw" or "from an int32 to a raw". :? Hi Craig, Have you managed to find the solution f...

Hi, My requirement is to load around 200 million reocords to Oracle. I need to capture all the reject records that Oracle will fail to load and continue with the rest of the records. I have tried using upsert method in Oracle Enterprise Stage (as in Load method we can't have a reject link) in variou...

6 nodes and Cache 20

The stages are forced to execute sequential.

Oracle Enterprise Stage --> peek stage User defined sql in OES - select seq.nextval from dual; I reset the sequence to start with 1 before running the job. Director log shows the nextval as 1. But when nextval is executed after the job run, the value shown is 3 rather than 2. Does anyone see the rea...

IBM says OSH process grows continuously storing everything when surrogate key is used with an oracle sequence and when it crosses 2GB limit, job aborts. Seems to be working fine with DB2 and state file.

Will update again when IBM comes up with a solution.

Thanks!

Craig, Running the job without surrogate key stage is sucessful and 20 million records are successfully loaded into the table. I guess this has to do with surrogate key stage which is throwing strange error. Surrogate_Key_Generator_26,0: Caught unknown exception from runLocally(). Surrogate_Key_Gene...

I have created the sequence using Surrogate key stage, but no difference. Job fails at surrogate key stage.

Date fields are made constant and yet the saem error.

Can someone help who have successfully tried using surrogate key for huge input?

I tried setting Disable_combination to true and found that the problem is with Surrogate key stage. But the log is the same in director. DBA is not of much help as they say the DATE_CHACHE has to be increased when sqlldr is used. I guess DataStage is using it by default. In surrogate key stage, i m ...

Hi, Sequential file --> transformer --> surrogate key generator --> Oracle enterprise stage. When I try to run the job, it aborts with the below error afer loading 23023 records into the table. But even more rows are read from the sequential file. APT_CombinedOperatorController(1),0: Caught unknown ...

I guess its best to use the User-defined SQL query in database stage, in which case database indexes will be used and will be faster compared to join stage.

Problem is not yet solved. We have done the basic homework but couldnt find much information on this.

Since no log is available in Oracle, I wonder if it has to do something with DataStage itself particularly reading from dataset.

Hi, We have a job which loads multiple tables from different datasets. On running the job the following error is logged in director for some of the oracle stages randomly. Error is not thrown for the same oracle stages. It is random. ORA-21561: OID generation failed No error logs available in oracle...

Can somebody help me understanding the process flow of a job when there are different inputs and write to the separate stages unlinked? Like dataset --> Oracle stage dataset --> Oracle Stage dataset --> Oracle stage all in the same job Will all the inputs start processing at the same time sharing th...