DSXchange

can anyone please suggest me what is this [oraUpsert.C:1852] error. I get this error message when etl job is inserting to oracle DB in version 8.1 the insert statement executes successfully in oracle (though 0 rows inserted) but etl job is aborting. Unable to insert a record into the table due to . ...

After restarting data stage, the director is not writing any log. I can find the number of records processed from director monitor. can anyone please suggest me.

Thanks
Mark

Hi All, The datastage job is aborting due to; The current soft limit on the data segment (heap) size (1610612736) is less than the hard limit (9223372036854775807), consider increasing the heap size limit Current heap size: 5776720 bytes in 7198 blocks Fatal Error: Throwing exception: APT_BadAlloc: ...

I believe these are the defunct processes which gets created while etl jobs are running and usually go away when the job completes. but i find around317 in 2715724 585894 0 21:04:38 - 0:00 /InformationServer/Server/PXEngine/bin/osh -APT_PMsectionLeaderFlag XXXX 10004 how do I kill them. i fine theis...

Thank You. there are 317 process running in this directory.
/PXEngine/bin/osh -APT_PMsectionLeaderFlag XXXX

if i kill the processes in /Server/PXEngine/bin/osh directory will it have any impact on how etl jobs run.

Thanks
Mark

Hi All, I am working on data stage 8.1 when I run this command ps -ef | grep bin/osh | wc -l i get around 317 can anyone please tell me what are these files and if i delete them does it improve the performance of etl. (jobs are taking atleast 5min to compile, not sure if both are related) 2637870 14...

My data stage job (v8.1) is aborting with the following error message; Fatal Error: Need to be able to open at least 16 files; please check your ulimit setting for number of file descriptors Failure during execution of operator logic. I verified the ulimit (ulimit -a) and it has; nofiles(descriptors...

I changed the default pool in my configuration file and all jobs competed successfully.

Thanks All.

Thanks
Mark

[quote="Sainath.Srinivasan"]Add a default pool for all resources. Alternatively change all jobs which uses the pools to use your named ones. To include the available in default, append "" after each pool definition. ...[/quote] I can't change in each job since i have around 200 e...

I executed df, it appears There is enough space in the directories; Filesystem 512-blocks Free %Used Iused %Iused Mounted on /dev/fs18 33554432 20534560 39% 457 1% /opt/IBM/IIS/dstage0 /dev/fs19 33554432 11569544 66% 405 1% /opt/IBM/IIS/dstage1 /dev/fs20 50331648 49999784 1% 56 1% /opt/IBM/IIS/scrat...

Actually now all the jobs are aborting (which ran successfully previously) with this error message; Error when inserting partitioner: No disk resources found in pool "". Disk resources in this pool are required to create a lookup table. this is what I see in my config file; { node "no...

Hi All, My etl job sometimes aborts with this error; Error when inserting partitioner: No disk resources found in pool "". Disk resources in this pool are required to create a lookup table can anyone please suggest me what might be causing this error message and the job to abort. Thanks Mark

when I compile the job it is giving me a message;

The Stagetype 'PxOracle' cannot be found in the repository.

Thanks
Mark

Hi All,

when I log in etl designer (v8.1) I am not able to find the database tab in the repository.

can anyone please tell me why this is happening.

Thanks
Mark

There is no enough table space in DB after little research

Thanks for all the suggestions.