Symptom
Not able to log on IQ database with following error by "DBA" user.
'dba' with "DBA" authority was locked by "max_failed_login_attempts" login policy option. But 'dba' user should be unlocked automatically after duration by "root_auto_unlock_time" (default 15 minutes).
However, 'dba' couldn't connect to IQ database with following message even after duration by "root_auto_unlock_time".
$ dbisql -c dsn=DBA_DSN -nogui
Could not connect to the database.
Invalid user ID or password
SQLCODE=-103, ODBC 3 State="28000"
Read more...
Environment
SAP IQ 16.1 SP04.03
Product
Keywords
-orp , SYS_OFFLINE_RESET_PASSWORD_ROLE , offline reset password , , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , Bug Filed
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.