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

[Former Member]

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 .

[sunny_pahuja2]

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

[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

[Former Member]

Hi...

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

~Pp

[AtulKumarJain]

Hi Pp,

What error are you getting ?

Can you please paset the error message and attach the screen shot.

Br

Aj