Skip to Content

SAP HANA 2.0 unable to start

Hi experts,

We are unable to start SAP HANA server.

its showing connection refused error in index server.

Internal Error Details. Basis/IO/Stream/impl/NetworkChannel.cpp:3037: System error: SO_ERROR has pending error for socket. rc=111: Connection refused. channel={<NetworkChannel>={<NetworkChannelBase>={this=140049911445016, fd=32, refCnt=1, local=127.0.0.1/57292_tcp, remote=127.0.0.1/30001_tcp, state=ConnectWait, pending=[----]}}}; $Context$=[dfdb611914700033,127.0.0.1:57292,127.0.0.1:30001,TRN,0]
[1642]{-1}[-1/-1] 2019-08-30 17:51:58.590629 e TNS              TNSInfo.cpp(00468) : sendRequest setinactive to s4hana:30001 failed with NetException. data=(S)databaseid=4294967295|host=s4hana|port=30003|(I)daemon=2|type=1|(B)watchdog=0|

Add a comment
10|10000 characters needed characters exceeded

  • Can you attach full error log.

  • The error log is of around 3 MB hence have uploaded on the below link.

    https://gofile.io/?c=S5q3in
  • Hi All,

    I am facing the same issue.

    Did anyone find the solution?

    I can see something like this in the logs which points out to Network/Port blocked issue.

    Logs :

    [155810]{315631}[-1/-1] 2020-08-27 10:26:32.817380 e SessionRemoteReq RemoteRequest.cc(00101) : failed to create a request: dest=sahanap6854:30007: exception 1: no.70012001 (TrexNet/EndPoint.cpp:305) TID: 155810 internal error; $TYPE$=OpenChannel; $MESSAGE$=an error occured while opening the channel; $INFO$=internal error; $PARAM$=127.0.0.1:30007 exception throw location: 1: 0x00007f1874fa1e11 in TrexNet::NetException::NetException(TrexNet::NetException::_ExceptionType, char const*, unsigned int, char const*, char const*)+0x60 at Exception.cpp:89 (libhdbbasement.so) 2: 0x00007f1874fbb7ce in TrexNet::ServerRep::openNewChannel(char const*, char const*, ltt::smartptr_handle &)+0x15a at EndPoint.cpp:305 ( libhdbbasement.so) 3: 0x00007f1874fa353b in TrexNet::Requestor::getChannel(char const*, char const*, unsigned short, char, ltt::smartptr_handle &)+0xc7 at Requestor.cpp:175 ( libhdbbasement.so) 4: 0x00007f1874fa82c5 in TrexNet::Request::Request(char const*, TRexUtils::HostAndPort const&, char, ltt::smartptr_handle )+0x2d1 at Request.cpp:556 ( libhdbbasement.so) 5: 0x00007f1874fa8d40 in TrexNet::Request::Request(char const*, char const*, char)+0xb0 at string.hpp:1458 ( libhdbbasement.so) 6: 0x00007f187c5017a8 in ptime::RemoteRequest::createRequest(ltt_adp::basic_string , ltt::integral_constant > const&, int)+0xc4 at RemoteRequest.cc:91 ( libhdbrskernel.so) 7: 0x00007f187c50524c in ptime::RemoteRequest::createRequest(unsigned int const&, int, int, bool)+0x1a8 at RemoteRequest.cc:239 ( libhdbrskernel.so) 8: 0x00007f187c506590 in ptime::RemoteRequest::createRequest(int, int, bool)+0x90 at RemoteRequest.cc:121 ( libhdbrskernel.so) 9: 0x00007f187c4ee946 in ptime::SessionContextRequestHandler::invalidateTempTableManager_(int, ltt_adp::vector >&)+0x92 at SessionContextRequestHandler.cc:729 ( libhdbrskernel.so) 10: 0x00007f1870092408 in Execution::JobObjectImpl::run(Execution::JobWorker*)+0x2144 at JobExecutorImpl.cpp:1110 ( libhdbbasis.so) 11: 0x00007f187007c4e2 in Execution::JobWorker::runJob(ltt::smartptr_handle &)+0x320 at JobExecutorThreads.cpp:385 ( libhdbbasis.so) 12: 0x00007f187007e2fc in Execution::JobWorker::run(void*&)+0xd28 at JobExecutorThreads.cpp:1284 ( libhdbbasis.so) 13: 0x00007f187003e0ef in Execution::Thread::staticMainImp(Execution::Thread*)+0x54b at Thread.cpp:528 ( libhdbbasis.so) 14: 0x00007f187002d368 in Execution::pthreadFunctionWrapper(Execution::Thread*)+0x164 at ThreadInterposition.cpp:633 ( libhdbbasis.so) 15: 0x00007f186f7e2e25 in start_thread+0xc1 (libpthread.so.0) 16: 0x00007f186e05b34d in __clone+0x69 (libc.so.6) [155810]{315631}[-1/-1] 2020-08-27 10:26:32.835184 e SessionRemoteReq SessionContextRequestHandler.cc(00756) : [invalidate temp table map] request set - failed: agcid=315631: error=ERROR [CODE-598] failed to execute the external statement: internal error; $TYPE$=OpenChannel; $MESSAGE$=an error occured while opening the channel; $INFO$=internal error; $PARAM$=127.0.0.1:30007 exception 1: no.71000598 (ptime/session/dist/ RemoteRequest.cc:102) TID: 155810 internal error; $TYPE$=OpenChannel; $MESSAGE$=an error occured while opening the channel; $INFO$=internal error; $PARAM$=127.0.0.1:30007

Related questions

3 Answers

  • Posted on Aug 30, 2019 at 05:59 PM

    Hello,

    I think someone from your team has already created a question for the same issue in the community (Other link here). Kindly close one of the two issue.

    In earlier part of your log, there are log disk full events but I think that has been resolved as I can see HANA is restarted after that again and that error didn't got captured in the log after that.

    The error which is currently you are seeing is SO_ERROR which is used to report errors that are the result of events within the network stack. I think your port 30001 is not open or blocked by firewall. Kindly open the port.

    Regards,

    Dennis Padia.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 31, 2019 at 09:48 PM

    Hello,

    it seems that your nameserver (Port 30001) is not running and disk full events were happening at the beginning of the log. Please check the systemDB and its nameserver.log.

    Regards,

    Jens

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 22 at 06:38 AM

    I got similar error which I have been troubleshooting;

    18: 0x000055604d4b414b in _GLOBAL__sub_I_getTimeOffset.cpp.lto_priv.328+0x4f7 at start.S:112 (hdbnsutil)
    [18950]{-1}[-1/-1] 2020-01-22 08:34:56.660577 e TrexNet EndPoint.cpp(00303) : ERROR: failed to open channel 10.99.99.120:30102! reason: (internal error)
    details: Internal Error Details. Basis/IO/Stream/impl/NetworkChannel.cpp:2524: System error: SO_ERROR has pending error for socket. rc=111: Connection refused. channel={<NetworkChannel>={<NetworkChannelBase>={this=140346075202072, fd=5, refCnt=1, local=10.99.99.144/40402_tcp, remote=10.99.99.120/30102_tcp, state=ConnectWait, pending=[----]}}}; $Context$=[18795fa758c60012,10.99.99.144:40402,10.99.99.120:30102,TRN,0]
    [18950]{-1}[-1/-1] 2020-01-22 08:34:56.660679 e TNS TNSInfo.cpp(00536) : sendRequest dr_registerdatacenter to pr-hn-db:30102 failed with NetException. data=(S)hdbversion=2.00.040.00.1553674765|instance=00|instancename=HDP|mode=async|name=Lugogo|opmode=logreplay|registrator=dr-hn-db|remoteHost=pr-hn-db|systempki_ssfs_data_chksum=825725348-2575281189-3007...|...|(B)...|(N)...|(SV)...|
    [18950]{-1}[-1/-1] 2020-01-22 08:34:56.660705 e sr_nameserver DRClient.cpp(01596) : unable to contact primary site; to pr-hn-db:30102; original error: internal error,location=pr-hn-db:30102
    [18950]{-1}[-1/-1] 2020-01-22 08:34:56.660759 e sr_nameserver srAction.cpp(00041) : unable to contact primary site; to pr-hn-db:30102; original error: internal error,location=pr-hn-db:30102;

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.