/support/notes/service/sap_logo.png){kind=logo}
SAP Knowledge Base Article - PreviewSymptom
- Client connection errors result in "DBSQL_CONNECTION_NO_METADATA" dumps with the following information in the context of SLT replication between a remote HANA database and non-HANA DB platform like MSSQL :
Category External Error
Runtime Errors DBSQL_CONNECTION_NO_METADATA
Date and Time 20.05.2023 23:42:14
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|Short Text |
| No metadata found for database connection "HANA_SID". |
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|What happened? |
| The metadata for database connection "HANA_SID" could not be found due to |
| error 99 in the Database Shared Library (DBSL). |
----------------------------------------------------------------------------------------------------
.....
----------------------------------------------------------------------------------------------------
|How to correct the error |
| For further information about this error, see "Database Interface |
| Information" |
----------------------------------------------------------------------------------------------------
- SLT server is running on the same database server platform (MSSQL in this example) as the Netweaver system where the dump occurred :
----------------------------------------------------------------------------------------------------
|System environment |
| SAP Release..... 750 |
| SAP Basis level 0017 |
| |
| Application server... hostname |
| Network address...... <> |
| Operating system... Windows NT |
| Release.............. 10.0 |
| Hardware type....... 16x AMD64 Level |
| Character length..... 16 Bits |
| Pointer length........ 64 Bits |
| Work process number... 35 |
| Shortdump setting. full |
| |
| Database server... DB Hostname,1502 |
| Database type..... MSSQL |
| Database name..... SID |
| Database user ID SID |
| |
| Terminal.......... |
| |
| Character set C |
| |
| SAP kernel....... 753 |
| Created on....... Mar 13 2021 03:33:41 |
| Created at....... NT 6.3 9600 x86 MS VC++ 18.00 use-pr20210313 |
| Database version msodbcsql17 |
| Patch level....... 800 |
| Patch text....... |
| |
| Database............. MSSQL 9.00.2047 or higher |
| SAP database version. 753 |
| Operating system... Windows NT 6.0, Windows NT 6.1, Windows NT 6.2, Windows NT |
| 6.3, Windows NT 10.0 |
| |
----------------------------------------------------------------------------------------------------
|Source Code Extract |
----------------------------------------------------------------------------------------------------
|Line |SourceCde |
----------------------------------------------------------------------------------------------------
| 38|STATICS: |
| 39| at_tabkey TYPE TABLE OF E071K-TABKEY, |
| 40| at_tabkey2 TYPE TABLE OF E071K-TABKEY, |
| 41| a_tabkeys_selected TYPE BOOLEAN. |
| 42|DATA: l_tabkey TYPE E071K-TABKEY, |
| 43| l_tabix TYPE SYTABIX. |
| 44|DATA: l_cnt_ins TYPE I, |
| 45| l_cnt_upd TYPE I. |
| 46| |
| 47|DATA ls_/1LT/40000000284 TYPE /1LT/40000000284. |
| 48|DATA con_name TYPE DBCON_NAME VALUE 'EP1_HANA_PROD'. |
| 49| |
| 50|DATA: lr_writer_exit_flat TYPE REF TO badi_iuuc_repl_writer_exit, |
| 51| lx_badi TYPE REF TO cx_badi, |
| 52| lv_badi_rc TYPE sysubrc. |
| 53| |
| 54|CONSTANTS co_repl_application TYPE iuuc_repl_application |
| 55| VALUE ''. |
| 56|DATA: lo_root TYPE REF TO cx_root, |
| 57|lv_access TYPE string. |
| 58| |
| 59|CALL METHOD CL_DMC_AUTHORITY_REMOTE=>CHECK_RT_WRITE |
| 60|EXCEPTIONS no_authorization = 1. |
| 61|IF SY-SUBRC NE 0. |
| 62| RAISE NO_AUTHORIZATION. |
| 63|ENDIF. |
| 64|IF NOT IM_TEST_MODE = 'X'. |
| 65| |
| 66|TRY. |
| 67|*** delete records |
|>>>>>|DELETE /1LT/40000000284 CLIENT SPECIFIED |
| 69| CONNECTION (con_name) |
| 70| FROM TABLE _NAME. |
| 71|E_CNT_DEL = sy-dbcnt. |
| 72| |
| 73|*** update records |
| 74|DESCRIBE TABLE _NAME |
| 75| LINES l_cnt_upd. |
| 76|IF l_cnt_upd > 0. |
| 77|UPDATE /1LT/40000000284 CLIENT SPECIFIED CONNECTION (con_name) |
| 78| FROM TABLE _IT_IO_R_ZDT_UDR_RECORDS_U. |
| 79|e_cnt_upd = sy-dbcnt. |
| 80|IF sy-dbcnt < l_cnt_upd. |
| 81|e_cnt_ins = l_cnt_upd - sy-dbcnt. |
| 82|INSERT /1LT/40000000284 CLIENT SPECIFIED CONNECTION (con_name) |
| 83| FROM TABLE_NAME |
| 84|ACCEPTING DUPLICATE KEYS. |
| 85|IF sy-dbcnt < e_cnt_ins. |
| 86|RAISE DUPLICATE_SECONDARY_INDEX. |
| 87|ENDIF. |
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|Database Interface Information |
----------------------------------------------------------------------------------------------------
|C|1|SlBreak [D:/depot/bas/753_REL/src/dbs/mss/slodbc.c#8198] |
|B|1|db_sqlbreak() = 15 [D:/depot/bas/753_REL/src/krn/dbi/dbs/dblink.c#2227] |
----------------------------------------------------------------------------------------------------
- Testing a Database Connection defined in DBCON to the remote HANA Database fails in error :
Could not open connection HANA_SID .
sql error 10,709- occured:
Connection failed (RTE:[89006] System call 'recv' failed, rc=10054:An existing connection was forcibly closed by the remote host {0.0.0.0:59553 -> xx.x.xx.xx:443} (DB hostname)
Read more...
Environment
SAP HANA Platform Edition 2.0
SAP HANA Cloud
Product
SAP HANA Cloud 1.0 ; SAP HANA, platform edition 2.0
Keywords
KBA , HAN-DB-CLI , SAP HANA Clients (JDBC, ODBC) , HAN-CLS-HC , HANA Cloud Services HANA Cloud , 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.
/support/notes/service/facebook.svg)
/support/notes/service/twitter.svg)
/support/notes/service/youtube.svg)
/support/notes/service/linkedin.svg)
/support/notes/service/instagram2.svg)