SAP Knowledge Base Article - Preview

2898513 - Workload analyzer command line: Replay comparison failed - SAP ASE

Symptom

Attempt to run a compare - failed with the following errors:

[INFO ] [Thread-9] [com.sybase.workload.replay.control.ReplayEngine.writeInfoLog(54)] - ReplayControlThread->replay is stopped
[ERROR] [Workload capture worker thread 9] [com.sybase.workload.ASECatCaptureMgr.writeErrorLog(264)] - Failed to generate report with mode 2 for replay replay_case1(2) (run(), ASECatCaptureMgr.java:5567)
[ERROR] [Workload capture worker thread 4] [com.sybase.workload.ASECatCaptureMgr.writeErrorLog(264)] - Failed to generate report with mode 1 for replay replay_case1(2) (run(), ASECatCaptureMgr.java:5567)
[ERROR] [Workload capture worker thread 7] [com.sybase.workload.ASECatCaptureMgr.writeErrorLog(264)] - Failed to generate report with mode 3 for replay replay_case1(2) (run(), ASECatCaptureMgr.java:5567)
[ERROR] [Thread-335785] [com.sybase.workload.ASECatCaptureMgr.writeErrorLog(264)] - Failed to compare replay replay_case1(2) (run(), ASECatCaptureMgr.java:5373)
[ERROR] [Workload capture worker thread 3] [com.sybase.workload.ASECatCaptureMgr.writeErrorLog(264)] - Failed to generate report with mode 4 for replay replay_case1(2) (run(), ASECatCaptureMgr.java:5567)
[ERROR] [Thread-335785] [com.sybase.workload.ASECatCaptureMgr.writeErrorLog(264)] - Failed to read queries for session 3 for capture replay_case1(2). com.sybase.workload.exception.ASECatRepoServerException:
             Call stored procedure p_gentopperfpctincrpt error. com.sybase.jdbc4.jdbc.SybSQLException:
             Attempt to insert NULL value into column 'tpcq_querytext', table 'sybcatdb.dbo.t_topperfchgqrys_cap2'; column does not allow nulls. Update fails.
             (ASECatRepoSvrASEController.java: Line 886)(ASECatCaptureMgr.java: Line 5574) (run(), ASECatCaptureMgr.java:5376)
[ERROR] [Workload capture worker thread 0] [com.sybase.workload.ASECatCaptureMgr.writeErrorLog(264)] - Failed to generate report with mode 5 for replay replay_case1(2) (run(), ASECatCaptureMgr.java:5567)
[ERROR] [Workload Analyzer Command Line Utility Replay Comparison Thread] [com.sybase.workload.cli.task.WLAReplay.run(352)] -
               Comparison of workload [replay_case1] was terminated with exception: Replay comparison failed.

Failed to read queries for session 3 for capture replay_case1(2). com.sybase.workload.exception.ASECatRepoServerException:
Call stored procedure p_gentopperfpctincrpt error. com.sybase.jdbc4.jdbc.SybSQLException:
Attempt to insert NULL value into column 'tpcq_querytext', table 'sybcatdb.dbo.t_topperfchgqrys_cap2'; column does not allow nulls. Update fails.
(ASECatRepoSvrASEController.java: Line 886)(ASECatCaptureMgr.java: Line 5574).


Read more...

Environment

Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 16.0

Keywords

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

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.