Migration issue and smtp

[Former Member]

Hi,

I migrated the reports from Crystal Enterpise 9.0 to Business Objects Xi. The reports which are runing on CE9.0 are failing on BO XI R2.

I checked the tnsnames.ora and modified it a well as created ODBC connections which were on CE 9.0.

2) How to configure SMTP so that E-mail can be sent to users from Bo Xi R2.0.

Thanks,

[Former Member]

answered

[Former Member]

1. Probably a rights issue - make sure you have granted the necessary privilages.

2. Using the CMC - go to the SERVERS list - there are 4 Delivery Options that you can configure for the respective Job servers - SMTP being one of them.

[Former Member]

Some more issues to look check.

A. Ensure that SMTP is working fine.

1. Go to Start > Run and type u201Ccmdu201D (without the quotation marks). This opens the Command Prompt window.

2. In the Command Prompt window, telnet to the SMTP server using the SMTP server name and the port the SMTP server is configured to use.

For example, to telnet to the SMTP server called 'mailman', which uses port 25, type the following command in the Command Prompt window:

telnet mailman 25

The SMTP server will return a message similar to the message: 220 mailman Microsoft ESMTP MAIL Service, Version: 5.0.2195.2966 ready at Wed, 24 Apr 2002 17:10:37 -0400

3. After the SMTP server returns a message similar to the one in step two, type the following commands in the Command Prompt window:

helo hi<Enter> mail from: sender.name <at> company.com<Enter> rcpt to: recipient.name <at> company.com<Enter> data<Enter> This is a test<Enter> .<Enter> quit<Enter>

The following variables are used in the commands above:

u2022 helo is a valid SMTP server command and not a spelling error.

u2022 <Enter> indicates that you have to press the 'Enter' key on your keyboard.

u2022 Replace sender.name <at> company.com and recipient.name <at> company.com with your valid fully qualified email addresses.

NOTE:When you type the commands they will not appear in the Command Prompt window. They will not be visible as you type them. Each time you press the 'Enter' key on your keyboard the SMTP server will return a message indicating whether it has recognized your request.

4. Verify that the inbox of the email address you submitted for the email address you provided for as recipient.name <at> company.com.

If your SMTP server uses standard SMTP requests and the SMTP server is configured properly, the test email will arrive in the inbox of the address you specified. If the email arrives, the SMTP server is valid for use with Crystal Enterprise.

B. Email is enabled on job server destination.

C. Any ANTI SPAM application e.g McAfee is not blocking SMTP port.

Regards

Dotun