on 06-22-2016 3:06 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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)...
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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!.
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.
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.