DSXchange

Hi,

I created a Range map using Write Range Map stage.
And then I try to use the Range map for Rangepartition.
The job compiled successfully.
when I execute the job, getting an error "Opening Write Range Map error"
Is there any way I can solve the issue?

Thanks in advance

Thank you Ray.

Previously I was worried that, some thing I am missing in stage properties.

So, now its clear to me that, in case of multiple update links, there shouldn't be duplicates.

Hi, I created a job which merges data from 1 Master file and 1 update file using Merge stage. here is the data as follows: Master file content: mKey,Col1 1,A 2,C 3,D Upadate1 fiel content: 1,P2 3,t2 3,u2 2,Q2 2,R2 The output file gives output as: 1,A,P2 2,C,Q2 2,C,R2 3,D,t2 3,D,u2 This works fine. B...

Thanks Vinz for your reply. It helped me to realize that, the issue might be with teh SMTP server. I tried direclty using the command. Its showing the actual error message as "Unable to locate server." When I provided the server as "mail.google.com", its showing some issue with s...

Hi, Here is the command output: Demo_Sequence_mail..JobControl (DSSendMail): Error when executing command: C:\IBM\InformationServer\Server\Projects\Tutorial\sendmail_Demo_Sequence_mail_58421446_12232.bat *** Output from command was: *** SMTPMail Looking up server... SMTPMail Opening connection to zz...

Yes Chulett. But my DS is installed on Windows 2003 server.

I am not sure, how can I do the similar task.

Could you please help me in this?

Hi chulett , Sorry for late reply. I gave the correct mail server address, which is my company's mail server address. I verified the file dssendmai_template.txt file. Its having the default options set during installation. * On Windows NT to run "dssmtpmail.exe", the template looks like th...

ray.wurlod wrote:Learn about the Search capability in DSXchange. Indeed, this very question has already been asked (and answered) this week.

Hi,

I did search. But didn't find any. Even I searched again after your suggestion. But couldn't find any.

Hi,

I am using "Notification Activity" in a Job Sequence.

When I provide the mail server address as "my server address", getting an error message as "Routine DSSendMail did not finish OK, return code = '-21''.

Any idea, what could be the issue?

Thanks a lot in advance.

vinothkumar wrote:Please mark it as resolved.

Sorry Vinoth,

I cannot mark it as Resolved. because I am not the author of this post.

Hi All,

I found the issue. The issue is that. there are some "spaces" in the folder name.

Thanks to all for helping me.

Hi Thanks for your reply. What are your exact file names and how did you gave in Sequential file stage. Also check that the metadata is same for both files and you are able to view both files when read individually. The exact file names: File Name1: D:\Files Pattern\EMP1.txt File Name2: D:\Files Pat...

Hi, The post might be old, but, I am having the same issue. No rows rather than an error usually means a metadata mismatch issue. Can you open a single file directly? ... -- Yes, I am able to open the single file directly by "view data" and then execute the job. I have 2 files, and I am tr...

Hi, Nope, No default value is set. Even I tried this option by manually setting it, its the same. I believe that, this value is being set as 0 in Join stage. Is there any way we can debug and find out how the data is changing? As its a parallel job there is no debug option. I am wondering how we can...

Hi, I created a simple job where I have two sources (defined as sequential file stages), a Join stage ( doing Outer joins) and then loading the final output to a sequential file stage. Everything works fine. As I am using outer joins I am expecting null values. There is a record where null values sh...