DSXchange

Thanks Craig. I will keep you updated.

Craig, I agree with you on the quotes - I got the error message during the compilation of the routine but forgot to make the change in my submission here. %report% - looks like the default variable defined in datastage that provides the report that is being generated in my job. FYI - My job consists...

Here you go

Result= DSSendMail("From:":FROM_MAILID:"\nTo:":TO_MAILID:"\nSubject:":SUBJECT:"\nAttach:":Final_Attachment:"\nServer:":ServerName:"\nBody:":"%report%)

Sorry, I got it wrong - let me send it to you again

Here you go If intNoRecReject >0 Then Final_Attachment = ERROR_DIR:"\":strRejectFile Result= DSSendMail("From:":FROM_MAILID:"\nTo:":TO_MAILID:"\nSubject:":SUBJECT:"\nAttach:":Final_Attachment:"\nBody:":"%report%":"\nServer:&q...

This change is treating the server information as part of the attachment as follows

Cannot open attachment file 'e:\data\dev\GenSys\Rejects\Reject1.csv \nServer:ndhamrexm05.amer.pfizer.com'

Any suggestions please

Thankyou Chulett. I will try that and will let you know if that solves the issue

Hi All, I searched the forums related to this one but could not find a solution to my problem. I have a parallel job retrieving reject records from a table in sql server to a file. I have an after job routine to email this file as an attachment after the retrieval is successful. I am getting the fol...

My job is running fine couple times and then failing with the following error message

APT_ParallelSortMergeOperator: Error when checking operator: Caught unknown exception during wrapDescribeOperator().

Did anyone experience the same before?

chulett wrote:Don't see a domain there anywhere.

I replied it to Prolifics on my command. Here is the revised command that I used without any success

E:\apps\IBM\InformationServer\Clients\Classic\dscmdexport.exe /H=AMRNWLW121 /D=AMER /U=username /P=password PROD E:\Tools\Backup\Prod.dsx

Hi, Can you please sent me the script for the Exporting the Datastage project .I am new to datastage and need your help. Appreciate, if you can email at kapeel24@gmail.com thanks KJ This is what I am using, you can use the same but modify it as per your directory structure E:\apps\IBM\InformationSe...

I tried with Domain option but it is still the same. My colleague cannot run it and I cannot schedule with Autosys.

chulett wrote:Depends on your network topology, it seems. This is exactly what we've seen here, works for some but not for others. Adding the domain option makes it work for everyone.

oh ok - let me add that and ask my colleague to try it. I will let you know if it works

chulett wrote:From what we've seen here, for 8.x you need to include the "domain" credential as well.

Then, how come I am able to run but not my colleague

kduke wrote:What user does Autosys run as?

Never post user names or passwords. Edit your post please.

Autosys runs under a user who has administrative rights