HANA Studio issue:> SAP DBTech JDBC: [2566]: distributed environment error: no servers found

[Former Member]

Hi,

Anyone know why I can't see the Alerts View in HANA Studio, please see error attached - SAP DBTech JDBC: [2566]: distributed environment error: no servers found

Database version 1.00.096.00.1432206182 (fa/newdb100_rel), studio version Version: 2.0.15.

Regards,

Willem

[Former Member · Accepted solution]

"No servers found" typically indicates that there are no services available that would be able to provide you access to the data you need. So it is usually a more severe issue. I would recommend you to check if all SAP HANA nodes and services are still up and running and if there are any errors in trace files (statisticsserver if standalone and indexserver to start with).

[Former Member · Accepted solution]

Hi,

All my services are running:

S4ZAJ1SYLX16:~> sapcontrol -nr 00 -function GetProcessList

18.06.2015 14:12:59

GetProcessList

OK

name, description, dispstatus, textstatus, starttime, elapsedtime, pid

hdbdaemon, HDB Daemon, GREEN, Running, 2015 06 15 12:19:01, 73:53:58, 37182

hdbnameserver, HDB Nameserver, GREEN, Running, 2015 06 17 21:54:09, 16:18:50, 30509

hdbpreprocessor, HDB Preprocessor, GREEN, Running, 2015 06 17 21:54:09, 16:18:50, 30512

hdbindexserver, HDB Indexserver, GREEN, Running, 2015 06 17 21:54:09, 16:18:50, 30515

hdbxsengine, HDB XSEngine, GREEN, Running, 2015 06 17 21:54:09, 16:18:50, 30518

hdbcompileserver, HDB Compileserver, GREEN, Running, 2015 06 17 21:54:09, 16:18:50, 30521

hdbwebdispatcher, HDB Web Dispatcher, GREEN, Running, 2015 06 17 21:54:09, 16:18:50, 30524

I notice the same error in the log file when I run a Consistency Check, as per screenshot attached.

I stopped the DB, cleared the trace directory, then started the DB, but don't notice errors in the trace files, attached them.

Kind Regards,

Willem

trace directory.zipx.txt.zip

[Former Member · Accepted solution]

I see that you no longer use the standalone statistics server. Is this a scale-out system? Can you run the following individual mini check and provide me with the results?

SELECT

        'STAT_SERVER_WRONG_HOST',

        '',

        TO_CHAR(COUNT(*))

      FROM

        M_TABLE_LOCATIONS

      WHERE

        SCHEMA_NAME = '_SYS_STATISTICS' AND

        LOCATION !=

        ( SELECT

            HOST || ':' || PORT

          FROM

            M_SERVICES

          WHERE

            SERVICE_NAME = 'indexserver' AND

            DETAIL = 'master'

        )

If something different from 0 is returned, SAP Note 2091256 applies.

[Former Member · Accepted solution]

Hi,

Yes, I upgraded from Revision 90 to 96 which would have automatically activated the embedded statistics server.

No, this is as single host system - may I still apply steps in SAP note 2091256?

Output to mini check is:

;'STAT_SERVER_WRONG_HOST';'';TO_CHAR(COUNT(*))

1;STAT_SERVER_WRONG_HOST  ;  ;238 

Thanks

[Former Member · Accepted solution]

That's strange, what's the output of the following command?

SELECT

       LOCATION,

        COUNT(*)

      FROM

        M_TABLE_LOCATIONS

      WHERE

        SCHEMA_NAME = '_SYS_STATISTICS'

      GROUP BY

        LOCATION

[Former Member · Accepted solution]

Hi,

Please find output of above query:

LOCATION;COUNT(*)

:0;238

s4zaj1sylx16:30003;1

[Former Member · Accepted solution]

This output indicates that 238 statistics server tables don't have any location specified - i.e. no service to handle it. I could imagine that something went wrong during statistics server migration. I would recommend you to check at first SAP Notes 2006652, 2036630 and 2091256. If you can't figure out the solution yourself, a more detailed analysis is required. Please open a SAP incident on component HAN-DB for that purpose.

[Former Member]

Hi,

Resolution on the incident are the following:

"It appears the migration was not completely successful. So to restart the migration, you can perform the following steps:

SAP Note: 2149427 - SAP HANA ESS_Embedded Statistics Server Migration

Guide

In section 5.1 Migration Failure."

Kind Regards,

Willem

[Former Member]

HI there,

could you let us know when exactly this occurred?

Was it working fine on revision 90 and error occurred right after you moved to 96? or was it working fine on 96 and stopped working after some time?

Please post the answer if you hear anything from SAP support!

[Former Member]

Hi Elizaveta,

Before the upgrade the statistics server had another issue which was addressed (http://scn.sap.com/message/16010442#16010442).

I did not notice this issue immediately, the upgrade showed successful, but I agree that most probably it was an issue during the migration.

I also notice the same error now when I try to view the parameters (attached).

Will post the resolution when it comes.

[Former Member]

I closed and opened the studio and can view "Configuration" now without this issue, so on the Configuration view this might be intermittent. Still same issue on Alerts view though.