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

Search for additional results

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