SAP Knowledge Base Article - Preview

2734494 - ASE Cockpit returns an error and stacktrace - ASE

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
     
    monitor_err.png

     
  • The agent and repository log record these warnings/errors
      
    a
    gent.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.