DSXchange

Hi, I am calling an Oracle Stored Procedure from ODBC stage, i am getting the following error if SP runs more than 30 minutes. ExtractPSFTServiceSeq..Transformer_Input_T1: ORA-03113: end-of-file on communication channel Attempting to Cleanup after ABORT raised in stage ExtractPSFTServiceSeq..Transfo...

Hi, We have environment variable(EDW_HOME) at Unix level whose value is set up at profile (.profile) file which presents at home directory of a user. Value depends on user logged in. Please find the values of EDW_HOME depends on the user. User= etladmin EDW_HOME=/hedw User= etldev EDW_HOME=/hedw_dev...

Hi,

I am calling a oracle stored procedure by using ODBC Stage. Job got aborted if Stored Procedure runs more than 30 Minutes. Please suggest some idea to resolve it. Is there any alternative to call a stored procedure from job. Thanks for your help.

Hi, Agree with your view. We took the performance statistics before and after abort. CPU Utilization is around 95% and Memory (Not used to store the data) to allocate the execution of jobs were increased by 20%. We restarted datastage server and it came back to original values. We thought the memory...

Hi,

If a job aborts, Does the memory allocated to process the job will be released?If so, when it will be released. Do i need to reset the job. Our jobs are taking more memory after every abort. Please help us.

Regards,
Venkatesh Babu Obla

Hi, We created a sequencer (Load_Process_Data) which calls 2 jobs. All (Sequencers & Jobs) are compiled and everything is ok. When we trigger the sequencer, we were running the instance of the sequencer(Load_Process_Data_TimeStamp Ex:- Load_Process_Data_20050522_220323). In Data Stage director, ...

Hi, Yesterday the sequencer was aborted and the error was -14. Please find the following error. V3ReceiptsControl..JobControl (fatal error from DSRunJob): Job control fatal error (-14) (DSRunJob) Job V3ReceiptsFileUpload appears not to have started after 60 secs Today i reset the jobs and tried to r...

Hi All,

Thanks for your help. I got the patch from Ascential EService.

Regards,
O.A.C.

Hi,

I am not able to find this site. Please give me some more info.

Regards,
O.A.C.

Hi,

Yes, it is running on Windows XP. Can you please let us know what is the patch we need to install it and from which place we can get this patch? Is it freely downloadable from Internet? If so, please provide the site details. Thanks in advance for your help.

Regards,
O.A.C.

Hi, I have datastage 7.1, i created 3 jobs all are working fine. I created one sequencer to call all these 3 jobs. So i added Job Activities in the sequencer but not able to do openup the properties by either double click on Job Activity Stage or by selection "Properties" Option by right c...

Hi,

Child job (DS_MNP_MNP_XFM ) is not called at all.

Regards,
O.A.C.

Hi, I have a sequencer which calls 3 jobs, during the call of one job the sequencer got aborted and find the following log message. Please help me in resolving this. 72 STARTED Tue Jan 17 03:19:08 2006 Starting Job DS_MNP_MNP.20060117_031852. (...) 73 INFO Tue Jan 17 03:19:08 2006 Environment variab...

Hi,


It is 50. But once the setup is done and compiled, it should remain same. Isn't?

Regards,
O.A.C.

Hi,

We didn't get that error message, Please find the below log.

Attempting to Cleanup after ABORT raised in stage Load_GSN_data..JobControl

Which we received, Please let us know if you received the same. Hope you can help me. Do i need to raise this to Support Group?

Regards,
O.A.C.