DSXchange

Hi, Is the recipient user and from user defined correctly? If yes, then It could be that if mail is not coming to the specified user, to could be going to the directory specified where DS Server is installed. Is DS Server on UNIX. You may want to check the value of MAIL variable defined in your Unix...

Hi,
SMTP Mail server name doesnot matter if you are running DS server on Unix.

Ketfos

hi,
You have mentioned that call seems to be made to DSSendMail routine?
What is text of message in the job log?

Ketfos

Hi,
Is there any message in the job log?
Are you getting a failure email at the end or no email?
Is your job execution status OK?
Are you running DS 7.5?

ketfos

Hi,
May be if you share your routine, it might solve your problem.

Ketfos

Hi,
What routines are you using for data transformation from ascii to edcdic?
what values for failing the conversion?

Ketfos

Hi,
Let us know the routine code and how it is being in the transformer?

What is the input data field?
What outcome you expect?

Ketfos

Hi,
Before that job was in DS 5.2 and it was column generated.
It was working fine in DS 5.2

Ketfos

Hi, The job in question was developed in 5.2 and was working fine. Recently we moved to ds 7.5 So when I tried to view data, I got above error. I tried to qualify the table names before the column names. It still gave the same error. Then I changed the user defined Sql Query. and clicked on VIew Dat...

Hi,
Using the group by clause, will make your job look simple and easy to debug.
If the data volume is large, Aggregator might give be better option.

Ketfos

Hi, I have a job. OCI 8 - Transformer - OCI 8 In the input stage I three columns - case #, Emp # and Amount. I go to BUILD button, select the table. In other clause, i put group by casenum,empid Under columns, I select three columns casenum,empid,amount. I also put SUM(Amount) under the derivation f...

Hi, I have a job. OCI 8 - Transformer - OCI 8 In the input stage I three columns - case #, Emp # and Amount. I go to BUILD button, select the table. In other clause, i put group by casenum,empid Under columns, I select three columns casenum,empid,amount. I also put SUM(Amount) under the derivation f...

Hi,
I donot think datastage puts any limit to the number of lookups in the transformer stage.
Yes performance would be an issue, if the look ups on the transformer exceed a certain limit.
Again this would vary with amount of data in the lookups.


Ketfos

Hi,
I am using the Job parameters in the sequencer and same parameters in the actual job.

Ketfos

Hi,
Is there any after job/activity in your job after the routine is over, something like calling prgram/job/function and that is not complied?

I got the controller error message in one of my jobs and found that the job called in the routine was not complied.

Ketfos