Skip to Content
avatar image
Former Member

SAP DBTech JDBC: [2566]: distributed environment error: no servers found

HI experts:

    I have 2 node of scale-out landscape HANA , saphana01 and saphana02 , I created some demo tables and uploaded the data into table on node saphana02 , which is HANA studio connected to  , after I shutdown node saphana02 ,  I have strange problem:

     When I connect the studio to saphana01 , everything looks fine , I could open the content package , check the definition of table , view. but when I execute the SQL statment " select * from CUSTOMER" , then I got following error :

  Could not execute 'select * from CUSTOMER' in 4 ms 837 µs .

  SAP DBTech JDBC: [2566]: distributed environment error: no servers found;LARRY:CUSTOMER

    It seems that the data of table was loaded on node saphana02 , and could not accessed on saphana01 . so I start HANA on node saphana02 again , everything work fine. I thought HANA will take care the load banlancing internally , so I could use any node of HANA cluster to access the data , but this error confused me totally  .... any advice is helpful .

reagrds

Thank you very much .

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Sep 13, 2013 at 05:48 AM

    Hi...

    I have got the same error... also could not open System Admin Console of my HANA System...

    ~Pp

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 13, 2013 at 07:17 PM

    Could you please run below query to check on which node this table physically resides?

    SQL to Verify where the tables or partitions of a split table physically reside :

    select * from M_TABLE_PERSISTENCE_LOCATIONS where

    schema_name='YOUR_SCHEMA' and table_name='YOUR_TABLE'

    Thanks

    Sunny

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi: Sunny:

      Using your SQL, if I have a table under M_TABLE_PERSISTENCE_LOCATIONS, but it is not found under M_TABLES or TABLES, how do I remove the entry in M_TABLE_PERSISTENCE_LOCATIONS?

      Thanks,

      wengen