Dear Experts ,
Wishing another successful day for you all ,
Recently we have experienced below error while going to initiation of Sap Customer Checkout manager in HANA flatform .
SAP DBTech JDBC: Cannot connect to jdbc:sap://127.0.0.1:30041 [Cannot connect to host /127.0.0.1:30041 [java.io.IOException: The remote computer refused the network connection: 127.0.0.1:30041], -813.].
So when google the issue we got the SAP Note : 2501339 - Error: "SAP DBTech JDBC: Cannot connect to jdbc..." occurs when connecting tenant DB by using JDBC driver
and did the mentioned resolution as below ,
You can determine the ports used by a particular tenant database by querying the M_SERVICES system view, either from the tenant database itself or from the system database.
From the tenant database:
SELECT SERVICE_NAME, PORT, SQL_PORT, (PORT + 2) HTTP_PORT FROM SYS.M_SERVICES WHERE ((SERVICE_NAME='indexserver' and COORDINATOR_TYPE= 'MASTER') or (SERVICE_NAME='xsengine'))
From the system database: Exchange the <DBNAME> to your tenant DB SID in the following SQL.
SELECT DATABASE_NAME, SERVICE_NAME, PORT, SQL_PORT, (PORT + 2) HTTP_PORT FROM SYS_DATABASES.M_SERVICES WHERE DATABASE_NAME='<DBNAME>' and ((SERVICE_NAME='indexserver' and COORDINATOR_TYPE= 'MASTER') or (SERVICE_NAME='xsengine'))<br>
We got the result when run the first sql script as below,
SERVICE_NAME; PORT; SQL_PORT; HTTP_PORT
indexserver ; 30040; 30041; 30042
And as advised 2nd point in the resolution try to config using the SQL_PORT 30041 but giving the error as mention in the begining of this query . other two port numbers also tried but not succeeded.
So could anyone advise on this matter to move forward . Really appreciated if possible .
SAP Business one HANA version 10 FP2102 and Sap Customer Checkout Manager 2.0 FP14PL00
Thanks in advance .
Best Regards,
Tharindu Wijesinghe.