10 Replies Latest reply: Jul 1, 2016 10:26 AM by Michael Healy RSS

Error-Database connection is not available while connecting to HANA

Partho Mukherjee
Currently Being Moderated

Hello All,

I am having trouble connecting to my HANA server and getting the following error. I have successfully installed HANA Studio but while connecting to the server it is not allowing me:

"database connection is not available", SAPcontrol request failed.

HANA Sudio version is 1.0.26. I tried with both the java versions:

java.version=1.6

java.version=1.7

 

Please advice.

 

Rgs,

Parth.

  • Re: Error-Database connection is not available while connecting to HANA
    Neha Singla
    Currently Being Moderated

    Hello Partho,

     

    While adding the system, have you changes your password?

    If yes, please delete the added system and try to add the system with same user id and new password.

     

    Hope it s helpful.

     

    Regards,Neha

    • Re: Error-Database connection is not available while connecting to HANA
      Partho Mukherjee
      Currently Being Moderated

      No, I have not changed any password. I am trying to access with the password provided to me by the administrator.

      I am getting a "Database Connection not Available"  error. below are some more details:

      !MESSAGE Database connection is not available. See error log for more details.

      !STACK 0

      com.sap.ndb.studio.jdbc.JDBCConnectionStatus: Database connection is not available. See error log for more details.

      at com.sap.ndb.studio.jdbc.JDBCPlugin.createConnection(JDBCPlugin.java:319)

      at com.sap.ndb.studio.navigator.operations.SAPSystemObjectUpdate.executeTryJDBC(SAPSystemObjectUpdate.java:196)

      at com.sap.ndb.studio.navigator.operations.SAPSystemObjectUpdate.execute(SAPSystemObjectUpdate.java:68)

      at com.sap.ndb.studio.navigator.operations.UpdateSAPSystemOperation.execute(UpdateSAPSystemOperation.java:75)

      at com.sap.ndb.studio.datamodel.controler.DataModelOperation.execute(DataModelOperation.java:67)

      at com.sap.ndb.studio.datamodel.controler.DataModelOperationQueue$DataModelOperationThread.run(DataModelOperationQueue.java:99)

      Caused by: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: Cannot connect to jdbc:sap://10.243.115.95:30015 [Cannot connect to host 10.243.115.95:30015 [Connection refused: connect], -813.].

      at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.createException(SQLExceptionSapDB.java:219)

      at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.createException(SQLExceptionSapDB.java:203)

      at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.generateDatabaseException(SQLExceptionSapDB.java:186)

      at com.sap.db.jdbc.Driver.connect(Driver.java:236)

      at com.sap.ndb.studio.jdbc.JDBCPlugin$5.run(JDBCPlugin.java:655)

      !ENTRY com.sap.ndb.studio.jdbc 4 4 2012-04-19 16:12:59.793

      !MESSAGE [{0}] Internal Error

      !STACK 0

       

  • Re: Error-Database connection is not available while connecting to HANA
    Rama Shankar
    Currently Being Moderated

    Partho:

     

    Check this blog - a similar problem was fixed in this blog. Also, refer to OSS note mentioned in the below blog.

     

    http://scn.sap.com/thread/2117543

     

    Let me know if this helped resolve your problem.

     

    Regards,

    Rama

  • Re: Error-Database connection is not available while connecting to HANA
    Patrik Kludsky
    Currently Being Moderated

    Hi Partho, everyone

     

    is there anyone who helped you? I have a similar problem. Our server was frozen then we had to do force restart and from this time our HANADB is not working.

     

    It's some problem with indexserver - service not started.

    I've tried manually start it -> nothing.

     

    I've tried HDB start/stop -> nothing.

    Recovery SAP HANA by date -> nothing.

     

    In the attachment I'm sending the error log file to connect database and system not running.

     

    I hope that anyone will help me.

     

    Thank you in advance.

    Best regards

    Patrik

    • Re: Error-Database connection is not available while connecting to HANA
      Michael Healy
      Currently Being Moderated

      Can you see what is been written into the nameserver + indexserver logs?

      • Re: Error-Database connection is not available while connecting to HANA
        Patrik Kludsky
        Currently Being Moderated

        I don't know where I can find it. Can you give me an advice?

         

        Thank you very much

        • Re: Error-Database connection is not available while connecting to HANA
          Michael Healy
          Currently Being Moderated

          Can you access the HANA Studio? You can see these in the Diagnosis files.

           

          If not you should be able to see the traces at OS level:

           

          /usr/sap/<SID>/HDB<instance>/<host>/trace

          • Re: Error-Database connection is not available while connecting to HANA
            Patrik Kludsky
            Currently Being Moderated

            Thank you Michael,

             

            I got it but it's a 5 files and are bigger than 1MB and when I tried .rar files, I'm not able to send you in this message. Rules doesn't allow that.

             

            Is there anyway how could I send you? If you can have my email you can write me and I will send you over email. Or any other idea?

             

            Greetings

            Patrik

                • Re: Error-Database connection is not available while connecting to HANA
                  Michael Healy
                  Currently Being Moderated

                  Looks like a corruption. You have to recover to a point in time to your last full db backup.

                   

                  I see you have a crashdump:

                   

                   

                   

                  [CRASH_STACK]  Stacktrace of crash: (2016-06-30 19:45:30 729 Local)

                  ----> Pending exceptions (possible root cause) <----

                  exception  1: no.3020046  (DataAccess/PageAccess/impl/PageImpl.cpp:377)

                      Wrong savepoint version: Expected 131404 but found 131406.; $verifiedForInternalReorganization$=false; $pno$=0x6d963L; $ppno$=0x700000014ac4P [0x14ac4,16k,0]

                  exception throw location:

                  1: 0x00007fae2fb99d01 in PageAccess::Page::verifyHeader(PageAccess::SizeClass, DataAccess::SavepointVersion const&) const+0x360 at PageImpl.cpp:377 (libhdbdataaccess.so)

                  2: 0x00007fae2fb9c774 in PageAccess::PageControlBlock::onLoad(unsigned int, PageAccess::PageNo const&, PageAccess::PageNo const&, bool, bool)+0x290 at Page.hpp:275 (libhdbdataaccess.so)

                  3: 0x00007fae2fb878a8 in PageAccess::LogicalPageControlBlock::onLoad(unsigned int, bool, bool)+0x94 at LogicalPageImpl.cpp:313 (libhdbdataaccess.so)

                  4: 0x00007fae2fb82f27 in PageAccess::LogicalPageAccessImpl::loadPageInternal(PageAccess::PageNo const&, ResourceManager::ResourceHint const&, ResourceManager::Disposition, bool, bool&, ResourceManager::HandleMissingResourceMode, bool const&)+0x753 at LogicalPageAccessImpl.cpp:1109 (libhdbdataaccess.so)

                  5: 0x00007fae2fb84611 in PageAccess::LogicalPageAccess::loadPage(PageAccess::PageNo const&, ResourceManager::Disposition, ResourceManager::HandleMissingResourceMode)+0x40 at LogicalPageAccessImpl.hpp:126 (libhdbdataaccess.so)

                  6: 0x00007fae2d1e4d5d in UnifiedTable::PageChain<UnifiedTable::DataPageDirectoryElement>::loadLastPage()+0x89 at PageChain.cpp:586 (libhdbunifiedtable.so)

                  7: 0x00007fae2cfdb970 in UnifiedTable::DeltaDataObject::DeltaDataObject(ltt::allocator&, UnifiedTable::FragmentObject&, PageAccess::PersistentObjectHandle<UnifiedTable::PersFragmentDescriptor>&)+0x4c0 at DeltaDataObject.cpp:809 (libhdbunifiedtable.so)

                  8: 0x00007fae2d002ce8 in UnifiedTable::FragmentObject::FragmentObject(ltt::allocator&, PageAccess::PersistentObjectHandle<UnifiedTable::PersFragmentDescriptor>&, UnifiedTable::TableContainerImpl&, PageAccess::PersistentObjectHandle<UnifiedTable::PersTableDescriptor> const&)+0xd64 at FragmentObject.cpp:402 (libhdbunifiedtable.so)

                  9: 0x00007fae2cfc3099 in UnifiedTable::DataObject::DataObject(ltt::allocator&, UnifiedTable::TableContainerImpl const*, PageAccess::PersistentObjectHandle<UnifiedTable::PersTableDescriptor>&)+0xbe5 at DataObject.cpp:126 (libhdbunifiedtable.so)

                  10: 0x00007fae2d103eba in UnifiedTable::TableContainerImpl::createDataObject(UnifiedTable::TableContainerImpl const&, PageAccess::PersistentObjectHandle<UnifiedTable::PersTableDescriptor>&) const+0x86 at TableContainerImpl.cpp:2404 (libhdbunifiedtable.so)

                  11: 0x00007fae2d10513e in UnifiedTable::TableContainerImpl::createDataObjectAndTableReader(PageAccess::PersistentObjectHandle<UnifiedTable::PersTableDescriptor>&) const+0x1a at TableContainerImpl.cpp:2427 (libhdbunifiedtable.so)

                  12: 0x00007fae2d10668b in UnifiedTable::TableContainerImpl::loadDataObject() const+0x157 at TableContainerImpl.cpp:2497 (libhdbunifiedtable.so)

                  13: 0x00007fae2d106e80 in UnifiedTable::TableContainer::getReader() const+0x10 at TableContainerImpl.cpp:689 (libhdbunifiedtable.so)

                  14: 0x00007fae2d0f3cd4 in UnifiedTable::RedoHandler::redo(DataAccess::PersistenceSession&, unsigned long, void const*, unsigned long) const+0x1b0 at RedoHandler.cpp:2455 (libhdbunifiedtable.so)

                  15: 0x00007fae2fae6259 in DataRecovery::ProxyPseudoLogRecord::redo(DataAccess::PersistenceSession&, unsigned long, void const*, unsigned long) const+0x1a5 at ParallelRecoveryProxy.cpp:479 (libhdbdataaccess.so)

                  16: 0x00007fae2fb0a223 in DataRecovery::RecoveryQueue::run(void*&)+0x440 at RecoveryQueue.cpp:156 (libhdbdataaccess.so)

                  17: 0x00007fae24e90b19 in Execution::Thread::staticMainImp(void**)+0x7e5 at Thread.cpp:467 (libhdbbasis.so)

                  18: 0x00007fae24e919ed in Execution::Thread::staticMain(void*)+0x39 at ThreadMain.cpp:26 (libhdbbasis.so)

                   

                   

                  exception  1: no.3020046  (DataAccess/PageAccess/impl/PageImpl.cpp:377)

                      Wrong savepoint version: Expected 131404 but found 131406.; $verifiedForInternalReorganization$=false; $pno$=0x6d963L; $ppno$=0x700000014ac4P [0x14ac4,16k,0]

                  exception throw location:

                  1: 0x00007fae2fb99d01 in PageAccess::Page::verifyHeader(PageAccess::SizeClass, DataAccess::SavepointVersion const&) const+0x360 at PageImpl.cpp:377 (libhdbdataaccess.so)

                  2: 0x00007fae2fb9c774 in PageAccess::PageControlBlock::onLoad(unsigned int, PageAccess::PageNo const&, PageAccess::PageNo const&, bool, bool)+0x290 at Page.hpp:275 (libhdbdataaccess.so)

                  3: 0x00007fae2fb878a8 in PageAccess::LogicalPageControlBlock::onLoad(unsigned int, bool, bool)+0x94 at LogicalPageImpl.cpp:313 (libhdbdataaccess.so)

                  4: 0x00007fae2fb82f27 in PageAccess::LogicalPageAccessImpl::loadPageInternal(PageAccess::PageNo const&, ResourceManager::ResourceHint const&, ResourceManager::Disposition, bool, bool&, ResourceManager::HandleMissingResourceMode, bool const&)+0x753 at LogicalPageAccessImpl.cpp:1109 (libhdbdataaccess.so)

                  5: 0x00007fae2fb84611 in PageAccess::LogicalPageAccess::loadPage(PageAccess::PageNo const&, ResourceManager::Disposition, ResourceManager::HandleMissingResourceMode)+0x40 at LogicalPageAccessImpl.hpp:126 (libhdbdataaccess.so)

                  6: 0x00007fae2d1e4d5d in UnifiedTable::PageChain<UnifiedTable::DataPageDirectoryElement>::loadLastPage()+0x89 at PageChain.cpp:586 (libhdbunifiedtable.so)

                  7: 0x00007fae2cfdb970 in UnifiedTable::DeltaDataObject::DeltaDataObject(ltt::allocator&, UnifiedTable::FragmentObject&, PageAccess::PersistentObjectHandle<UnifiedTable::PersFragmentDescriptor>&)+0x4c0 at DeltaDataObject.cpp:809 (libhdbunifiedtable.so)

                  8: 0x00007fae2d002ce8 in UnifiedTable::FragmentObject::FragmentObject(ltt::allocator&, PageAccess::PersistentObjectHandle<UnifiedTable::PersFragmentDescriptor>&, UnifiedTable::TableContainerImpl&, PageAccess::PersistentObjectHandle<UnifiedTable::PersTableDescriptor> const&)+0xd64 at FragmentObject.cpp:402 (libhdbunifiedtable.so)

                  9: 0x00007fae2cfc3099 in UnifiedTable::DataObject::DataObject(ltt::allocator&, UnifiedTable::TableContainerImpl const*, PageAccess::PersistentObjectHandle<UnifiedTable::PersTableDescriptor>&)+0xbe5 at DataObject.cpp:126 (libhdbunifiedtable.so)

                  10: 0x00007fae2d103eba in UnifiedTable::TableContainerImpl::createDataObject(UnifiedTable::TableContainerImpl const&, PageAccess::PersistentObjectHandle<UnifiedTable::PersTableDescriptor>&) const+0x86 at TableContainerImpl.cpp:2404 (libhdbunifiedtable.so)

                  11: 0x00007fae2d10513e in UnifiedTable::TableContainerImpl::createDataObjectAndTableReader(PageAccess::PersistentObjectHandle<UnifiedTable::PersTableDescriptor>&) const+0x1a at TableContainerImpl.cpp:2427 (libhdbunifiedtable.so)

                  12: 0x00007fae2d10668b in UnifiedTable::TableContainerImpl::loadDataObject() const+0x157 at TableContainerImpl.cpp:2497 (libhdbunifiedtable.so)

                  13: 0x00007fae2d106e80 in UnifiedTable::TableContainer::getReader() const+0x10 at TableContainerImpl.cpp:689 (libhdbunifiedtable.so)

                  14: 0x00007fae2d0f3cd4 in UnifiedTable::RedoHandler::redo(DataAccess::PersistenceSession&, unsigned long, void const*, unsigned long) const+0x1b0 at RedoHandler.cpp:2455 (libhdbunifiedtable.so)

                  15: 0x00007fae2fae6259 in DataRecovery::ProxyPseudoLogRecord::redo(DataAccess::PersistenceSession&, unsigned long, void const*, unsigned long) const+0x1a5 at ParallelRecoveryProxy.cpp:479 (libhdbdataaccess.so)

                  16: 0x00007fae2fb0a223 in DataRecovery::RecoveryQueue::run(void*&)+0x440 at RecoveryQueue.cpp:156 (libhdbdataaccess.so)

                  17: 0x00007fae24e90b19 in Execution::Thread::staticMainImp(void**)+0x7e5 at Thread.cpp:467 (libhdbbasis.so)

                  18: 0x00007fae24e919ed in Execution::Thread::staticMain(void*)+0x39 at ThreadMain.cpp:26 (libhdbbasis.so)

                   

                   

                   

                  More than likely it is related to the below note.

                   

                  2203059 - HANA persistence corruption because of GPFS rapid repair feature

                   

                   

                  Can you confirm what was happening before this happened? Did you perform a failover?

Actions