Symptom
- An Attempt to view an ASE 15.7 errorlog from the ASE Cockpit Monitor tab raises an error
The Error message pop-up returned to the Cockpit User Interface
- The agent and repository log record these warnings/errors
agent.log - [ERROR] [scc.SccService ] [scc-ui::139638] - The assignment of the persistent value with the name:ase_server_log_exp# has failed.
Caused by: java.sql.SQLException: [Sybase][JDBC Driver][SQL Anywhere]Index 'AK_STV_NAME' for table'UI_SETTING_VALUE' would not be unique
repository.log - [WARN ] [util.JDBCExceptionReporter] [scc-ui::1814] - SQL Error: -196, SQLState: 23000
[ERROR] [util.JDBCExceptionReporter] [scc-ui::1814] - [Sybase][JDBC Driver][SQL Anywhere]Index 'AK_STV_NAME'
for table 'UI_SETTING_VALUE' would not be unique
- Agent.log - partial stacktrace that follows the above error
org.hibernate.exception.ConstraintViolationException: could not insert: [com.sybase.scc.model.app.ui.SettingValue]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:96)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:64)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2329)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2836)
at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:71)
<snip>
Caused by: java.sql.SQLException: [Sybase][JDBC Driver][SQL Anywhere]Index 'AK_STV_NAME' for table 'UI_SETTING_VALUE' would not be unique
at sybase.jdbc4.sqlanywhere.IIPreparedStatement.execute(Native Method)
at sybase.jdbc4.sqlanywhere.IPreparedStatement.execute(IPreparedStatement.java:390)
at sun.reflect.GeneratedMethodAccessor382.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
at $java.sql.Wrapper$$EnhancerByProxool$$cf0df0aa.execute(<generated>)
at org.hibernate.id.IdentityGenerator$InsertSelectDelegate.executeAndExtract(IdentityGenerator.java:138)
at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:57)
Read more...
Environment
-
Adaptive Server Enterprise (ASE) 16.0 SP03 PL05
- ASE Cockpit 4.0
Product
SAP Adaptive Server Enterprise 16.0
Keywords
Cockpit, ASE errorlog, ASE 15.7, popup , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed
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.