SAP Knowledge Base Article - Preview

2588282 - SQL error "SQL code: 100" occurred while accessing table & SQL message: Row not found

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

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

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.