cancel
Showing results for 
Search instead for 
Did you mean: 

HANA Alerts email Issue

former_member183087
Participant
0 Kudos

Hello Folks

I have an issue sending mails from HANA Studio where we configure the alert notifications. I am able to send mails from OS level from root and sidadm as well.

When I give the below settings in Alerts Configuration I am not able to receive Alert mails.

Sender E-mail Address: xxxxx@xxxxx.com

SMTP Sever: localhost or hostname.local

SMTP Port: 25

I get the below errors in statisticsserver trace:

Recommended action: Investigate the alerts., exception  1: no.2110001  (Basis/IO/Stream/impl/NetworkChannelCompletion.cpp:546)

    Generic stream error: getsockopt, Event=EPOLLERR - , rc=111: Connection refused

$NetworkChannel$=

NetworkChannel FD 16 [0x00007ff76b6c0940]  {refCnt=4, idx=0} (invalid)->10.1.1.181/465_tcp ConnectWait,[r--c]

exception throw location:

1: 0x00007ff9b1293ab9 in Stream::NetworkChannelCompletionThread::run(void*&)+0x215 at NetworkChannelCompletion.cpp:546 (libhdbbasis.so)

2: 0x00007ff9b12262eb in Execution::Thread::staticMainImp(void**)+0x627 at Thread.cpp:475 (libhdbbasis.so)

3: 0x00007ff9b122648d in Execution::Thread::staticMain(void*)+0x39 at Thread.cpp:543 (libhdbbasis.so)

[1189]{-1}[-1/-1] 2014-11-14 07:52:13.852704 e StatsSeq         EmailJob.cpp(00268) : Exception caught while sending email

exception  1: no.9001006  (StatisticsServerAsSQLClient/interfaces/outbound/impl/SMTPClient.cpp:367)

    Error 2110001 when trying to send email: [SMTPMail: (), "Alert "Notification of high priority alerts" (id 24) on GBD 05", SnapshotID: 14.11.2014 07:52:07 747 Fri

Rating: Info

30 high priority alerts occurred.

3: 0x00007ff9b122648d in Execution::Thread::staticMain(void*)+0x39 at Thread.cpp:543 (libhdbbasis.so)

[1477]{-1}[-1/-1] 2014-11-14 07:53:59.809746 e StatsOC          SMTPClient.cpp(00366) : error sending email [SMTPMail: (), "Alert "Notification of medium and high priority alerts" (id 23) on GBD 05", SnapshotID: 14.11.2014 07:53:59 747 Fri

Rating: Info


Any thoughts here ?


Thanks

Srikar


Accepted Solutions (0)

Answers (2)

Answers (2)

abhishek_singh11
Explorer
0 Kudos

Hi Srikar,

Please could you share the resolution steps. i am facing similar issues.

Thanks Much,

Abhishek

former_member183087
Participant
0 Kudos

Hi Abhishek

I have used localhost as hostname and standard port 25 in HANA Alert settings. Everything started working. We use postfix as underlying OS mail functionality.

Thanks

Srikar

Former Member
0 Kudos

This message was moderated.