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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.