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.
SAP Knowledge Base Article - Preview