SAP Knowledge Base Article - Preview

1972413 - Cannot drop a user from the repository database in SCC, if the user settings have changed - SAP ASE

Symptom

When trying to delete an error is reported. Here is an example from the agent.log:

    • Caused by: java.sql.SQLException: [Sybase][ODBC Driver][SQL Anywhere]Primary key for row in table 'SEC_LOGIN' is referenced by foreign key 'FK_UI_SETTI_REFERENCE_SEC_LOGI' in table 'UI_SETTING'
    • at ianywhere.ml.jdbcodbc.jdbc3.IIPreparedStatement.internalExecuteBatch(Native Method)
    • at ianywhere.ml.jdbcodbc.jdbc3.IPreparedStatement.executeBatch(IPreparedStatement.java:404)
    • at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    • at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    • at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    • at java.lang.reflect.Method.invoke(Unknown Source)
    • at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
    • at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
    • at $java.sql.PreparedStatement$$EnhancerByProxool$$6a5c


Read more...

Environment

  • Adaptive Server Enterprise (ASE) 15.7
  • Sybase Control Center 3.2.7

Product

SAP Adaptive Server Enterprise 15.7

Keywords

Drop, User, Sybase Control Center , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.