Abnormal termination of DataStage - OCI8 stage
Posted: Tue Nov 22, 2005 1:19 pm
Has anybody come across similar problem?
Several of our production DataStage jobs abort when extracting data from Oracle tables. There is no meaningful error message. The abort happens once the extracts reaches a certain number of rows (about 15.7 million). It does not matter if the extract is to a hash file, sequential file, or another table. it also does not matter how many columns are extracted (I run the query with one column only and it aborted). The resulting file is much less than 2 GIG limit.
This started happening when we migrated the jobs from DS6.0 to DS7.5.1. At the same time we also moved the jobs to a new server.
The same jobs run fine in DS6.0 and on the old server using the same data base and tables.
I have created a ticket with IBM for this issue. After multiple tests and exchange of information their suggestion was that we have a memory leak in Oracle client. However, the same problem appears when the jobs run on the development server with DS7.5.1 using production volume of data.
The error message from &PH& file is:
[/datastage01/Ascential/DataStage/Projects/ARS/&PH&]cat DSD.StageRun_42964_13800
DataStage Job 458 Phantom 22438
kgefec: fatal error Abnormal termination of DataStage.
Fault type is 11. Layer type is BASIC run machine.
Fault occurred in BASIC program DSD.StageRun at address 1500.0
Several of our production DataStage jobs abort when extracting data from Oracle tables. There is no meaningful error message. The abort happens once the extracts reaches a certain number of rows (about 15.7 million). It does not matter if the extract is to a hash file, sequential file, or another table. it also does not matter how many columns are extracted (I run the query with one column only and it aborted). The resulting file is much less than 2 GIG limit.
This started happening when we migrated the jobs from DS6.0 to DS7.5.1. At the same time we also moved the jobs to a new server.
The same jobs run fine in DS6.0 and on the old server using the same data base and tables.
I have created a ticket with IBM for this issue. After multiple tests and exchange of information their suggestion was that we have a memory leak in Oracle client. However, the same problem appears when the jobs run on the development server with DS7.5.1 using production volume of data.
The error message from &PH& file is:
[/datastage01/Ascential/DataStage/Projects/ARS/&PH&]cat DSD.StageRun_42964_13800
DataStage Job 458 Phantom 22438
kgefec: fatal error Abnormal termination of DataStage.
Fault type is 11. Layer type is BASIC run machine.
Fault occurred in BASIC program DSD.StageRun at address 1500.0