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.