cancel
Showing results for 
Search instead for 
Did you mean: 

Analytics Platform connection problem. Administration Console shows error.

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

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

Former Member
0 Kudos

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

Answers (2)

Answers (2)

duncanspeidel
Contributor
0 Kudos

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

Former Member
0 Kudos

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)...

duncanspeidel
Contributor
0 Kudos

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

Former Member
0 Kudos

Hi Duncan,

I haven't tested it before replication, as the Installation Guide procedure is to execute a SQL query before using the Administration Console.

I will test in a new environment to see if I it is working before enabling replication (Re-Installing right now).

As soon as I finish I'll post.

Thanks!.

Former Member
0 Kudos

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.