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
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.
SAP Knowledge Base Article - Preview