Skip to Content
author's profile photo Former Member
0
Former Member

Analytics Platform connection problem. Administration Console shows error.

Posted on Jun 22, 2016 at 02:06 PM 1k Views

Hi...

Recently we're trying to deploy a High-Availability environment following the "SAP Business One, version for SAP HANA High-Availability Installation Guide Ver. 3.0.1 - 2015-12-15", but Analytics Platform shows "You are not connected to the SAP HANA database server; the database server is not available or you entered an invalid SYSTEM logon password.".

The catalina.out file shows this error:

java.lang.NullPointerException: while trying to invoke the method org.w3c.dom.Node.getChildNodes() of a null object loaded from local variable 'firstEntry'

at com.sap.businessone.licenseProxy.service.impl.XMLResponseParser.getDatabaseInstanceFromServiceUnitEntity(XMLResponseParser.java:252)

at com.sap.businessone.licenseProxy.service.impl.LicenseManagerRestfulImpl$9.received(LicenseManagerRestfulImpl.java:1740)

Operating System used is SLESB1HANA 11 SP4 and SBO is 9.1 PL11.

SYSTEM password has never been changed.

Do you have any clue what could possibly be causing this problem?

Thanks.

1.png (163.1 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Jiawei Huang
    Jiawei Huang
    Posted on Jun 24, 2016 at 02:43 AM
    3

    Hi Christopher,

    I know this error is very annoying.

    1. please make sure below 2 value is the same.

    select value from comm.comm_config where name='licenseComponentID'

    select id from slddata.b1ahservers where name='<Virtual IP Address>'


    2. please make sure "B1AHSERVER_ID" in "SLDDATA"."HOSTINGUNITS"

    is the same as ID in SLDDATA.B1AHSERVERS.


    After modify data, please restart b1ahservertools via command "/etc/init.d/sapb1servertools restart" in both HANA primary server and central server.

    Best Regards

    Jiawei

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member
      Jun 28, 2016 at 03:24 PM

      Hi Jiawei,

      Efectively the HOSTINGUNITS.B1AHSERVER_ID value was different from B1AHSERVERS.ID.

      Matching this IDs cause the Analytics Administration Console to connect correctly to the DB.

      The problem is now solved... Thank you very much!

      Best regards...

      Christopher

      2.png (162.4 kB)
  • author's profile photo Duncan Speidel
    Duncan Speidel
    Posted on Jun 22, 2016 at 04:37 PM
    0

    Hi Christopher,

    I do not have the HA guide you reference in front of me but I have helped a lot of people with HA. Are you working with HA that includes automatic or manual fail over?

    Did you confirm analytics was working before you enabled replication? Did the problem occur when you tested failover, or when you completed initial setup? Have you opened a support ticket? It is good to raise this issue to support so they can provide any solutions they might have or forward it to product development if required.

    Best regards,

    Duncan

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member
      Jun 22, 2016 at 05:41 PM

      Hi again Duncan,

      Efectively Analytics Platform works before enabling replication, and even more... It works before SQL query to modify the Analytics Platform.

      Assuming the Virtual IP is 192.168.2.100, SQL query looks like this:

      UPDATE "SBOCOMMON"."SLSPP" SET "ParamValue"='192.168.2.100' WHERE "ParamKey"='host' AND "CompID"=(SELECT "CompID" FROM "SBOCOMMON"."SLSP" WHERE "CompType"='IMCEsrv');

      DELETE FROM SLDDATA.B1AHSERVERS a WHERE NOT EXISTS (SELECT 1 FROM COMMON.COMM_CONFIG b WHERE a.id=b.value AND b.name='licenseComponentID');

      UPDATE "SLDDATA"."B1AHSERVERS" SET "NAME"='192.168.2.100' ,"URL"='192.168.2.100:40000', "ACCESSURL"='https://192.168.2.100:40000/Enablement';

      Once I run this query the Analitycs Platform can't stablish connection to the database.


      By the way... It's Manual Failover.

    Comment on This Answer
  • author's profile photo Duncan Speidel
    Duncan Speidel
    Posted on Jun 23, 2016 at 06:58 PM
    0

    Hi Christopher,

    You need to run the referenced queries so that the analytics will be available in case of a failover. When you say "can't stablish connection to the database." Are analytics not available with DB issue or is it the same error you reported earlier?

    Best regards,

    Duncan

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member
      Jun 23, 2016 at 07:21 PM

      Hi Duncan,

      Same error I reported: "You are not connected to the SAP HANA database server; the database server is not available or you entered an invalid SYSTEM logon password.". I'm comparing data in tables SBOCOMMON.SLSPP, SBOCOMMON.SLSP with a working server tables and are the same. The SLDDATA.B1AHSERVERS shows the correct data.

      Something else is that when I try clicking the Change Password button, catalina shows this:

      com.sap.db.jdbc.exceptions.jdbc40.SQLInvalidAuthorizationSpecException: [10]: authentication failed

      at com.sap.db.jdbc.exceptions.jdbc40.SQLInvalidAuthorizationSpecException.createException(SQLInvalidAuthorizationSpecException.java:40)

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

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.