Hi folks,
Hopefully one of you can help with the problem I am having after upgrading from C8 BI to C10 BI.
Upgrade went fine, with exception of e-mail delivery service.
I haven't changed the configuration during migration,
but all Cognos e-mailed reports have the status "Waiting" with the detail message:
"CNC-SDS-0408 There are email messages waiting to be sent."
The Notification config parameter is set up as follows:
SMTP mail server: <intranet SMTP server>:25
Account and Password: null/null
default sender: my e-mail ID
Testing in Cognos config gives authentication error, but this is as expected because of null userid/password. I am pretty sure SMTP server is not an issue: It works fine for notifications coming from my database servers.
Then it gets weird:
- Cognos startup says Delivery Service started successfully
- Any attempt to stop/start Delivery Service from Cognos Admin results in a message "http://hostname:9300/p2pd > DeliveryService Failed DPR-ERR-2064 The administration request failed. Please verify the input parameters and try again "
I turned on the trace which results in messages in cogserver.log messages (file attachment), but I have no clue how to interpret them in a meaningful way.
Thinking it's something with my upgraded server, I installed Cognos 10 BI from scratch on another server (Win 2008 64-bit). Other than using the same cogstartup.xml and using the same Cognos Content DB2 database, everything else was from scratch. Same thing: SMTP Delivery is not working. Maybe it's something in the startup configuration or inside the database or something else entirely...
Any ideas?
cogserver.log is attached with additional SMTP error messages.
Thanks in advance,
Gene
Have you tried specifying a user account, just to be sure. And was your Cognos 8 configuration running under a domain user account or as a local system account?
Specifying valid userid & password doesn't change anything -- job is in "email messages waiting to be sent" state.
IBM Cognos 10 service is running under the default "Local System" account.
And in C8 was it a Local System account?
I didn't check on the earlier installation, but it must have run under LSA as well -- I used default install for that installation (no domain userid, no local userid/password created).
Strange... Can't think of anything else...
Is the upgrade in same server or different?
We had similar issue when we moved Cognos from one server to another.
The new server was not added to exchange server's list for relay information so the delivery was failing.
Not sure if this is the case but a thought.
Hi Suraj,
Upgrade was on the same server. Our SMTP server does not need a list of valid names -- any machine can send an SMTP message.
Changing SMTP server name to it's IP address (as recommended in another posting) doesn't change anything.
Gene,
The following may be dumb questions but still double check.
Did you change the services to run under the user account instead of default as suggested before?
That may or may not help but at least narrows down the issue.
Also, in Cognos configuration >> right click on notification >> Test; is the test successful?
Account and password: only use username without the domains.
For default sender, are you using FQDN such as username@company.domain instead of just username?
HTH
I just changed the IBM Cognos 10 service to run as a userid instead of LSA.
Cognos startup generates the following message:
Since the value is empty, the feature is disabled. There is nothing to test.
[ ERROR ] Mail server authentication failed.
The above is not surprising since the userid & password are set to nulls (our intranet SMTP server does not require userid/password authentication). The default sender is of the form userid@domain.com
No luck. cogserver.log still spits out the error message every 10 seconds:
9.26.163.139:9300 1876 2011-02-04 15:45:58.590 -5 SMTPQueueConsumerManager DLS 4707 4 Audit.RTUsage.ds.DLS <trace>CNC-DS-0001 The following Delivery Service general error occurred: null</trace>
9.26.163.139:9300 1876 2011-02-04 15:46:09.044 -5 SMTPQueueConsumerManager DLS 4707 4 Audit.RTUsage.ds.DLS <trace>CNC-DS-0001 The following Delivery Service general error occurred: null</trace>
9.26.163.139:9300 1876 2011-02-04 15:46:09.044 -5 SMTPQueueConsumerManager JSM 4707 4 Audit.RTUsage.JSM Problem with mail server, will test again in 10 seconds
:(
OK, I think I have my answer from Cognos technical support analyst.
Cognos 10.0 requires configuring mail server to have a user account and then using that userid/password in Cognos configuration.
But folks like me (who are in an environment mail server cannot be configured this way) will have to wait for a Cognos code fix.
Quote: "code fix may be included in Fix Pack 1 of Cognos 10."
So I will wait and hope the fix makes FP1.
Does anyone know if this was fixed in FP001?
ken
Yes, it was.
;D
Gene