DSXchange

From previous run DataStage Job 802 Phantom 22346 kgefec: fatal error 0 ********** Internal heap ERROR 17113 addr=0x0 ********* ****************************************************** HEAP DUMP heap name="" desc=0x0 extent sz=0x0 alt=0 het=0 rec=0 flg=0 opc=0 parent=0 owner=0 nex=0 xsz=0x0 ...

Hi All, We have extracting data from SAP-BW and Loading into a file. Total no. of records are 32 millions. When i run my job it is extracting 31.9 millions after that i got this error. ( I ran this job twice it is aborting at same no of records). Abnormal termination of stage BWDB2AR4Extract_FullLoa...

As you mentioned Job is not finished in BW (Yellow). This problem occurs due to broken pipe error or no child process in BW or RFC server connection last. Please check RFC server connections in Datastage Administrator for SAP.

Hi All,

Here is my requirement.

I need to call shell script and email notification from after job subroutine.
i.e ExecSH and DSSendMail funtions. Please suggest.

Thanks&regards
venu

After restart sendmail service now we receiving email notifions.

Thanks koolnitz & Tania

Hi Tania,

How to find sendmail service stopped or not. How to fix this issue.
Please help me.

thanks
venu

Hi All, Till morning we have received email notifications successfully after job runs. But now we are unable to receive any mail notifications. Please suggest me. job logs: (previous job logs and current job log same) Jobname..JobControl (DSSendMail): Sent message to abc@a.com' Executed command: /op...

Hi Rk,

I have checked for scheduled job run options. Here
Limits-->Warnings -->No limit option checked. This problem occurs for last 4 days. Please suggest me.

Hi kcbland,

Manually means? Using Director we have reset the job and run the job with out any changes. This job scheduled for Mon to Fri in Director. There is no sequence,script or batch process.

Hi All, We have one new issue. Our Job fails everyday if warnings are more than 50. But our run time option is nolimit. Without any changes in the job i ran manually job finished successfuly. Why this situation occurs. The below error message which i got when job ran on schedule. Please suggest me.....

Hi ray, The issue seems to be permissions to cron, the datastageadmin id which owns the rfc server process doesn't have permission to the Unix Scheduler. EVERY uses cron , but TODAY uses at - maybe you don't have some required permission to use cron ? Now this problem solved. Thanks Arndw, Ray and c...

Hi ArndW,

No change in output. I have checked with other function which you have suggested in previous posts that is
Convert(svControlSet0, svSpaces, inlink.Columnname)
Still we have received same data in output.

Thanks&regards
venu

Hi ArndW,

No change in output. I have checked with other function which you have suggested in previous posts that is
Convert(svControlSet0, svSpaces, inlink.Columnname)
Still we have received same data in output.

Thanks&regards
venu

Hi All, We have scheduled our datastage jobs with EVERY/DAILY option. All Jobs got hanged. But when we have schedule with TODAY option all jobs got success. This problem occurs only for BW Load Packs not for other jobs. We have observed with Different scheduling options. But jobs are working under T...

parallel Job

roy wrote:Hi,
the answer depends on the server or parallel question Craig asked you.
So which job type do you need it for?