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) , 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.