Extraction problem with Oracle 9i and Datastage 5.2

Archive of postings to DataStageUsers@Oliver.com. This forum intended only as a reference and cannot be posted to.

Moderators: chulett, rschirm

Locked
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Extraction problem with Oracle 9i and Datastage 5.2

Post by admin »

We just upgraded our database to 9i from 8.1.x, and now I am having problem
with my OCI/ODBC extract.

It is a very simple job

OCI -> Transformer -> Sequential File

The job aborts after 12000000 millions rows (more or less), with a
mysterious message:

Abnormal termination of stage SLAMPRR3MNTHL103..T1_BulkXfm detected

Is there a known issue with using Oracle 9i and DS 5.2? Any new special
parameter in 9i?

Any input is welcome...

:o)

Thanks!

Christian Pelletier
BI/DataStage Analyst
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Locked