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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.