3408867 - ADBC error 'Internal error 8.192 has occurred' in DBACOCKPIT

• 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]

SAP HANA Platform Edition 2.0

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