Skip to Content
0

CAL SAP HANA Express, unable to connect with SAP HANA Studio

Nov 24, 2017 at 04:34 PM

172

avatar image
Former Member

Hi all,

I request a server with SAP CAL for an instance with SAP HANA express studio.

I can access to HANA with SAP HANA web IDE for SAP HANA and SAP HANA Database Explorer. However, I cannot connect myself to HANA with SAP HANA Studio on Eclipse. I got the following message:

The system could not be reached. The logon data could not be used 

For the setting of the connection I follow this guide.

I don't think is an password problem since I have another error when the password is wrong:

Invalid user name or password

I think, it is a network problem but on the CAL dashboard, the security group allow the port that I used 39015. (I didn't change default security groupes).

Do you have any idea on why I cannot access to HANA with SAP HANA Studio?!? Do you need more information?!?

Thanks,

Romain

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Lucia Subatin
Nov 26, 2017 at 09:00 PM
0

So, if you are accessing Web IDE I'm assuming your hosts file is mapped properly and you can reach your system. I just created a new machine, did not change the ports that are configured by default and used the following to access from HANA Studio, and it worked:

Of course this applies to the system database. You can activate the JDBC trace for this connection by creating it anyways, right-clicking on it, properties and then JDBC trace, "Enable trace":

That may give a better hint of what is going on.


cal.png (22.0 kB)
activate-jdbc.png (22.1 kB)
Show 3 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hello Lucia and thank you for your answer.

I used the same configuration to access the system: hostanme -> vhcalhxedb, instance number -> 90, multiple containers -> system database. And, I try this with all users: SYSTEM, XSA_ADMIN and XSA_DEV.

I configure the log to trace and the output is the following for all user:

RTEException: SQLRECEIVE_LINE_DOWN(8) -708 Data receive failed [Operation timed out (Read failed)].
Stack trace:
java.lang.Throwable
	at com.sap.db.jdbc.trace.Tracer.printCurrentStackTrace(Tracer.java:209)
	at com.sap.db.jdbc.exceptions.RTEException.<init>(RTEException.java:43)
	at com.sap.db.jdbc.exceptions.RTEException.<init>(RTEException.java:23)
	at com.sap.db.jdbc.Session._throwRTEException(Session.java:547)
	at com.sap.db.jdbc.Session._receive(Session.java:359)
	at com.sap.db.jdbc.Session.execute(Session.java:290)
	at com.sap.db.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:1638)
	at com.sap.db.jdbc.InternalStatementSapDB.sendCommand(InternalStatementSapDB.java:36)
	at com.sap.db.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:419)
	at com.sap.db.jdbc.StatementSapDB._execute(StatementSapDB.java:1675)
	at com.sap.db.jdbc.StatementSapDB._executeQuery(StatementSapDB.java:1633)
	at com.sap.db.jdbc.DatabaseMetaDataSapDB._getDBInfo(DatabaseMetaDataSapDB.java:4071)
	at com.sap.db.jdbc.DatabaseMetaDataSapDB.<init>(DatabaseMetaDataSapDB.java:126)
	at com.sap.db.jdbc.ConnectionSapDB._refreshMetaData(ConnectionSapDB.java:2215)
	at com.sap.db.jdbc.ConnectionSapDB._getNewConnection(ConnectionSapDB.java:2474)
	at com.sap.db.jdbc.ConnectionSapDB._tryReconnect(ConnectionSapDB.java:2619)
	at com.sap.db.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:1867)
	at com.sap.db.jdbc.CallableStatementSapDB.sendCommand(CallableStatementSapDB.java:1062)
	at com.sap.db.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:419)
	at com.sap.db.jdbc.CallableStatementSapDB.doParse(CallableStatementSapDB.java:131)
	at com.sap.db.jdbc.CallableStatementSapDB.constructor(CallableStatementSapDB.java:99)
	at com.sap.db.jdbc.CallableStatementSapDB.<init>(CallableStatementSapDB.java:83)
	at com.sap.db.jdbc.CallableStatementSapDBFinalize.<init>(CallableStatementSapDBFinalize.java:21)
	at com.sap.db.jdbc.ConnectionSapDB._prepareStatement(ConnectionSapDB.java:2711)
	at com.sap.db.jdbc.ConnectionSapDB.prepareStatement(ConnectionSapDB.java:241)
	at com.sap.ndb.studio.jdbc.JDBCConnection.initialize(JDBCConnection.java:251)
	at com.sap.ndb.studio.jdbc.JDBCPlugin.createConnection(JDBCPlugin.java:220)
	at com.sap.ndb.studio.navigator.properties.JDBCPropertyPage$2$1.call(JDBCPropertyPage.java:444)
	at com.sap.ndb.studio.navigator.properties.JDBCPropertyPage$2$1.call(JDBCPropertyPage.java:1)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:745)

And just before this exception, I got this:

<Packet SessionID=449364109292714 PacketCount=3 VarpartLength=720 VarpartSize=720 NumberOfSegments=1 PacketOptions=0>
  <Segment Request SegmentLength=720 SegmentOffset=0 NumberOfParts=4 SegmentNumber=1 SegmentKind=1 MessageType=ExecuteDirect(2) CommitImmediately=1 CommandOptions=8[HOLD_CURSORS_OVER_COMMIT]>
    <Part PartKind=Profile(38) PartAttributes=0(none) ArgumentCount=2 BigArgumentCount=0 BufferLength=20 BufferSize=660>
      <PartBuffer>
        [00 04 c1 01 00 00 00 00 00 00 01 04 f1 fe 08 00 00 00 00 00]
        Option=SendTime(0) Type=BIGINT(4) Value=449
        Option=ReceiveTime(1) Type=BIGINT(4) Value=589553
      </PartBuffer>
    </Part>
    <Part PartKind=SessionContext(34) PartAttributes=0(none) ArgumentCount=6 BigArgumentCount=0 BufferLength=56 BufferSize=584>
      <PartBuffer>
        [01 03 b2 98 01 00 02 1d 0c 00 31 30 2e 37 39 2e 36 32 2e 31 37 32 03 03 65 98 00 00 04 03 b2 98 01 00 05 1d 0c 00 31 30 2e 37 39 2e 36 32 2e 31 37 32 06 03 65 98 00 00]
        Option=PrimaryConnectionID(1) Type=INT(3) Value=104626
        Option=PrimaryHostName(2) Type=STRING(29) Value=10.79.62.172
        Option=PrimaryHostPortNumber(3) Type=INT(3) Value=39013
        Option=AnchorConnectionID(4) Type=INT(3) Value=104626
        Option=AnchorHostName(5) Type=STRING(29) Value=10.79.62.172
        Option=AnchorHostPortNumber(6) Type=INT(3) Value=39013
      </PartBuffer>
    </Part>
    <Part PartKind=ClientInfo(57) PartAttributes=0(none) ArgumentCount=8 BigArgumentCount=0 BufferLength=504 BufferSize=64>
      <PartBuffer>
        [11 41 50 50 4c 49 43 41 54 49 4f 4e 53 4f 55 52 43 45 f6 9b 01 63 73 6e 73 2e 6e 61 76 69 67 61 74 6f 72 2e 70 72 6f 70 65 72 74 69 65 73 2e 4a 44 42 43 50 72 6f 70 65 72 74 79 50 61 67 65 24 32 24 31 2e 63 61 6c 6c 28 4a 44 42 43 50 72 6f 70 65 72 74 79 50 61 67 65 2e 6a 61 76 61 3a 34 34 34 29 3b 63 73 6e 73 2e 6e 61 76 69 67 61 74 6f 72 2e 70 72 6f 70 65 72 74 69 65 73 2e 4a 44 42 43 50 72 6f 70 65 72 74 79 50 61 67 65 24 32 24 31 2e 63 61 6c 6c 28 4a 44 42 43 50 72 6f 70 65 72 74 79 50 61 67 65 2e 6a 61 76 61 3a 31 29 3b 6a 61 76 61 2e 75 74 69 6c 2e 63 6f 6e 63 75 72 72 65 6e 74 2e 46 75 74 75 72 65 54 61 73 6b 2e 72 75 6e 28 46 75 74 75 72 65 54 61 73 6b 2e 6a 61 76 61 3a 32 36 36 29 3b 6a 61 76 61 2e 75 74 69 6c 2e 63 6f 6e 63 75 72 72 65 6e 74 2e 54 68 72 65 61 64 50 6f 6f 6c 45 78 65 63 75 74 6f 72 2e 72 75 6e 57 6f 72 6b 65 72 28 54 68 72 65 61 64 50 6f 6f 6c 45 78 65 63 75 74 6f 72 2e 6a 61 76 61 3a 31 31 34 32 29 3b 6a 61 76 61 2e 75 74 69 6c 2e 63 6f 6e 63 75 72 72 65 6e 74 2e 54 68 72 65 61 64 50 6f 6f 6c 45 78 65 63 75 74 6f 72 24 57 6f 72 6b 65 72 2e 72 75 6e 28 54 68 72 65 61 64 50 6f 6f 6c 45 78 65 63 75 74 6f 72 2e 6a 61 76 61 3a 36 31 37 29 3b 6a 61 76 61 2e 6c 61 6e 67 2e 54 68 72 65 61 64 2e 72 75 6e 28 54 68 72 65 61 64 2e 6a 61 76 61 3a 37 34 35 29 3b 0f 41 50 50 4c 49 43 41 54 49 4f 4e 55 53 45 52 07 69 33 33 36 31 39 37 0b 41 50 50 4c 49 43 41 54 49 4f 4e 09 48 44 42 53 74 75 64 69 6f 12 41 50 50 4c 49 43 41 54 49 4f 4e 56 45 52 53 49 4f 4e 06 32 2e 33 2e 32 39]
      </PartBuffer>
    </Part>
    <Part PartKind=Command(3) PartAttributes=0(none) ArgumentCount=1 BigArgumentCount=0 BufferLength=48 BufferSize=0>
      <PartBuffer>
        [53 45 4c 45 43 54 20 56 45 52 53 49 4f 4e 2c 20 43 55 52 52 45 4e 54 5f 55 53 45 52 20 46 52 4f 4d 20 53 59 53 2e 4d 5f 44 41 54 41 42 41 53 45]
        SELECT VERSION, CURRENT_USER FROM SYS.M_DATABASE
      </PartBuffer>
    </Part>
  </Segment>
</Packet>

My understanding is that the query 'SELECT VERSION, CURRENT_USER FROM SYS.M_DATABASE' is taking to long time. So I tried it on the web IDE and it was rather fast.

Statement 'SELECT VERSION, CURRENT_USER FROM SYS.M_DATABASE' executed in 3 ms.

I looked for the error on this blog but I found nothing and for RTEException: SQLRECEIVE_LINE_DOWN(8) -708 on SAP Hana documentation with the same result.

Add to this, here is the configuration printed when SAP Hana Studio try to connect to Hana:

try to reconnect
databaseName=SYSTEMDB
dburl=jdbc:sap://vhcalhxedb?databaseName=SYSTEMDB∈stanceNumber=90
encrypt=false
instanceNumber=90
locale=en_US
password=***
reconnect=true
timeout=0
user=SYSTEM
HOSTLIST: [vhcalhxedb:39013]

Thanks,

Romain

0

Hi, Romain, I've seen the -708 Data receive failed before related to connection problem, especially as all the proper database services must be started if you can run the SQL statement. I had similar problems connecting from the SAP network at the office. Can you make sure you can reach the combination of host and port?

0
Former Member
Lucia Subatin

It seems that I have no problem to reach the combination of host and port.

I tried this:

➜  ~ telnet vhcalhxedb 39013
Trying 34.234.98.64...
Connected to vhcalhxedb.
Escape character is '^]'.

Connection closed by foreign host.
➜  ~ telnet vhcalhxedb 39015
Trying 34.234.98.64...
Connected to vhcalhxedb.
Escape character is '^]'.

Connection closed by foreign host.

There is another host/port that I should test?

Add to this, I have access to another Hana DB and I am able to reach it with SAP Hana Studio. The difference is that I use 'tenant db' configuration instead of 'system database'.

0