Symptom
You get the following abap dump
Category Installation error Runtime Errors DBSQL_SQL_ERROR Except. CX_SY_OPEN_SQL_DB Date and Time 24.10.2017 11:13:04 ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- |Short Text | | SQL error "SQL code: 100" occurred while accessing table "DDFTX". | ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- |What happened? | | Database error text: "SQL message: Row not found" | ----------------------------------------------------------------------------------------------------
and wp trace shows the following information
Example (dev_w4):
C Tue Oct 24 17:59:14:537 2017
C
C Try to connect via secure store (SERVICE) on connection 1 ...
C Attach to HDB : 2.00.010.00.1491294693 (fa/hana2sp01)
C Database release is HDB 2.00.010.00.1491294693
C INFO : Database 'SID/00' instance is running on 'rhana'
C *** ERROR => Get session info failed : rc=100
[dbhdbsql.cpp 1446]
C {root-id=1AA9323AD5661ED7AE96DE168F6D012B}_{conn-id=00000000000000000000000000000000}_0
C SQLCODE : 100
C SQLERRTEXT : Row not found
C SQL COMMAND: SELECT CURRENT_USER, CURRENT_SCHEMA, CURRENT_CONNECTION FROM DUMMY;
C Disconnecting from connection 1 ...
C Now I'm disconnected from HDB
B ***LOG BY2=> sql error 100 performing CON [dbds 989]
B ***LOG BY0=> Row not found [dbds 989]
B *** ERROR => Could not get a shared connection for CONNAME = R/3*AMDP_ADBC ab_get_connection: rc = -2
[dbacds.c 865]
or no connection is possible via R3trans
4 ETW000 [ dev trc,00000] Loading SQLDBC client runtime (pid=3932356)...
4 ETW000 [ dev trc,00000] SQLDBC Runtime : libSQLDBCHDB 2.01.037.1490890836
4 ETW000 [ dev trc,00000] SQLDBC client runtime is 2.01.037.1490890836
4 ETW000 [ dev trc,00000] Try to connect via secure store (DEFAULT) on connection 0 ...
4 ETW000 [ dev trc,00000] Attach to HDB : 2.00.010.00.1491294693 (fa/hana2sp01)
4 ETW000 [ dev trc,00000] fa/hana2sp01 : build_weekstone=0000.00.0
4 ETW000 [ dev trc,00000] fa/hana2sp01 : build_time=2017-04-04 10:37:35
4 ETW000 [ dev trc,00000] Database release is HDB 2.00.010.00.1491294693
4 ETW000 [ dev trc,00000] INFO : Database 'SID/00' instance is running on 'rhana'
4 ETW000 [dbhdbsql.cpp,00000] *** ERROR => Get session info failed : rc=100
4 ETW000 [ dev trc,00000] SQLCODE : 100
4 ETW000 [ dev trc,00000] SQLERRTEXT : Row not found
4 ETW000 [ dev trc,00000] SQL COMMAND: SELECT CURRENT_USER, CURRENT_SCHEMA, CURRENT_CONNECTION FROM DUMMY;
4 ETW000 [ dev trc,00000] Disconnecting from connection 0 ...
4 ETW000 [ dev trc,00000] Now I'm disconnected from HDB
4 ETW000 [ dblink ,00000] ***LOG BY2=>sql error 100 performing CON
4 ETW000 [ dblink ,00000] ***LOG BY0=>Row not found
2EETW169 no connect possible: "DBMS = HDB --- SERVER = '' PORT = ''"
Read more...
Environment
Issue was reported for Hana Revision 2.00.010 but this issue could also occure on all other Hana Revisions too
Product
Keywords
Hana, HDB, SPS 2, Hana 1.0, Hana 2.0, DBACOCKPIT, Workprocess Trace, R3trans, trans.log, connection error, Hana Platform Edition, , KBA , HAN-DB , SAP HANA Database , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.