Skip to main content

Posts

Showing posts from January, 2010

Email Alerts are not received...

In one of application, Email alerts are sent using SQL sp_send_dbmail stored procedure. Email alerts were working properly, but suddenly noticed email alerts are not received.

To troubleshoot the issue, first I checked the msdb.dbo.sysmail_event_log table using the below query.

SELECT log_id, event_type, log_date, description, process_id, mailitem_id, account_id, last_mod_date, last_mod_user
FROM
msdb.dbo.sysmail_event_log 
ORDER BY
log_date DESC

If there is any error, you should see records with the event_type value as error.
In my case there are records with event_type value as error, and the description value for those records is same as below

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 (2018-02-01T10:41:27). Exception Message: Cannot send mails to mail server. (The SMTP server requires a secure connection or the client was not authenticated. The server response was: Authentication required).  )

As per the error descript…

Unable to connect to server in PerformancePoint Server 2007

While I am trying to connect to the server in PerformancePoint Dashboard Designer, I got a message saying "Unable to connect to server".
There may be two resons.
* The first reason is the services required to run the PerformancePoint server are stopped in the
Internet Information Services (IIS) Manger Application Pools.
Therefore to fix that issue, first go to the IIS Manger and select Application Pools.
Then the services run in the Application Pools will be shown and you will see the services
related to PerformancePoint server (PPSMonitoringCentral, PPSMonitoringPreview,
PPSMonitoringWebService) are stopped.
Start those services by click on it and selecting Start in the Application Pool Tasks.

* The other reason is the SQL Server Service is not started.
To fix it open the Sql Server Configuation Manager and start the relevant Sql Server Service

After that you will be able to connect to the server...

Dashboard was not deployed...

While am trying to preview a dashboard in PerformancePoint Server, it shows the detail that "Dashboard was not Deployed".
The reson for that issue is we don't have permissions to preview it.

To fix it follow below steps.

Go to IIS-->Local Host-->SitesClick on PPS MonitoringRight click on Preview and click Edit Permissions.Then you will get the Preview Properties. Click on the Security tab and click on the Edit button.Then add the current user by allowing Full Control.
After that that click Ok and you will be able to preview the dashboard...That will fix the issue which I mentioned on top of the article.