SAP Knowledge Base Article - Preview

2207453 - User defined login policies generate errors after upgrade - SAP IQ

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.