DSXchange

How do i give u the complete log? Below are the fatal errors.. I agree with you it must be the environment variaibles... ora_Sample_load,1: Operator terminated abnormally: received signal SIGBUS main_program: APT_PMsectionLeader(2, node2), player 7 - Unexpected exit status 1. APT_PMsectionLeader(1, ...

This issue is yet open.. can anyone help. Now values i used for the environment variables did not work for jobs which had record count >100000.

Please help.

By default these values were set as

APT_ORAUPSERT_COMMIT_ROW_INTERVAL = 5000
APT_ORAUPSERT_COMMIT_TIME_INTERVAL = 2

Please help me understand why did the job run to success after setting APT_ORAUPSERT_COMMIT_ROW_INTERVAL =1.

Searching some posts I tried the option to set APT_ORAUPSERT_COMMIT_ROW_INTERVAL variable to 1 and the job ran to success. I did even try setting it to 0 and it aborted,

Can you please let me know what is happening..

We are doing inserts only with an update SQL of Where condition as 1=2. We want to have Upsert mode as we need to capture records in an error table that would silently get dropped using LOG ERRORS clause. There is another flow that handles the updates. Issue here is with the insert flow with upsert ...

Yeah... Looks like its with tables that don't have unique keys defined on them.. and that loads huge data.

Yeah.. we are talking about 10g..

Could there be any problem in the table.. not sure why we are facing issues with all the tables.

When the Write Method = Load then all the records gets successfully inserted. Its issues with Upsert that I face...

If it is nullable, it loads 0...

Is this right?

Hi All,

The output of my lookup stage is Decimal(5) Null. Will DataStage not give output as Null when the lookup fails. It loads 0 instead.

Please confirm.

Thanks

Sorry the Oracle version is 10.2.0.3.0.

We have migrated the metadata using Orchestrate based one.
We yet have issues.

Please advice.

Yes, I tried with array size 1, I yet face the same issue.
We are using Oracle 11g. When we import the metadata I see Unicode datatypes, are these CLOB columns not sure.

Please advice on how do we resolve this issue, any suggestions.

Hi All, We have a simple job design that reads records from a dataset does some transformation in the transformer stage and insert them to the Oracle table using oracle enterprise stage. We have an upsert option set with "LOG ERRORS" statement given in the Oracle Enterprise stage to captur...

yes only one record in the reference link and the primary link is the link from the source table.

Any help on this issue..

Yes.

For example:

Source Records
1 A B
1 A D
1 E P

One Reference Record only
1 PP

Output required
1 A B PP
1 A D PP
1 E P PP


The column with value 1 is the lookup key