Cannot insert rows into sysstatistics, due to multiple equal frequency values

[Former Member]

Hi,

I want to deply on NW PI 7.4 an update and run with SUM into an error during statistics update in the execution phases:

Nov 12, 2013 4:29:26 PM [Info  ]:   Standard out: /sybase/S01/sapdata_1/SUM/sdt/log/SUM/UPDATE_STATS_SYBTaskExecutorService_06.OUT

Nov 12, 2013 4:29:26 PM [Info  ]: Process ID 100 has been started.

Nov 12, 2013 4:29:26 PM [Info  ]: Waiting for process ID 100, name java to finish.

Nov 12, 2013 4:29:28 PM [Info  ]: Process ID 100, name java has been finished, exit code 200.

Nov 12, 2013 4:29:28 PM [Error ]: The following problem has occurred during step execution: com.sap.sdt.util.diag.DiagException: Error

while executing Task with input file ExecuteTasks_SYB.xml and task UPDATE_STATS_SYB.

Error while processing the result.

Cannot Update Index Statistics; for more information

          see /sybase/S01/sapdata_1/SUM/sdt/log/SUM/UPDATE_STATS_SYB*.*. Could not execute '/sybase/S01/sapdata_1/SUM/jvm/jre/bin/java

-cp /usr/sap/S01/J00/exe/sybjdbc/jconn4.jar:/usr/sap/S01/J00/exe/sybjdbc/EccpressoFIPS.jar:/usr/sap/S01/J00/exe/sybjdbc/EccpressoFIPSJc

a.jar:/sybase/S01/sapdata_1/SUM/sdt/lib/sdt_db_SYB.jar:. com.sap.sdt.db.tools.syb.SQLMain /usr/sap/S01/J00/exe/sybjdbc/jconn4.jar:/usr/

sap/S01/J00/exe/sybjdbc/EccpressoFIPS.jar:/usr/sap/S01/J00/exe/sybjdbc/EccpressoFIPSJca.jar jdbc:sybase:Tds:megvmpq0:4901/S01?EXECUTE_BATCH_PAST_ERRORS=TRUE&SQLINITSTRING=SET ANSINULL ON SET STRING_RTRUNCATION ON&HOMOGENEOUS_BATCH=FALSE&DYNAMIC_PREPARE=TRUE&EARLY_BATCH_READ_THRESHOLD=50&ENCRYPT_PASSWORD=TRUE SAPSR3DB <SecureField> UPDATE_STATS_SYB', return code '200'. Check if process output file(s) '/sybase/S01/sapdata_1/SUM/sdt/log/SUM/UPDATE_STATS_SYBTaskExecutorService.OUT', '/sybase/S01/sapdata_1/SUM/sdt/log/SUM/UPDATE_STATS_SYBTaskExecutorService.ERR' have been created.

UPDATE_STATS_SYBTaskExecutorService_06.OUT:

SQLException (exec sap_updateStats): Cannot insert rows into sysstatistics, due to multiple equal frequency values, please contact Sybase Technical Support

ASE is on version 15.7.0.102

The same procedure on DEV System worked fine - with same JDBC, ODBC and Kernal version as on this system.

Hope anybody has an idea.

Best regards

Arne Knöller

[Former Member]

Hi Mark,

thanks for your reply.

The SAP SUM procedure creates a procedure and runns update statistics:

Create sap_updateStats Procedure done for [71] ms

update index statistics "SAPSR3DB"."ADS_LICENSED_FORMS"

update index statistics "SAPSR3DB"."BC_ACA_DC_DATA"

update index statistics "SAPSR3DB"."BC_ACA_FUN_DATA"

The manual update statistics workes fine:

1> use S01

2> go

1> update index statistics SAPSR3DB.BC_DDDBDP

2> go

1>

Here some additional infos out of the troubleticket.txt

An error has occurred during the execution of the Update statistics (SYB) step with action execute. Service com.sap.sdt.j2ee.services.servicesimpl.TaskExecut

orService 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 /sybase/S01/sapdata_1/SUM/sdt/log/SUM/UPDATE-STATISTICS-PRE-DEPLOY-SYB_01.LOG and ProcessOverview.html.

Use the information provided to trouble-shoot the problem. There might be an OSS note providing a solution to this problem. Search for OSS notes with the fol

lowing search terms:

SUM,execute,pre-component-deploy,update-statistics-pre-deploy-syb,com.sap.sdt.j2ee.services.servicesimpl.TaskExecutorService,class com.sap.sdt.util.diag.Diag

Exception

[Former Member]

I successfully updated all statistics of the related DB - including the statistics for the tables which SUM wants to update.

I can't see which table causes the error "Cannot insert rows into sysstatistics, due to multiple equal frequency values, please contact Sybase Technical Support"

I also tried to delete the statistics, but SUM runns into the same error during the execution.