SAP Knowledge Base Article - Preview

3724025 - INVALID_CONNECT_ATTEMPTS in users table displays 0 despite invalid connection attempts

Symptom

  • The value of INVALID_CONNECT_ATTEMPTS is different between the USERS table and the INVALID_CONNECT_ATTEMPTS system view. 
  • Querying SYS.INVALID_CONNECT_ATTEMPTS for USER_NAME 'SAPABAP1' shows multiple entries with INVALID_CONNECT_ATTEMPTS set to value larger than 0. 

    SELECT * FROM SYS.INVALID_CONNECT_ATTEMPTS WHERE USER_NAME = 'SAPABAP1';

    USER_NAME SUCCESSFUL_CONNECT_TIME INVALID_CONNECT_ATTEMPTS
    ----------------------------------------------------------------------------------
    SAPABAP1 20181208205732135000000 1
    SAPABAP1 20181208220743140000000 1
    SAPABAP1 20181208220801737000000 1
    ...
    SAPABAP1 20260305104953073000000 1

  • Querying the USERS table for USER_NAME 'SAPABAP1' shows INVALID_CONNECT_ATTEMPTS set to 0. 

    SELECT USER_NAME, INVALID_CONNECT_ATTEMPTS FROM USERS WHERE USER_NAME = 'SAPABAP1'

 USER_NAME INVALID_CONNECT_ATTEMPTS
 -------------------------------------------------
 SAPABAP1  0 

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental." 

 




Read more...

Environment

  • SAP HANA DATABASE

Product

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

Keywords

INVALID_CONNECT_ATTEMPTS, USERS table, SYS.INVALID_CONNECT_ATTEMPTS, HANA database, invalid password attempts, successful connection, connection reset, user authentication, database error, troubleshooting, system view, invalid login attempts, connection issues, error resolution, database query, user connection , KBA , HAN-DB-SEC , SAP HANA Security & User Management , 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.