Symptom
Some customer sites that have user defined login policies experience either login failures or failures editing the login policy post upgrading from SAP IQ 15.2 and earlier to IQ 15.4 and higher or IQ 16 and higher.
- login failure messages seen
Could not connect to the database.
Connection disallowed by login policy for this user
SQLCODE=-1212, ODBC 3 State="HY000"
Msg 2727, Level 11, State 0:
SQL Anywhere Error -189: Unable to find in index 'ISYSLOGINPOLICY' for table 'ISYSUSER'
- login policy editing error messages seen
Unable to find in index 'ISYSLOGINPOLICY' for table 'ISYSUSER'SQLCODE=-189, ODBC 3 State="HY000"
- dbvalid output messages seen
VALIDATE TABLE "SYS"."ISYSUSER"
Foreign key "ISYSLOGINPOLICY" has missing index entries
Foreign key "ISYSLOGINPOLICY" has missing index entries
SQL error (-300) -- Run time SQL error -- Validation of table "ISYSUSER" has failed
Read more...
Environment
- SAP IQ 15.2
- SAP IQ 15.4
- SAP IQ 16
Product
SAP IQ 16.0
Keywords
KBA , BC-SYB-IQ , Sybase IQ , 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.