DB host alias in HANA DB import

[Former Member]

We are at the step "IMPORT JAVA DUMP"  using SWPM.

However we see in the "jmigmon.java.log" following errors:

completed:0 aborted:0 running:1 pending:306

com.sap.sql.exception.OpenSQLException: SAP DBTech JDBC: Cannot connect to VolumeID=10 [Cannot connect to host ###.24.119.221:30815

[Connection timed out (port 30815 to address ###.24.119.221 (hanadbhost-int.et.com))], -813.].

        OpenSQLExceptionCategories: [NON_TRANSIENT, DB_ADMINISTRATOR_REQUIRED]

        at com.sap.sql.exception.SQLExceptionFactory.createOpenSQLException(SQLExceptionFactory.java:167)

        at com.sap.sql.exception.SQLExceptionFactory.wrapChainedSQLException(SQLExceptionFactory.java:72)

        at com.sap.sql.jdbc.direct.DirectPooledConnection.processSQLExceptionJava6(DirectPooledConnection.java:1000)

        at com.sap.sql.jdbc.direct.DirectPooledConnection.processSQLException(DirectPooledConnection.java:926)

        at com.sap.sql.jdbc.direct.DirectConnection.processSQLException(DirectConnection.java:1544)

        at com.sap.sql.jdbc.direct.DirectPreparedStatement.executeQuery(DirectPreparedStatement.java:318)

        at com.sap.sql.jdbc.direct.DirectPreparedStatement.executeQuery(DirectPreparedStatement.java:271)

        at com.sap.dictionary.database.dbs.DbBasicTable.getRows(DbBasicTable.java:277)

        at com.sap.dictionary.database.dbs.DbDeployLogs.insertToDb(DbDeployLogs.java:184)

        at com.sap.dictionary.database.dbs.DbDeployLogs.closeObjectLog(DbDeployLogs.java:172)

        at com.sap.dictionary.database.dbs.DbTableModificationAnalyser.analyse(DbTableModificationAnalyser.java:73)

        at com.sap.dictionary.database.dbs.DbModificationController.analyse(DbModificationController.java:505)

        at com.sap.dictionary.database.dbs.DbModificationController.distribute(DbModificationController.java:395)

        at com.sap.dictionary.database.dbs.DbModificationController.distribute(DbModificationController.java:386)

        at com.sap.dictionary.database.opentools.DbTableOpenTools.dropTable(DbTableOpenTools.java:115)

        at com.sap.inst.jload.db.DBTable.drop(DBTable.java:87)

        at com.sap.inst.jload.executor.JobExecutor.dbImport(JobExecutor.java:332)

        at com.sap.inst.jload.executor.JobExecutor.runJob(JobExecutor.java:859)

        at com.sap.inst.jload.executor.JobExecutor.executeJob(JobExecutor.java:780)

        at com.sap.inst.jmigmon.engine.dispatcher.JLoadTask.runJLoad(JLoadTask.java:118)

        at com.sap.inst.jmigmon.engine.dispatcher.JLoadTask.execute(JLoadTask.java:147)

        at com.sap.inst.jmigmon.engine.dispatcher.JLoadTask.run(JLoadTask.java:125)

1)We know that port 30815 on ###.24.119.221 (hanadbhost-int.et.com) will NEVER work.

But the same host has another alias ###.24.119.222 (hanadbhost.et.com) which  WILL work.

So we want direct sapinst to use ###.24.119.222 (hanadbhost.et.com)

2) We searched the entire "configuration" tab in hana studio and did not find a place to replace

###.24.119.221 (hanadbhost-int.et.com)

with

###.24.119.222 (hanadbhost.et.com)

i.e. ###.24.119.221 (hanadbhost-int.et.com) is not in "configuration" tab.

3) All parameter files for sapinst also do not have "###.24.119.221 (hanadbhost-int.et.com)"

Please help tell how to direct sapinst to use ###.24.119.222 (hanadbhost.et.com).  Thanks a lot.

Please do not advice "open that port " at ###.24.119.221 (hanadbhost-int.et.com) , because that is not an option.

[Former Member · Accepted solution]

Hi Mike,

You have to change DB Configuration file using hdbuserstore utility from SAP application server by <sid>adm user.

check current configuration:

hdbuserstore list

above command will give you HANA DB configuration with IP address ###.24.119.221

Now execute below commands to change HANA DB user store.

hdbuserstore set default ###.24.119.222:30815 <DB SCHEMA> <Password>

hdbuserstore set system ###.24.119.222:30815 SYSTEM <Password>

Before starting import, check R3trans -d whether you are able to connect to DB from application server.

Regards,

Ganesh