Skip to Content
0
Former Member
Nov 12, 2013 at 04:14 PM

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

164 Views

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