Symptom
- A DBCO test fails with ADBC error 'Internal error 8.192 has occurred' for a connection test with a connection id called DITHSTAGING
- The 2nd DBCO connection with the username SYSTEM exists and will be referred to as 'SID'.
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."
- The error 414 is discovered as the culprit and later resolved either by changing the password or disabling the password lifetime :
Error:
C *** ERROR => Connect to database failed, rc=1, rcSQL=414
[dbhdbsql.cpp 827]
C SQLCODE : 414
C SQLERRTEXT : user is forced to change password: alter password required for user DITHSTAGING
B ***LOG BYI=> connect failed for connection DITHSTAGING [dbds 1120]
- However afterward, SQL queries are failing with the same 8192 error. Running a dummy query like this against the SQL Editor in DBACOCKPIT dumps : SELECT * FROM M_HOST_INFORMATION
Exception CX_DBA_ADBC in class CL_HDB_SQL_EXECUTOR method EXEC_QUERY_DYN line 222
Kernel Error ID:
WP ID: 39
WP PID: 21140
Application Server: hostname
SYSID: SID
SY-SUBRC: 0
SQL statement: SELECT * FROM M_HOST_INFORMATION
Database: SID
caused by
Exception CX_SQL_EXCEPTION in class CL_SQL_CONNECTION
Kernel Error ID: UNCAUGHT_EXCEPTION
DB Error: No
SQL Code: 0
SQL Message:
DB Object Exists: No
Duplicated Key: No
Internal Error: 8192
Invalid Cursor: No
Unknown Connection: No
Connection Closed: No
- SM21/ST11 shows the following authentication failures with the SYSTEM user on the connection SID :
B Connect to SID as SYSTEM with hostname:port
B Wed Nov 8 16:07:22:092 2023
B B Connect to SID as SYSTEM with hostname:port
C Try to connect SECONDARY as SYSTEM@hostname:port on connection 2 ...
C connect property [APPLICATION = ABAP:SID]
C connect property [APPLICATIONVERSION = 789 PL 74]
C connect property [APPLICATION_SERVER_INSTANCE_NAME = hostname]
C connect property [APPLICATION_SERVER_WORKPROCESS_INDEX = 39]
C connect property [UNICODE = 1]
C connect property [SQLMODE = SAPR3]
C connect property [VARCHARMODE = ABAP]
C connect property [PACKETSIZE = 1048576]
C connect property [COMPLETEARRAYEXECUTION = 1]
C connect property [CONNECTTIMEOUT = 30000]
C connect property [CACHEDVIEWTS = 1]
C connect property [EMPTYTIMESTAMPISNULL = false]
C connect property [SPATIALTYPES = 1]
C connect property [STATEMENTROUTINGWARNINGS = TRUE]
C connect property [STATEMENTHASH = 1]
C connect to SYSTEM/<pwd>@hostname:port on connection 2 ...
C *** ERROR => Connect to database failed, rc=1, rcSQL=10
[dbhdbsql.cpp 827]
C {root-id=27EF2CE0E3511EDE9FC8EB43E201A8B1}_{conn-id=00000000000000000000000000000000}_0
C SQLCODE : 10
C SQLERRTEXT : authentication failed
B ***LOG BYI=> connect failed for connection SID [dbds 1120]
B
B Wed Nov 8 16:07:25:938 2023
B Connect to SID as SYSTEM with hostname:port
C Try to connect SECONDARY as SYSTEM@hostname:port on connection 2 ...
C connect property [APPLICATION = ABAP:SID]
C connect property [APPLICATIONVERSION = 789 PL 74]
C connect property [APPLICATION_SERVER_INSTANCE_NAME = hostname]
C connect property [APPLICATION_SERVER_WORKPROCESS_INDEX = 39]
C connect property [UNICODE = 1]
C connect property [SQLMODE = SAPR3]
C connect property [VARCHARMODE = ABAP]
C connect property [PACKETSIZE = 1048576]
C connect property [COMPLETEARRAYEXECUTION = 1]
C connect property [CONNECTTIMEOUT = 30000]
C connect property [CACHEDVIEWTS = 1]
C connect property [EMPTYTIMESTAMPISNULL = false]
C connect property [SPATIALTYPES = 1]
C connect property [STATEMENTROUTINGWARNINGS = TRUE]
C connect property [STATEMENTHASH = 1]
C connect to SYSTEM/<pwd>@hostname:port on connection 2 ...
C *** ERROR => Connect to database failed, rc=1, rcSQL=10
[dbhdbsql.cpp 827]
C {root-id=27EF2CE0E3511EDE9FC8EB43E201A8B1}_{conn-id=00000000000000000000000000000000}_0
C SQLCODE : 10
C SQLERRTEXT : authentication failed
B ***LOG BYI=> connect failed for connection SID [dbds 1120]
Read more...
Environment
SAP HANA Platform Edition 2.0
Product
SAP HANA, platform edition 2.0
Keywords
KBA , BC-DB-HDB-SYS , Database Interface/DBMS for SAP HANA , HAN-DB-SEC , SAP HANA Security & User Management , HAN-DB-CLI , SAP HANA Clients (JDBC, ODBC) , 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.