SAP Knowledge Base Article - Preview

2270501 - SUM update of a Java stack for BS on Sybase ASE fails

Symptom

  • During an upgrade activity on a Java system following error is received:

An error has occurred during the execution of the Update statistics (SYB) step with action execute.
Service com.sap.sdt.j2ee.services.servicesimpl.TaskExecutorService failed with the following message
Error while executing Task with input file ExecuteTasks_SYB.xml and task UPDATE_STATS_SYB.
You can find more information in the files /install/SUM/SUM/sdt/log/SUM/UPDATE-STATISTICS-PRE-DEPLOY-SYB_##.LOG and ProcessOverview.html 
 

  • File UPDATE_STATS_SYBTaskExecutorService_##.ERR contains following error message

com.sybase.jdbc4.jdbc.SybSQLException: Cannot insert rows into sysstatistics, due to multiple equal frequency values, please contact Sybase Technical Support
at com.sybase.jdbc4.tds.Tds.processEed(Tds.java:4117)
at com.sybase.jdbc4.tds.Tds.nextResult(Tds.java:3207)
at com.sybase.jdbc4.jdbc.ResultGetter.nextResult (ResultGetter.java:78)
at com.sybase.jdbc4.jdbc.SybStatement.nextResult (SybStatement.java:294)
at com.sybase.jdbc4.jdbc.SybStatement.nextResult (SybStatement.java:276)
at com.sybase.jdbc4.jdbc.SybStatement.updateLoop (SybStatement.java:2749)
at com.sybase.jdbc4.jdbc.SybCallableStatement.executeUpdate (SybCallableStatement.java:201)
at com.sap.sdt.db.tools.syb.SQLHelper.executeUpdateStatsProcedure (SQLHelper.java:834)
at com.sap.sdt.db.tools.syb.SQLHelper.updateStats (SQLHelper.java:420)
at com.sap.sdt.db.tools.syb.SQLMain.main(SQLMain.java:40)


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite (BS) or higher
  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite (BS) or higher
  • SAP Netweaver (NW) 7.4
  • SUM 1.0 SP 19

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver 7.4

Keywords

update statistics hashing partial, UPDATE_STATS_SYB, ExecuteTasks_SYB.xml , KBA , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , 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.