Email Distribution Error

[Rags]

When I trigger a email distribution alert to be sent, I get the following error:

System.ArgumentException: The path is not of a legal form. at System.IO.Path.nGetFullPathHelper(String path, Char[] invalidPathChars, Char[] whitespaceChars, Char directorySeparator, Char altDirectorySeparator, Char volumeSeparator, Boolean fullCheck, String& newPath) at System.IO.Path.FixupPath(String path) at System.IO.Path.GetDirectoryName(String path) at DwchServer.DistributionStep.MakeOutputPath(Distrib utionItem item, ProcessItem processitem) at DwchServer.DistributionStep..ctor(Object parent, DistributionItem item, String strInputPath, DistributionRank rank, ProcessItem processitem) at DwchServer.DistributionPlan.ProcessAlert(ProcessIt em alert, JobLogEvent joblog_event) at DwchServer.DistributionPlan.Prepare()

Anybody have any suggestions on why this might be happening?

[Bill Tilghman]

I'm also getting errors trying to use the emailer.
the message:
Could not accesss 'CDO.Message' object

This error can occur if the SMTP server is inaccessible.

I have entered the Microsoft exchance server name as: PBOSEXCH01 and as PBOSEXCH01 and get the same error.

[Gareth Horton]

Bill

The best approach would be to use the IP address.

Additionally, ensure that the username and password is set if the SMTP requires authentication.

Gareth

Originally posted by Bill TIlghman:
I'm also getting errors trying to use the emailer.
the message:
Could not accesss 'CDO.Message' object

This error can occur if the SMTP server is inaccessible.

I have entered the Microsoft exchance server name as: PBOSEXCH01 and as PBOSEXCH01 and get the same error.

[Bill Tilghman]

Thanks for the reply.

Here is one of the log entries using the IP address:

operation type="Email">
<status>Failed</status>
<error>Could not access 'CDO.Message' object.</error>
<error_info>This error can occur if the SMTP server is inaccessible.</error_info>
<start_time>2005-06-01T14:10:08</start_time>
<stop_time>2005-06-01T14:10:08</stop_time>
<smtp_server>JH_INFORMATION165.71.91.16</smtp_server>
<to>jnusslein@jhancock.com</to>
<from>wtilghman@jhancock.com</from>
<resolved_to>jnusslein@jhancock.com;</resolved_to>
<resolved_from>wtilghman@jhancock.com;</resolved_from>
<subject>Test of email distriution06 2005</subject>
<attachment>R:WFS2ComplianceMonthly60576A.xls</attachment>


Also used the bare IP address with no domain name, and the following:

PBOSEXCH01

JH_INFORMATIONPBOSEXCH01

JH_INFORMATIONPBOSEXCH01ADDRESS

JH_INFORMATIONPBOSEXCH01ADDRESSX400

[Gareth Horton]

Bill

You should just use the IP Address, i.e. 165.71.91.16

There are a few things to check with Exchange, and you may need to enlist your Exchange Administrator's help on this.

You should first ping the IP address to make sure it is accessible.

You can then test that your SMTP service is accessible from the Data Pump machine using this (http://support.microsoft.com/default.aspx?scid=kb;en-us;323350) type of approach. Don't worry about it being related to 2003 Server, it should work on 2000/XP also.

You also need to check what type of authentication Exchange is using, if any and also if there is an IP filter that only allows certain addresses to use it.

If Exchange is using basic authentication, ensure the username and password are valid on Exchange.

If it is using Windows Authentication, make sure you check the box and also ensure that the account under which the Data Pump service is running has the necessary credentials.

If you are using SSL with Exchange, make sure the SSL checkbox in Data Pump is checked.


Gareth

Originally posted by Bill TIlghman:
Thanks for the reply.

Here is one of the log entries using the IP address:

operation type="Email">
<status>Failed</status>
<error>Could not access 'CDO.Message' object.</error>
<error_info>This error can occur if the SMTP server is inaccessible.</error_info>
<start_time>2005-06-01T14:10:08</start_time>
<stop_time>2005-06-01T14:10:08</stop_time>
<smtp_server>JH_INFORMATION165.71.91.16</smtp_server>
<to>jnusslein@jhancock.com</to>
<from>wtilghman@jhancock.com</from>
<resolved_to>jnusslein@jhancock.com;</resolved_to>
<resolved_from>wtilghman@jhancock.com;</resolved_from>
<subject>Test of email distriution06 2005</subject>
<attachment>R:WFS2ComplianceMonthly60576A.xls</attachment>


Also used the bare IP address with no domain name, and the following:

PBOSEXCH01

JH_INFORMATIONPBOSEXCH01

JH_INFORMATIONPBOSEXCH01ADDRESS

JH_INFORMATIONPBOSEXCH01ADDRESSX400

[Bill Tilghman]

The answer was that the Hancock exchange server is not an SMTP email router.

Entering:

mailhost.jhancock.com

worked perfectly!

Thanks ofr the assistance from you and Mary.