SAP Knowledge Base Article - Preview

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

Symptom

  • During a SUM activity on a Java system, the 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) - All versions

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 , Business Suite on Adaptive Server Enterprise , Problem

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.