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